SUMMARY

• 9+ years of experience as an Oracle core DBA, implemented business systems under various platforms to handle all database administration and troubleshooting activities including database design, installation, upgrades, patching, scheduling backups/recovery and maintenance of high availability databases using Data Guard / Standby and RAC (Real Application Clusters & GRID Infrastructure).
• Understand the pre - requisite for installing oracle software on Unix flavors of operating systems.
• Experience in implementing Oracle Advanced Security, ODI/OUD, replication and administering RDBMS Oracle 9i/10g/11g/12c within enterprise-wide database environment and multi TB OLTP databases.
• Apply patches on requirement basis, applying bundled patches, CPU Patches on clustered, non-clustered and disaster recovery environments
• Upgradation/migration works of production databases Non-RAC/RAC on different OS platforms (HP-UX, RHEL, OEL, Solaris, IBM AIX, Windows server).
• RMAN backup and recovery configuration using IBM TSM and Veritas net backup.
• Implementation and configuration of Oracle 11g, 12c clusterware/grid environment in ASM file systems.
• Clone/refresh UAT and development environments from production using RMAN backup based or active duplication methods.
• Implement disaster recovery solutions with dataguard/Standby for high availability.
• Administering oracle databases on SAN and Exadata storage server.
• Database performance tuning in analyzing and tune PL/SQL using scripts.
• Configure and manage physical/logical standby databases and monitoring using dataguard.
• Experience in installing and managing Oracle EM Cloud Control 13c(GUI).
• Experience in SQL server clustering, mirroring and migration activities.
• Migration of non-Oracle and SQL Server databases from various versions across heterogeneous platforms
• Goldengate installation, configuration and troubleshoot GG issues.
• Experience in shell scripting and data loading using SQL*LOADER.
• Administering and configuration of Oracle Fusion Middleware products such as Oracle Weblogic Server 12c and oracle EBS applications.
• APEX installation, configuration and administration.
• Knowledge on scoop based Hadoop connector for MS SQL server and moving data from Hadoop to SQL server using Hive ODBC connector.

TECHNICAL SKILLS

RDBMS: Oracle 9i/10g/11g/12c versions

Middleware: Oracle Weblogic Server 12c, Glassfish, ORDS 2/3.X.

Languages: SQL, PL/SQL, Unix shell scripting

High Availability: RAC, Data guard, Golden gate

Tools: /Packages: RMAN, OEM 13c Cloud Control, Datapump, TOAD, ASM, Data guard broker

Operating System: RHEL, OEL, IBM AIX, HP Unix, Solaris 10, Windows Server 2003, SQL server 2008

Others: VMware workstation/server, Virtual Box

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Oracle DBA Consultant

Responsibilities:

• This project involved Support of various apex, dot net and java applications which are hosted in 11gR1 RAC.
• Migration of Oracle 11.1.0.7 databases on windows to Oracle 12.1.0.2 on OEL 6x.
• Involved in database design, planning and creation of oracle 12c databases from scratch.
• Installed and configured Oracle enterprise linux 6.7.
• Partitioned the carved out space allocated in HP 3PAR SAN storage and configured UDEV rules for ASM disks.
• Provided timely, reliable status reports of the servers to clients for their analysis.
• Installed and configured Oracle 12C grid server binaries on Linux machines
• Configured 3 Node RAC cluster with ASM storage and created container and pluggable databases for primary databases and implemented backup policies using RMAN.
• Successfully configured and managed standby database for RAC primary using RMAN active duplication method.
• Tested the DR SWITCHOVER of RAC to standby database as part of the migration.
• Node addition and deletion during primary elections to serve business needs.
• Move pluggable databases between the container databases and created pluggable database from seed database.
• Cloned pluggable database in existing container database.
• Install apex in oracle 12c pluggable databases.
• Troubleshoot memory leaks related to Oracle 12c database instance, ASM instance and applications related issues associated with pluggable databases.
• Troubleshoot complex problems with root cause analysis during product deployment/release.
• Clone UAT RAC databases using RMAN active duplication method.
• Configured and Installed Oracle enterprise manager 12c cloud control utility.
• Deployed oracle 12c agents on respective targets for monitoring using cloud control.
• Worked extensively on 12C OEM cloud control on daily basis by configuring various monitoring metrics across all production and non-production databases. Upgraded OEM 12c cloud control to OEM 13c cloud control.
• Setup Golden Gate to execute unidirectional replication between databases.
• Heterogeneous replication using Golden Gate Oracle to SQL server.
• Perform health check of goldengate configuration and resolve errors using logdump utility.
• Installed and configured Oracle Weblogic server 12.2.1 and created domains for production and development purposes.
• Clustered domains for production servers and deployed web application using weblogic server admin console.
• Configured ORDS and oracle REST data services in weblogic servers (APEX listener configuration)
• Tuning weblogic server configuration. Migrated all the applications from Glassfish server to Oracle Weblogic server 12.2.1

Confidential, Vernon hills, IL

Oracle DBA Consultant

Responsibilities:

• Migrated single instance 11gR2 databases to oracle 12c container with pluggable databases.
• Convert standalone 11gR2 databases to multi-node 12c RAC database.
• Managing user request, responds to the tickets, change and incidents requests.
• Responses to the critical alert on PROD/DEV/QA environment and contact appropriate team for loading issues.
• Configure SSL for online transactions, configure wallets for trusted/root certificates.
• Configure ACL and provides access to business users to upload and download files on FTP server.
• RMAN backup and recovery configuration with Veritas net backup.
• Monitored and maintained existing multi-node 11g RAC databases.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing. schedule backup, monitoring database for thresholds and schedule different jobs for different environments.
• Performing database code releases and assisting developers to promote their code into production from test servers.
• Refresh UAT and development databases/schemas using RMAN, Mviews, dblinks and datapump.
• To Involve in disaster management and high availability of production environments. Managing password security and user roles.
• High level evaluation of performance tuning, load balance and TAF failover, RMAN, dataguard and different database performance tuning with latest Cloud control utility.
• Implemented dataguard broker to automate the creation, maintenance and monitoring of Data Guard configurations using OEM (GUI) or DGMGRL (CLI).
• Identify the server which were not efficiently configured in areas of caches, network, locks including other configuration parameters, which resulted in deferred updates and insert.
• Goldengate installation, configuration and maintenance for replication activities.
• Generating data and starting goldengate process and check statistics.
• Setup Golden Gate to execute unidirectional replication and setup user with privileges.
• Oracle exadata database machine monitoring. Database healthcheck with (Exachk).
• Open service requests during the deployment.
• Understanding exadata patching definitions and strategies. Preparing to apply exadata patches.
• Configuring multiple oracle software owners on exadata compute nodes.
• Monitoring SQL statements response time.
• Exadata storage cell administration and database machine fault monitoring.