PROFESSIONAL PROFILE:
- 18+Yrs. Database Management professional experience with Cloud Database DBA Consultant in AWS RDS/EC2 & Azure PaaS/VM, Oracle, MySQL, PostgreSQL, NoSQL, Ansible Tower, Terraform (IaC), CloudFormation (IaC), Power BI Reports etc.
Primary Expertise in Cloud Database Tech Consultant
- Before go-live, preparing Database perspective Solution Building Block (SBB) Specification as per Project Standard for the followings, getting approval from the appropriate technology stack-holders (Application Owners / Product Owners).
AWS Migration
- Heterogeneous Migration (Re-factor in AWS Cloud) from On-Prem/IaaS to AWS RDS/Aurora Managed Database Instances Example: Oracle19c to PostgreSQL Ver.15.0 using AWS SCT (Schema Conversion Tool) & AWS DMS (Database Migration Service)
- Homogeneous Migration (Re-factor in AWS Cloud) from On-Prem/IaaS and AWS RDS Managed Database Instances Example: MySQL 5.7 to MySQL 8.0, Oracle19c to Oracle 19c using AWS DMS (Database Migration Service)
Azure Migration
- Homogeneous Migration (in Azure Cloud itself) from Azure PaaS DB Single Server to Azure PaaS DB Flexible Server Example: Azure MySQL Single Server 5.7 to Azure MySQL Flexible Server 5.7 and then Azure MySQL Flexible Server 5.7 to Azure MySQL Flexible Server 8.0 using Azure DMS (Database Migration Service) in the same/cross subscription.
- Homogeneous Migration (Re-factor in Azure Cloud) from On-Prem/IaaS to Azure Paas DB Flexible Server Example: MySQL 5.7 to MySQL 8.0 using Azure DMS Assessment for Schema Conversion & Azure DMS (Database Migration Service) Project.
- AWS RDS/Aurora Database for Oracle/MySQL/PostgreSQL
- Azure PaaS Database for MySQL/PostgreSQL Flexible Server
- Cloud IaaS (VM/EC2)/On-Prem Databases for Oracle/MySQL/PostgreSQL in Latest Version
- Knowledge on handling NoSQL DB in AWS DynamoDB, MongoDB (IaaS/VM)
- Knowledge on handling AWS Redis for In-Memory Caching to faster the WebServices.
- Ansible Github, Ansible Automation Platform-RedHat & Ansible Playbook ex: for automating Oracle PSU Patching,
Database Binary Installation in IaaS (EC2/VM) cloud Server.
- Terrafrom (IaC) automation ex: Provisioning RDS/PaaS Instance, EC2 Instance/VM, Security Group etc ..
- Develop “Power BI” Report on Compliance practice & strong security practices (Metric & Remediation Plan) by pulling the data from centralized Database ex: OEM.
- Deepen my knowledge of major cloud providers' database offerings: Amazon AWS RDS (Relational Database Service)/Amazon Aurora and potentially MS Azure PaaS Databases. Understand their strengths, limitations, and migration strategies.
Other Expertise in On-Prem Databases:
- DB Design & Build perspective, preparing SBB-Solution Building Block for the Cloud Databases & Technical documents for the DBA Operation Team in 19c/12c, RAC, DataGuard, RMAN, ASM, Upgrade/Migrate, Cloning, DB Creation, DBRU & OJVM PSU Patching Steps, DB Refreshes & Security management.
- Working closely with Product Owner and senior client stakeholders to establish the delivery credentials to create strategic and completive differentiation for the company.
- Actively monitoring Metric & Remediation Plan and brings it up to senior management attention.
- Ensuring clear and timely communication and reporting of progress status risks to internal.
