MySQL and PostgreSQL installation Setup on VMware or AWS Cloud( EC2 and RDS both).
Query optimization, Performed Migration of MySQL and Postgres On-Premise/EC2 Databases to AWS RDS. Performed Migration of MySQL and Postgres, AWS RDS to On-Premise/EC2.
Developed and executed comprehensive strategies for database backup, restoration, and policy formulation. Orchestrated full, differential, and transactional backups, ensuring data integrity and disaster recovery readiness.
Executed database recovery procedures for both system and user databases, minimizing downtime and data loss.
Managed log shipping, mirroring, replication, and cluster configurations for high availability and scalability.
Employed query optimization techniques to enhance performance and efficiency of long-running queries.
Conducted code optimization initiatives, including re-indexing, updating statistics, and recompiling stored procedures.