SUMMARY:

• Highly energetic with Over 8 years of hands - on experience as an Oracle Database Administrator
• I have worked on Oracle databases involving database administration, production support, installation, configuration, upgrades, patching, migration, backup and recovery, performance tuning, cloning, migrations and goldengate, shell programming and ansible.
• Providing DBA support to multiple Cluster, Non-cluster and ASM Databases in production, development and Testing Servers in Linux, Solaris Environments.
• Expert in oracle sql and database performance tuning.
• Skillful in Performance Tuning including SQL Query analysis using Explain plan and TKPROF analysis.
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports.
• Upgrade databases to 11g and 12c.
• Build, configured and managed multi node RAC Clusters.
• Experience with setting up and managing standby database using Data Guard.
• Proficient with Amazon Cloud (AWS).
• Migrated oracle databases to AWS rds ..
• Installed, Configured and replicated databases using Oracle Golden Gate.
• Database refresh, cloning of production database’s for QA from RMAN backups and using database duplicate.
• Providing 24/7 production support for critical production databases.

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, California

Oracle Database Administrator

Responsibilities:

• Involved in support for Production, QA and development databases of sizes ranging from 500 GB to 50 TB.
• Install and configured 12cR2 RAC cluster.
• Upgraded databases from 11g to Oracle 12c.
• Applied regular database and grid patches.
• Migrated databases from old hardware to new ones.
• Cloning production database instances using RMAN.
• Setup standby databases for high availability.
• Created and enabled an Oracle Data Guard Broker Configuration.
• Troubleshooting Active Dataguard, resolving lags, perform switch over, failover.
• Configured Goldengate replication from OLTP database's to Oracle data warehouse database.
• Adding new tables to an existing Oracle GoldenGate replication and perform initial load using expdp/impdp.
• Offloading (few) Reports (read only sql queries) to Active Data Guard Instances.
• Schema refreshes and backup's using data pump (expdp/impdp).
• Work with developers in tuning time consuming SQL’s and suggesting changes, leveraged Real Time SQL Monitoring, SQLT extract, and trace analyzer tools to analyze poorly performing SQL's.
• Database tuning using Oracle tools like explain plan,tkprof,AWR, ADDM, SPM,sql profiles and analyze query execution using different techniques.
• Monitoring and managing databases with OEM 12c.
• Support for other databases including EDB(Postgre sql), Cassandra (no sql), Vertica and Hadoop environment .
• Integrated oracle database CDC to Kafka using oracle Golden gate.

Confidential, San Diego, California

Database Consultant

Responsibilities:

• Upgrading the oracle databases to oracle 11g/Oracle 12c
• Database migration from Solaris T5 to Solaris T7 servers.
• Analysis and Solutions for poor running queries causing application performance degrades by implementing Data Statistics, Index Maintenance, SQL profiles and SQL baselines. Review AWR and ADDM reports for an in-depth analysis. Provided solutions to the application based on performance analysis.
• Maintain and Manage database on Oracle Grid Infrastructure and Automatic Storage Management (ASM).
• Plan, Configure and Implement successful database migrations and upgrades to current versions, latest infrastructure and technology.
• Plan & Deploy monthly code deployments to production databases in corporation with application team.
• Provide Monitoring, troubleshooting, historical analysis on real time performance monitoring of databases in an 24X7 critical environment.
• Configured and Implemented backup strategy based on backup tools like RMAN in sync with Veritas Net Backup.
• Respond & Align support tickets and provide timely resolution to the issues reported.
• Apply database PSU patches in a timely manner in compliance to patching cycle
• Maintain documentation for new processes, architecture topology, critical tasks like new technology implementation, major issue fix, new configurations implemented.
• Configured Goldengate replication for reporting instances .

Confidential, San Jose, CA

Database Consultant

Responsibilities:

• Conduct Meeting with Application team pertaining to DB performance.
• Recommending to fine tune the SQLs based on analysis of AWR reports and find the reason why it is slow and finding out the exact bottleneck causing performance issue.
• RCA of Performance Issues.
• TOP SQL and Host Analysis.
• Analysis of TKPROF
• Monitoring DB performance during the load testing.
• Monitoring the database performance using the OEM 12C
• Reactive Performance tuning, providing recommendations to resolve highest priority, critical performance issues in production databases.

Confidential

Oracle Database administrator

Responsibilities:

• Oracle Database configuration, installation, migration & upgrades (standalone).
• Real application cluster configuration and implementation.
• Manage databases on clusterware and monitor the same for high availability enabled applications.
• Oracle Database patching (interim PSU, standalone), rolling upgrade patch sets (RAC).
• Plan database backup strategy based on business/application requirements and database criticality.
• Database tuning using Oracle tools like AWR, ADDM, Sql Baselines and analyze query execution using different techniques.
• Tuning database queries to improve better response time at application level.
• Setting up Standby databases and configure Data Guard on 11g environments.
• Active participant of disaster recovery activities, testing production backups on the DR sites for data consistency and data availability.
• Manage database on ASM storage, which involves monitoring of disk availability, addition of new disks and managing disk rebalancing based on database load.
• Configuring Oracle Grid Control for advanced database monitoring and alerting mechanism.
• Assisting development team in developing/fine tuning SQL codes for deployments in production environment, PL/SQL procedures & triggers.
• Provide on on-call support during weekends to address critical issues and perform weekend production database maintenances.
• Maintain documentation on tasks performed at database levels and adhering to processes defined within the organization.

Confidential

Oracle Database administrator

Responsibilities:

• Oracle Database installation on Linux, AIX, Windows.
• Oracle 11g R2 RAC installation on two nodes Cluster.
• Troubleshooting the RAC related issues (Node evictions).
• Addition of third node to, existing two node rac clusters.
• Monitoring the health of RAC databases by checking the logs and OSWTAHCER and rac check tool.
• Upgrading the database from 10gr2 to 11gr2.
• Implemented and administered Oracle data guard.
• Used Oracle Grid Enterprise Management for Database Monitoring.
• Refreshing Databases from production to other environments using 11g RMAN ACTIVE DUPLICATE feature.
• Periodical checking on Alert Log file and Trace files for errors.
• Management of Users, Roles and Privileges.
• Converting physical standby database to Snapshot standby database for testing purposes.
• Creating a physical standby database in oracle11g.
• Recovering standby database using RMAN incremental backups whenever required.
• Export & Import of tables, tablespaces, schemas and full database by using Data pump Export & Import Utility.