Talent.com
Tawaran kerja ini tidak tersedia di negara anda.
Database Administrator (PostgreSQL / AWS Aurora & MySQL)

Database Administrator (PostgreSQL / AWS Aurora & MySQL)

Mission Consultancy Services Sdn. Bhd.Puchong, Selangor, Malaysia
1 hari lalu
Penerangan pekerjaan

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.
  • Notes : This description excludes non-essential boilerplate and is focused on responsibilities, requirements, and qualifications for the role.

    #J-18808-Ljbffr

    Buat amaran kerja untuk carian ini

    Database Administrator • Puchong, Selangor, Malaysia

    Pekerjaan yang berkaitan
    • Dinaikkan pangkat
    Senior Software Engineer

    Senior Software Engineer

    EngageRocketSepang, Selangor, Malaysia
    Senior Software Engineer at EngageRocket.EngageRocket is the first venture-backed HR Technology company in SEA with the mission to create better workplaces with people analytics.We help organisatio...Tunjukkan lagiKemas kini terakhir: 5 hari yang lalu
    • Dinaikkan pangkat
    Lead Oracle Database Administrator

    Lead Oracle Database Administrator

    HFG Insurance RecruitmentKuala Lumpur, Kuala Lumpur, Malaysia
    Benjamin Chong | Specialist Recruiter at HFG Insurance Recruitment provides a high-level overview for a Senior Database Administrator / Manager role focusing on Oracle, MS SQL, MySQL, and DB2 platfor...Tunjukkan lagiKemas kini terakhir: 1 hari yang lalu
    • Dinaikkan pangkat
    AWS Infra System Administrator

    AWS Infra System Administrator

    Razer Inc.Shah Alam, Selangor, Malaysia
    Manage and monitor AWS infrastructure to ensure reliability and performance.Perform system administration tasks, including configuration, patch management, and backups. Implement security measures t...Tunjukkan lagiKemas kini terakhir: 29 hari yang lalu
    • Dinaikkan pangkat
    Corporate Trainee – DBA

    Corporate Trainee – DBA

    Commerz Global Service SolutionsKuala Lumpur, Kuala Lumpur, Malaysia
    The Database Administrator Corporate Trainee will provide day-to-day support to team members, especially on database and documentation. The Corporate Trainee will embark on a structured development ...Tunjukkan lagiKemas kini terakhir: 30+ hari yang lalu
    • Dinaikkan pangkat
    Senior Full Stack Engineer

    Senior Full Stack Engineer

    ExperianSepang, Selangor, Malaysia
    We are looking for a full stack Software Developer to help us develop our next generation of insights products.Your primary focus will be to develop the main insights portal to help expand it into ...Tunjukkan lagiKemas kini terakhir: 1 hari yang lalu
    • Dinaikkan pangkat
    Data Architect

    Data Architect

    Net2Source (N2S)Kuala Lumpur, Kuala Lumpur, Malaysia
    Minimum 5 years of Data architecture experience in respective platform.Proficiency in data modelling tools and concepts.Knowledge of various database types (SQL, NoSQL) and cloud platforms (e.Under...Tunjukkan lagiKemas kini terakhir: 4 hari yang lalu
    • Dinaikkan pangkat
    HPC / AI Solution Architect

    HPC / AI Solution Architect

    Hewlett Packard EnterpriseKuala Selangor, Kuala Selangor, Malaysia
    Remote / teleworker role; you will primarily work from home.Hewlett Packard Enterprise is the global edge-to-cloud company advancing the way people live and work. We focus on connecting, protecting, a...Tunjukkan lagiKemas kini terakhir: 1 hari yang lalu
    • Dinaikkan pangkat
    Senior Software Engineer

    Senior Software Engineer

    HyppiesSepang, Selangor, Malaysia
    About our client : Our client is on a mission to enable meaningful work for all by making digital creation accessible to everyone through its. US, Australia, and Asia, using technologies like.Typescr...Tunjukkan lagiKemas kini terakhir: 5 hari yang lalu
    • Dinaikkan pangkat
    Oracle 19c Database Administrator

    Oracle 19c Database Administrator

    Analytx Sdn BhdSepang, Selangor, Malaysia
    Hands-on Oracle 19c DBA to install, configure, operate, tune and secure Oracle 19c databases (single-instance and RAC).Role includes backup & recovery (RMAN), performance tuning (AWR / ASH / ADDM), pat...Tunjukkan lagiKemas kini terakhir: 1 hari yang lalu
    • Dinaikkan pangkat
    Senior Database Administrator (Oracle, PL / SQL)

    Senior Database Administrator (Oracle, PL / SQL)

    Hitachi eBworxSelangorMalaysia, Selangor, Malaysia
    Senior Database Administrator (Oracle, PL / SQL).Join Us as a Senior Database Administrator (Oracle, PL / SQL)!.Bhd, we’re looking for a talented. Senior Database Administrator (Oracle, PL / SQL).Work wit...Tunjukkan lagiKemas kini terakhir: 1 hari yang lalu
    • Dinaikkan pangkat
    Senior Software Engineer, Web Cross-platform (Remote)

    Senior Software Engineer, Web Cross-platform (Remote)

    FreelancingSepang, Selangor, Malaysia
    We want to make work and study more efficient and enjoyable, by providing the best digital paper solution possible.We plan to be the go-to tool for all forms of notes. Our digital paper and learning...Tunjukkan lagiKemas kini terakhir: 5 hari yang lalu
    Database Engineer

    Database Engineer

    Two95 International Inc.Kuala Lumpur, Federal Territory of Kuala Lumpur, MY
    Quick Apply
    We are looking for an experienced and passionate Database engineer with a strong desire to learn and work on complex systems. You will own database management, infrastructure, performance, availabil...Tunjukkan lagiKemas kini terakhir: 30+ hari yang lalu
    • Dinaikkan pangkat
    Database Administrator

    Database Administrator

    Phillip Capital GroupKuala Lumpur, Kuala Lumpur, Malaysia
    The Database Administrator / Developer role is responsible for the performance and integrity of the company’s databases.The role provides technical expertise in the design, implementation, and main...Tunjukkan lagiKemas kini terakhir: 1 hari yang lalu
    • Dinaikkan pangkat
    Azure Cloud Solution Architect (Bahasa speaking)

    Azure Cloud Solution Architect (Bahasa speaking)

    AvanadeKuala Lumpur, Kuala Lumpur, Malaysia
    Location : Avanade Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia.Avanade is seeking a highly experienced and motivated Azure Cloud Solution Architect, proficient in Infrastructure, Data ...Tunjukkan lagiKemas kini terakhir: 30+ hari yang lalu
    • Dinaikkan pangkat
    Principle DBA (PostgreSQL) – WFH

    Principle DBA (PostgreSQL) – WFH

    MindteckSepang, Selangor, Malaysia
    Principle DBA (PostgreSQL) – WFH from anywhere Malaysia.Need to travel to Singapore office once in a while if required.Years of experience : 10+ years (If only 5+ yrs hands on PostgreSQL DBA experie...Tunjukkan lagiKemas kini terakhir: 1 hari yang lalu
    • Dinaikkan pangkat
    AWS Solution Architect

    AWS Solution Architect

    Noventiq MalaysiaKuala Lumpur, Kuala Lumpur, Malaysia
    You’ll be a part of our Solution Sales team.Working office : Noventiq Malaysia, 301D, Level 3, Tower D, Uptown 5.Jalan SS21 / 39, Damansara Utama, 47400 Petaling Jaya. As the Cloud Solution Architect, ...Tunjukkan lagiKemas kini terakhir: 1 hari yang lalu
    • Dinaikkan pangkat
    Senior Software Engineer (Remote)

    Senior Software Engineer (Remote)

    PortcastSelayang Municipal Council, Selayang Municipal Council, Malaysia
    Our mission is to transform international supply chains to be more resilient by helping logistics companies realize the full potential of their data. We cater to both shipping lines and cargo airlin...Tunjukkan lagiKemas kini terakhir: 6 hari yang lalu
    • Dinaikkan pangkat
    Site Reliability Engineer

    Site Reliability Engineer

    CanonicalSepang, Selangor, Malaysia
    Site Reliability Engineer role at Canonical.We deploy and run OpenStack, Kubernetes, storage solutions, and open source applications, applying DevOps practices. To succeed in this role, you need to ...Tunjukkan lagiKemas kini terakhir: 6 hari yang lalu
    • Dinaikkan pangkat
    Database Administrator (PostgreSQL / AWS Aurora & MySQL)

    Database Administrator (PostgreSQL / AWS Aurora & MySQL)

    Mission Consultancy ServicesPuchong, Selangor, Malaysia
    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 Auror...Tunjukkan lagiKemas kini terakhir: 5 hari yang lalu
    • Dinaikkan pangkat
    Division CFO, Trilogy (Remote) - $400,000 / year USD

    Division CFO, Trilogy (Remote) - $400,000 / year USD

    TrilogySelayang Municipal Council, Selayang Municipal Council, Malaysia
    Division CFO, Trilogy (Remote) - $400,000 / year USD.Trilogy Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia.Be among the first 25 applicants. Get AI-powered advice on this job and more excl...Tunjukkan lagiKemas kini terakhir: 14 hari yang lalu