SUMMARY

• Oracle Certified Professional (OCP) with 14 Years of experience as Oracle Database Administrator providing 24/7 Production support/ Engineering for Oracle databases 19c/18c/12c/11g/10g/9i/8i on various Unix platforms like Solaris, HP - UX, Linux, AIX and Oracle Engineered System - Exadata, M7 Super Cluster .
• Designed and implemented Oracle Real Application Clusters (RAC) for a high transaction volume OLTP application with Transaction Application Failover.
• Hands on experience on RAC database /EXADATA maintenances such as patching / disk replacement / supporting hardware failure repair/ performance issues.
• Configured Hybrid columnar compression / Flash cache compression. Also created Cell/ Grid disks in Exadata.
• Experience in Oracle 12c database consolidations. Implemented Multi-tenancy architecture in 12c, migrated databases from Non-CDB to Container/Pluggable databases.
• Expertise in setting up replication using Golden Gate, Streams and Materialized Views.
• Extensive experience in Installations, Configurations, Cloning, Patching, Upgrades, Performance Tuning, Backup-Recoveries, Data Archiving, DB Monitoring, Capacity Management, User Management, Index Management, Managing Data Dictionary Objects, and Database Troubleshooting and Oracle tools.
• Extensive experience in supporting very large and mission critical Oracle databases in both OLTP and OLAP environment with databases size over 40+ TB.
• Experience in deploying secondary and disaster sites with physical standby databases using Data Guard and Logical standby as well.
• Experience in Upgrading/Migrating Oracle databases to 10g/11g/12c versions.
• Perform necessary Co-ordination with Application team and other IS teams during the project life-cycle.
• Responsible for applying patches on Single / RAC database instances.
• Install and Manage Automatic Storage Management (ASM) Instances and databases on it.
• Responsible for performing Data guard switchover/failover and fixing GAP issues.
• Experience in Data Migrations using SQL Loader and DATA PUMP.
• Perform the capacity management for the Databases and Administering Databases of size in TBs.
• Troubleshoot Performance issues in databases using OEM and all available tools like AWR, ADDM, SQLT, SPM and other functions/ packages.
• Experience in Database level tuning using SAR reports, TOP, IOSTAT, VMSTAT, Session wait monitoring etc
• Perform Table Partitioning activities such as Addition, Merge, Split, Exchange and Drop partition.
• Involved in and successfully performed a number of restore and recovery operations.
• Configuring Database maintenance scripts and new shell scripts for the requirement.
• Successfully performed database cloning using RMAN and disk mirroring.
• Good Knowledge in Configuring and Maintaining Database Backup Strategies. Also configured and restored databases using Flashback.
• Creation of roles, granting privileges and profiles based on Application design.
• Coordinating with various teams and Oracle support during Sev-1 issues.
• Provided On-Call support and resolved many priority Incidents.
• Involved in Problem management and provided Service Improvements.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Result oriented, self-motivated, team player with ability to work independently. Managed a team of 20+ members across locations - Offshore, Nearshore and Onsite as Technical Lead.
• Excellent analytical and problem-solving skills with good written and verbal communication skills.

TECHNICAL SKILLS

Operating systems: Red hat Linux, Sun Solaris, IBM AIX, HP UX

Databases: Oracle 8i/9i/10g/11g/12c/18c/19c

Database tools & Utilities: RMAN, Datapump, Dataguard, Streams, RAC, ASM, Materialized views, SQLLoader, SRVCTL, EMCTL, CRSCTL, AWR, ADDM, DBArtisan, TOAD, OEM, DBCA, OUI, SQLT, Opatch, Golden Gate and Exadata.

Languages: Unix shell scripts, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Exton, PA

Senior Database Administrator

Environment: Oracle 10g/11g/12c/18c/19c on RHEL, Solaris,Windows

Responsibilities:

