Senior Database Administrator SQL Server & PostgreSQL

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

We are looking for an experienced Database Administrator (DBA) to manage, maintain, and optimize mission-critical database environments.

The ideal candidate will have strong hands‑on experience with Microsoft SQL Server and PostgreSQL, including database administration, performance tuning, high availability, disaster recovery, security, and automation.

You will work closely with application, infrastructure, cloud, and business teams to ensure database availability, reliability, security, and performance.

Key Responsibilities

Microsoft SQL Server Administration

• Install, configure, upgrade, patch, and maintain SQL Server environments.
• Administer SQL Server 2016/2019/2022.
• 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.

PostgreSQL Administration

• 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.

Performance & Capacity Management

• 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.

High Availability & Disaster Recovery

• 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.

Database Security & Compliance

• 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.

Automation

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

Production Support

• Provide L3/L4 support for critical production database environments.
• Participate in 24x7 on-call support.
• Support Incident, Problem, and Change Management processes.
• Work with application and infrastructure teams during outages and major incidents.
• Mentor junior DBAs and support technical improvement initiatives.

Mandatory Technical Skills

SQL Server

• SQL Server 2016/2019/2022
• AlwaysOn Availability Groups
• Clustering
• Replication & Log Shipping
• Backup & Recovery
• Performance & Query Tuning
• Database Security & Auditing

PostgreSQL

• PostgreSQL 12–16
• Replication & High Availability
• Backup & Recovery
• Performance & Query Tuning
• Extension Management
• Schema & Role Administration

Operating Systems

• Windows Server
• Linux – RHEL / CentOS / Ubuntu

Automation

• Ansible
• PowerShell
• Shell / SQL scripting

Preferred Skills

• Database migration and modernization projects.
• Cloud-based / cloud-native database platforms.
• DevOps and CI/CD practices.
• ITIL processes.
• Database security and cybersecurity compliance frameworks.
• Experience supporting globally distributed production environments.

Key Attributes

• Strong analytical and troubleshooting skills.
• Excellent communication and stakeholder management skills.
• Comfortable working in a 24x7 production environment.
• Strong documentation and presentation skills.
• Ability to mentor junior DBAs and lead technical initiatives.