SUMMARY

• 11 Years of experience as an Oracle DBA, working with 24X7 production, QA and development databases of versions 12c/11g/10g/9i/8i on various platforms including Red Hat Enterprise Linux, Solaris, HP - UX, AIX and Windows
• Experience with design and administration of large Oracle database, set up critical, secure and complex database for pharma environment
• Worked extensively in Oracle Database Administration and management, systems architecture and RDBMS on diverse operating systems
• Extensive experience in carrying DBA activities such as Oracle Server installation, database creation, Backup and recovery, RMAN Backup, Database tuning, Problem solving, Database Upgrades and Migration, Cloning, Patching, Client/server connectivity.
• Experience in designing backup strategies using RMAN and Data Pump (Expdp and Impdp)
• Implemented backup policies, recovery and restoration procedures
• Excellent knowledge in Hot/Cold Backup, recovery and Cloning of databases using RMAN
• Efficiently worked on Database Migrations associated with various Oracle versions
• Performed database upgrades from 9i, 10g to 11g and 12c
• Skilled in setting up Physical Standby Database, Data Guard and Active Data Guard
• Performed database switchover and failover
• Completed cross platform migration such as: Windows to Linux, HP-UX to Linux and Solaris to Linux
• Experience in interacting with the UNIX, Linux, Networking, Application and Business Teams to get database environment setup
• Extensive experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM
• Experience in PL/SQL and Shell scripting.
• Hands-on experience withOracle 10g/11g RAC Administration
• Worked on RAC database refresh and RAC to non RAC database refresh
• Hands-on experience using Oracle 12c cloud control for database monitoring and maintenance
• Implemented Oracle Advanced Security features like TDE (Transparent Data Encryption), Data Vault and Audit Vault
• Strong experience working within teams and providing core guidance to effectively and resourcefully plan and execute projects

TECHNICAL SKILLS

Operating Systems: Linux, Solaris, Windows, HP-UX, IBM-AIX

RDBMS: Oracle 9i, 10g, 11g, & 12c

Languages: SQL, PL/SQL

Tools: Remedy, Service Center, Service Now, TOAD, OEM

Tuning tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR

Others: RAC, ASM

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

• The Software Defined Data Center (SDDC) database team is responsible for migrating about 10,000+
• Oracle databases residing on various datacenters across the globe under JnJ subsidiary to Amazon’s Virtual
• Private Cloud (VPC) in the EMEA/ASPAC/NA region. It indirectly also supports the large number of applications running on these databases, providing support to clients for Database related issues for all the four environments Production, Stage, Test & Development.

Confidential, Raritan, New Jersey

Oracle Database Administrator

Responsibilities:

• Perform database migration activities using Export/Import, Transportable tablespace, Golden Gate as well as lift & shift (v2v) for migrating the database
• Set up encryption for databases that run financial systems
• Provided solution and then implemented tablespace level compression to reduce the database size
• Manage and set up Data Guard environment in SDDC, for both 11g and 12c databases
• Built Data Guard with all protection levels
• Used RMAN incremental restore process to reduce the down time for cut-over, and to eliminate Archive log missing issues
• Created a Run-book and troubleshooting guide to effectively manage common issues during Data Guard build
• User and Role management and compare privileges between pre-and post migration
• Produced knowledge article to handle Domain Indexes during migration
• Database export/import and evaluating the Backup and Recovery Procedures periodically and performing backups using RMAN

Confidential, New Jersey

Oracle Database Administrator

Responsibilities:

• Performed Database Administration activities such as space management in database, user and roles administration, schema management, checking alert log of the databases
• Database export/import and evaluated the Backup and Recovery Procedures periodically and performed backups using RMAN
• Migrated 200+ large databases from Wyeth to Pfizer data center and efficiently led the entire team
• Performed Database clone and Refresh using RMAN duplicate database
• Conducted database upgrades from 9i, 10g to 11g
• Worked on new database installation and configurations
• User account and schema management. Creation/retirement/refresh/migration of Schemas around different environments
• Applied PSU and CPU patches using OPatch
• Tested various purging scenarios and reclaimed unused space
• Management of schemas, objects partitioning the tables & indexes
• Used Data Pump Import/Export to move large amounts of data and performed database cloning when necessary
• Involved in design of databases
• Configured, created and managed Oracle Data Guard
• Database RMAN Backup and Restore and tapes identification for database refresh/restore
• Created standby databases using RMAN
• Hands-on experience in Oracle 10g/11g RAC administration
• Performed various restore and recovery of databases
• Deployment of scripts into Stage and Production environment following the Change Management processes
• Coordinated with UNIX team and worked on Server/database outage and implementing Server/DB Level Blackouts
• Performed DB patching, Cloning, DB Installation, troubleshooting issues/errors/incidents, and collaborated with Oracle support for bugs & issues resolutions
• Provided 24/7 on-call support

Confidential

Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11gR2
• Implemented Oracle database backup & recovery solutions using RMAN
• Conducted overall maintenance of Oracle database, performance tuning, backup, recoveries and other database-related activities
• Upgraded the Oracle Database from 9i to 10g and 10g to 11g
• Implemented Data Guard to provide high availability of the database
• Extensive uses of Oracle Data pump Export/Import utility for moving data among the servers
• Implemented advanced feature of Oracle 10g such as Automatic Workload Repository (AWR) for monitoring database performance.
• Responsible for installing, upgrading, patching and configuring the Oracle environment
• Performed database export and import for porting tables across databases
• Day-to-day performance monitoring and tuning of database
• Performed Database Migration using RMAN
• Prepared Backup and Recovery plan
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backup
• Usage of Partitions to improve the query performance and manageability
• Monitored and troubleshot database issues
• Involved in upgrading the development and production databases to Oracle 10g
• Performed database cloning for various environments