Noida, Uttar Pradesh
Job Summary
To ensure on-time resolution of escalations/incidents through efficient analysis as per the SLA, quality norms and ensure positive customer satisfaction and contribute to EN business creation.
Key Responsibilities

Microsoft SQL Server Administration

Install, configure, upgrade, patch, and maintain SQL Server environments.

Manage SQL Server AlwaysOn Availability Groups, Clustering, Log Shipping, Replication, and Failover strategies.

Perform database backup, recovery, refresh, and cloning activities.

Monitor database health, performance, and capacity utilization.

Troubleshoot production issues and provide root cause analysis.

Implement SQL Server security standards, auditing, and compliance controls.

PostgreSQL Administration

Install, configure, administer, and maintain PostgreSQL databases.

Manage PostgreSQL replication, streaming replication, logical replication, and high availability solutions.

Perform performance tuning of PostgreSQL databases, queries, indexes, and configurations.

Execute PostgreSQL version upgrades and migrations.

Administer PostgreSQL backup and recovery solutions.

Monitor PostgreSQL instances and proactively identify performance bottlenecks.

Skill Requirements

SQL Server

SQL Server 2016/2019/2022 Administration

AlwaysOn Availability Groups

Clustering

Replication

Backup & Recovery

Performance Tuning

Query Optimization

Security & Auditing

Other Requirements

PostgreSQL

PostgreSQL 12/13/14/15/16 Administration

Replication & High Availability

Backup & Recovery

Performance Tuning

Query Optimization

Extension Management

Schema & Role Administration

Operating Systems

Windows Server

Linux (RHEL, CentOS, Ubuntu)

Preferred Skills





Experience with database migrations and modernization projects.

Experience in cloud-native database platforms.

Knowledge of ITIL processes.

Experience working in globally distributed support teams.

Exposure to DevOps and CI/CD practices.

Knowledge of database security and cybersecurity compliance frameworks.

Soft Skills

Excellent communication and stakeholder management skills.

Strong analytical and troubleshooting abilities.

Ability to work under pressure in a 24x7 production setting.

Strong documentation and presentation skills.

Ability to mentor junior DBAs and lead techni

Performance & Capacity Management

Analyze and optimize database performance.

Identify slow-running queries and implement tuning recommendations.

Conduct index optimization and statistics maintenance.

Perform database growth forecasting and capacity planning.

Ensure optimal resource utilization across database environments.

High Availability & Disaster Recovery

Design, implement, and support HA/DR architectures.

Execute disaster recovery testing and failover exercises.

Maintain and validate backup and recovery strategies.

Ensure compliance with defined RTO/RPO objectives.

Database Security & Compliance

Implement database security best practices.

Manage user access, roles, privileges, and authentication mechanisms.

Support vulnerability remediation and security audits.

Enforce encryption, password policies, and governance standards.

Ensure compliance with organizational and regulatory requirements.

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

📌 Sr Subject Matter Expert (Support&Ops) (Noida)
🏢 HCLTech
📍 Noida