SUMMARY

• Experienced and motivated professional seeking constant improvement in a renowned organization and eager to improve performance and design of database applications, by leveraging skills practiced over 9+ years in the field of Database administration and Information Technology along with the knowledge gained from master’s degree in computer science.
• My experience has scaled in providing client support, analysis, designing, development, testing, installation, migration, maintenance, and administration for oracle databases, which included understanding the requirements, upgrades, performance tuning, backup & recovery, cloning, and space management using ORACLE 19c/12c/11g/10g, performing the role of Oracle Database Administrator according to the set standards and timelines.
• Extensive knowledge on database administration for Oracle 19c/12c/11g/10g/9i versions with experience in very large - scale database environments and mission critical systems.
• Worked extensively on Very Large Databases (VLDB) ranging from 200 GB to 200 TB
• Experience in configuring and managing Oracle Real Application Cluster (RAC) with ASM, Data Guard for Oracle High Availability.
• Providing DBA support to multiple Cluster, Non-Cluster and ASM Database in production, development and Testing Servers in UNIX & Windows Environments.
• Installed, configured and maintained databases on EXADATA X2-2 half rack.
• Configured Database File System (DBFS) on EXADATA.
• Installed and configured Container and Non-Container 19c/12c databases, Installation and the concepts associated with 19c/12C database.
• Experience in Migration of Database from 10g to 11g, 11g to 12c and 12c to 19c.
• Worked on migrating databases from cross platforms windows, Solaris and Linux.
• Experience in upgrading Oracle databases from 10g to 11g, 11gR2 to 12c and 12c to 19c on OEL, RHEL, AIX and Solaris systems.
• Experience in Oracle Patching for 10G, 11G and 12c databases.
• Experienced in Oracle Apps Database administration R12, 11.5.10.
• Experience on Implementation, Maintenance of Oracle Apps R12.2. Expertise in Cloning, Patching using ADOP in 12.2
• Planning and scheduling Backups using RMAN (hot, cold and incremental backups)
• Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).
• Recovery of Databases (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, recovering from Block Corruption etc.)
• Installation and configuration of Recovery Catalog for multiple Databases.
• Experience in Uni-directional, Bi-directional and Integrated Capture data replication using GoldenGate.
• Experience in configuring Integrated Extract and Coordinated Replicat after upgrading GoldenGate software to 12.1.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases.
• Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, STATSPACK, SQL TRACE, SQL profiling and SPM.
• Experience in performing database related activities using Oracle Enterprise Manager Grid (OEM Grid).
• Implementation of Flashback Technology.
• Generate and interpret Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Knowledge of Exadata Smart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers. Installed, configured, and maintained databases on EXADATA X2-2 half rack.
• Managed Database Structures, Converted Logical data to Physical data, Storage Allocation, Table/Index segments, Rollback and undo segments, Constraints, Database Access, Roles and Privileges and Database Auditing.
• Experience with databasesecurity and auditing.
• Experience in SOX Controls, compliance reporting and audit validation.
• Experience using Erwin as a Data Modeling tool & Designing the ETL processes
• Worked closely with Development, QA teams to recommend appropriate changes to applications and coordinate in reduction of down time for the conversion.
• Experience in UNIX Shell Scripting for automating the DBA tasks.
• Hands on Experience working with Database Resource Management and Capacity Planning.
• Participated in 24 X 7 on-call rotation, off-hour production problem resolution activities.

TECHNICAL SKILLS

Databases Skills: Oracle 19c/12c/11gR2/10g, SQL Server 2008/2012/2014/2016 , PostgreSQL 9.4, 9.5, Replication, Migration planning and Implementation, Install, Patch and Upgrade, Backup and Recovery, Performance Monitoring, Analysis and Tuning, Disaster Recovery, Partitioning.

Database Advance Feature: RAC, Data Guard, ASM, Standby Database, Oracle Golden Gate, Quest Shareplex, Grid Control, OEM (GC), TOAD, SQL Developer.

Database Utility: RMAN, 12cOEM, 13cOEM, Export/Import, DataPump (expdp, impdp), SQL*Loader, DGMGRL, ASMCMD, OID, Oracle Data Vault, Oracle Key Vault, OVD, pgAdmin.

Performance Tuning: Grid control, AWR, ADDM, ASH report, Foglight, SQL performance analyzer (SPA), SQL Optimizer, STATSPACK and OS Watcher.

ERP: Oracle E-Business Suite 11.5.x, R12

Languages: UNIX Shell scripts, PL/SQL, SQL, Python

