职位介绍
摘自雇主发布的职位信息 · PCCW SOLUTIONS INSYS PTE. LTD. · 发布于2026年10月9日
About the Role
We are looking for a 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, 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.
-
3 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.
-
One of the relevant certifications is a must (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.
















