Database Administrator

upscale; Kuala Lumpur; On-site; MYR 180,000 - 260,000; Full time

Job summary

upscale in Kuala Lumpur is seeking an experienced Database Administrator to design, deploy, and optimize PostgreSQL and MySQL databases across on-premises and AWS Aurora environments. You will ensure high availability, security, and performance for mission-critical workloads.

The role emphasizes disaster recovery, automation with shells and Python, and integration with CI/CD and DevOps practices, while managing security, backups, replication, and cost sizing.

Qualifications

• 7+ years of experience as a Database Administrator with hands-on PostgreSQL and MySQL expertise.
• Experience deploying and managing PostgreSQL and MySQL clusters on-premises and in AWS.
• Strong knowledge of high availability, backup, disaster recovery, and security best practices.
• Familiarity with CI/CD, DevOps practices, and automation scripting.

Responsibilities

• Deploy and configure PostgreSQL clusters in on-prem and AWS Aurora.
• Manage MySQL databases with optimal configuration and performance.
• Tune parameters for throughput and reliability (shared_buffers, work_mem, WAL, buffer pool).
• Implement WAL streaming, replication, failover, and DR drills.
• Design backup strategies and encrypt/secure credentials (AWS Secrets Manager).
• Monitor performance with CloudWatch, pg_stat_statements, and MySQL tools.

Skills

Database tuning

High availability

Security & compliance

Automation & scripting

DevOps integration

Performance optimization

Tools

PostgreSQL

MySQL

AWS Aurora

CloudWatch

pgAdmin

MySQL Workbench

Talend

ETL scripting

AWS CLI

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-premisesand cloud environments (AWS Aurora). You will ensure high availability, security, andperformance of mission-critical database clusters, supporting large-scale transactionprocessing and modern DevOps practices.

Minimum Requirements

• Experience: At least 7 years as a Database Administrator, with hands-on expertise inPostgreSQL 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 deployments.
• 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,SubnetsSecurity 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