SUMMARY

• 9 years of professional experience as an Oracle Application and Database Administrator having hands on experience in administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, shell scripting and documentation.
• Excellent experience in Installation, administration and troubleshooting of Oracle 12c/11g/10g for OLTP (multiple instances)/ OLAP environment on Very Large Databases (VLDB).
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle PL/SQL Developer in various versions.
• Responsible for setup and implementation of two node RAC.
• Experience in Oracle 11g/12c RAC implementation, administration and troubleshooting RAC databases including Oracle Clusterware setup and configuration.
• Configuration and Management of Data Guard on RHEL, OEL and Windows.
• Configuring Oracle Golden Gate for replications.
• Experience in setting up DDL/Bi - directional replication between source and target databases. Experience in configuring Integrated Extract and Co-ordinated Replicat after upgrading Golden gate software to 12.1.
• Extensive noledge on Amazon Web Services (AWS) provisioning and good noledge of AWS services like EC2, S3, Elastic Beanstalk, ELB (Load Balancers), RDS, VPC, Direct Connect, Route53, Cloud Watch, Cloud Formation, IAM, SNS etc.
• Performed Migration and Upgrade of databases to 12c and 11g.
• Expertise in handling company audits and providing answers to the auditors.
• Installation of the web services like Tomcat and Apache.
• Responsible for Installation and maintains of Microstrategy reporting tool.
• Involved in performance tuning and configuration of Microstrategy Intelligence server.
• Troubleshooting of the web services and tuning of the web services.
• High level trouble shooting in the Database and Application level performances.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Experience is setting up GoldenGate to migrate large databases.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.
• Testing and implementing different physical (hot/cold) and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Data loading using SQL*LOADER, Logical backups using export/import and DATAPUMP.
• Performed Database refresh from production to QA, development databases and testing environments.
• Experience in using 13c/12c OEM cloud control, TOAD, Data Migrations using export/import, benchmarking using load testing tools
• Monitoring, identifying areas dat need to be improved in the application and database using AWR, ADDM, ASH and 13c/12c OEM cloud control.
• Implemented database monitoring alert scripts for database status and sizing issues using OEM.
• Experience in SQL Tuning, Optimization, cost based optimization and Hints.
• Extensive experience on Jenkins (Jenkins Pipelines) for continuous integration and end to end automation for all build and deployments.
• Experience on automating the build, test, and deployment of an application and implement Continuous integration and deployment (CI/CD) pipeline.
• Writing scripts in the UNIX based environments for managing the user's roles and privileges, scheduled backups (using data-pump /cold backups), manage statistics, Disk space management.
• Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, various UNIX Shell Scripting.
• Proficient in raising TAR with Oracle Support and using Metalink(MOS) to resolve the bottlenecks in the database environments.
• Extensively used JIRA ticketing systems.
• 24/7 on-call production database support.
• Excellent communication skills, interpersonal, strong architectural skills, hardworking and has ability to TEMPeffectively communicate with all levels of the organization such as technical, management and customers.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g, MS Sql Server.

Operating Systems: Sun Solaris, RHEL, OELDevelopment Tools: RAC, OEM Grid Control, SQL* Loader, ASM,OEM, SQL ServerTuning Tools: TKPROF,EXPLAIN PLAN.STATSPACK,ADDM,AWR

Others: MS Visio 2010

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Oracle Database Admin

Responsibilities:

• Installed, configured, and maintained Oracle 12c and 11g R2 on RHEL and also Upgraded from Oracle 11g to 12c.
• Installed, managed and monitored the Oracle Real Application Cluster (2 node RAC)
• Experience in RMAN recovery in RAC and standalone database.
• Implemented DataGuard with maximum availability, protection and performance configurations and worked with DataGuard Fail over and Switch over cases at the times of up gradation and migration.
• Monitored and Supported the DataGuard - Standby Databases using OEM/grid Control and DataGuard Broker
• 24/7 on-call production database support.
• Installation of the Tomcat and apache-based web services.
• Refresh the test and development databases from the source production databases on a regular basis using export/import utility.
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control.
• Used SQL *Loader for loading the data into database tables.
• Experience in OEM cloud control installation, configuration and administration and regular database management.
• Extensive use with 13c/12c OEM cloud control for monitoring, administration and performance tuning.
• Upgrade and manage oracle 12c OEM cloud control to 13c OEM Cloud Control.
• Data modeling for OLTP database using CA ERwin tool.
• Experience in Online and Offline backups and recovery.
• Experience in contributing and participating in the RFP document preparation.
• Configure and Manage Jenkins for automated web server deployments across all working environments.
• Monitoring & Scheduling jobs for the daily activities for all the databases using CRONTAB.
• Table space monitoring, Performance monitoring and tuning for performance improvement.
• Managing, troubleshooting and resolving oracle database and application issues.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, AWR, TKPROF, Explain Plan, TOAD from Quest software (DB Tuning).

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• Installation, Configuration, Designing and Maintaining of Oracle 11g and 12c on Solaris.
• Involved in migrating single instance databases to RAC databases.
• Implemented and Monitored Data Guard (physical standby) for standalone Oracle 11g/12c.
• Responsible in leading the project and writing shell scripts to automate the process of upgrading Enterprise level GoldenGate software from 11.2 to 12.1
• Experience in configuring Integrated Extract (to support Compressed table extraction) and Co-ordinated replicat after upgrading Golden Gate to 12.1.
• Responsible in implementing Oracle’s Transparent Data Encryption (TDE) in production/lab instances and performing relevant changes to support GoldenGate.
• Has a deep understanding of Oracle Enterprise Manager (OEM) 12c, command line and GUI
• Articulate monitoring and management of technologies via OEM 12c to customers and stakeholders
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Daily incremental backup and weekly full backup of databases using RMAN.
• Responsible for refreshing and cloning of databases per customer requirements using RMAN, export/import, Data Pump and physical(hot/cold) backups.
• Supported development by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager (OEM).
• Troubleshooting the OEM Agent issues and fixing.
• Performing clear state of the OEM Agents whenever required to keep the target and destination agents in sync.
• Continuously monitoring Production and Staging databases for optimal performance.
• Provided 24*7 Production Support.
• Worked with Oracle Support on Sev1 issues to keep business running.
• Responsible for Making Documentation on collaboration site for every monthly release changes.

Confidential, Omaha, NE

Oracle DBA

Responsibilities:

• Involved in gathering user Requirements, application design, and analysis of hardware requirements to meet business needs.
• Implementation of High Availability solutions with Oracle 10g Physical and Logical Standby Databases (Data Guard).
• Configuration of system to achieve High Availability, Load balancing and automatic fail over functionality.
• Install, upgrade and maintain Oracle 10g on RHEL.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Hands on experience configuring, installing, deploying, and maintaining OEM Agents
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security.
• Database Restore using RMAN, Cold Backup and Export.
• Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption).
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Cloning of databases from production to test environments.
• Periodic data refresh from production to testing environments, Re-organizing database structures etc.
• Performed database Cloning using hot backup and cold backup to setup test and development database.
• Usage of Partitions to improve the query performance and manageability.
• Involved in taking logical backup using Data pump and Exports/Imports Utility
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Tuning and balancing I/O by monitoring file system and table-space I/O statistics.
• Tuning SGA, I/O Tuning, identifying contention, waits and tuning.
• Expertise in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK using OEM.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• 24/7 on-call production database support.