Database Administrator (PostgreSQL/AWS Aurora & MySQL)

Database Administrator (PostgreSQL/AWS Aurora & MySQL) - Mission Consultancy Services | Career Page

Database Administrator (PostgreSQL/AWS Aurora & MySQL)

Puchong, Selangor, Malaysia

Apply for Position Or refer someone

Job Openings Database Administrator (PostgreSQL/AWS Aurora & MySQL)

About the job Database Administrator (PostgreSQL/AWS Aurora & MySQL)

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.

GET IN TOUCH

Please apply online or send your CV to Talent@mcs-global.com

For more details, feel free to reach out me directly at :

WhatsApp link

wa.me/62 821-3768-2541

Apply for Position

Or refer someone

Share

• Facebook
• Line
• LinkedIn
• X (Formerly Twitter)
• Whatsapp
• Email