SME - Logical DBA, MySQL

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\-