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