PROFESSIONAL SUMMARY:

• 9+ years of experience as an Oracle core/apps DBA, building and administering RDBMS such as Oracle, Oracle RAC, Oracle Exadata and MS SQL server databases.
• Migrated several projects from the scratch and have very good experience in working on Unix operating systems.
• Database design, installation, upgrades, patching, scheduling RMAN backups using IBM TSM/Veritas net backup and implementing recovery procedures.
• Implement and maintain RDBMS oracle 10g/11g/12c within enterprise - wide clusterware/grid environment with ASM file systems.
• Apply bundled patches, CPU Patches on clustered, non-clustered and disaster recovery environments.
• Experience in implementing Oracle Advanced Security, ODI/OUD and replication activities.
• Upgradation/migration works of production databases Non-RAC/RAC on different OS platforms (HP-UX, RHEL, OEL, Solaris, IBM AIX, Windows server).
• Configure and implement disaster recovery solutions using dataguard/Standby for high availability RAC and standalone databases.
• Clone/refresh UAT and development environments from production using RMAN backup based or active duplication methods.
• Administering of databases on SAN and Exadata storage server.
• Database tuning, instance tuning, tune PL/SQL statements and query optimization using scripts.
• Installing and managing Oracle EM Cloud Control 13c(GUI) and monitor target database using OEM Cloud Control (GUI) or DGMGRL (CLI).
• Experience in MS SQL server administering, clustering, mirroring and migration activities.
• Goldengate installation, configuration and maintenance.
• Experience in shell scripting and data modeling using SQL developer and TOAD.
• Administering and configuration of Oracle Fusion Middleware products such as Oracle Weblogic Server 12c and oracle EBS applications.
• APEX installation, configuration and administration.
• Administrative experience in Hadoop and knowledge on Mongodb, Cassandra and MySQL databases.
• Experience in Cloud Computing (Oracle Java cloud, Microsoft Azure). Knowledge in AWS (Amazon Web Service)

TECHNICAL SKILLS:

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

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

Cloud Computing: Oracle Java cloud, Microsoft Azure, Amazon Web Service (AWS).

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, MS SQL server 2008/12

Others: VMware workstation/server, Virtual Box

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Oracle DBA Consultant

Responsibilities:

• Migration of Oracle 11.1.0.7 database on windows to Oracle 12.1.0.2 on OEL 6x.
• Configured 3 Node RAC cluster with ASM storage and created container and pluggable databases Build single node RAC standby database for RAC primary database and using RMAN active duplication method.
• Configured and Installed Oracle enterprise manager 12c cloud control utility.
• Setup Golden Gate to execute unidirectional replication between databases.
• Installed and configured Oracle Weblogic server 12.2.1 and created domains for production and development purposes.
• Clustered existing 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)
• 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.
• Configure SSL for online transactions, configure wallets for trusted/root certificates.
• Concurrent Manager Setup and troubleshooting Oracle Applications 11i/R12.
• 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). Exadata storage cell administration and database machine fault monitoring.
• Building a Hadoop Cluster with Amazon EC2 and S3.
• Install and configure the MS SQL Server-Hadoop Connector. Configured SCOOP on MS SQL server for exporting and importing data into HDFS. 

Confidential, Atlanta, GA

Sr. Database Administrator

Responsibilities:

• Developed PL/SQL code to capture encryption and scrambling table/data activities by scheduling an automated jobs. Partitioned large tables to enhance faster querying.
• Identify and encrypt critical application tables or individual columns using Data Masking and TDE.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
• Migrated single instance databases to multi-node 11g RAC for high availability with ASM.
• Configured RAC standby database for RAC primary databases.
• summarize historical Exadata Storage Server metrics in order to recognize performance trends using Oracle tables and SQL. Determine whether you have Exadata cell disk I/O bottlenecks on your storage grid.
• Diagnose Exadata grid disk I/O bottlenecks on your Exadata storage grid.
• Work with the development team in troubleshooting pl/sql issues and during deployments.
• Configure and build Golden Gate Extracts/replicat for multiple databases.
• Configured LDAP server extension for OUD on application server, shell scripts to process the files on daily basis.