SUMMARY

• 17 Years of experience in the field of information technology. Predominantly associated with Oracle Database Administration
• Strong expertise in administration of Oracle databases with 24×7 database availability, Data Guard, RAC. Worked on various client facing critical databases as Oracle Primary DBA. Size of databases range up to 10TB.
• Strong expertise in performance tuning & troubleshooting, SQL /UNIX shell scripting, database tuning Confidential various stages, backup & recovery, advanced replications, materialized views, transportable table spaces.
• Good experience in Database Administration along with Database Maintenance, User managed Backup / Recovery and RMAN backup recovery, Performance Tuning in SQL, Application and Database
• Strong Experience in SQL, PL/SQL and UNIX Shell Scripting
• Strong Exposure on High Availability Concepts (Data Guard, Standby) and Database Cloning
• Good Experience in Database installation and Upgrades (9i,10g,11g) and Patching
• Strong programming experience in creating Packages, Stored Procedures, Stored Functions, Database Triggers
• Good Knowledge on Oracle Collaboration Suite Administration includes Oracle Web Conferencing, Email, Content
• Hands on experience on RAC database.
• Good Experience on New Environments setups includes 8i,9i,10g,11G Databases Installations and Middleware Installations
• Excellent communication skills. Exceptional ability to interact with users and all levels of management
• Extensive experience in database design, and distributed database systems.

TECHNICAL SKILLS

Operating System: Solaris 10/9/8/2.7/2.6 ; Red Hat Linux EL 4.0, Compaq Tru64 UNIX 5.1/5.1a/4.0, IBM AIX 4.3.2/4.3.3 , Windows XP, NT / 2000; SCO Open Server; HP UX 11.00 / 10.20 ; Su SE Linux, Veritas Clusters, VERITAS NetBackup 4.5/5.0/6.5/7

Databases/ Warehouse: RAC, OLAP, OLTP, Data warehousingData Mining, Oracle 32/64 - bit 10g/9i/ 8i/8.0/7.X

Oracle Tools/Utilities: RMAN, EXP/IMP, SQL * LoaderDBVERIFY, TKPROF and STATSPACKAutomatic Workload Repository, ADDMOracle Enterprise Manager(OEM) Grid ControlOracle Directory Manager, Oracle Data guard

Languages: SQL, PL/SQL, Java and UNIX Shell

GUI: Java and Visual Basic

Others/Tools: Toad, Sql Navigator, Quest Spotlight, Attachmate/Reflection X

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, Delaware

Sr. Database Administrator

Environment: Oracle11G,10g,9i Linux, Sun Solaris UNIX, AIX, Oracle RAC on 11gR2,, PL/SQL

Responsibilities:

• Managing Oracle 11g databases which are having maximum size of more than 40TB
• Application, SQL, and database instance tuning using a wide range of technologies including ADDM, AWR, Stats pack, extended SQL trace (event 10046 trace files), CBO analysis (event 10053 trace files), OEM Performance Manager, and custom scripts.
• Managing RAC four node Oracle 11gR2 environments on Linux platform.
• Oracle database migration from Oracle 10g to Oracle 11g
• Table space point in recovery using RMAN and user managed scripts
• Convert Non ASM file system to ASM and vice versa

Confidential, New Jersey

Lead Database Administrator

Environment: Oracle11G,10g,9i,8i Linux, Sun Solaris UNIX, AIX,PL/SQL

Responsibilities:

