SUMMARY

• 10+ years of experience in IT industry as Oracle Database administrator, having exclusive experience in database administration, installation, configuration and upgrades with Oracle Software 19c/12c/11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Hands on experience with database performance tuning, backup and recovery, cloning, space management, and database security.
• Good exposure in Configuring Single instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).
• Experience in configuring Oracle Multitenant Container Databases (CDB) and Pluggable Databases (PDB) in Oracle 19c/12c RAC.
• Strong experience in Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Experience in Backup and Recovery, Disaster Recovery options and Oracle Recovery Manager (RMAN).
• Experience in configuring standby databases using Oracle Data Guard.
• Proficient in working with Grid Control and Oracle Enterprise Manager (OEM) Cloud Control 13c/12c, and OEM 11g/10g.
• Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator.
• Expertise in Installing and configuring ASM and RAC for high availability databases.
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Autotrace, TKPROF and Statspack.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Good knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experience in cloning Database from Production to Test and Development and from Development to Production.
• Over 4+ years of Oracle Golden Gate experience in performing database upgrades, Cross platform/heterogeneous environment (Operating Systems & Databases) migrations, and replications.
• Good knowledge in Oracle Golden Gate installation, configuration (Extract, Pump, Replicate processes), and troubleshooting Oracle Golden Gate issues.
• Experience in using Oracle Golden Gate for Unidirectional, and Bi-Directional (Active-Active Synchronization) Replication.
• Experience inOracle 19c GDS (Global Data Services) Catalog creation, GDS GSM (Global Service Manager) Server installation, registration of Oracle GSM Server with the GDS Catalog, Oracle GDS pools creation, registration of databases in GDS pools, and Oracle GDS services creation.
• Hands on experience in setting up and administering Oracle Streams, also configured replication based on Oracle Streams.
• Experience in migration of oracle database to higher version and installing patches.
• Experience in writing shell scripts to check to the Status, Space Management and Performance of Database. Exporting and Importing of dumps using expdp and impdp.Extensively used the Grid Control for maintaining many databases together on separate servers.
• Having experience in performance tuning issues using AWR and ADDM Reports.
• Responsible for interacting with business partners to identify information needs a nd business requirements.
• Excellent interpersonal, strong analytical and problem-solving skills with customer service-oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x,6.x,7.x, HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2 and Windows 98/NT/2000/2003.

Data Bases: Oracle 12cRAC/12c/11gRAC/11g/10gRAC/10g/9i/8i, SQL Server 2005/2008

Languages: SQL, PL/SQL, Dynamic SQL, C, C++, UNIX Shell Scripting, Perl Script, XML, JAVA

Tools: /Utilities: RAC, OEM Grid Control, ESM, SQL Navigator, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, DBArtisan, Patch Management, SQLNET, ODBC, Oracle Streams, Data pump, Data Guard, VERITAS Net Backup, VMware, Zabbix

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation: Putty, MTPutty, Telnet, Secure CRT, FTP, WinSCP

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA

Responsibilities:

• Building new, or upgrading / patching existing databases and associated software in accordancewith vendor best practices;
• Setting up/Installation and configuration of 18c/19c ASM GI (Grid Infrastructure),Oracle Binaries 12c/19c, and 12c/19c RAC databases and Non-RAC CDBs/PDBs on EXADATA machines.
• Managing Tablespaces, Users, and privileges for Container Databases (CDB), and pluggable databases (PDB) in Oracle 12c/19c RAC.
• Delivering required database functionality that meets project requirements on or before defineddue date;
• Working with Delta Oracle Engineers and our service provider to deliver a highly available,resilient and performant database environment;
• Translate a logical data model and user specifications into a physical design;
• Ensure the detailed physical design of data structures and database complies with enterprisebuild and configuration standards and processes;
• Install, configure, and maintain Oracle software on database and application servers asrequired;
• Create physical database structures based on physical design for development, test, andproduction environments;
• Install, configure and maintain Oracle Golden Gate for use as a database migration tool and forbi-directional replication;
• Experience in Oracle Golden Gate installation, configuration (Extract/Pump/Replicat processes), and troubleshooting Oracle Golden Gate issues.
• Experience in using Oracle Golden Gate for Unidirectional, and Bi-Directional (Active-Active Synchronization) Replication.
• Performed Oracle Golden Gate upgradations, and cross-platform/heterogeneous environment (Operating Systems & Databases) migrations using Oracle Golden Gate 12c/18c/19c.
• Provide consultation to application development teams on Oracle database technical issues andtechniques;
• Experience in Oracle 19c GDS (Global Data Services) Catalog creation, GDS GSM (Global Service Manager) server installation, and registration of Oracle GSM Server with the GDS Catalog.
• Experience in Oracle 19c GDS pools creation, registration of databases in GDS pools, and Oracle GDS services creation to connect application users.
• Database performance testing and tuning, user configuration, security and support processesincluding gather stats, database backup/recovery, partition administration, etc;
• Ensuring Delta’s Oracle database environment is secure, providing recommendations forimproving database security and implementing approved security improvements;
• Coordinating downtime with application teams and system engineers to implement approvedchanges;
• Interfacing with vendor Microsoft to resolve operational issues or questions;
• Following established IT / DBA policies and procedures.

