PostgreSQL DBA (Senior)

ALPHAWALL PTE. LTD.; Singapore; On-site; SGD 60,000 - 80,000; Full time

Job summary

A technology company in Singapore is looking for a Database Administrator to build high availability database environments. Tasks include monitoring and optimizing PostgreSQL and MySQL databases, implementing security controls, and providing technical support. The ideal candidate has a Bachelor's degree in IT and at least 3 years of experience in database management. Attractive benefits are provided.

Benefits

Attractive rewards for long-term service staff

Friendly working environment

Medical insurance

Qualifications

• At least 3 years of experience in PostgreSQL for a senior position.
• Familiar with SQL statement, performance tuning, and troubleshooting.
• Strong knowledge in database security control.

Responsibilities

• Build a new HA DB environment and monitoring system.
• Daily PostgreSQL and MySQL database monitoring and optimization.
• Participate in database cutovers and data migration.
• Perform stress testing on production databases.

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

Job Description

• 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;
• Arrange to participate in the implementation of various types of cutovers, including the switchover from one master to multiple slaves, the implementation of 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.

Requirement

• Candidate must possess at least Bachelor's Degree/Post-Graduate Diploma/Professional Degree in Computer Science/Information Technology or equivalent.
• 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.

Company Benefit

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