Database Administrator | SQL

ScienTec Consulting Pte Ltd; Singapore; Hybrid; SGD 60,000 - 80,000; Full time

Job summary

A leading company in Singapore is seeking an experienced Database Administrator to manage and optimize PostgreSQL databases. The role includes substantial responsibilities for installation, administration, and collaboration with AWS teams to ensure high availability and performance. Ideal candidates should possess a relevant degree and significant DBA experience.

Qualifications

• Minimum 5 years' experience as a PostgreSQL DBA.
• Strong proficiency in PostgreSQL and management on AWS.
• Experience with backup, replication, monitoring, and performance tuning tools.

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases.
• Collaborate with AWS teams to patch and update databases.
• Develop and maintain backup and recovery strategies.

Skills

PostgreSQL

Database Security

Troubleshooting

SQL

Performance Tuning

Education

Bachelor’s degree in Computer Science, IT, Software Engineering, or related field

Tools

AWS RDS

Monitoring Tools

Backup and Replication Tools

Job description

Working Hours: Monday - Friday (10am – 7pm) [Hybrid Working Arrangement]
Working Location: Central
Salary Package: Up to $7,500 (with VB and AWS)

We are seeking an experienced Database Administrator to manage, maintain, and optimize our PostgreSQL database systems, ensuring high availability, performance, and security.

Key Responsibilities:

• Install, configure, upgrade, and maintain PostgreSQL databases.
• Administer and support production databases with 24/7 monitoring.
• Collaborate with AWS teams to ensure databases are patched and updated.
• Monitor database health and troubleshoot issues to maintain stability.
• Design and optimize PostgreSQL schemas.
• Diagnose and resolve performance issues through query optimization.
• Conduct performance analysis and recommend improvements.
• Implement indexing, partitioning, and other performance techniques.
• Develop and maintain backup and recovery strategies; perform recovery testing.
• Manage user access, roles, and data encryption to ensure security.
• Conduct regular audits and apply security patches promptly.
• Ensure compliance with data protection standards.
• Collaborate with development and infrastructure teams on scalable solutions.
• Develop and maintain schemas, tables, indexes, views, and functions.
• Provide database support for new projects.
• Write scripts to automate routine tasks and improve efficiency.
• Deploy monitoring tools for proactive database management.
• Maintain clear documentation of configurations, processes, and procedures.

Qualifications:

• Bachelor’s degree in Computer Science, IT, Software Engineering, or related field.
• Minimum 5 years’ experience as a PostgreSQL DBA
• Strong proficiency in PostgreSQL, including management on AWS RDS.
• Experience with tools for backup, replication, monitoring, and performance tuning.
• Solid knowledge of SQL, PL/pgSQL, and database optimization best practices.

By submitting your resume, you consent to the collection, use, and disclosure of your personal information per ScienTec’s Privacy Policy (scientecconsulting.com/privacy-policy).
This authorizes us to:

• Contact you about potential opportunities.
• Delete personal data as it is not required at this application stage.
• All applications will be processed with strict confidence. Only shortlisted candidates will be contacted.

Wong Siew Ting (Maeve) - R25127375
ScienTec Consulting Pte Ltd - 11C5781