Overall 4.5+ years’ experience as MySQL and PostgreSQL Database Administrator (DBA) in Production, Development and Staging environments.
Installation and configuration of MySQL and PostgreSQL with recent versions.
Installation of MySQL and PostgreSQL instance on AWS EC2 and RDS instance.
Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
Performing Database Recovery on MySQL and PostgreSQL and also point in time recovery.
Implementing Replication on MySQL and PostgreSQLFixing Replication Issues on Live Production. Support Environment Experienced in Performance Tuning Client/Server Connectivity, and Database Consistency Checks using Different Utilities.
Expertise in MySQL Master-slave, Master-Master and PostgreSQL Streaming Replication
Expertise in PostgreSQL Maintainace using Vacuum, Full vacuum and Auto vacuum.
Expertise import/export, DB optimization MYSQL .
Experience in user creation, backup and restore basic troubleshooting.
Involved in client Production Support and Maintenance - Tasks including programming, debugging and testing of existing applications that run in a production environment for purposes of remediation system errors or to extend application life span
Providing 24*7 Support for Critical Projects which require maximum uptime Tuning Windows & Linux Server as per client requirement
Performing Time Constraint based Database Implementation with maintaining highest level of quality Performing Manual Product Testing before the Go Live Period
Working with Cross Functional Team’s to enhance the support experience for the end user