SUMMARY:

• 9+ years of experience in Information Technology in various roles, as an Oracle Database Administrator having hands on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, Golden Gate, backup and recovery, production support, cloning, space management, database security, monitoring the database using OEM Grid Control, shell scripting using ORACLE 19c,12c/11g/10g/9i. Install and configure Container and Non - Container 12c databases, Pluggable databases - Architecture, Installation and the concepts associated with 12C database.
• Deploying configuration management and CI/CD services such as Ansible, Powershell, Jenkins, Docker, JIRA and CloudFormation.
• Implementation and administration of Oracle Audit Vault, VPD, VPC and data encryption for sensitive data.
• Experience working with VMware and Oracle Virtual Machine (VM).
• Support for Oracle EBS 11i/12 Refresh & Database Refresh
• Oracle E-Business Suite Administration - configuration, maintenance, tuning, patching, and cloning.
• Experience working with large health care network called VHA within Department of Veterans.
• Experience with My Oracle Support (MOS)/MetaLink for Oracle SR, patch download and software delivery cloud.
• HL7 V3 messaging between HDR and a wide variety of administrative, clinical, and financial systems is a critical component.
• Processing patient records in a HL7 v.2 and HL7 v.3 standards to communicate with DOD and VA.
• Experience in using OEM 12c and migrating 12c to 13c to manage Oracle Database Vault and applying patches to a Database that is protected by Oracle Database Vault.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).
• Experience in configuring, managing, and monitoring ASM for standalone and RAC databases
• Administrated database of various sizes from 40GB to 50TB
• Experience in installing and configuring Goldengate (OGG) 12.2 for data replication, migrations, and upgrades.
• Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
• Experienced in Oracle Global data services (GDS).
• Refreshing prod data into lower environments using Delphix solution.
• Experience in SQL tuning using Explain Plans and Hints.
• Experience in Performance Tuning for better performance. Identifying bottlenecks with memory and disk contentions.
• In-depth study of Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Experience in UNIX Bash Shell Scripting.
• International experience and exposure in three different countries: India, Australia and USA.

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12C,19C, MongoDB, Mysql, Sql Server.

Applications: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM 13c,12c,11g), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Erwin, TOAD, Data Pump (expdp and impdp), AutoSys, Query Analyzer, VERITAS, NetBackup, DD Boost, Actifio, Developer 2000, SQL*Plus, SQL*Loader, Golden Gate, SQL Developer, HL7,VNC Viewer, Remote Desktop, VPN, Citrix Remote Access

Operating Systems and Oracle Engineered systems: Windows 2003/2008/2010/ XP, RHEL 5.x,6.x, Sun Solaris, AIX, HP-UX, Oracle Exadata Enterprise Linux 6 & 7 on X-5, X-6,X7-2,VMware,vCenter&vSphere,OracleVM,Virtual BoxSuper cluster M8.

Utilities: SQL Plus, SQL Net, Import/Export, TKPROF, STATSPACK, OEM, Moogsoft, Service now, BMC service desk Express, Cherwell ITSM.

PROFESSIONAL EXPERIENCE:

Confidential, Austin TX M

Sr. ORACLE DBA

Responsibilities:

