SUMMARY

• Diligent Oracle DBA with 8+ years of proven experience in maintaining databases running on various platforms with providing high availability of data to the end users.
• Comprehensive experience as Oracle DBA, especially in Exadata, Oracle Golden Gate, Data Guard, Oracle RAC, proficient in Oracle 10g/11g/12c/18c/19c software installations, migrations, database capacity planning, automated backup implementation, performance tuning on Linux/Unix, Windows and Exadata platform.
• Extensive knowledge on database administration for Oracle 10g, 11g, 12c, 18c, 19c with experience in very large scale database environments and mission critical large OLTP and OLAP systems.
• Provided architecture design and implemented all production database replication, backup and contingency recovery strategies for all OLTP and OLAP Data Warehouse databases.
• Administrated and supported 200+ global development and production Oracle 11g, 12c and MS SQL server databases including Oracle ERP systems.
• Experienced with installation and maintenance of ORACLE 10g RAC/11gRAC/12c RAC and standby database for High Availability and Disaster Recovery purpose.
• Administered Oracle Clusterware and resources on 11g and 12c using CRSCTL/SRVCTL.
• Migrated OS file system storage to ASM with minimal downtime and administered ASM disks.
• Expertise in configuring Active Dataguard, Snapshot standby and troubleshooting issues and configuring Service Level Agreements for query’s accessing standby databases.
• Migrated databases into Exadata Machine with minimal downtime using Data guard.
• Proven experience in RAC Clusterware administration, Configuration and Patching.
• Expertise in configuring and implementing ASM and proficient in using ASMCMD and ASMLIB and configuring ASM disk groups using ASMCA and SYSASM.
• Migrated and upgraded Oracle Database from 11.2.0.4 on Solaris/Windows to 12.2.0.2 on Linux environment using Datapump and Bi - Directional Golden Gate replication.
• Setup Oracle Enterprise Manager (OEM) 11g & Grid Control (12c) for database monitoring/performance/diagnostics.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Proven Experience in installing and administrating RAC environments on Oracle Exadata .
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc .
• Implemented new Exadata Machine features like smart scan, Flash Logging, Storage Index, HCC and enabling Smart Scan on Exadata Databases.
• Worked on Exadata Database Machine X3-2, X4-2, X6-2, X6-4, X7-2
• Experienced in Patching and Upgradation from 9i, 10g, 11g, 12c, 18c .
• Good experience in Patching PSU and CPU Patches Quarterly and Upgradation of databases from versions from 10g, 11g to 12c and to 18c.
• Experienced in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• Extensive experience in Database Backups RMAN (F ull/Incremental backups) and in traditional hot/cold backups.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces .
• Involved in Building Oracle Global Data Services (GDS).
• Provided On-Call 24x7 production DBA support, application/development DBA.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers .
• Experienced in Database Refresh and patch management and in Database cloning with RMAN.
• Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams and providing technical directions to teams.
• Experienced and Strong knowledge in UNIX Shell scripting, and extensively used to automate jobs (Batch, Backups, Refresh etc.)

TECHNICAL SKILLS

RDBMS: Oracle 19c, 18c, 12c, 11g, 10g, 12cRAC, 11gRAC, SQL Server

Operating Systems: Linux (OEL), Redhat, Solaris, Windows, AIX

Hardware: Oracle Exadata X2/X3/X4/X6 Full rack and Half Rack machines.

Data Replication: Golden Gate (Uni-Directional & Bi-Directional)

High Availability: RAC, Data Guard, Golden Gate

Tools: & Utilities: OEM 13c, TOAD, SQL Developer, SQL* Loader, Data Pump, RMAN, TKPROF, Explain Plan, Statspack, ADDM, AWR, ASH, SQL Tuning Advisor, EXP/IMP, ORACHECK, ORATOP

Web Technology/ Fusion Middleware: Oracle WebLogic, OBIEE

Languages: C, Java, PL/SQL, UNIX Shell Script, SQL

PROFESSIONAL EXPERIENCE

Confidential, Eagan, MN

Sr. Oracle Database Administrator

Responsibilities:

