Lead Database Engineer
PostgreSQL :✓ Install, configure, test, monitor, upgrade and tune new and existing PostgreSQL databases 9.6,10,11,12,13,14 & 15 Versions✓ Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples✓ providing support for various projects and ongoing issue in Development, Testing and PROD environment including Database upgrade, Application patches and DR solution.✓ User Management✓ Implemented high-availability solution like Streaming Replication✓ Quarterly Patching on On-prem and AWS RDS InstancesMySQL :✓ Install, Configure and manage multiple MySQL instances✓ Upgradation from MySQL 5.6 to 5.7 and 5.7 to 8.0✓ Configuring MySQL Enterprise Backup✓ Configured Master and slave replication✓ Performed backups and restoration✓ Refreshing databases and tables from Production to DEV/QA/UAT✓ Setup and manage user privileges within the database✓ Managing more than 80 prod/non-prod database servers.✓ Applying Quarterly MySQL Database Patching on On-prem and AWS RDS.✓ Preparing database patching calendar and coordinating with different application teams for database patching.✓ Performing periodic BCP drill✓ Performing AWS RDS failover testing.✓ Managing and preparing database inventory every month.✓ Performing database archiving activity and Capacity Planning.✓ Preparing SOP for different DBA activities and updating it periodically.✓ Efficient handling of DB tools like Percona-toolkit, Xtrabackup, MySQL Utilities etc to perform various DBA Tasks.✓ Maintaining Resource Profiling & Index Management with respect to the MySQL database.✓ Migrating Database Servers from Traditional DC to AWS Cloud service.MongoDB Atlas:✓ Installed mongodb & Configured 3 node & 5 Node Replicasets✓ User Management in MongoDB Atlas✓ Worked on Online Archive Configuration✓ Worked on Database Issues✓ Mongo exports and Mongo dump.✓ Upgraded MongoDB Atlas Cluster from 4.4 V to 6.0 V on Dev/Staging/Production Environment Clusters.