• Install, configure, and maintain Oracle 12C, 18C & 19C multitenant container and pluggable model software on database and application servers as required and assist in the sunrise of Oracle Exadata technology at Department of Veterans.
• Performed database migration from non-Exadata to Exadata using golden gate. Also upgraded databases from 11.2.0.4 to 19C.
• Building Oracle Stand by databases, both Active data guard for real-time replication and normal data guard for disaster recovery also referred as BCP clone purposes.
• Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
• Also tested disaster recovery with database failover and switchover also tested Goldengate (OGG) replication after that using DBFS filesystem and ACFS.
• Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using data guard switchover and Export & Import.
• Worked on EXADATA X5-2 Half-Rack, also researching to test and implement the new features available for EXADATA X6.
• Experienced the special features of EXADATA related to performance such as Smart Scan, Intelligent flash Cache, Columnar Compression etc. on 12C databases.
• Implemented Oracle Goldengate (OGG) (both Classic and integrated capture) and Sha replex for replicating data from Primary (OLTP system) to downstream systems such as data warehousing for reporting purposes and history databases for archival purposes.
• Created Source to Target Mapping and Transformation Logic document for ETL process. These documents also contains detailed information applicable to ETL data from source to Data Mart(s) (star schema tables).
• Implemented Oracle Goldengate (OGG) bi-directional setup (Active-Active).
• Resolved sync issues Oracle Goldengate (OGG) in bi-directional replication and applied required patches and bug fixes.
• Tested and implemented OGG bi-directional (Active-Active) replication from on-prem databases to databases on windows.
• Configured golden gate downstream mining and integrated components for bi-directional (Active -Active) replication.
• Worked on setting up of Goldengate (OGG) 12c Integrated Capture on Exadata Servers for replication purposes from OLTP system to Downstream systems. And on Non-EXADATA servers we used separate mining database Goldengate replication and on EXADATA source databases is used as mining database too.
• Developing and supporting end-to-end Oracle RAC and data guard solutions in VMware and Linux environment.
• Installed Goldengate version 11 and version 12 (12.1 and 12.2) with latest patches applied on DBFS filesystem and ACFS filesystem.
• Attended NoSQL Couchbase presentations and deployed VMs for MongoDB and MySQL.
• Implemented Goldengate integrated replicat and co-ordinated replicat(available from OGG 12c) to improve the performance of data replication to targets .
• Tested and implemented 12.3 (Parallel Replicat) for Oracle targets to achieve better replicat performance, Also migrated GG instances to 18c OGG MA (Micro service Architecture).
• Implemented Goldengate bi-directional for heterogeneous systems . i.e Oracle and MS SQL Server database as source and JMS (Weblogic Queues) as target using Goldengate (OGG) adapter for java and configured Java User Exit (JUE) goldengate pump to read from GG trails and post messages to JMS queues. Also used customized data format templates such as velocity template (vm), XML and JSON to post the messages to JMS queues. Also did tested Java Based Replicat available from OGG 12.2 version as a replacement for JUE OGG processes on JMS.
• Converting HL7 into relational database (Oracle) through the application.
• Used HL7 as black box to process patient records to server veterans more efficiently.
• Tested and implemented OGG replication from on-prem databases to government Cloud for DB migration to cloud.
• Implemented Goldengate Security features such as credential store for masking usernames and passwords from parameter file, Goldengate Wallet and ENCKEYS (encryption keys) for trail file and password encryption.
• Installed Goldengate plugin on OEM Grid control and JAGENT (java agent) on goldengate instances to monitor Goldengate processes through OEM grid control.
• Also installed and configured Goldengate Monitor, Goldengate Director and Goldengate Veridata tools for OGG Monitoring, Data comparision, repair and fixing the GG related issues.
• Working on testing Goldengate Studio to test Goldengate Artifact deployments using GUI based interface and monitoring.
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Capacity Planning and requesting the storage required by analyzing the database growth.
• Customization and development of K- shell scripts required for monitoring space usage, backup jobs, stats gathering, Goldengate Process Monitoring etc.
• Cloned and refreshed development and staging databases from production for development and testing.
• Responsible for optimizing sql queries and tuning the long running queries as a part of performance improvisation.
• Setup and maintenance of various versions of oracle engineered systems such as Oracle Database Appliance (ODA) V1, X3-2, X5-2 & X6-2 and Exadata X 3-2 & X5-2.
• Experiencing in using oracle Exadata X 7-2 and Oracle M8 proof of concept.
• Install, configure and administer Oracle Real Application Cluster (RAC) for versions 10g/11g/12c on ODA and Exadata super clusters.
• Upgrade and migrate databases from Oracle 11g to 12c in a RAC environment.
• Golden gate (OGG) 12c Integrated Capture on EXADATA Servers for replication purposes from OLTP system to downstream systems. And on Non-EXADATA servers we used separate mining database.
• Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using Data guard switchover, Export & Import (Data pump).
• Installed Golden gate version 11 and version 12 with latest patches applied on DBFS file system and ACFS file system, also worked on testing OGG 12.2 new features.
• Installed 0EM13C and migrated OEM from 12C to 13C.
• Setup physical standby’s (DATAGUARD) for several Databases.
• Configure Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status.
• Upgrade existing 10g/11g databases to 12.1.0.2 on HP database machine using transportable table space method. Upgraded supported versions using DBUA (direct path upgrade).
• Migrated databases from RHEL 6 to RHEL 7 using golden gate with no downtime.
• Configured new scripts (shell script) for database monitoring and service availability.
• Experience in configuring and managing 3-node RAC database and used ASMCMD command-line utility to manage ASM disk groups, administering ASM storage by adding disk to the disk groups.
• Backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and for full database backups using data pump.
• Database Installation, Upgrades and Patching. Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto.
• Hands on experience and knowledge in SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for oracle database and use of joins and cursors like explicit and implicit cursors.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Used various ticketing tools like Service Now, ITSM, BMC service desk and HP ticketing tools at the enterprise level.
• RAC: Expertise in the Installation of Oracle 11gR1/R2 and 12cR1/R2 on Oracle Enterprise Linux (5.8/6.2 64-bit) and using VMware Server (from 1.0.6, 2.0.2) and VMware Workstation 9.0.0 and 12.5.0. Familiar with database related file systems i.e. ASM, ACFS, OCFS2.
• Expertise in PL/SQL, SQL and UNIX Shell scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities
• Involved in migrating databases to Oracle M8 super cluster using golden gate.
• Execute changes to database based on preapproved change requests.

