PROFESSIONAL SUMMARY:

• Over 8+ years of experience as Oracle DBA in development and production environments.
• Proficiency in installation, upgrading, patching, administration of multiple Oracle Enterprise Edition 9i, 10g,11g and 12C databases on RHEL, Sun Solaris, HP - UX, IBM-AIX and on Exadata Cluster.
• Hands on experience in Replication tools Oracle GoldenGate and IBM Change Data Capture (CDC).
• Experience in Performance Tuning using AWR, ADDM, ASH, EXPLAIN PLAN, SQLTRACE, TKPROF and STATSPACK.
• In-depth understanding of backup procedures to ensure database integrity. Background in developing backup and disaster recovery plans for mission critical databases.
• Superior communication, presentation, analytical and problem-solving skill. Work well with all levels of business.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g /10g/9i.

Operating Systems: Linux, HP-UX, Sun Solaris and AIX.

Languages: SQL, PL/SQL, C, UNIX Shell Scripting, Python.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, TOAD, SQL Developer.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, OEM Grid Control, ADDM,ASH.

Replications Tools: Oracle GoldenGate, IBM Change Data Capture (CDC) .

Backup Vendors: Oracle ZFS Appliance, Veritas NetBackup.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Maintaining and Administering EXADATA X2-2, X3-2 and X5-2.
• Monitoring Exadata Health Check using Sundiag.sh and Exachk.
• Successfully improved database performance on Exadata using Smart Scan features such as Storage Indexes and predicate filtering.
• Configured backups on Exadata cluster using Sun ZFS backup appliance.
• Implemented Archive High and Query High methods of Hybrid Columnar Compression (HCC) on database tables residing on Exadata Cluster.
• Applied Bundle Patches
• Installed and Configured Goldengate DML and DDL replication between Oracle databases and DML replication between Oracle and HDFS.
• Upgraded existing Goldengate configuration from 11.2 to 12.2 version.
• Implemented ENCKEYS method encryption for encrypting Goldengate trail files Confidential rest and in transit.
• Made use of Integrated Extract for replicating transactions occurred on OLTP and HCC compressed tables.
• Implemented Oracle Advanced Compression (OLTP) compression Confidential table level and tablespace level for compressing existing data and future data in Oracle databases.
• Worked on Migrating databases from one server to another using Export/Import, RMAN duplicate and Goldengate.
• Handled large data warehouse databases up to nTB
• Created standby databases using RMAN duplicate method.
• Working on implementing TDE with Oracle key Vault (OKV).
• Upgraded Oracle databases from 11.2.0.3, 11.2.0.4 to 12.1.0.2 version.
• Created Oracle databases using DBCA silent installation and using GUI.
• Configured RMAN backups using OEM.
• Implemented Interval Partitioning, List partitioning, Range partitioning and composite
• Partitioning on Tables. Converted Range Partitioned tables into Interval Partitioned tables.
• Configured replication between DB2 and Oracle databases using IBM Change Data Capture (CDC) tool.
• Made use of Rumba software to access tables on DB2 database.
• Made use of TRANSFORM feature of IMPDP for compressing data while importing using TABLE COMPRESSION CLAUSE and for storing the LOBs as Secure File using LOB STORAGE.
• Performed Initial Load of tables b/w Oracle databases using “File to Replicat” method and Direct Load methods of Goldengate.
• Created Triggers for converting timestamp of data being inserted into the table, for storing logging information of all users in a table in the database.
• Moved the data from Non-partitioned table into Range/Interval Partitioned tables and from Partitioned tables to Non-partitioned tables using Exchange Partition.
• Made use of Segment Advisor to reclaim unused space and for segments compression.
• Installed and Configured Apache Hadoop 2.6.0 on a Single node VM.
• Installed Postgresql-9.5 on a Single Node VM.
• Installed MongoDB 3.6 on a Single node VM.
• Written shell scripts for taking database backups, archived backups, monitoring tablespace usage in databases and filesystem space usage etc .
• Configured OEM 13c monitoring tool for more than 300 databases for proactively monitoring the issues on the databases like performance of databases, tablespaces, database growth etc.
• Experience in Using BMC Remedy Tool for creating HLP, Service Requests and Tasks .
• Experience in Using Tortoise SVN for uploading/downloading/accessing scripts needed for Deployments .

