Cloud Senior Database Administrator - AWS

PCCW SOLUTIONS INSYS PTE. LTD.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

PCCW SOLUTIONS INSYS PTE. LTD. is seeking a Senior Database Administrator to design, implement, and maintain database environments across AWS Redshift, MSSQL, PostgreSQL, and Oracle. You will ensure performance, availability, security, and data integrity while mentoring junior DBAs.

You will lead capacity planning, backups, DR strategies, and upgrades, and participate in on-call rotations to support critical production systems. A strong, hands-on candidate with 5+ years of experience is required.

Qualifications

• Bachelor's degree or equivalent hands-on experience.
• 5 years of progressively responsible DBA experience.
• Hands-on with at least two systems (AWS Redshift, MSSQL, PostgreSQL, Oracle).
• Experience designing backup, recovery, and disaster recovery strategies.
• Strong performance tuning skills: queries, indexing, partitioning.
• Knowledge of security, access control, encryption, and audit/compliance.
• Scripting in Python, Bash, or PowerShell; IaC tools like Terraform/CloudFormation.
• Certifications preferred (AWS/Oracle/MaCZA).
• Experience mentoring junior engineers and leading best practices.
• Excellent written communication; able to document SOPs/runbooks.
• Willingness to participate in on-call rotation.

Responsibilities

• Administer and maintain multi-platform database environments (AWS Redshift, MSSQL, PostgreSQL, Oracle).
• Monitor performance, identify bottlenecks, and implement tuning strategies.
• Lead capacity planning and cloud resource optimization for AWS Redshift.
• Design and implement backup, recovery, and disaster recovery plans.
• Plan upgrades, patches, and migrations with minimal downtime.
• Troubleshoot incidents, perform root cause analysis, implement preventive measures.
• Manage security, access controls, encryption, and data governance compliance.
• Establish and enforce database standards and runbooks.
• Document architecture and configurations; maintain SOPs.
• Automate DBA tasks with scripting and IaC tools; mentor junior DBAs.
• Participate in on-call rotation to support production systems.

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

AWS Redshift

MS SQL Server (MSSQL)

PostgreSQL

Oracle

Terraform

CloudFormation

Python

Bash

PowerShell

Job description

About the Role:

We are looking for a Senior Database Administrator (DBA) to design, implement, and maintain database environments across multiple platforms, including AWS Redshift, Microsoft SQL Server (MSSQL), PostgreSQL, and Oracle. The ideal candidate is a hands-on database expert who ensures the performance, availability, security, and integrity of business-critical data systems, while mentoring junior team members and driving best practices across the organization.

Responsibilities:

• Administer, configure, and maintain database systems across AWS Redshift, MSSQL, PostgreSQL, and Oracle environments, ensuring high availability and optimal performance.
• Monitor database performance, proactively identify bottlenecks, and implement tuning strategies including query optimization, indexing, and partitioning.
• Lead capacity planning and scalability initiatives, including cloud resource optimization for AWS Redshift environments.
• Design and implement backup, recovery, and disaster recovery strategies to safeguard data integrity and minimize downtime.
• Plan and execute database upgrades, patches, and migrations with minimal disruption to production systems.
• Troubleshoot and resolve complex database incidents, performing root cause analysis and implementing preventive measures.
• Manage database security, including user access controls, roles, encryption, and compliance with data governance and regulatory requirements.
• Establish and enforce database standards, policies, and best practices across the organization.
• Develop and maintain documentation for database architecture, configurations, standard operating procedures, and runbooks.
• Automate routine database administration tasks using scripting languages (e.g., Python, Bash, PowerShell) and infrastructure-as-code tools.
• Mentor and provide technical guidance to junior DBAs.
• Participate in an on-call rotation to support critical production systems.

Requirements:

• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent hands-on experience.
• 5 years of progressive DBA experience, including hands-on administration of at least two of the following: AWS Redshift, MSSQL, PostgreSQL, Oracle.
• Proven experience designing and executing backup, recovery, and disaster recovery strategies in production environments.
• Strong grounding in performance tuning: query optimization, indexing strategy, partitioning, and capacity planning.
• Working knowledge of database security practices - access control, roles, encryption at rest/in transit, and audit/compliance requirements.
• Scripting proficiency in Python, Bash, or PowerShell, with experience automating routine DBA tasks; familiarity with infrastructure-as-code tools (e.g., Terraform, CloudFormation) is a plus.
• Relevant certifications preferred (e.g., AWS Certified Database - Specialty, Oracle OCP, Microsoft Certified: Azure Database Administrator Associate).
• Experience mentoring junior engineers and leading technical best-practice initiatives.
• Strong written communication skills for documentation, SOPs, and runbooks.
• Comfortable participating in an on-call rotation.

Nice to Have:

• Experience operating in regulated or public-sector environments with strict data governance and compliance requirements.
• Exposure to multi-account/multi-tenant cloud environments.
• Prior experience leading migrations or major version upgrades with minimal production disruption.