PostgreSQL DBA (Junior & Senior)

ALPHAWALL PTE. LTD.; Singapore; On-site; SGD 50,000 - 90,000; Full time

Job summary

A tech company in Singapore is seeking a Database Administrator responsible for maintaining a high-availability database environment. Candidates should have experience in PostgreSQL and be able to implement monitoring and automation systems. The role offers a friendly work environment and benefits like medical insurance and rewards for long-term staff.

Benefits

Attractive rewards for long-term service staff

Friendly working environment

Medical insurance

Qualifications

• 1+ year experience in PostgreSQL for junior role; 3+ years for senior role.
• Familiarity with SQL statements, performance tuning.
• Strong knowledge in DB security control.

Responsibilities

• Build a new HA DB environment including monitoring and automation systems.
• Daily monitoring and optimization of PostgreSQL, MySQL databases.
• Ensure database security hardening.

Skills

PostgreSQL

Database monitoring

DB automation system

Technical support

HA DB environment

Production database testing

Education

Bachelor's Degree in Computer Science/Information Technology

Job description

Overview

The job involves building and maintaining a high-availability (HA) database environment and related systems, including monitoring, automation, logging, backups, and other DB components.

Responsibilities

• The candidate must be able to build up a new HA DB environment, including a DB monitoring system, DB automation system, DB log system, DB backup system, and other DB systems.
• Daily PostgreSQL, MySQL database monitoring, operation and maintenance, optimization, troubleshooting;
• Database security hardening to ensure the integrity and security of the database and backup data availability;
• Participate in the implementation of various types of cutovers, including switchover from one master to multiple slaves, BI data push, cluster data synchronization, and data migration;
• Perform stress testing on production databases and optimize database performance;
• Set up a cluster and disaster recovery environment to achieve high availability of the database.

Qualifications

• Candidate must possess at least Bachelor\'s Degree/Post-Graduate Diploma/Professional Degree in Computer Science/Information Technology or equivalent.
• At least 1 Year of working experience in PostgreSQL database for a junior position. At least 3 Year(s) of working experience in PostgreSQL database for a senior position.
• Required Skill(s): PostgreSQL, database monitoring, DB automation system, technical support, HA DB environment, production database testing
• Familiar with SQL statement, performance tuning, and troubleshooting application issues
• Strong Knowledge in DB security control
• Team player and able to work independently
• Provide technical support to other team members
• Preferably Senior Executive specialized in IT/Computer - Network/System/Database Admin or equivalent.

Benefits

• Attractive rewards for long-term service staff
• Friendly working environment (flexible working hours, quarterly events, staff birthday celebration and etc.)
• Medical insurance