Environment: Oracle 19c R1 RAC, 12R1/R2 RAC, 11gR2 RAC, OEM Cloud Control 13c, OEM 11g, RMAN, Data Guard/ADG, Oracle Golden Gate 19c/18c/12c, TOAD 12.8,EXADATA, RHEL/Linux 7.5, andASM 12c/18c/19c.

Confidential

Senior Oracle DBA

Responsibilities:

• Planning and implementing DR & high availability solutions using Oracle 12c R1 (12.1.0.2) Standby Database using Oracle Data guard, 12c R1 RAC.
• Configuring Oracle Multitenant Container Databases (CDB) and Pluggable Databases (PDB) in Oracle 12c RAC.
• Setting up/Installation and configuration of 12c R1 RAC CDB, PDB,and Non-CDB with ASM 12.1.
• Converting Oracle 12c Non-CDB databases to PDB, and CDB databases.
• Managing Tablespaces, Users, and privileges for Container Databases (CDB), and pluggable databases (PDB) in Oracle 12c RAC.
• Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.
• Replicated databases using OracleGolden Gate and Data Guard for reporting purposes in OLTP environment with minimum lag.
• Oracle Enterprise Manager (OEM) Cloud Control 13c on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Experience ensuring the high availability, integrity of databases &database designing.
• Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.
• Wrote Shell Scripting for managing day-to-day activities and automation of backup.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Experience in Oracle Golden Gate installation, configuration (Extract, Pump, Replicat processes), and troubleshooting Oracle Golden Gate issues.
• Experience in using Oracle Golden Gate for Unidirectional, and Bi-Directional (Active-Active Synchronization) Replication.
• Performed Oracle Golden Gate upgradations, and cross-platform/heterogeneous environment (Operating Systems & Databases) migrations using Oracle Golden Gate 12c R1 & R2.
• Creating and managing database objects such as tables, indexes, partition tables and views.
• Monitoring and Troubleshooting of Database Replication issues.

Environment: Oracle 12c R1, 11g R2 RAC, OEM Cloud Control 13c, RMAN, Data Guard, Oracle Golden Gate 12c R1 & R2, TOAD 12.8, Zabbix 2.4.4, AIX 7, RHEL/Linux 7.5, ASM 12.1.

Confidential

Senior Oracle DBA

Responsibilities:

• Planning and implementing DR & high availability solutions using Oracle 11g R2 Standby Database using Oracle Data guard, 11g R2 RAC.
• Setting up/Installation and configuration of 11gR2 RAC with ASM.
• Configuring Oracle Multitenant container databases (CDB) and pluggable databases (PDB) in Oracle 12c RAC.
• Replicated databases using OracleGolden Gate and Data Guard for reporting purposes in OLTP environment with minimum lag.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
• Creation of Materialized views and partitioned the oracle tables to improve reporting performance.
• Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.
• Oracle Enterprise Manager (OEM) Cloud Control 13c/12c on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Experience ensuring the high availability, integrity of databases &database designing.
• Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.
• Wrote Shell Scripting for managing day-to-day activities and automation of backup.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.
• Experience in Oracle Golden Gate installation, configuration, troubleshooting Oracle Golden Gate issues.
• Experience in using Oracle Golden Gate for Unidirectional, and Bi-Directional (Active-Active Synchronization) Replication.
• Performed Oracle Golden Gate upgradations, and cross-platform/heterogeneous environment (Operating Systems & Databases) migrations using Oracle Golden Gate 11g R2 and 12c R2.
• Creating and managing database objects such as tables, indexes, partition tables and views.
• Monitoring and Troubleshooting of Database Replication issues.
• Creating and rebuilding indexes and optimizing the code to improve the performance.

Environment: Oracle 11g R2 RAC, OEM 12c/13c, RMAN, Data Guard, Oracle Golden Gate 12c/11g, TOAD 12.9, UNIX, RHEL/Linux 6.7/7.0/7.5, ASM.

Confidential

Senior Oracle DBA

Responsibilities:

• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, streams & failover.
• Setting up/Installation and configuration of 11gR2 RAC with ASM.
• Creating and managing users, roles, privileges, profiles, schemas using OEM 12c.
• Planning and implementing DR & high availability solutions using Oracle 11g Standby Database using Oracle Data guard, 11g RAC
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
• Creation of Materialized views and partitioned the oracle tables to improve reporting performance.
• Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.
• Oracle Enterprise Manager (OEM) 12c on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Experience ensuring the high availability, integrity of databases &database designing.
• Creating and managing database objects such as tables, indexes, partition tables and views.
• Monitoring and Troubleshooting of Database Replication issues.
• Experience in Oracle Golden Gate installation, configuration (Extract, Pump, Replicat processes), and troubleshooting Oracle Golden Gate issues.
• Replicated databases using OracleGolden Gate and Data Guard for reporting purposes in OLTP environment with minimum lag.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Worked on recovering of database in case of Media Failure, Block Corruption, missing data files and accidental tables dropped.
• Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.
• Wrote Shell Scripting for managing day-to-day activities and automation of backup.
• SQL tuning and Database tuning has been done based on reports generated bySQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.

Environment: Oracle 11g, 11g RAC, OEM 12c, RMAN, Data Guard, Oracle Golden Gate 12c/11g, TOAD 12.9, UNIX, Linux 5.11/6.7/7.0, Secure CRT, DB Smart, ASM.