SUMMARY

• Certified lead database administrator/engineer focused on IT in various industries, primarily financial, pharmaceutical and managed service provider with over 22 years of experience in infrastructure, clustering, planning, capacity, tuning, troubleshooting, backup/recovery, migration, upgrades, disaster recovery, project management and project leading efforts.
• Extensive experience and exposure with Oracle Architecture and Administration as Database Lead/Specialist with Oracle 11g/12c/19c/RAC/ASM/Data Guard/Golden Gate and related technologies.
• With an eye on current industry trends, have transitioned into cloud configuration, migration and support efforts.
• Efficient and diligent involvement with AWS and Azure technologies with primary focus on RDS/Aurora/DMS/EC2/DB deployment on cloud VMs has been the norm also for the past 3 years.
• To stay abreast with recent trends have achieved AWS certifications as Solutions Architect Associate and Database Specialty. Currently pursuing AWS Data Analytics certification.

PROFESSIONAL EXPERIENCE

Confidential, NYC

Lead Cloud Database Engineer

Responsibilities:

• Lead major client’s (MAS - HHS, Orion Health) clustered database infrastructure in all areas including projects management, migration (11g to 18c/19c), support, tuning, troubleshooting, monitoring, automation, HA, DR etc.
• Project lead and coordinator on major project of RAC cluster and database upgrade/migration from RHEL 6 to RHEL 7 and 111g/18c to 19c.
• Major private could projects completed as well as ongoing, in the capacity of a Project Lead in areas of Database upgrade, Grid Infrastructure Management, Data Guard setup, Backup Infrastructure and Oracle 11g to 12c migration (ongoing).
• Mentor junior DBAs and operations specialists on monitoring and support in both private and public cloud environments
• Support public cloud clients in database tuning, troubleshooting, monitoring, upgrade, migration for databases on AWS EC2, AWS RDS, RDS Aurora and Azure VM environments.
• Currently working on major Oracle migration project planning and implementation from private cloud to AWS RDS and EC2.
• Services used in AWS are EC2, IAM, S3, DMS/SCT, Multi-AZ, RDS backups/snapshots, and Aurora cloning/backtrack.
• Completed AWS Solutions Architect certification and AWS Database Specialty Certification as per company objective and appraisal guidelines.
• Pursuing AWS Data Analytics certification and RedHat Ansible deployment review for AWS databases.

Environment: Oracle 11gR2/12c/18c/19c, CRS/ASM, RAC, Data Guard, Linux, ADDM/AWR/ASH, RMAN, OEM, EMC Data Domain, Rubrik, AWS, AWS RDS, Aurora (MySql, Prostgres), EC2, Azure VM

Confidential, NJ

Senior Oracle Infrastructure DBA (Consultant)

Responsibilities:

• Completed major design and implementation project for 12c database and Goldengate migration from 11g to 12c database and Goldengate 12.2 bidirectional replication.
• Accomplished various efforts in resolving Golden Gate issues with bi-directional replication, DBFS versus NetApps storage, memory and other performance issues with 12. Golden Gate and Oracle 12c
• Converted Critical Tier 1 databases DR from SRDF to Data guard.
• Get involved in several L3 escalations for on-call, performance tuning, troubleshooting, patching, backup, DR and other support related issues
• Worked on database migration from 11g to 12C DbaaS Oracle RAC on Exadata by strategizing policies involving RMAN, Transportable tablespace and Golden Gate.

Environment: Oracle 11gR2/12c, CRS/ASM, RAC, Exadata X5-2, Data Guard, Linux, ADDM/AWR/ASH, RMAN, SAN, Golden Gate 12.2, Avamar, Netbackup, SAN, NetApps Filers

Confidential, NJ

Senior Oracle Infrastructure Architect/Engineer (Consultant)

Responsibilities:

