SUMMARY:

• Over 12 Years of experience in IT Industry exclusively as an Oracle DBA. 8 years of USA onsite work experience as Oracle database Expert.
• Duties included database creation, up - gradation, Patching, cross platform database migration, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, script development, and documentation.
• Established best practices and best procedure for database administration & maintenance.
• Implementation, administration & maintenance of DELL Shareplex 8.2 Replication.
• Setup, configuration, & troubleshooting of Oracle Goldengate 11g & 12c replication.
• Database upgrade & migration using Goldengate.
• Expert in Oracle clusterware RAC 11.2 & 12.1 Installation, configuration, administration & troubleshooting.
• Setup and administration, failover of Physical & Logical standby Dataguard, 12c Snapshot Standby, 11g,12c Active data guard, bi-direction stream replication.
• Manage Backup and Recovery using RMAN & Storage solution EMC Replication Manager and NetApp. Performed several complicated recovery scenarios.
• Well versed with database duplication/cloning using RMAN.
• Proficient in complex SQL Tuning - SQLT, explain plan review and recommendations.
• Experienced in 24x7 database production support.
• ASM administration and migration of non ASM database to ASM using RMAN.
• Expert in Oracle Enterprise Manager (EM) 12c/13c, command line and GUI with solid experience as an EM administrator.
• Implement, configure, maintain, support and administer EM 12c/13c.
• Experience configuring, installing, deploying, and maintaining EM Agents
• Understand EM 12c plug-ins, management packs, provisioning and extensions.
• Technical design and architecture for Exadata X6 systems, Exadata expert with network, system administration, storage & database design,configuration.
• Providing technical troubleshooting on issues related to Exadata X6.
• Exadata X6 Patching, daily administration & maintenance.
• Migrating database to Oracle Exadata X6 Model.
• Managing 800 databases & administration of large DW databases of sized 30TB.
• Experience as a Database Administrator for Oracle 10g, 11g, 12.1 & 12.2.
• Expert in 12c Multitenant PDB/CDB setup, migration, administration & troubleshooting.
• Well versed with 12c advanced database security and partitioning.
• IT Security policy enhancement, Implementation of PCI & SOX compliance.
• Oracle 10g, 11g,12c RAC Database administration, configuration and maintenance.
• Proficient in structuring complex SQL queries,
• Strong Database & SQL performance Tuning experience.
• Experienced in leading several critical DBA related projects.
• Expert with datampump Export/import, RMAN cloning, duplication, DR setup.
• Expert in 11g,12c oracle database migration clusterware upgrade & patching.
• Strong database and sql performance tuning experience.
• Implementation of LDAP , Active Directory tool.
• Strong Troubleshooting, Problem solving, Analytical & Design Skills.
• Design, implementation and administration of databases in the public cloud environment Amazon AWS & Oracle cloud.
• Experienced in designing, implementing, and supporting Database as a service(DBaaS) in public cloud.
• Migrate & manage databases to Amazon AWS & Oracle public cloud.
• Excellent communication and problem solving skills.
• W orked closely with other teams like Unix, storage, Netbackup and Application Team.
• Worked in Oracle Database Administration, Maintenance, Creation, Configuration, Installation, Up-gradation, Patching, Cloning, Migration, Performance Tuning, Backup/ Recovery, Troubleshooting and other DBA related activities.

TECHNICAL SKILLS:

Operating Systems: SUN SPARC,, SUN Solaris 10, HP UX PA-RISC,HP-UX Itanium, HP UX 11.11,Linux x86,Linux X86-64, Linux PPC, IBM AIX 5L, SCO UNIX

RDMBS: Oracle 9i, 10g, 11g, 12.1.02; 12.2.0.1

Replication: Shareplex 8.2, Oracle Goldengate 11g, 12c;Dataguard

Tools: EMC Replication Manager 5.2, NetApp, Ignite monitoring, OEM Cloud control, SQL Loader, Oracle Datapump,RMAN,LAB128,WinSCP,Putty,Foglight, SQL-Developer,TOAD8.6,AWR,DP-SPI,Autosys,HP Open View, HP Service Desk, PL-SQL Developer 3.1, Service center,Remedy, DASH; Spectrum, Active Directory.