• As a Senior Oracle DBA provided advanced technical support to enterprise DBA team on Oracle database related technologies such as Exadata, Golden Gate, Streams, RAC, upgrades, migration, Performance Tuning, Backup and Recovery, RMAN, Partitioning, Oracle Enterprise Manager, SQL, PL/SQL, Code review and optimization, Materialized views, Flashback, troubleshooting, Data pump, RDBMS security, VLDB, optimize server resource utilization etc.
• Working with primary DBAs in the DB support team, support the mission critical OLTP and Data Warehouse production databases.
• Migrated Number of critical Oracle Databases from 11.2.0.4 running on sun Solaris server to 12.2.0.2 running on OEL.
• Installed 4 node RAC cluster on 12.2.0.2 and migrated the database from 11g to 12c using Golden Gate, RMAN and DATA Pump.
• Installed and configured High Availability Oracle Golden Gate (OGG) systems on Oracle 11gR2 and 12c RAC environments (Front-end Sun SPARC Server, Back-end Oracle Exadata Full Rack).
• Upgrade Oracle Golden Gate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.
• Involved in database troubleshooting and maintenance activities and resolved Golden Gate issues such like abended, lagging, long transaction issues.
• Installed ASM environment and migrated database from Non-ASM to ASM.
• Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA).
• Expert in SRVCTL and CRSCTL to manager RAC environment activities.
• Installed and configured 12c & 13c Oracle Enterprise Manager (OEM) and monitored top SQLs.
• Migrated Oracle database 12c to 18c from Linux Boxes to EXADATA 6-2 machine using Golden Gate and Export &Import.
• Installed OJVM patch on 12.2.0.2 databases on Exadata X3 environments before migrating it to Exadata X6 machines to match with Bundle patch version.
• Worked with Storage team in configuring NetBackup and Data domain on Exadata X6.
• Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.
• Installed and configured oracle 18c database and migrated the data from 12c to 18c using Oracle Golden Gate Bi-Directional Replication.
• Configured GoldenGate downstream mining and integrated components for Active-Passive and Active-Active replication.
• Configured GoldenGate High availability using Oracle DBFS and Active Dataguard.
• Experienced in performing Point-in-Time Recovery .
• Installed and Configured GoldenGate JAgent to work with OEM GoldenGate plugin.
• Configured Dataguard for high availability/disaster recovery purpose and configured to switchover and failover.
• Configured Physical Standby databases using data guard in maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c, 18c accordingly.
• Installed Oracle Global Data Services (GDS) for managing workloads.
• Involved in Global Service Manger (GMS) Listener setup to incoming database connections.
• Created GDS catalog database on GSM server and setup Administrative accounts & granted privileges and Configured GDS pools accordingly and configured client Connectivity.
• Deployed GDS Services and created GDS admin user and catalog user and granted roles and privileges accordingly and used GDSCTL to configure and added listener services of catalog database and added the services and made sure that GDS connectivity is in TNS entry.
• Installed Oracle 19c in Test Environments and configured fully functional 19c database.
• Exposed Oracle 19c new features and documented all the related functionalities for other DBA’s.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand-alone instances.
• Developed UNIX shell scripts and setting up cronjobs that automate database monitoring.
• Executed and provided ADDM, AWR and database health check reports to information owners and recommended solutions for improved performance.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Partitioned large tables for better performance and manageability.
• Applied CPU Patches and PSU Patches.
• Created User accounts, Roles and granting required access permissions and privileges to users.
• Cloned/Refreshed Oracle Databases and Oracle Applications when needed.
• Provided 24X7 support for all the production and development databases.

Environment: Oracle 19c/18c/12c/11g, SQL Developer, Toad, Mobaxterm, GoldenGate, DataGuard, RAC, RMAN, DataPump, Exadata, AWR, ASH, ADDM, Putty, Servicenow

Confidential, Minneapolis, MN

Sr. Oracle Database Administrator

Responsibilities:

• Provided architecture design and implemented all production database replication, backup and contingency recovery strategies for all OLTP and OLAP Data Warehouse databases.
• Installed and Configured 4 Node RAC on 12.2.0.2 and administrated databases and maintained high availability of data with minimal downtime.
• Adding a New Node to RAC cluster and Installed Oracle RDBMS software on new node of cluster and Created ASM Volume using ASMCA.
• Installed and configured transactional level DDL, DML, BI-DIRECTIONAL replication using GoldenGate.
• Performance tuning, GoldenGate replication and used Log dump and report files for troubleshooting.
• Implemented GoldenGate Replication 11g/12c on ACFS and configured for Automatic failover of GoldenGate process and Handy in upgrading GoldenGate from v11 to 12c.
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Provide and implement performance tuning recommendations of all components in Exadata.
• Advice, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Working on Exadata X6 and X4 machines which included Half Rack and Full Rack
• Configured and modified Exadata x6.2 machines as per confidential requirement and specifications after Oracle handed over the standard Exadata machines.
• Involved in Upgrading and Migrating 15TB of Oracle databases on Oracle 11g, 12c.
• Analyzed the user requirements and designed partitioned tables for improving performance of Data Marts.
• Performed Partition Maintenance and automated the process of creating new Partitions as and when required.
• Used OEM 11g and 12c grid control for monitoring multiple databases and notification of database alerts and configured EM agents on multiple database servers.
• In-depth understanding Oracle Goldengate internal mechanism, OGG new features such as integrated capture, coordinate apply mode, multi-threaded replication. Developed home cooked OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM
• Performed Daily Monitoring of Oracle Instances, monitor users, and Table spaces, Memory Structures, Rollback Segments, Logs and Alerts
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Configured backup & recovery solutions using RMAN and NetBackup, Troubleshooting RMAN and resolved issues, performed Block Recovery, Data file Recovery.
• Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory.
• Performed health checks and monitored logs and CPU, memory, I/O and disk usage on production and application servers.
• Performance tuning of databases using AWR, ASH reports, ADDM reports, provided instance level performance monitoring and tuning for Event Waits, Sessions.

