We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

Dallas, TX

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

Hire Now