SUMMARY

• Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, capacity planning, shell scripting, and documentation.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g, 12C & 19c with experience within large Oracle databases (VLDB) environment of size more than 70 TB and mission critical OLTP and OLAP systems.
• Proficient with Setup and support replication technologies like Oracle Goldengate and Shareplex.
• Application DBA support in Exadata environment.
• Installing and Maintaining AWS RDS instances for Oracle and MySQL databases.
• Proficient in installing, configuring and managing Oracle 12C RAC, 11g R2 RAC, Oracle 10g RAC
• Expertise in Installation, Configuring, and Maintenance OEM 13c and 12c (OEM Grid Control).
• Performance monitoring and tuning with EXPLAIN PLAN, TKPROF, SQL TRACE, AWR, ADDM, ASH, SQLT, SQL tuning advisor.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR), AWR comparison report and Automatic Database Diagnostics Monitor (ADDM).
• SQL query tuning using PLAN management, explain plan review, index creation, base line implementation using SQL profile and SPM.
• Successfully implemented physical Standby database using Oracle Data Guard feature for High availability configuration.
• Experience in Flash - Back Recovery, Data Pump, AWR, ASM, ASH and ADDM, Recycle Bin and Grid Monitoring.
• Migrated databases from one OS to other and from one cluster to other cluster.
• Planning and scheduling for the backup of database information using UNIX shell script and Crontab jobs, Autosys, OEM 12C.
• Expertise in Data transferring with Export, Import, Data Pump and SQL* Loader utilities.
• 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 backup, incremental and cumulative backup.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Managing and administrating MySQL databases.
• Shell scripting for automating DBA related monitoring jobs.
• Proficient in PL/SQL coding and debugging.
• Implemented IBM Optim Data Growth Solution 11.3 on Oracle and SQL databases for enabling data archival.
• Experience in installing, configuring, upgrading and monitoring DataStax Cluster (Enterprise Edition).
• Experience in designing data models in Cassandra and working with Cassandra Query Language.
• Implemented multi - data center and multi-rack DSE Cassandra cluster.
• Experience with adding and removing node from Cassandra Ring.
• Experience with Cassandra Application Data modeling.
• Experience for performing migration of data to and from Cassandra databases.
• Experience in managing multi-tenant Cassandra clusters on public cloud environment - Amazon Web Services (AWS).
• Managing Cassandra clusters, compaction, repair using Datastax Opscenter and managing using nodetool tool.
• Experience in Cassandra systems backup and recovery using Imanis Data tools.
• Experience in performance tuning and maintenance of Cassandra Database.
• Experience in migrating several data bases from on premise data center to Cassandra.
• Experience with Disk Management and User Management and permissions.
• Proficient knowledge in bash shell scripting.

PROFESSIONAL EXPERIENCE

Confidential, CA

Responsibilities:

• Working as a Sr. DBA in the Database Support Team to support production and non-production environments.
• Oracle Database Administration 10gR2, 11gR2, 12c and 19c on Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control on both Linux X64 server and AIX Sun Solaris Servers, including very large databases more than 50 TB.
• Upgrading and migrating the database to different version depending on Business requirements. (For Example 10g R2 to 11gR1, 11gR2 to 12c and 12c to 19c on different OS). Applying CPU, PSU and other patches per audit/compliance requirements.
• Install the Oracle GoldenGate (OGG) software to implement one-way/two-way data replicate process, enable DML/DDL data replicate, setup the heart-beat table to monitor OGG replicate lag and provide real-time lag report.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Duplicate all the non-production databases on server according the Data Warehouse development project's requirement. Help to compress large volume partition table by using various techniques.
• Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, ASH, OEM Performance Manager and in-house scripts by using Shell/Perl.
• Carried out Disaster Recovery tests using DataGuard and flashback.
• Created centralized db server standard build documents and backup standardization scripts and documents for the DBA teams.
• Designing the production system monitoring framework, Configuring/Tuning Oracle Enterprise Management 12c/13c (OEM), developing and maintaining the Shell based in-house monitoring scripts to monitor database instance status, tablespace usage, goldengate process running status.
• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export /Import utilities and SQL*Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Experience in managing multi-tenant Cassandra clusters on public cloud environment - Amazon Web Services (AWS).
• Managing and Administrating Oracle Databases on AWS RDS instances.
• Installing, upgrading, adding Cassandra 5.X to 6.X
• Performance management of Cassandra databases.

Confidential

Responsibilities:

• Worked as a Sr. DBA in the Database Support Team to support (daily On-Call rotation) production and non-production environments.
• Oracle Database Administration 10gR2, 11gR2, 12c and 19c on Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control on both Linux X64 Servers, including very large databases more than 70 TB.
• Upgrading and migrating the database to different version depending on Business requirements. (For Example 10g R2 to 11gR1, 11gR2 to 12c and 12c to 19c on different OS). Applying CPU, PSU and other patches per audit/compliance requirements.
• Participated in analysis and designing of Oracle Server for infrastructure and related projects. Assisted in integration of applications into current IT actionable events and solutions.
• Duplicate all the non-production databases on server according the Data Warehouse development project's requirement. Help to compress large volume partition table by using various techniques.
• Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, ASH, OEM Performance Manager and in-house scripts by using Shell/Perl.
• Carried out Disaster Recovery tests using DataGuard and flashback.
• Created centralized db server standard build documents and backup standardization scripts and documents for the DBA teams.
• Designing the production system monitoring framework, Configuring/Tuning Oracle Enterprise Management 12c/13c (OEM), developing and maintaining the Shell based in-house monitoring scripts to monitor database instance status, tablespace usage, goldengate process running status.
• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export /Import utilities and SQL*Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Experience in managing multi-tenant Cassandra clusters on public cloud environment - AZURE.
• Installing, upgrading, adding Cassandra 5.X to 6.X
• Performance management of Cassandra databases.