Noida, Uttar Pradesh
Job 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.
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 .
Skill Requirements
Technical Skills Strong experience with: MySQL (5.x/8.x) PostgreSQL (9.x and above) Expertise in: Query optimization & indexingBackup tools (mysqldump, pg_dump, XtraBackup, etc.)Replication and clusteringKnowledge of: Linux/Unix environmentsSQL and database design principlesPerformance monitoring tools (Nagios, Prometheus, Grafana, etc.) Scripting & Tools Experience with Shell/Python scripting
#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-