• Play primary role in architecting and designing Oracle 12c multitenant project globally as part of Infrastructure Services in the capacity of a database engineer.
• Manage POC and support for Oracle 12c provisioning for consolidation using multi-tenants in classical (Linux) and Integrated Platforms (Exadata).
• Lead the effort of Oracle 12c Cloud Control (OEM) monitoring architecture and design and integration with BMC Patrol.
• Lead the effort to design strategy for Oracle rolling upgrade from RHEL 5 to RHEL 6/7 for Oracle RAC environments to support EMC ExtremIO storage array.
• Used AddNode/DeleteNode RAC technology with no downtime strategy.
• Assist in Oracle 12c Exadata POC regression and load testing using Swingbench.
• Support redesign and performance issues issue escalations from L3 DBA team for existing environments

Environment: Oracle 11gR2/12c, Multitenant Architecture, CRS/ASM, RAC, Exadata X5-2, Data Guard, Linux, ADDM/AWR/ASH, GoldenGate, Cloud Control, RMAN, SAN

Confidential, NYC

Senior Oracle Database Architect/SME (Consultant)

Responsibilities:

• Reviewed existing RAC and Data Guard configuration and make recommendations and successfully coordinate implementation and support of changes for SOA database of 10TB in size.
• Designed, developed and scheduled jobs for ASM throughput monitoring. This was highly desired and appreciated.
• Worked effectively with SA and for storage team on new storage benchmark for RAC via coordinating and testing database/disk I/O throughput (SLOB, DD, CALIBRATE IO) for new IBM v7000 storage with flash.
• Played major role in Oracle infrastructure and monitoring improvements suggestions for the engineering team. Implemented Huge Pages for all Oracle RAC environments on OEL 6.
• Defined strategies for object redefinition, de-fragmentation and developed scripts, implemented and scheduled primarily for tables, indices and LOBs.

Environment: Oracle 11gR2/12c, CRS, ASM, RAC, Data Guard, Linux, ADDM/AWR/ASH, OEM (12c), RMAN, SLOB, OSWatcher, Oracle Cluster Health Monitor (CHM), PLSQL, Shell Scripts

Confidential, NJ

Lead Oracle Database Engineer/L3 Escalation Support (Consultant)

Responsibilities:

• Hired to lead Oracle database consolidation efforts for Confidential, successfully conceptualized, planned, designed, configured and implemented Oracle 11gR2 RAC farms on RHEL 6.2.
• Worked closely with Oracle Engineering team members to successfully automate database migration from standalone Oracle database from IBM ZLinux for RHEL Oracle RAC consolidated farms.
• Documented all RAC deployment modules including OS configuration, CRS & database deployment and run books for ongoing support.
• Successfully completed in record time to perform cross-platform migration from Solaris to Linux for mission critical PCR database sized at 17TB. This effort was highly appreciated.

Environment: Oracle 10g/11gR2, CRS, ASM, RAC, Data Guard, ZLinux, Linux, EMC Symmetrix, SRDF, BCV Snaps, ADDM/AWR/ASH, OEM (12c), RMAN, Golden Gate, Swingbench, Shell Scripts

Confidential, NJ/NY

Lead Database Administrator/Project Lead

Responsibilities:

• In charge of all aspects of database architecture, infrastructure, capacity planning, policies, 24/7 production support, upgrades, security, backup/recovery, Disaster Recovery, performance tuning, design, project management, capacity planning & maintenance for Tier 1 mission critical databases.
• Project planning, execution and implementation of migration efforts for mission critical database environments involving cross-platform migration (Solaris to Linux), non-RAC to RAC, non-ASM to ASM and Oracle 10g to Oracle 11g.
• Played major role successfully to improve database performance by 70-80% which was highly desired and appreciated.
• Assisted other lead DBAs in supporting bi-directional replication using Golden Gate.

Environment: Oracle 10g/11g,, Solaris, Linux, EMC Symmetrix, VCS, ADDM/AWR/ASH, OEM, CRS/ASM, RAC, Exadata, Legato, Golden Gate, Netbackup, Autosys, Data Guard, EMC SRDF, Shell Scripts