SME - Logical DBA, MySQL
India
Apply now
Job Description
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 & SupportProvide 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 & OptimizationAnalyze slow-running queries and optimize SQL performance.Implement indexing strategies and query improvements.Monitor and tune database parameters for optimal performance.Backup & RecoveryDesign 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 & ReplicationConfigure and maintain replication setups (Master-Slave, streaming replication, etc.).Support failover, clustering, and load balancing solutions.Ensure minimal downtime and quick recovery.Security & ComplianceManage database user roles, privileges, and access control.Implement database security best practices and audit compliance.Monitor unauthorized access and apply patches regularly.Automation & ScriptingDevelop scripts (Shell, Python, etc.) for automation of routine DBA tasks.Implement database monitoring and alerting mechanisms.Collaboration & DocumentationWork closely with application, DevOps, and infrastructure teams.Maintain proper documentation for configurations, processes, and SOPs.Provide support during deployments and releases.

Skill Requirements

Technical SkillsStrong 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 & ToolsExperience with Shell/Python scripting

Other Requirements

null
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 227,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending March 2026 totaled $14.7 billion.