Database Administrator (PostgreSQL/AWS Aurora & MySQL)

Mission Consultancy Services Sdn. Bhd.; Puchong; On-site; MYR 70,000 - 90,000; Full time

Job summary

A tech consultancy firm in Malaysia is seeking an experienced Database Administrator to manage and optimize PostgreSQL and MySQL databases in both on-premises and cloud environments. The ideal candidate will have at least 7 years of experience and strong skills in database performance tuning, security, and data migration. This position offers a dynamic work environment focused on modern DevOps practices.

Qualifications

• Minimum 7 years of experience as a Database Administrator with expertise in PostgreSQL and MySQL.
• Strong understanding of database performance tuning and disaster recovery strategies.
• Hands-on experience with database security and compliance.

Responsibilities

• Manage and optimize PostgreSQL and MySQL databases in on-premises and cloud environments.
• Deploy and configure database clusters on AWS.
• Implement security best practices and manage user permissions.

Skills

PostgreSQL

MySQL

AWS Aurora

Data migration

Database performance tuning

Tools

CloudWatch

pgAdmin

MySQL Workbench

Talend

Shell scripting

Python

Job description

Position Overview

• As a Database Administrator, you will be responsible for the design, deployment, management, and optimization of PostgreSQL and MySQL databases in both on-premises and cloud environments (AWS Aurora). You will ensure high availability, security, and performance of mission‑critical database clusters, supporting large‑scale transaction processing and modern DevOps practices.

Minimum Requirements

Experience: At least 7 years as a Database Administrator, with hands‑on expertise in PostgreSQL and MySQL environments.

Key Responsibilities

• Deploy and configure PostgreSQL clusters on‑premises and in AWS Aurora.
• Set up and manage MySQL databases, ensuring optimal configuration and performance.
• Customize database parameter groups in Aurora and MySQL to optimize performance and enable advanced features.
• Define VPC, subnet, and security group configurations for secure cloud deployment.
• Use tools such as pg_stat_statements, CloudWatch, pgAdmin, MySQL Workbench, and custom scripts to monitor database performance and replication status.
• Tune PostgreSQL and MySQL parameters (e.g., shared_buffers, work_mem, WAL settings, buffer pool size) for optimal throughput and reliability.
• Implement WAL streaming and cluster status checks for PostgreSQL; configure MySQL replication and failover strategies.
• Design and execute backup strategies using native tools and AWS features (e.g., automated snapshots).
• Conduct regular disaster recovery drills and maintain standby clusters for failover scenarios.
• Manage user roles and permissions, enforce encryption, and monitor access logs for both PostgreSQL and MySQL.
• Apply security best practices and integrate with AWS Secrets Manager for credential rotation.
• Ensure compliance with organizational and regulatory standards for data protection.
• Lead schema conversion and incremental data migration from on‑premises to AWS Aurora and MySQL using ETL tools such as Talend and custom scripts.
• Validate data integrity post‑migration through row count comparisons and compatibility tests.
• Develop automation scripts for data loading, monitoring, and maintenance using Shell, Python, PL/pgSQL, and MySQL scripting.
• Integrate databases with CI/CD pipelines and containerized environments (e.g., ECS Fargate).
• Manage clusters that process large volumes of financial transactions daily.
• Model AWS costs and size resources appropriately for PostgreSQL and MySQL workloads.
• Set up secure DB‑to‑DB communication over VPN between on‑premises and AWS Aurora/MySQL.

Required Technical Skills

• Database Engines:
  • PostgreSQL (on‑premises)
  • AWS Aurora PostgreSQL
  • MySQL
• Monitoring Tools:
  • CloudWatch
  • pgAdmin
  • pg_stat_statements
  • MySQL Workbench
  • custom shell scripts
• Security:
  • Role management
  • WAL configuration
  • AWS Secrets Manager
  • MySQL user management
• ETL & Migration:
  • Talend
  • custom scripts
  • schema conversion
• DevOps & Automation:
  • Bash
  • Python
  • PL/pgSQL
  • MySQL scripting
  • AWS CLI

Cloud Services

• AWS RDS
• VPC
• Subnets
• Security Groups
• Aurora Serverless

Qualifications

• Minimum 7 years of experience as a Database Administrator, with proven expertise in both PostgreSQL and MySQL.
• Strong understanding of database performance tuning, high availability, and disaster recovery strategies.
• Hands‑on experience with database security, compliance, and credential management.
• Experience with ETL processes, data migration, and automation scripting.
• Familiarity with AWS cost modeling and resource sizing for database workloads.
• Ability to work collaboratively in DevOps and agile environments.