• Experience in Oracle 12c database consolidations. Implemented Multi-tenancy architecture in 12c,18c,19c and migrated databases from Non-CDB to Container/Pluggable databases.
• Designs, installs, configures and maintains High Availability (RAC, Data Guard etc.) Database solutions.
• Performs installations and configurations of grid infrastructure, databases, clients etc.
• Designs and maintains access and security administration. Configured Encryption for the databases.
• Designs, implements and maintains backup and recovery strategies on Database Management Systems.
• Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
• Manage databases on Oracle M7 Super clusters.
• Performs upgrade of databases to Oracle 12c
• Expertise in setup using OEM as a monitoring and diagnostics tool and identifies/resolves the performance issues.
• Performs capacity planning of Oracle server environment and provides recommendations to management to sustain business growth.
• Designs, implements, maintain Disaster Recovery (DR) methodologies and create documentation.
• Installed and configured replications using Golden Gate.
• Gathers business requirements and designs, implements multiple projects along with the production support.
• Creates standard operational procedures, templates and Qualification documents.
• Acts as mentor for Junior Database Administrators and Associate Database Administrators.
• Performs research and provides plans to remediate complex business problems.
• Assists the development teams to improve database design and procedures on PL/SQL best practices etc.
• Perform Node Fail over testing, D/R switch over activities during project life cycle.

Confidential

Senior Database Administrator

Environment: Oracle 9i/10g/11g/12c on Solaris, AIX, RHEL

Responsibilities:

• Experience in Upgrading/Migrating Oracle databases to 10g/11g/12c versions.
• Perform necessary Co-ordination with Application team and other IS teams during the project life-cycle.
• Experience in Oracle 12c database consolidations. . Implemented Multi-tenancy architecture in 12c, migrated databases from Non-CDB to Container/Pluggable databases.
• Expertise in setting up replication with Materialized Views, Streams.
• Experience in deploying secondary and disaster sites with physical standby databases using Data Guard and Logical standby as well.
• Hands on experience on Exadata Cell Maintenance / patching / hardware failure repair / performance issues.
• Configured Hybrid columnar compression / Flash cache compression . Also created Cell/ Grid disks in Exadata.
• Managing the database's storage structures like control files, redo log files, archive log files, tablespaces and datafiles.
• Managing users and security by creating roles and profiles.
• Managing the databases on Automatic Storage Management (ASM).
• Performing database cloning and restoration of very large sized databases using RMAN/Disk Mirroring.
• Perform Dataguard switch over for maintenance and special purposes.
• Perform Object and schema refreshes using data pump.
• Troubleshoot Performance issues in databases using OEM and all available tools like AWR, ADDM, SQLT, SPM and other functions/ packages.
• Experience in identifying TOP SQLs consuming OS and database resources and perform tuning using Unix/Linux utilities like SAR, IOSTAT, TOP, VMSTAT.
• Perform Table Partitioning - Addition, Merge, Split and Drop partition.
• Extensive performance tuning experience, SQL/ Database instance Tuning.
• Administering Databases of size in Terabytes.
• Analyze the database growth and perform necessary capacity planning.
• Analyze the Dataguard GAP issues and fix them.
• Hands on experience on RAC database maintenance.
• Good Knowledge in Maintaining Database Backup Strategies. Also configured and restored databases using Flashback.
• Experience in managing security through grants, roles, privileges and profiles.
• Experience in handling a team of 20 + members in offshore / Nearshore / Onsite.

Database Administrator

Confidential

Environment: Solaris, AIX with Oracle 9i/10g/11g

Responsibilities:

• Have Performed up-gradations from Oracle 9i/10g to 11g versions and migrations in Dataguard and RAC databases.
• Perform necessary Co-ordination with Application team and other IS teams during the life-cycle design.
• Creating, Configuring and deleting Oracle databases using the DBCA.
• Building Dataguard environments - Both Physical and Logical standby databases.
• Install one-off /PSU Patches and Bundle fixes on Single / RAC database instances.
• Install and Manage Automatic Storage Management (ASM) Instances.
• Installing and configuring RAC databases based on project need.
• Configuring Database maintenance scripts.
• Performed Dataguard switchover/failover.
• Perform the capacity management for the Databases.
• Administering Databases of size in TBs.
• Involved in and successfully performed a number of restore and recovery operations.
• Successfully performed database cloning from production to lower environments using RMAN and disk mirroring.
• Coordinating with various teams and Oracle support during Sev-1 issues.
• Provided On-Call support and resolved many priority Incidents.
• Configuring the Replication using MVIEWs and STREAMS.
• Creation of roles, granting privileges and profiles based on Application design.
• Involved in Problem management and provided Service Improvements.