Database Administrator

Lancesoft; Kuala Lumpur; Hybrid; MYR 90,000 - 120,000; Full time

Job summary

A leading tech company in Kuala Lumpur seeks a Senior PostgreSQL Database Engineer. You will manage and optimize PostgreSQL databases on Linux and Azure, lead database migration projects, and implement advanced features to enhance performance. The ideal candidate has over 3 years of database experience in a cloud environment and a strong background in relational DBMS. This role offers a hybrid work model with flexibility for remote work, requiring presence in the office at least three days a week.

Qualifications

• 3+ years of experience with PostgreSQL in a cloud environment.
• Strong knowledge of Relational Database Management Systems.
• Advanced expertise in PostgreSQL internals and performance tuning.

Responsibilities

• Manage, optimize, and ensure high availability of PostgreSQL databases on Linux and Azure.
• Lead complex database projects, including migrations and performance tuning.
• Architect disaster recovery solutions and manage high-availability configurations.

Skills

PostgreSQL

Azure cloud platform

Database optimization

Disaster recovery solutions

Education

Bachelor's degree or equivalent work experience

Tools

CI/CD pipelines

Azure Database for PostgreSQL

Job description

An excellent opportunity for a Database Administrator, looking for a long‑term opportunity, growth and flexible work environment within the Database Services team.

We will rely on you to:

• Manage, optimize, and ensure the high availability of PostgreSQL databases hosted on Linux and Azure cloud platform.
• Lead complex database projects, including database migrations, performance tuning, and high‑availability configurations.
• Implement advanced PostgreSQL features (e.g., partitioning, indexing strategies, advanced query tuning, and replication) to optimize database performance at scale.
• Oversee the configuration and management of Azure‑specific PostgreSQL offerings such as Azure Database for PostgreSQL - Flexible Server and Azure Database for PostgreSQL - Single Server.
• Configure and maintain high‑availability solutions for PostgreSQL (e.g., Azure Availability Zones, synchronous replication, failover strategies) using the Azure Resource Manager templates and CI/CD pipelines.
• Architect and manage disaster recovery solutions, including point‑in‑time recovery (PITR) and cross‑region replication.
• Strong knowledge of PostgreSQL extensions (e.g., PostGIS, pg_partman, pg_stat_statements), their deployment in a cloud environment using the CI/CD pipelines and how to leverage them in production environments.
• Collaborate with DevOps teams to implement CI/CD pipelines for database schema changes and PostgreSQL deployments.

What you need to have:

• Experienced Senior PostgreSQL Database Engineer with extensive expertise in PostgreSQL and Azure PostgreSQL.
• 3+ years of database experience with Postgres in Cloud.
• Bachelor’s degree preferred or equivalent work experience.
• Sound knowledge of Relational DBMS (Database Management Systems).
• Talented in Database and cloud computing design, architectures, and data lakes.

What makes you stand out?

Advanced experience with PostgreSQL internals and performance tuning, including query execution plans, auto vacuum settings, and complex transaction management.

Hybrid work model, including flexibility for remote work and collaboration in the office. Colleagues are expected to be in their local office or working onsite with clients at least three days per week.

Flexibility is required in this role, so from time to time, the individual may need to work longer hours or outside of regular working hours in the event of critical issues requiring expedited problem management support.

Global support coverage required inclusive of coverage for Pacific timezone. With this, candidate must be available for early morning shifts.

If you are interested in this position, please share your updated resume at ***********@lancesoft.com with these details:-