Job Title: MySQL & PostgreSQL Database Support Engineer
Role Summary
We are seeking a skilled Database Support Engineer with hands-on experience in MySQL and PostgreSQL to manage, maintain, and support mission-critical database environments. The role involves performance tuning, troubleshooting, backup/recovery, and ensuring high availability of database systems.
Shape
Key Responsibilities
Database Administration & Support
Provide 24/7 production support for MySQL and PostgreSQL databases.
Monitor database health, performance, and availability using monitoring tools.
Handle incident management, root cause analysis (RCA), and resolution of database issues.
Perform installation, configuration, and upgrades of database servers.
Performance Tuning & Optimization
Analyze slow-running queries and optimize SQL performance.
Implement indexing strategies and query improvements.
Monitor and tune database parameters for optimal performance.
Backup & Recovery
Design and manage backup and restore strategies (logical and physical backups).
Perform regular backup validation and disaster recovery (DR) drills.
Ensure data integrity and availability during failures.
High Availability & Replication
Configure and maintain replication setups (Master-Slave, streaming replication, etc.).
Support failover, clustering, and load balancing solutions.
Ensure minimal downtime and quick recovery.
Security & Compliance
Manage database user roles, privileges, and access control.
Implement database security best practices and audit compliance.
Monitor unauthorized access and apply patches regularly.
Automation & Scripting
Develop scripts (Shell, Python, etc.) for automation of routine DBA tasks.
Implement database monitoring and alerting mechanisms.
Collaboration & Documentation
Work closely with application, DevOps, and infrastructure teams.
Maintain proper documentation for configurations, processes, and SOPs.
Provide support during deployments and releases.