Storage: SAN, Hitachi, XIV, EMC, NetApp, Exadata,ASM

Clusterware/Netbackup: RAC, Automatic storage management ASM, Veritas Volume Manager 4.1, Veritas Cluster 4.1,Veritas Netbackup, Oracle Clusterware, RAW Devices, Tivoli Storage Manager,EMC Replication Manager 5.2, NetApp

Enterprise Manager: 12c EM Grid & 13c cloud.

Engineered System: Oracle Engineered System X5 & X6 Model.

Cloud: Amazon AWS, Oracle, Microsoft Azure

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Senior Database Administrator

Responsibilities:

• Perform and troubleshoot database backup, recovery, capacity, and security plans.
• Database creation, up-gradation, Patching, cross platform database migration, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, script development, and documentation.
• Administer, maintain, and implement changes to existing databases to meet customer requirements.
• Manage Backup and Recovery using RMAN & Storage solution EMC Replication Manager and NetApp. Performed several complicated recovery scenarios
• Respond to test and production database problems and implement immediate resolution efforts across technology areas.
• Implementation, administration & maintenance of DELL Shareplex 8.2 Replication.
• Setup, configuration, & troubleshooting of Oracle Goldengate 11g & 12c replication.
• Database upgrade & migration using Goldengate.
• Serve as a communications liaison between the business customer and the technology development and support groups.
• Setup and administration, failover of Physical & Logical standby dataguard, 12c Snapshot Standby, 11g,12c Active data guard.
• Documenting and communicating assigned work progress to immediate project team, and management.
• ASM administration and migration of non ASM database to ASM using RMAN.
• Communicate problems or issues in a timely manner, manage resolution of problems and escalate as required.
• Expert in Oracle Enterprise Manager (EM) 12c/13c, command line and GUI with solid experience as an EM administrator.
• Implement, configure, maintain, support and administer EM 12c/13c.
• Experience configuring, installing, deploying, and maintaining EM Agents
• Understand EM 12c plug-ins, management packs, provisioning and extensions.
• Technical design and architecture for Exadata X6 systems, Exadata expert with network, system administration, storage & database design,configuration.
• Providing technical troubleshooting on issues related to Exadata X6.
• Exadata X6 Patching, daily administration & maintenance.
• Migrating database to Oracle Exadata X6 Model.
• Employ productivity aids in all aspects of assignments, analyze and resolve problems of medium complexity. Research and recommend alternative actions for problem resolution, with minimal supervision.
• Design, implementation and administration of databases in the public cloud environment Amazon AWS & Oracle cloud.
• Experienced in designing, implementing, and supporting Database as a service(DBaaS) in public cloud.
• Migrate & manage databases to Amazon AWS & Oracle public cloud.
• Performing UNIX Shell scripting..
• Working with Database Export/import, RMAN cloning, duplication, DR setup.
• Managing 800 databases and administration of large DW databases of sized 30TB.
• Oracle 10g, 11g,12c RAC Database Installation, administration, configuration and maintenance.
• RAC clusterware 11.2,12.1 & 12.2 upgrade.
• Implementing moderately complex changes to existing databases.
• Expert in 12c Multitenant PDB/CDB setup, migration, administration & troubleshooting.
• Well versed with 12c advanced database security and partitioning.
• Experienced in leading several critical DBA related projects.
• Implementation of LDAP , Active Directory tool.
• Installing and configure new database engines and upgrades to new product releases 11.2.0.4 & 12.10.2,12.2.0.1
• IT Security policy enhancement, Implementation of PCI & SOX compliance.
• Implement physical data models at a project level.
• Working on oracle database migration, upgrade & patching 11g,12c.
• Create, document, and administer, and document database backup and recovery plans, capacity plans and security plans to meet project requirements.
• Proficient in complex SQL coding and complicated Performance Tuning.
• Administration and maintenance of Oracle Database 10g, 11g & 12c.
• Oracle RDBMS installation, up-gradation & patching on different Oracle versions.
• Performing through Performance Tuning of Database.
• Database backup and recovery using both RMAN and Storage copy.
• Performing major Application release and implementing major Database related changes.
• Database Cloning, RMAN duplication,11g Active cloning, active duplication for DR.
• Managing Data warehouse large databases on a daily basis (> 30 terabyte ),
• Documenting step by step procedures for new release installation, upgrade, patches.
• 24X7 primary On-call support based on a rotation.
• Applying Critical CPU patches, PSU and DST Patches on every quarter.
• Performance Tuning of database, Performance tuning of Sql /Pl- SQL query.
• Configuring & monitoring Backup and Recovery using RMAN and Storage method.
• Creating effective UNIX shell scripts for Oracle DB monitoring & administration.
• Well versed in working with Oracle Support to resolve any unidentified issue.