Environment: Oracle 11G and 12c, 18c,19c OEM 12c and 13c, UNIX, SQL, Oracle text, Oracle Partitioning, GoldenGate versions 11g, 12c (12.1,12.2 and 12.3) & 18c OGG MA, DMS (Data Migration Service), GoldenGate bi-directional (Active-Active), Physical Standby (Active Dataguard, normal standby), Oracle Database Appliance V1, X3-2, X5-2 & X6-2 and Exadata X3-2 & X5-2.,Oracle weblogic,Hl7,HPPA,Unix/Windows, Red Hat Linux 5.8, RHEL 6,7, Oracle super cluster M8, OEM 12c,13c, RAC, Oracle Advanced Security, SQL server 2012, VMWARE,Data guard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, OVD, Opatch Auto, TOAD for oracle 12.2/11.6, TOAD, Golden gate, Inter scope monitor, AppDynamics.

Confidential, West Des Moines, IA

Sr. ORACLE DBA

Responsibilities:

• Maintaining the availability of Oracle Database versions 12c, 11g, 10g in both Production and lower environments.
• Experience as On-Call 24x7 production DBA support, application/development DBA
• Building Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.
• Worked on Disaster Recovery by converting physical standby databases to Snapshot standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
• Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using Dataguard switchover, Export & Import (Datapump).
• Implemented Oracle Goldengate (OGG) (both Classic and integrated capture) for replicating data from Primary (OLTP system) to downstream systems such as data warehousing for reporting purposes and history databases for retention based archival purposes.
• Customization and development of K- shell scripts required for monitoring space usage, backup jobs, stats gathering, Goldengate Process Monitoring etc.
• Worked and implemented Database Wallet for Oracle 11g also called as keystore from 12c and TDE (Transparent Data Encryption) for encrypting the Sensitive data using column encryption and tablespace encryption, also used TDE for Goldengate replication and worked on OKV (Oracle Key Vault).
• Implemented Goldengate unidirectional replication on RAC using ACFS file system.
• Implemented 12c Grid control (Multi OMS architecture) on 11.2.0.3 database, Standby OMS architecture is under progress.
• Monitored Goldengate using 12c Goldengate Plugin and also Goldengate Director and shell scripts for alerting GG process down alerts.
• Implemented OVD and Kerberos setup.
• Also Implemented OID (Oracle Internet Directory) i.e. LDAP directory on Oracle databases.
• Implemented Audit Vault for collection and consolidation of Audit related information and Database Vault for security and compliance purposes.
• Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Datapump and Normal ) for restoring the specific objects at the database level.
• Responsible for installation of Oracle Clusterware (CRS) also referred as Grid Infrastructure from 11g, and 12c Oracle Re-start (standalone grid Infrastructure) and creating the RAC and Standalone databases.
• Upgraded the RAC and standalone databases from 11g to 12c in Dev/Test. As part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.1 and 12.1.0.2).
• Pro-Active Monitoring of the Databases using 12c OEM and fixing the issues, also working on Root Cause Analysis, and documenting the issue resolution steps for future reference.
• Applied the Cluster ware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for Bug resolution) using Opatch.
• Storage Migrations: Solely responsible for migrating the Prod/Test/Dev/Sit/UAT Databases from Net App to HNAS and to block level storage. (Migrating the databases from Non-ASM to ASM)
• User management, Table space management, file system space management, backups management
• Create, Track and work and tickets (Change Requests, Work Orders and incidents) generated from PAC2000 (BMC Remedy) Tool.
• Generate reports needed to provide details with number of tickets closed, current status, average age on tickets to client from Remedy’s Business Analytics tool.
• Execute changes to database based on preapproved change requests
• Installs necessary tools on infrastructure (deploying agents, RMAN FRAMEWORK, control M, RMAN framework, 12c agents)
• Deliver the reports on time as agreed. Follow-up all actions items and provide status.
• Training the new team members on Security Baselines and Installation Qualifications.
• Monitor and educate team with new processes and standards.
• Effective Production Support and off hour support, support handover, off-shore co-ordination.

