Senior DBA: SQL Server & PostgreSQL Expert (24/7 Ops)

IoTalents Pte. Ltd.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

IoTalents Pte. Ltd. is seeking an experienced Database Administrator to manage, maintain, and optimize mission-critical database environments in Singapore.

The role focuses on SQL Server and PostgreSQL, with emphasis on administration, performance tuning, high availability, disaster recovery, security, and automation to keep databases reliable and secure. You will collaborate with application, infrastructure, cloud, and business teams to ensure availability, reliability, and strong data

Qualifications

• Strong hands-on experience with Microsoft SQL Server and PostgreSQL.
• Experience in database administration, performance tuning, high availability, disaster recovery, security, and automation.
• Ability to work with application, infrastructure, cloud, and business teams to ensure database availability, reliability, security, and performance.

Responsibilities

• Install, configure, upgrade, patch, and maintain SQL Server environments.
• Support AlwaysOn Availability Groups, Clustering, Replication, and Log Shipping.
• Perform database backup, recovery, refresh, and cloning.
• Monitor database health, performance, and capacity.
• Troubleshoot production issues and perform root cause analysis.
• Implement database security, auditing, and compliance controls.
• Install, configure, administer, and maintain PostgreSQL databases.
• Administer PostgreSQL 12–16 environments.
• Support streaming replication, logical replication, and high availability solutions.
• Perform database, query, index, and configuration tuning.
• Manage PostgreSQL upgrades and migrations.
• Administer backup and recovery solutions.
• Monitor database performance and proactively identify bottlenecks.
• Manage schemas, roles, privileges, and extensions.
• Analyze and optimize database performance.
• Identify and resolve slow‑running queries.
• Perform query, index, and statistics optimization.
• Conduct database growth forecasting and capacity planning.
• Optimize resource utilization across database environments.
• Support HA/DR database architectures.
• Conduct disaster recovery testing and failover exercises.
• Maintain and validate backup and recovery strategies.
• Ensure database environments meet defined RTO/RPO requirements.
• Implement database security best practices.
• Manage database users, roles, privileges, and authentication.
• Support vulnerability remediation and security audits.
• Implement encryption, password policies, and governance controls.
• Ensure compliance with organizational and regulatory requirements.
• Automate DBA activities using: Ansible, PowerShell, Shell scripting, SQL scripting.
• Develop automation workflows for: Database provisioning, Backup validation, Database health checks, Patching, Database refresh and cloning.
• Provide L3/L4 production support and participate in 24x7 on-call.

Skills

SQL Server

PostgreSQL

Performance tuning

High availability

Disaster recovery

Security

Automation

Mentoring

24x7 on-call

Tools

Ansible

PowerShell

Shell scripting

SQL scripting

Job description

IoTalents Pte. Ltd. is seeking an experienced Database Administrator to manage, maintain, and optimize mission-critical database environments in Singapore.

The role focuses on SQL Server and PostgreSQL, with emphasis on administration, performance tuning, high availability, disaster recovery, security, and automation to keep databases reliable and secure. You will collaborate with application, infrastructure, cloud, and business teams to ensure availability, reliability, and strong data