Confidential, Dallas, TX

Senior Database Administrator

Responsibilities:

• Oracle software installation, up-gradation, patching on different Oracle versions.
• Installation & configuration of new Shareplex Bidirectional replication setup.
• Performing through Performance Tuning of Database.
• Up-gradation of databases from oracle 9i to oracle 10g, 11g& 12c.
• Database creation, migration and capacity planning.
• Implementation and administration of Oracle Goldengate 11g
• Database backup and recovery using both RMAN and SRDF copy.
• Performing major Application release and implementing major Database related changes.
• Extensive experience in Database Cloning, RMAN duplication, 11g Active cloning, 11g active duplication for DR.
• Configuration and maintenance of One directional and Bi-directional Shareplex replication.
• Performed Export/Import, Data pump Export/Import for oracle 9i/10g,11g databases.
• Managed Data warehouse large databases on a daily basis (> 18 terabyte), supporting 600 databases. Worked on Data Guard, and Oracle RAC 10g,11g systems.
• Oracle 10g & 11g RAC Database administration, configuration and maintenance.
• Installing & managing of oracle clusterware and RAW Devices.
• Creation of physical standby DR and logical standby reporting databases.
• Administration and maintenance of Logical standby reporting and Physical standby DR databases.
• IT Security policy enhancement through role & priveleges, Implementation of PCI & SOX compliance.
• Administration of oracle Bidirectional Streams replication.
• Worked with OEM Grid Control, configured agent in different Host for monitoring.
• OEM 12C cloud control.
• Worked on OEM production Grid configuration, administration and maintenance.
• Documenting step by step procedures for new installation, upgrade, patches etc.
• 24X7 primary On-call support. Applied Critical CPU patches, PSU and DST Patches.
• Database sizing, Capacity Planning. Performance Tuning of database.
• ASM Instance creation, administration, maintenance. Migrate Databases to ASM Storage.
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan,10046 event etc.
• Leading several DBA projects
• Configured and implemented Backup and Recovery using RMAN.
• Working extensively on Oracle database partitioning.
• Performed/Tested different RMAN database recovery scenario as a part of disaster recovery drill. Performed several complicated recovery scenario in reality.
• Creating effective UNIX shell scripts for Oracle DB monitoring & administration.
• Database Cloning/refresh from production to test and development environments using SRDF, RMAN and Import utility.
• Implemented Oracle Advanced Replication using snapshots, materialized views.
• Database Reorganizations for better space management.
• Worked with Oracle support to resolve several complex Severity1 Database issues.

Confidential, Atlanta, GA

Senior Database Administrator

Responsibilities:

• Performing through Performance Tuning of Database. Up-gradation of databases to 11g.
• Database creation, migration and capacity planning.
• Oracle software installation, up-gradation, patching on different Oracle versions.
• Database backup and recovery using both RMAN and Storage solution.
• Performing major Application release and implementing major Database related changes using Service centre.
• Oracle 11g RAC Database administration, configuration and maintenance.
• Creation, administration & maintenance of physical standby DR and logical standby reporting databases.
• Worked with OEM Grid Control configuration, administration and maintenance.
• Documenting step by step procedures for new installation, upgrade, patches etc.
• Database sizing, Capacity Planning. Performance Tuning of database.
• Performance Tuning of Oracle Database & SQL statement.
• Backup & Recovery Solution using RMAN. Performed several complicated recovery scenario in reality.
• Creating effective UNIX shell scripts for database monitoring & administration.
• Database cloning from production to test and development environments using SRDF, RMAN and Import utility.
• Implemented Oracle Advanced Replication using snapshots, materialized views.
• Database Reorganizations for better space management.
• Oracle partitioning management.