Operating Systems: Sun Solaris 10, 11 Red Hat Linux RHEL 4.x, 5.x, 6.x, 7.x and Windows 2008/2012, OEL, AIX, Exadata.

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration including Oracle 11g/12c/19cRAC.
• Handling long running sql queries and Performance Tuning, sql profiling, extensive usage of Oracle Hints for debugging the slow sqls.
• Installed, configured and maintained Oracle Real Application Cluster(RAC) and Enterprise Manager Grid/Cloud Control
• Developed 4 node RAC environments for a 100TB database and Implementing Data guard on this RAC environment with another RAC Standby Database.
• Applied patches and CPU regularly to keep the databases in current version.
• Worked with oracle support to report and resolve issues in production databases.
• Handling Tickets assigned via remedy queue and Oracle severity for critical DB Applications.
• Create and maintain shell scripts to backups and restore databases using RMAN and pgdump.
• Monitored/managed 4 node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery.
• Implementation of High Availability solutions with Oracle 12C RAC, Physical/Logical Standby Databases (DataGuard) and Replication using Golden Gate. Establishing standards, policies and procedures for Goldengate replication administration.
• Configure DG Broker setup for the data guard environments to assist automatic failovers.
• Responsible for installing and configuring Golden Gate 12.2 on Oracle Servers
• Monitored Goldengate using 12c Goldengate Plugin and wrote shell scripts for alerting GG process down alerts
• Worked as a Core DBA as migration specialist on Oracle 12cR1, 11gR2, OEM 13c, RAC, Data Guard, Linux.
• Performed monitoring of databases using OEM 12C. Generated AWR, ADDM, ASH, Foglight reports and taken Backups using OEM.
• Implementation and support of 11g and 12c migrations and upgrades from Oracle 11g databases to 12c, including RAC (Real Application Clusters) databases on HP-UX and Linux.
• Worked on Performance issues such as query/batch slowdowns and intermittent web spikes. Worked with application groups on High Load SQL Reviews and plans to improve query performance.
• Redesigned Oracle application architecture to prepare for migration to PostgreSQL environment.
• Developed procedures to migrate source code and data from Oracle to PostgreSQL
• Worked on Oracle Golden Gate to perform Real time production ETL processes

Environment: Oracle 19c/18c/12c/11g/10g on Unix/Windows, Golden Gate, OEL 7.x, 6.x,Red Hat Linux 7.5,6.0,5.8, OEM 13c,12c, RAC, Oracle Advanced Security, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations, OID, PostgreSQL 9.4, 9.5.

Confidential, GA

Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration including Oracle 11g/12cRAC.
• Installed and configured OEM Grid Control.
• Upgraded OEM from 12c to 13c.
• Installed, configured, and maintained Oracle Real Application Cluster (RAC) and Enterprise Manager Grid/Cloud Control
• Migrated 50+ databases from Exadata X2 and X3 machines to Exadata x6 machines.
• Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating Data Guard Exadata clusters for maximum availability.
• Extensive use of Veritas Cluster Services for high availability and disaster recovery purpose of cluster environments.
• Implementation of Maximum Availability Architecture (MAA) techniques, best practices and blue prints.
• Disaster recovery of Exadata Data Guard Physical Standby.
• Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of data file testing.
• Use of RMAN for backup operations with Exadata.
• Worked on X3-2 machine where backups, restores are run across all database instances in Exadata system with two or four RMAN channels allocated per instance.
• Created database objects like tables, views, synonyms, materialized views, stored procedures, packages using PL/SQL developer.
• Engineering implement and support builds of new clusters to use Oracle 11g/12c RAC on Linux. Including installing cluster ware, ASM (and shared disks) and creating new databases.Consolidation of ASM Disk Groups/Rebalancing.
• Configure DG Broker setup for the data guard environments to assist automatic failovers.
• Implementation and support of 11g and 12c migrations and upgrades from Oracle 11g databases to 12c, including RAC (Real Application Clusters) databases on HP-UX and Linux.
• Configured OS Watcher to collect operating system and network metrics which can be used to diagnose performance issues.
• Worked on Performance issues such as query/batch slowdowns and intermittent web spikes. Worked with application groups on High Load SQL Reviews and plans to improve query performance.
• Annual DR Exercise for various databases related to Key Financial applications.
• Maintained database security and audited database.
• Involved in SOX Controls, compliancereporting andaudit validation
• Install and configure PostgreSQL 9.x(9.4/9.5) on RHEL/CentOS Linux
• Creating PostgreSQL databases, Tables and doing user administration/security by creating and deleting users
• Configuring PgAdmin and using it for managing the database server
• Backing up and restoring databases in PostgreSQL
• Managed AWS Oracle RDS, PostgreSQL on EMC Storage in a data center environment.
• Configured Security group for EC2 Window and Linux instances and for puppet master and puppet agents.
• Experience with monitoring tools such as Cloud Watch.

Environment: Oracle 12c/11g/10gon Unix/Windows, Golden Gate, Oracle EXADATA X2-2 HALF RACK 4,7/Oracle 11g, Sun SPARC T4-1, Red Hat Linux 7.5,6.0,5.8, OEM 13c,12c, RAC, Oracle Advanced Security, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations, OID, PostgreSQL 9.4, 9.5.

Confidential, GA

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle Database 12c.
• Monitored/managed 2 node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery.
• Deploy the 12c agents on the target servers and add the target Configuration Items to monitor.
• Installed, configured Shareplex 8.6.2 on 2-node RAC servers.
• Maintained primary and standby databases using Shareplex replication.
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using datapump.
• Database Installation, Upgrades and Patching. Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto.
• Configure Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the dataguard status
• Upgrade existing 10g/11g databases to 12.1.0.1 machine using transportable tablespace method. Upgraded supported versions using DBUA (direct path upgrade)
• Configured 2 node RAC in Test and Production.
• Had good experience in migrating data using Exp, Imp, Expdp and Impdp.

Environment: Oracle 12c/11g/10gon Unix/Windows, Sun SPARC T4-1/T3-1, Red Hat Linux 5.8, AIX 6, OEM 12c, RAC, Oracle Advanced Security, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations, Shareplex.

Confidential

Oracle DBA

Responsibilities:

• Worked as an Oracle database administrator. My work included backup scheduling, backup monitoring, migration, up-gradation and cloning and 24*7 support of Oracle database environment.
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Table space monitoring, Performance monitoring and tuning for performance improvement and daily health checkup of the database using AWR, ADDM.
• My roles and responsibilities in the team included mentoring the team and giving cross technology trainings within the team to improve productivity of each individual.