PostgreSQL DBA (Junior)

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

Job summary

A database solutions company in Singapore is seeking a candidate to develop and maintain HA database environments. The role includes responsibilities in database monitoring, optimization, and security hardening. Applicants should have a Bachelor's degree in Computer Science/IT and at least one year of relevant experience. Benefits include medical insurance and a friendly working environment.

Benefits

Attractive rewards for long-term service staff

Friendly working environment

Medical insurance

Qualifications

• At least 1 year of relevant working experience for a junior position.
• Familiar with SQL statements, performance tuning, and troubleshooting.
• Strong knowledge in database security control.

Responsibilities

• Build a new HA DB environment, including various database systems.
• Monitor and maintain PostgreSQL and MySQL databases.
• Implement cutovers, data migration, and data synchronization.

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 1 year of working experience in the related field is required for a junior 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