SQL Server & PostgreSQL Database Administrator

SMC Global Securities; New Delhi; Presencial; INR 1 500 000 - 2 500 000; Tempo integral

Resumo da oferta

SMC Global Securities in Delhi is seeking an experienced SQL Server and PostgreSQL DBA to manage production databases across on‑premises and AWS environments. You will be responsible for database availability, performance, security, backup/recovery, compliance, and operational support.

The role requires 4+ years of hands‑on DBA experience, strong Linux/Windows administration, and expertise in Always On, replication, and security controls.

Qualificações

• 4+ years hands-on DBA experience.
• Hands-on with MS SQL Server and PostgreSQL.
• Experience on On-Premises and AWS infrastructure.
• Backup/recovery, HA/DR, replication, and security.
• Linux and Windows administration knowledge.

Responsabilidades

• Administer, monitor, and troubleshoot SQL Server and PostgreSQL production environments.
• Manage databases hosted on On-Premises and AWS infrastructure.
• Perform installation, configuration, patching, upgrades, migrations, and capacity planning.
• Manage SQL Server Always On, PostgreSQL Replication, HA/DR, and failover activities.
• Perform backup, restore, recovery, and DR testing.
• Automate routine DBA activities using T-SQL, PowerShell, Bash, or Python.
• Handle production incidents, perform RCA, and implement preventive measures.
• Maintain DBA documentation, SOPs, security controls, and operational procedures.

Conhecimentos

DBA experience

MS SQL Server

PostgreSQL

On-Prem & AWS

Backup/Recovery

HA/DR

Replication

Security controls

Linux/Windows admin

Descrição da oferta de emprego

Job Description

SQL Server & PostgreSQL Database Administrator.

Experience: 4 to 7yrs.

Role: SQL Server & PostgreSQL Database Administrator.

Job Summary

We are looking for an experienced SQL Server & PostgreSQL DBA with 4+ years of hands‑on experience managing production databases hosted across On‑Premises and AWS environments. The candidate will be responsible for database availability, performance, security, backup/recovery, compliance, and operational support.

Key Responsibilities

• Administer, monitor, and troubleshoot SQL Server and PostgreSQL production environments.
• Manage databases hosted on On‑Premises and AWS infrastructure.
• Perform database installation, configuration, patching, upgrades, migrations, and capacity planning.
• Manage SQL Server Always On, PostgreSQL Replication, HA/DR, and failover activities.
• Perform database backup, restore, recovery, and DR testing.
• Perform performance tuning, query optimization, indexing, and troubleshooting.
• Manage database growth, storage, and capacity planning.
• Implement database security including users, roles, permissions, encryption, TDE, and least‑privilege access.
• Support security audits, compliance requirements, access reviews, and audit findings remediation.
• Monitor database health, performance, replication, backups, storage, and availability.
• Automate routine DBA activities using T‑SQL, PowerShell, Bash, or Python.
• Handle production incidents, perform RCA, and implement preventive measures.
• Maintain DBA documentation, SOPs, security controls, and operational procedures.

Required Skills

• 4+ years of hands‑on DBA experience.
• Strong experience with Microsoft SQL Server and PostgreSQL.
• Experience managing databases on On‑Premises and AWS‑hosted infrastructure.
• Strong knowledge of backup/recovery, performance tuning, HA/DR, replication, and database security.
• Good experience with PostgreSQL TimescaleDB.
• Experience with SQL Server Always On and PostgreSQL replication.
• Experience with database audit, compliance, access management, and security controls.
• Good Linux and Windows administration knowledge.
• Strong troubleshooting, analytical, and communication skills.

Good to Have

• AWS infrastructure/database hosting experience.
• PostgreSQL TimescaleDB administration and performance tuning.
• AWS DMS / database migration experience.
• CloudWatch or other monitoring tools.
• Python/Bash/PowerShell automation.
• MongoDB administration.