Environment: Oracle 12c/11g/10gon Unix/Windows, Oracle EXADATA X2-2 HALF RACK 4,7/Oracle 11g, Goldengate (OGG), Red Hat Linux 5.8, RHEL 6, AIX 6, OEM 12c, RAC, Oracle Advanced Security, Data guard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, OVD, Performance tuning, opatch Auto, TOAD for oracle 12.1/11.6, SQL developer, Golden gate.

Confidential, Austin, TX

Sr. ORACLE DBA

Responsibilities:

• 24 hrs. production support.
• Provide DBA support with a high degree of customer service, technical expertise, and timeliness. Provide adequate and creative solutions to user problems of reasonable nature to ensure user productivity and assuring data is protected and recoverable as required.
• Analyze load and capacity allocation and participate in performance debugging exercises when required. Plan for backup and recovery of the database and allocate system storage and plan future storage needs.
• Study relevant business processes, understanding application design/behavior and the data flow, criticality, and dependencies.
• Responsible for configuring, administering, and maintaining the database environments in a RAC configuration .
• Upgraded database from 11g to 12c.
• Upgrade of Grid and Oracle Infrastructure on multi node RAC cluster from 11.2.0.3 to 11.2.0.4.
• Performed Migration between different datacenters, Non ASM to ASM, Single instance to RAC.
• Extensively worked on identifying bugs and installing necessary/latest CPU/PSU patches in a rolling fashion for both the Cluster ware home and Database home.
• Responsibilities include database upgrades, patching , security, troubleshooting and issue resolution and backup procedures using RMAN and data pump .
• Implemented Data guard with maximum availability, protection and performance configurations and worked with Data guard Fail over and Switch over cases by configuring Physical/Active standby databases .
• Create automated scheduled jobs for integrity checks, index defragmentation and update statistics.
• Good in Database and Transaction log Backups and Restoration, backup strategies, scheduling the backups.
• Resolving the issues in conflicts between the target and source database in Golden gate.
• Involved in deploying new application and setting up replication between the databases using Golden gate.
• Moved data across different servers and platforms using FTP utility.
• Resolving the different sync issues between primary and standby by identifying the root cause and resolving the same, restore logs and applying manually if require.
• Performing and prepare maintenance for adding new luns, changing IP ’s and kernels for Production environment.
• Configure, monitor and trouble shoot Nimbus monitoring tool.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML

Confidential, COLUMBUS, OH

ORACLE DBA

Responsibilities:

• Installed and Configured 2node RAC on Linux.
• Installed and Configured and maintained oracle 10g and 11g.
• Oracle Grid Control 11g Installation and Configuration.
• Refreshing the Database from one version to another version.
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM
• Working Knowledge of installation and configuration of GOLDENGATE in Unix environment
• Done Installation and configuration of golden gate on 11g database for the replication.
• Implemented Bi-Directional replication in golden gate from target to source and source to target.
• Resolving the conflicts between the target and source database.
• Configuring parameters for DDL support in golden gate replication
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health checkup of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log and managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML

Confidential

ORACLE DBA

Responsibilities:

• Installation and configuration of Oracle software 10g version.
• Created databases, allocated system storage and planned future storage requirements for the database.
• Installed Oracle and related tools, upgraded the database and applied patches as and when required.
• Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Configured the Data guard for switchover and failover and thereby providing high availability.
• Coordinated operating system setup/upgrades and infrastructure troubleshooting in partnership with system administrators.
• Implemented Recovery Manager (RMAN) Recovery Catalog performed Complete and Incomplete recovery.
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Implemented Cloning to migrate data from PROD to Test and Dev databases.
• Performed Capacity planning and storage management.
• Estimation of database growth and analysis.
• Reorganization of tables and rebuilding of indexes.
• Maintained a disaster recovery site and planned and instituted disaster recovery process.
• Coordination with the team and ORACLE Support for troubleshooting the database issues.
• Developed UNIX Shell scripts to backup and recover the Oracle databases.
• Modified shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Worked as a team member to provide 24x7 on-call production database support.