Database DBA: SQL Server & PostgreSQL | HA/DR & Automation

AVATAR MODERN TECHNO SERVICES PTE. LTD.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

AVATAR MODERN TECHNO SERVICES PTE. LTD. is seeking a highly skilled SQL Server and PostgreSQL Database Administrator (DBA) to manage, optimize, and secure mission-critical database environments.

You will work with application, infrastructure, cloud, and business teams to ensure high availability and operational excellence. Responsibilities include managing SQL Server Always On, replication, clustering, backups, performance tuning, and PostgreSQL HA, tuning, upgrades, and security compliance.

Qualifications

• Experience administering SQL Server 2016/2019/2022.
• Experience with Always On, clustering, replication, and log shipping.
• Experience administering PostgreSQL and HA configurations.
• Backup, recovery, performance tuning, and security auditing.

Responsibilities

• Install, configure, upgrade, patch, and maintain SQL Server environments.
• Manage SQL Server Always On 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.
• 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.
• 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.
• 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.
• 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.
• Automate repetitive DBA activities using tools such as Ansible, PowerShell, Shell scripting, SQL scripting.
• Build automated workflows for Database provisioning, Backup validation, Health checks, Patching activities, Refresh and cloning operations, Production Support.
• Provide L3/L4 support for critical production environments.
• Participate in on-call support rotation.
• Support incident, problem, and change management processes.
• Work closely with application and infrastructure teams during outages and major incidents.

Skills

SQL Server

SQL Server Administration

Always On Availability Groups

Clustering

Replication

Backup & Recovery

Performance Tuning

Query Optimization

Security & Auditing

Windows Server

Linux

Tools

Ansible

PowerShell

Shell scripting

SQL scripting

Job description

AVATAR MODERN TECHNO SERVICES PTE. LTD. is seeking a highly skilled SQL Server and PostgreSQL Database Administrator (DBA) to manage, optimize, and secure mission-critical database environments.

You will work with application, infrastructure, cloud, and business teams to ensure high availability and operational excellence. Responsibilities include managing SQL Server Always On, replication, clustering, backups, performance tuning, and PostgreSQL HA, tuning, upgrades, and security compliance.