Database Administrator

HCLTech; Dadri; On-site; INR 900,000 - 1,300,000; Full time

Job summary

HCLTech is seeking a skilled Database Support Engineer to manage MySQL and PostgreSQL environments with hands-on expertise in tuning, backup/recovery, and high availability. The role requires 24/7 production support, incident management, and close collaboration with DevOps and application teams.

The candidate will perform installations, upgrades, performance tuning, and security best practices to ensure data integrity and availability across mission-critical systems.

Qualifications

• Hands-on experience with MySQL and PostgreSQL databases.
• Ability to troubleshoot complex SQL queries and performance issues.
• Experience with backup, recovery, and disaster recovery planning.
• Familiarity with high availability, replication, and failover strategies.
• Scripting knowledge (Shell, Python) to automate DBA tasks.

Responsibilities

• Provide 24/7 production support for MySQL and PostgreSQL databases.
• Monitor database health, performance, and availability using monitoring tools.
• Handle incident management, RCA, and resolution of database issues.
• Perform installation, configuration, and upgrades of database servers.
• Analyze slow queries and optimize SQL performance.
• Design and manage backup and restore strategies (logical and physical).
• Configure and maintain replication setups (Master-Slave, streaming replication).
• Support failover, clustering, and load balancing.
• Manage database user roles, privileges, and access controls.
• Develop automation scripts for routine DBA tasks and deploy monitoring/alerts.

Job description

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.

Work closely with application, DevOps, and infrastructure teams.

Maintain proper documentation for configurations, processes, and SOPs.

Provide support during deployments and releases.

Key Responsibilities

1. To adhere to quality standards, regulatory requirements and company policies.

2. To provide support for on call escalations and doing root cause analysis of given issue.

3. Work on value adding activities such Knowledge base update & management, Training freshers, coaching analysts.

4. To independently resolve tickets within agreed SLA of ticket volume and time.

5. To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions / Reopen Cases.