Lead/Manager DBA, AWS Cloud DBA, Migration Specialist, MySQL/Postgres

ANBUMANI GANESAN

Oracle DBA AWS Cloud DBA MySQL & PostgreSQL DBA Database Migration Specialist DBA Manager

Mobile +1-732-***-**** Mail: ***.****@*****.*** 1, Willow Pl, Iselin, NJ, 08830

LinkedIn : https://www.linkedin.com/in/anbumani-ganesan-2a709b15/

Professional Summary

Seasoned Database Administrator with extensive 15 plus years of experience in Mission-critical production support for Oracle and additionally AWS Cloud, PostgreSQL, MySQL & NoSQL databases. Proven track record in Database Migration, Cross platform Migrations, Installation, upgrades, patching, and performance tuning, Security & Monitoring. Strong expertise in building & supporting AWS environments, Cloud database Cost Optimization & Reduction and database operations, with a focus on Maximum High Availability, Major Incident and Disaster Solutions. Committed to excellence in database Performance Optimization, Troubleshooting, Backup & Recovery solutions & Database outages. Expertise in On-prem, Cloud & On-prem to cloud Migrations.

Technical Expertise & Responsibilities:

Excellent working experience as SME in Oracle/PostgreSQL/MySQL database support & operations in Very large-scale Mission critical environments. (20,000+ databases & ~40, 000 Incidents per month).

Expertise in Managing and Supporting Oracle, AWS Aurora, PostgreSQL and MySQL databases in AWS cloud and On-prem environments.

Mission critical Support in Troubleshoot Database issues, database performance enhancement, tuning.

Expertise in Maximum Availability Architecture, High availability, Replication & Fault-tolerant DB Solutions for Oracle, PostgreSQL, AWS RDS, RDS Aurora & MySQL databases.

Experience in Database Migration, Datacenter Migration, database Upgrades and all types of database & cluster Patching, including Cross platform database migration for applicable RDBMS.

Strong Performance tuning experience with a good understanding of database statistics, Locks & Blocking sessions & AWR/ASH/ADDM report analysis, Server/Database resource monitoring etc.

Excellent understanding and experience in SQL tuning, Query Optimization, Performance Tuning, Troubleshooting, indexing, identifying & resolving bottlenecks for all supporting database technologies.

Proficiency in Oracle RAC, ASM, Data Guard, DB Security & RMAN Backup/Recovery, SQL Loader.

Experience in implementing and managing the database Security includes Encryption, Oracle Wallet, Data Redaction, Access Control, DB Vault & Auditing.

Experienced in Managing and supporting Container / Pluggable databases using Oracle Multitenancy.

Good Experience in Troubleshooting and solving complex Performance Issues & Database Outages.

Good Experience in planning and supporting Planned & emergency database Disaster Recovery.

Optimize cloud resources for performance and cost-efficiency, ensuring alignment with business needs.

Strong experience in DB Migrations for MySQL, PostgreSQL & Oracle databases (On Prem & Cloud).

Good Hands on in Migrating Oracle, MySQL, PostgreSQL databases from on-prem to Cloud.

Experienced in Install, Configure and managing RDS (Oracle, PostgreSQL, MySQL) & Aurora databases.

Planning and implementing the Database backup and recovery & Database Refreshes for Oracle, PostgreSQL, MySQL Databases for On-Prem & AWS Cloud Environments.

Proficiency in AWS tools and utilities like CloudFormation, DMS, SCT, CloudWatch, IAM, S3, Lambda etc.

Proficiency in Migrating Database to RDS/Aurora PostgreSQL & MySQL using AWS DMS & SCT.

Proficient in Configuring and performing PostgreSQL backup and recovery using Barman, pg_basebackup, pg_baserecovery, pg_dump utilities & WAL archive backup including perform PITR.

Proficient in Configure and support MySQL backup and recovery using tools mysqlbackup & mysqldump including handling Point in time Recovery and making backups using Replicas.

Well experience in Planning, Design and Setup DR solutions for AWS cloud and On-Prem databases.

Provisioning, Monitoring, Security, Profiling and Support for DocumentDB (Mongo) database.

Good Knowledge on configuration, support, and troubleshooting of FileNet Content Manager.

Good Knowledge of Snowflake Provisioning, Monitoring and Maintenance best practices & Tuning.

Manage cloud networking, storage, and security configurations, including identity and access management.

Solid experience in scripting for Managing databases & automation using Python, Ansible & shell.

Proficient in Troubleshooting & coordinating with Oracle/AWS support for bugs and unresolved issues.

Experienced in GxP implementation/deployment, HIPAA and data migration in the Life science industry.

Operation Skills & Responsibilities:

Good experience in handling teams of L2/L3 DBAs for mission critical 24/7 Environments.

Proficient in communication, coordination and interpersonal skills to work across with teams & clients.

Coaching & mentoring team members, recognize their strengths and encourage team members to take ownership of their personal development.

Strong leadership, communication, and collaboration skills across global teams.

Experienced in datacenter migration which involves regular discussion with relevant infra teams and good knowledge in Server, Storage, Backup areas.

