Posted today · be early

Database Administrator

HCLTech

Noida, Uttar Pradesh, IndiaPosted today

Skill Required

FulltimeDatabase AdministratorQuery OptimizationBackup and RecoveryNginxPostgreSQLObservabilityPythonMySQLSQL

Role overview

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.

Responsibilities

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.
Analyze slow-running queries and optimize SQL performance.
Implement indexing strategies and query improvements.
Monitor and tune database parameters for optimal performance.
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.
Configure and maintain replication setups (Master‑Slave, streaming replication, etc.).
Support failover, clustering, and load balancing solutions.
Ensure minimal downtime and quick recovery.
Manage database user roles, privileges, and access control.
Implement database security best practices and audit compliance.
Monitor unauthorized access and apply patches regularly.
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.
To adhere to quality standards, regulatory requirements and company policies.
To provide support for on call escalations and doing root cause analysis of given issue.
Work on value adding activities such Knowledge base update & management, Training freshers, coaching analysts.
To independently resolve tickets within agreed SLA of ticket volume and time.
To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions / Reopen Cases.