Database Administrator

2 days ago

Kuala Lumpur, Kuala Lumpur, Malaysia Upscale Full time 120,000 - 140,000 per year


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 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, 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

  • Database Administrator

    2 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia AMK Technology Sdn Bhd Full time 90,000 - 108,000 per year

    We're Hiring: Senior Database Administrators (2 Positions)We are looking for experienced Database Administrators (DBAs) with 7+ years of hands-on experience to join our team.Open Positions:1) Oracle Database Administrator – Expert in Oracle DB architecture, performance tuning, backup/recovery, and high availability.2 )Microsoft SQL Server Database...

  • Database Administrator

    2 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia CXC Full time 60,000 - 80,000 per year

    We are seeking a skilled and detail-orientedDatabase Administrator (DBA)to join our growing IT team in Malaysia. The ideal candidate will be responsible for managing, maintaining, and optimizing our organization's database systems to ensure high performance, security, and availability.Key Responsibilities:Install, configure, and upgrade database servers and...

  • Database Administrator

    2 weeks ago

    Kuala Lumpur, Kuala Lumpur, Malaysia AMK Technology Sdn Bhd Full time 60,000 - 120,000 per year

    Location:OnsiteContract Duration:6 MonthsExperience Level:Minimum 3 YearsJob Overview:We are seeking an experiencedDatabase Administratorto join our team on a 6-month contract. The ideal candidate will be responsible for managing, maintaining, and optimizing our database systems to ensure high performance, security, and reliability across multiple...

  • Database Administrator

    2 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia AVANADE ASIA PTE LTD Full time 80,000 - 150,000 per year

    Database Administrator (MS SQL) Responsible for the effective design, implementation, maintenance, and enhancement of database systems for within the Asia Pacific Region, primarily MSSQL Server databases and other database technologies such as but not limited to Oracle, IBM DB2, MySQL and PostgreSQL databases. Come join us As a valued member of our team,...

  • Database Administrator

    2 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Upscale Sdn Bhd Full time 80,000 - 120,000 per year

    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...

  • Database Administrator

    2 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Hyppies Full time 90,000 - 120,000 per year

    Our clients' IT Infrastructure team is expanding We're looking for experiencedSenior Database Administratorsto manage and optimize our enterprise-grade database environments. If you're passionate about database performance, reliability, and automation, we'd love to hear from you.We havethree openingsfor the following specializations:1. Senior Oracle DBA,Key...

  • Database Administrator

    2 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Robotico Digital® Full time 60,000 - 120,000 per year

    Duties and Responsibilities:·       Manage and perform administrative tasks on databases (Microsoft SQL, Oracle, MySQL) running on Windows & Linux platforms.·       Monitoring the health of the databases, and perform trouble-shooting to identify and resolve any reported issues.·       Install, configure and setup databases for...

  • Database Administrator

    2 weeks ago

    Kuala Lumpur, Kuala Lumpur, Malaysia HCLTech Full time 120,000 - 240,000 per year

    About the roleHCL Technologies Malaysia SDN BHD is seeking a skilled and experiencedDatabase Administratorwith a strong background in managing and maintaining open-source databases such asMariaDBin production environments. The ideal candidate will demonstrate deep expertise in database performance tuning, query optimization, and backup and recovery...

  • Senior Database Administrator

    2 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Oxydata Software Full time 120,000 - 180,000 per year

    Job Opening: Senior Database Administrator Location: KL| Employment Type: Full-time Experience: 3 to 4 Years |We are seeking a highly skilled Senior Database Administrator to manage and optimize database environments across MS SQL Server and PostgreSQL platforms. This role is pivotal in ensuring database performance, high availability, and scalability...

  • Database Administrator

    2 days ago

    Kuala Lumpur, Kuala Lumpur, Malaysia ASW Full time 120,000 - 240,000 per year

    Job Description THE OPPORTUNITYOur client, a highly respected and long-established Australian financial services organization providing wealth management, trustee, and corporate fiduciary services, is embarking on an exciting digital transformation journey.You will be part of their Technology & Projects division, contributing to the modernization of their...