Good in Maintaining and Managing Database & Process Documentation, DB Configurations, Changes.

Well experience in Automation, Incident trend Analysis & reduction.

Responsible for making detailed technical RCA for P1/P2 Incidents and implementing corrective actions.

Proficient in Analytical and Problem-solving skills, can work independently and quick learner.

Good exposure to Remedy & SNOW, ITIL Processes around Incident, Change, Problem Management and Continuous Service Improvement & Database security management tools like CyberArk.

Analyze, Diagnose and assess problems and provide long term solutions to stakeholders.

Proficient in handling cases with vendors and follow up on all Severity issues and technical bugs, particularly in outage & Major Incident situations.

Good experience in managing teams in High volume, VLDB (Size in 100+ TBs), fast paced and high stress environments.

Strong experience in Work closely and collaboration with multi-functional teams with priority.

Professional Experience:

Cloud Vertex (Clovertex) - Dec 2022 – Till Date (Client: Regeneron Pharmaceuticals)

Lead DBA with Cloud Migration Specialization & Cross Platform Migration.

Production support & operations in Mission critical various database environment.

Handling Major Incidents & production database outages, follow up problem analysis, determination and Root cause analysis.

Build, Supporting, Managing RDS Oracle, PostgreSQL and MySQL database environments in AWS cloud.

Setup and managing data replication from RDS PostgreSQL/Aurora to S3 Data Lake.

Database Migration from Oracle to AWS RDS PostgreSQL/ MySQL using SCT & DMS.

Planning, Design and Setup DR for AWS cloud and On-Prem databases.

Implement and Administering Oracle RAC, ASM, Data Guard, DB Security & RMAN Backup and Recovery.

Supporting Planned & Unplanned Disaster Recovery test and exercises.

Planning, build and Perform Cross Platform Database Migration like windows to Linux environments.

Planning, support and perform the Cloud Migration, databases Upgrades and all types of database Patching.

Build, configure and managing data replication in On-prem & AWS cloud databases

Managing and support Container and Pluggable databases using Oracle Multitenancy.

Capacity planning and Server & Database space management

Cost estimation and Cost optimization, Reduction for AWS Cloud database instances.

Planning and implementing the Database backup and recovery & Database Refreshes for all RDBMS.

Migrating Oracle database from on-premises (Physical) to Cloud environment.

Provisioning Fault-tolerant, Scalability, Replication methods and Maximum Availability Architecture (MAA).

Troubleshooting and solving complex Performance Issues & Database Outages.

Works on incident reduction for high volume and identical incident patterns.

Perform SQL tuning, DB Performance Tuning, troubleshooting, identify & resolving bottlenecks.

Design, deploy, and manage AWS Cloud Infrastructure hosting Oracle, PostgreSQL and MySQL databases.

Works with Oracle and AWS support Priority vendor cases for Bugs and unresolved issues.

Work closely and collaborate with multi-functional teams with accepted priorities.

Citicorp (CSIPL) - Feb 2021 – Oct 2022 (Citi Bank – Global Support)

Assistance Vice President (SME, Oracle DBA, Cloud DBA. Migration Specialist, Manager Database)

Managing Oracle DBA support & operations in Very large scale and Mission critical environments. (20,000+ databases & ~40, 000 Incidents per month)

Handling Major Incidents & production database outages, follow up problem analysis, determination and Root cause analysis.

Build, Supporting, Managing RDS Oracle, PostgreSQL and MySQL database environments in AWS cloud.

Implement and Administering Oracle RAC, ASM, Data Guard, DB Security & RMAN Backup and Recovery.

Planning and supporting database Disaster Recovery test cases and drills.

Perform Cross Platform Database Migration, Datacenter Migration, databases Upgrades and all types of database Patching.

Managing and support Container and Pluggable databases using Oracle Multitenancy.

Configuration, Managing, Monitoring and Performance handling through Oracle Enterprise Manager (OEM) 13c Cloud Control & 12c Grid Control.

Planning and implementing the Database backup and recovery & Database Refreshes.

Capacity planning and Server & Database space management.

Cost estimation and Cost optimization, Reduction for AWS Cloud database instances.

Set up and managing data replication from RDS PostgreSQL/Aurora databases.

Database Migration from Oracle to AWS RDS PostgreSQL using SCT & DMS.

Migrating Oracle database from on-premises (Physical) to Cloud environment.

Provisioning Replication methods and Maximum Availability Architecture (MAA).

Troubleshooting and solving complex Performance Issues & Database Outages.

Perform SQL tuning, DB Performance Tuning, troubleshooting, identify & resolving bottlenecks.

Design, deploy, and manage AWS Cloud Infrastructure hosting Oracle, PostgreSQL and MySQL databases.

Works with Oracle and AWS support Priority vendor cases for Bugs and unresolved issues.

Works on incident reduction for high volume alert patterns.

Work closely and collaborate with multi-functional teams with accepted priorities.

DXC Technology - July 2018 – Feb 2021 (Client: Deutsche Bank – Global Support)

Assistance Vice President

Managing Oracle DBA support & operations in Very large scale and Mission critical environments. (18000+ databases & ~24000 Incidents per month)