• Database Installations and Upgrades (8i and 9i to 10g, 10.1.0.2patchset to 10.1.0.4 Patchset, 10.1.0.4patchset to 10.1.0.4.2 /10.1.0.5 patchset and 10.1.0.4.2 patchset to 10.2.0.0patchset Oracle 9i,10G to 11g)
• Handling Critical, Emergency Issues in All Production Environments and On Call Support over the weekend
• Defining the project, analyzing the risk, working with project manager to prepare the project plan.
• Identifying the issues and working with the team to find solutions.
• Attending weekly meeting with the team to discuss the issues.
• Attending weekly meeting project manager and manager to assess the progress
• Critical Patch Update on all Oracle Collaboration Suite Components in every quarter
• Capacity Planning for all the Production and Stage Servers (Performance Analysis, Storage Growth and Automatic Storage Management and Grid Implementation)
• Gather Database and User Level Statistics and Analyze Overall System Performance
• New Production/Development/Test Environment Setups (Cluster and Non-Cluster)
• Handling Oracle 8/8i/9i/10g/11g software installation and database creation for production, development and test environment
• Applying Database patches
• SQL/Database Instance Tuning by running STATSPACK and AWR/ADDM reports and analyzing, recommend any changes
• RMAN Database Backup/Recovery - Monitoring hot backups and Monitoring Archivelog Destinations
• Managing Data Guard and Standby Setups in high availability mode.
• Table space Management, objects creation, and user management
• Implements and provides direction for all Oracle advanced security related initiatives, vulnerabilities etc. Conduct periodic SOX review and remediate deficiency uncovered during the review.
• Hands on experience on database replication using Shareplex replication technology from quest .Managed Shareplex for keeping databases for real time synching.
• Replication Setups, Configurations and Data migrations
• Creating Pl/Sql Packages, Stored Procedures, Stored Functions, Database Triggers .
• Users Integration Checking, Adding users, Modifying Users attributes, Deleting Users, Indexing Attributes in LDAP Environments
• Shell Scripting for monitoring System Synchronization, Database growth size, monitoring free space availability Confidential Database level and Confidential Disk Level, Backups, Performance and Log rotations
• Working with UNIX team for supporting/maintaining existing systems. Also for new systems in order to configure servers for Oracle software and databases. Used systems range from standalone Solaris/Linux server, Highly Available symmetric VCS clusters, Highly Available asymmetric VCS clusters and RAC ready clusters using Veritas.
• Managing ASM instances on RAW files system environment
• Managing mission critical applications on RAC environment keeping the entire alert monitoring up to date.

Confidential, NJ

Sr. DBA /Team Lead

Environment: Oracle 9i, 10g, LINUX, UNIX (Sun Solaris), PL/SQL

Responsibilities:

• Provide CORE DBA support for Confidential applications
• Work within the production support team and maintain operational consistency and efficiency
• Provide input to the Project and Enhancement teams to define database storage structures (tablespaces) after application developers have designed an application
• Implementation of reviewed changes to the production databases
• Provide primary DBA support to Production /Development and Test Applications.
• Provide application DBA skills to identify and focus on strategic opportunities
• Creating primary objects (tables, views, indexes, snapshots, database links, etc) once application developers have designed an application
• Modifying the database structure as necessary, from information given by application developers
• Maintain system security
• Handling Oracle 8/8i/9i/10g/11g software installation and database creation for production, development and test environment
• Controlling and monitoring user access to the database
• Monitor and optimize the performance of the database
• Maintaining archived data
• Collaborate with Enhancement and Production support teams to verify all instances are healthy and up
• Monitor new alert log entries for any issues (ex. ORA-600 errors, frequency of log switches and archiving status)
• Verify success of database backup and archiving
• Verify enough resources for acceptable performance
• Monitoring objects validity and Usage
• Analyzing database objects and Generate statistics periodically
• Monitoring security policy violations
• Look for harmful growth rates
• Review tuning opportunities
• Partitioned tables across hard disks and built proper indexes
• Tune SQL, I/O, Application and Database
• Review Data Fragmentation
• Development/Test Instances Creation and manage thereafter.
• Refresh Databases and Schemas with Production Database
• Migrating data from development data to Stage and then Stage to production

Confidential

Sr. DBA

Environment: Oracle 8i/9i, Linux, Unix, PL/SQL, SQL Loader, Oracle Forms, Oracle Report

Responsibilities:

• Responsible for Oracle7/8i/9i logical and physical databases design, implementation and maintenance on UNIX and NT
• Handling Oracle 8/8i/9i/10g/11g software installation and database creation for production, development and test environment
• Creating Users and Maintaining Security of the Database
• Moved database Schema changes to stage or production
• Developed some Unix Shell scripts to automate database operation and database monitoring
• Implemented database refresh with the hot backup using DUPLICATE or full export
• Used EXPORT/IMPORT to do table level and full database defragmentation
• Provided on-call production database support
• Creating Indexes and Monitoring Performance
• Data loading using SQL Loader (from Text files to Database)
• Perform Daily Logical backups using exp
• Perform RMAN operations (Level 0 and Level 1 Backups)
• Coding PL/SQL, SQL and Unix Scripts
• Server and Clients Installations for New Clients
• Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC
• Performed SQL Tuning by using explain plan and TKPROF
• Daily Monitoring Database and Tablespaces Growth and Monitoring Space Availability Confidential Operating System
• Trained a new DBA in our environment

Confidential

PL/Sql Developer, Junior DBA

Environment: Pl/Sql, Oracle 7 and 8i Unix, and Windows.

Responsibilities:

• Database Design and Creation of Database Objects and Creating Users and Maintaining Security for various Teams
• Coding and Testing
• Perform Periodic Database Backups
• Database and Application Maintenance