Confidential, Philadelphia, PA

Senior Database Administrator

Responsibilities:

• Performing through Performance Tuning of Database.
• Up-gradation of databases from oracle 9i to oracle 10g & 11g.Database creation, migration and capacity planning.
• Database objects creation, maintenance, problem diagnostics and resolution.
• Oracle software installation, up-gradation, patching on different Oracle versions.
• Database backup and recovery using both RMAN and SRDF copy.
• Performing major Application release and implementing major Database related changes using Service centre. Database monitoring script development.
• Performed Export/Import, Data pump Export/Import for oracle 9i/10g&11g databases.
• Managed Data warehouse large databases on a daily basis (> 8 terabyte).
• Supported more than 500 databases of GMAC spread across the various environment like Development, Staging and production.
• Implemented Oracle 10g RAC for mission critical Application.
• Oracle 10g RAC Database administration, configuration and maintenance.
• Managing oracle clusterware and RAW Devices. Database sizing, Capacity Planning.
• Creation of physical standby DR and logical standby reporting databases.
• Administration and maintenance of Logical standby reporting and Physical standby DR databases. Administration of oracle Bidirectional Streams replication.
• Worked on OEM production Grid configuration, administration and maintenance.
• Documenting step by step procedures for new installation, upgrade, patches etc.
• 24X7 primary On-call support. Applied DST patches Applied Critical Patches Update (CPU) every quarter.
• Physical and Logical database design.
• Performance Tuning of databases & SQL queries.
• Creating effective UNIX shell scripts. Performed various UNIX Administration tasks.
• Database Cloning/refresh using SRDF, RMAN and Import utility.
• Implemented Oracle Advanced Replication using snapshots, materialized views.

Confidential, Torrance, CA

Database Administrator

Responsibilities:

• Database objects creation, maintenance, problem diagnostics and resolution.
• Developing database scripts/shell script for Database monitoring and maintenance.
• Performing core DBA activities for 50 mission critical production databases.
• Managed large Data Warehouse databases on a daily basis (> 4 terabyte).
• 24X7 primary On call support.
• Installing of Oracle 9i and Oracle 10g on Solaris 9 and HP-UX Itanilum Platform.
• Creation, Configuration and maintenance of database on Unix environment.
• Implementing major Database releases and changes.
• Performance Tuning of database, Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, SQL Advisor. Worked very closely with development team.
• Applying DST patches to the Database on UNIX and NT environment.
• Applying quarterly Security Patching for production Databases.
• Well versed in working with Oracle Support to resolve any unidentified issue.
• Database sizing, Capacity Planning.
• Extensive experience in testing and implementation of enterprise level Backup and recovery strategy using RMAN and Import/Export Utilities.
• Performed different RMAN recovery scenario as a part of disaster recovery drill.
• Developing shell script to perform Online/Offline RMAN backup and Recovery.
• Loading Data into the Databases using Sql-Loader.
• Performing through Performance Tuning of Database.
• Optimizing SQL/PL-SQL queries for better Performance.
• Performing in depth analysis of database performance during the peak activity, identify bottleneck, finding the best solution and implement the best solution in the Production.
• Extensive experience of cloning the production Databases using RMAN, Import.
• Upgrading database from Oracle 9i to 10g using manual approach.
• Configuring OEM Database Control in Production for 10g databases.
• Implementation of several new features of 10g for the Databases.
• Configuring and maintenance of Database monitoring Tools FOGLIGHT and DP-SPI with HP Openview database monitoring Agent.
• Perform routine DBA activities like maintaining Space, Schema management and troubleshooting the Databases issues and solving the Incidents.
• Migration of databases from Stage/Dev platform to the production environment, configure backup, creation of database monitoring scripts for the migrated databases.
• Troubleshooting Oracle Database issues for mission Critical Production systems