Handling Major Incidents & production DB outages, follow up problem analysis, determination & RCA.

Build, Supporting, Managing RDS Oracle, PostgreSQL and MySQL database environments in AWS cloud.

Implement and Administering Oracle RAC, ASM, Data Guard, DB Security & RMAN Backup and Recovery.

Capacity planning and Database space management

Planning and supporting database Disaster Recovery test cases and drills.

Perform Cross Platform Database Migration, Datacenter Migration, databases Upgrades and all types of database Patching.

Set up and managing data replication from RDS PostgreSQL/Aurora databases.

Cost estimation and Cost optimization, Reduction for AWS Cloud database instances.

Database Migration from Oracle to AWS RDS PostgreSQL using SCT & DMS.

Planning and implementing the Database backup and recovery & Database Refreshes.

Migrating Oracle database from on-premises (Physical) to Cloud environment.

Provisioning database Replication through Golden gate, Dataguard & Standby databases.

Planning and configure High availability and Maximum Availability Architecture (MAA) systems.

Troubleshooting and solving complex Performance Issues & Database Outages.

Perform SQL tuning, DB Performance Tuning, troubleshooting, identify & resolving bottlenecks.

Works with Oracle support for Priority vendor cases for various Bugs and unresolvable situations.

Works on incident reduction for high volume incident patterns.

Wipro Technologies - June 2017 – Dec 2017 (Client: Woolworths & Woodside energy)

Database Manager (Subject Matter Expert and Manager)

Managing Database supports team & operations in Very large-scale managed services for 24/7 Support.

Handling Major Incidents & production database outages, follow up problem analysis, determination and Root cause analysis.

Implement and Administering Oracle RAC, ASM, Data Guard, DB Security & RMAN Backup and Recovery.

Planning and supporting database Disaster Recovery test cases and drills.

Perform Cross Platform Database Migration, Datacenter Migration, databases Upgrades and database Patching.

Configuration, Managing, Monitoring and Performance handling through 12c Grid Control.

Planning and implementing the Database backup and recovery & Database Refreshes.

Provisioning Replication methods and Maximum Availability Architecture (MAA).

Troubleshooting and solving complex Performance Issues & Database Outages.

Performance tuning and analyzing database statistics, Locks & Blocking sessions & AWR/ASH/ADDM report, Server/Database resource monitoring etc.

Perform SQL tuning, DB Performance Tuning, troubleshooting, identify & resolving bottlenecks.

Works with Oracle support for Priority vendor cases for various Bugs and unresolvable situations.

Works on incident reduction for high volume incident patterns.

Work closely and collaborate with multi-functional teams with accepted priorities.

Tech Mahindra Limited – May 2007 - May 2017 (Clients/Projects: IFC, SBI, BASF, MARS, NISSAN)

Database Manager (Subject Matter Expert, Principal consultant & Manager)

Managing Oracle DBA supports team & operations in Mission critical various database environments.

Handling Major Incidents & production database outages, follow up problem analysis and RCA.

Implement and Administering Oracle RAC, ASM, Data Guard, DB Security & RMAN Backup and Recovery.

Planning, build & supporting database Disaster Recovery test cases and drills.

Perform Datacenter Migration, databases Upgrades and all types of database Patching.

Configuration, Managing, Monitoring and Performance handling through OEM & 12c Grid Control.

Planning and implementing the Database backup and recovery & Database Refreshes.

Provisioning Replication methods and Maximum Availability Architecture (MAA).

Performance tuning and analyzing database statistics, Locks & Blocking sessions & AWR/ASH/ADDM report, Server/Database resource monitoring etc.

Troubleshooting and solving complex Performance Issues & Database Outages.

Perform SQL tuning, Database Performance Tuning, troubleshooting, identify & resolving bottlenecks.

Works with Oracle support for Priority vendor cases for various Bugs and unresolvable situations.

Technical Skills:

Database Technologies: Oracle (19c, 12c, 11g, 10g, 9i, 8i), PostgreSQL, MySQL, MSSQL

Cloud Technologies: AWS (EC2, ECS, EKS, RDS, RDS Aurora, S3, CloudFormation, Lambda, CloudWatch.

High Availability/MAA: Oracle RAC, Data Guard, AWS Multi-AZ, Aurora replica, Goldengate

Database Migration Tools: Oracle XTTS, TTS, PGLOADER, AWS DMS & SCT, Ora2Pg

NoSQL Database: AWS Document DB, Mongo

Backup & Recovery: RMAN, AWS Snapshots, mysqlbackup, SQL Backtrack, Druva, BARMAN

DB Monitoring: OEM (Cloud & Grid Control), MySQL EM, SolarWinds DPA, PMM, Splunk, CloudWatch

Operating Systems: Linux, UNIX, Solaris, Windows

PM/ITSM Tools/Frameworks: JIRA, Remedy, ServiceNow (SNOW), Confluence, Scrum, DevOps

Education:

Master of Computer Applications (MCA) University of Madras April 2000 73.87% Regular

Bachelor of Electronics Science (BES) University of Madras April 1997 74% Regular

Work Authorization:

H1B – Valid till Sep 2026.

Contact this candidate