23 Aug
|
SMC Group
|
India
Role/Position – SQL Server & PostgreSQL Database Administrator.
Experience:
4+yrs.
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.
Solid experience with
Microsoft SQL Server and PostgreSQL
.
Experience managing databases on
On-Premises and AWS-hosted infrastructure
.
Solid knowledge of
backup/recovery, performance tuning, HA/DR, replication, and database security
.
Valuable experience with
PostgreSQL TimescaleDB
.
Experience with
SQL Server Always on
and PostgreSQL replication.
Experience with database
audit, compliance, access ma
📌 Sql Server Delhi (India)
🏢 SMC Group
📍 India