PostGres Database Administrator

TROYTECH INTERNATIONAL CONSULTING PTE LTD; Singapore; On-site; SGD 80,000 - 120,000; Full time

Job summary

A leading company in consulting seeks a Database Architect/Developer to oversee database design and migration. The role requires extensive experience with PostgreSQL, strong analytical skills, and a solid background in database management. This position offers the opportunity to work with cloud technologies and contribute to significant projects within the organization.

Qualifications

• Minimum 5 years of relevant experience with PostgreSQL and 10 years in database domain.
• Certification as a Database Architect/Developer in PostgreSQL required.
• Experience with UNIX/Linux and Windows environments.

Responsibilities

• Design, implement, document, administer, and monitor databases.
• Migrate databases from DB2 and MySQL to PostgreSQL.
• Work with development team on requests and changes.

Skills

Database design

Communication

Problem-solving

Cloud services management

Scripting

Automation

Performance tuning

Education

Bachelor's degree in engineering, data communications, or computer science

Job description

Responsibilities:

• The candidate is responsible for designing, implementing, documenting, administering, and monitoring databases to ensure they run efficiently and securely.
• Work with the development team to keep them updated on the status of their requests, initiate and perform changes on non-production systems, and proactively escalate any issues that cannot be resolved within established timeframes.
• Extensive experience in migrating from current database systems (DB2, MySQL) to PostgreSQL.

Qualifications & Requirements:

• Bachelor's degree in a technical major such as engineering, data communications, or computer science.
• Good communication and documentation skills.
• Certification as a Database Architect/Developer in PostgreSQL.
• Minimum of 5 years of relevant experience with PostgreSQL and 10 years in the database domain.
• Extensive understanding of architecture and design in server and cloud technologies.
• Proficiency in both cloud and on-premise enterprise data warehouse configuration and administration.
• Hands-on experience managing cloud services, scripting, automation, and administration tools.
• Experience with Continuous Integration and Continuous Delivery (CI/CD) practices.
• Experience through at least one full software development lifecycle using RUP, including requirements specification, use cases, design models, and data modeling.
• Experience with UNIX/Linux and Windows environments.
• Extensive database design experience with knowledge of OLTP and OLAP concepts.
• Experience in database performance tuning, maintenance, and backup methodologies.
• Proven experience migrating databases from systems like DB2 and MySQL to PostgreSQL.
• Strong analytical and problem-solving skills.
• Proficient in written and verbal English communication skills.