Environment: Oracle 12c/11g, RAC, Exadata, OEM, RMAN, DataPump, GoldenGate, ASM

Confidential

Oracle Database Administrator

Responsibilities:

• Administrative maintenance, monitoring on Oracle database systems in a global 24x7 environment. Worked in Real Application Clusters (RAC), ASM, RMAN, and Data Guard and maintain Standby database.
• Performed health checks of RAC Clusterware components OCR, voting files and backups using ocrconfig.
• Installed, configured and maintained Oracle 12cR2 Real Application Cluster (RAC) 3 node RAC, migrating single Instance Databases to 3 Node RAC environments.
• Installed the 3 node RAC for the 12c database and administered the 12c databases on these RAC servers.
• Administration and troubleshooting 11g and 12c RAC Clusterware using Clusterware logs. Worked with VMware team in building new servers, performing Clusterware installation, and RAC RDBMS installation.
• Experience in logical backups and database migration tools with Data Pump, Export/Import and Transportable Tablespaces.
• Configured Physical Standby databases using Data Guard in maximum performance & max availability and Converted Physical standby to Snapshot Standby in 11g, 12c.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools such as AWR, ASH, SQL-Trace, Tkprof, ADDM, SQL tuning using Explain Plans and Hints.
• Performed Zero-Down Time migration from AIX to RHEL using Expdp and GoldenGate and process improvement for GoldenGate by proactive monitoring using Shell scripts.
• Used GoldenGate 12c new features: Configured Integrated Extract, Integrated Replication coordinated replication Oracle multitenant database 12.1.0.2.
• Implemented GoldenGate Replication 11g/12c on ACFS and configured for Automatic failover of GoldenGate process and handy in upgrading GoldenGate

Environment: Oracle 12c/11g, RAC, DataGuard, GoldenGate, DataPump, ASM, AWR, ASH, RMAN.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed and configured oracle 11.2.0.4 database and upgraded the database from 11.2.0.2 to 11.2.0.4.
• Configured Active DataGuard and maintained physical standby databases.
• Troubleshooting Dataguard using Views, troubleshooting missing archive log scenario, patching Dataguard environment, applied logs with delay Configured Dataguard Broker and managed standby databases using DG broker.
• Worked on Exadata X2-2 and x3-2 machines and migrated databases using Expdp, GoldenGate and Dataguard.
• Worked on different Features of Exadata x3-2: Hybrid column compression, Smart scan, Flash Logging, DCLI, create and drop Flash disks, Flash Logging, Enabling Flash Cache Compression, Cell monitoring and Alerts, Cell Offload Efficiency, Hybrid columnar compression.
• Applied PSU and CPU Patches as per the requirements and when needed.
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via command line and GUI.
• Converted physical standby to Snapshot standby and back to physical standby.
• Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate.
• Experience in logical backups and Database migration tools with Data Pump, Export/Import and Transportable Table-spaces.
• Making sure that proper RMAN backups are in place as part of a daily job

Environment: DataGuard, GoldenGate, RMAN, DataPump, Exadata.

Confidential

Oracle DBA

Responsibilities:

• Installation, setup & configuration of Oracle 10gR2 RAC & single instance databases.
• Perform monitoring, administration & troubleshooting of Oracle databases.
• Monitor and troubleshoot database backups, disk space, and server availability.
• Setup, configuration and management of Oracle Enterprise Manager.
• Managed the databases using OEM.
• Monitoring the table space growth and resizing the table space
• Experience in moving the data from one server to another server using SFTP, FTP and SCP.
• Involved in construction of Disaster Recovery (DR) for all the production databases.
• Grant and Revoked user privileges and roles as per requirement and killed blocking session.
• Installed Standalone servers on ASM and migrated databases to ASM.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Contact to the development team to solve the issues with the new enhancement releases.
• Installation, configuration, upgrade and performance tuning of Oracle RAC.
• Managing Schema Objects like Tables, Views and Indexes.
• Making database backups and performing recovery when necessary.
• Managing the database storage structures.

Environment: Oracle 10g, RAC, DataGuard, ASM, DataPump, RMAN, OEM