Confidential, Dallas, TX

Oracle Database Administrator

Responsibilities:

• 24x7 on-call production database support. Primarily responsible for supporting mission critical databases to resolve the database issues on the time and make sure database up and running
• Configured OEM 12c monitoring tool for more than 300 databases. For proactively monitoring the issues on the databases issues like performance of databases, tablespaces, database growth etc.
• Applying the latest patches like quarterly and one off patches for Oracle Database to fix bugs which occurred in previous version and applying it using Opatch utility.
• Configuring 11gR2 RAC databases on EXADATA. Cell administration on EXADATA.
• Migrating databases to EXADATA Database Machine.
• Working on Smart Scan and query processing that can be offloaded to EXADATA storage server.
• Using the EXADATA monitoring tools like EXACHK, DIAGTOOLS, ADRCI, IMAGEINFO, and OSWATCHER. EXADATA database patches, cell patch
• Working on EXADATA Full Rack (8 node RAC) applying quarterly patches using Rolling Methodology.
• Mapping EXADATA physical disks, Luns and Cell Disks on the Storage Servers using CellCLI.
• Configuring RMAN backup’s for humungous databases to ZBA controllers on EXADATA machine.
• Manual cluster upgrade from Grid infrastructure 11.2.0.3 version to 11.2.0.4 version.
• Installed and configured Oracle clusterware 11gR2 and Oracle RAC for One Node databases on Linux platform.
• Created Oracle11gR2 RAC standby databases for High availability purpose from primary database using "RMAN duplicate from Active database" procedure.
• Created recoverable and restartable test databases using EMC BCV/SRDF/SYMCLONE technologies.
• Refreshed lab databases from production using RMAN Image method and Backup compression methods.
• Golden Gate Replication configuration like unidirectional as well as bidirectional as per the requirement and addition of tables for the existing Golden Gate configuration.
• Configured Oracle Transparent Data Encryption (TDE) on 11g databases with an Auto-Open wallet option and enabled TDE Tablespace encryption.
• Generated and analyzed AWR, ADDM and ASH reports for resolving production performance issues.
• Partitioned large tables, created global portioned indexes for manageability and performance improvement. Managed and resolved design issues. Dropping and rebuilding indexes.
• Performed block recovery to restore corrupted block in application tables using RMAN.
• Created and managed users, profiles, implementing security, granting roles and privileges etc.
• Worked on different types of shell scripting like Korn shell (ksh), Bourne Shell (sh).
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Developing SQL, PL/SQL stored procedures, packages, functions, triggers and views.
• Worked with Data Pump to take the logical backups of databases.
• Experienced in performing Point-in-Time Recovery.
• Load and Transform data using SQL*Loader and External Tables
• Helped developers to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.
• Experience in Using BMC Remedy Tool.

Confidential, Columbus, OH

Oracle Database Administrator

Responsibilities:

• Provided 24X7 support for all the production and development databases.
• Installed and configured Oracle 10g and Oracle 11g databases .
• Performed upgrades from Oracle 9i to 10g.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Instance cloning done to create test and training environments.
• Resource Management (Create and manage Indexes, Clusters, Tables), allocate and manage physical storage structures like Data files, Redo logs, Control files. Allocate and Manage logical storage structures like Table spaces.
• End-user requests in terms of assisting them in effectively create tables, views, packages, sequences.
• Issues related to Space Management, Locks, Database Hit Ratios, Backup failures and UNIX related On-Call alerts.
• Load data using SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Export and Import Data according to the users request using EXP/IMP and Datapump .
• Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers.
• Alert monitoring and Ticketing.
• Applying Quarterly CPU patches and One-off patches for bug fixes .