This job offer is not available in your country.
Database Administrator (PostgreSQL / AWS Aurora & MySQL)
Mission Consultancy Services Sdn. Bhd.Puchong, Selangor, Malaysia14 hours ago
Job descriptionDeploy 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. 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 AWS RDS VPC Subnets Security Groups Aurora Serverless 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.
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
Required Technical Skills
Cloud Services
Qualifications
Notes : This description excludes non-essential boilerplate and is focused on responsibilities, requirements, and qualifications for the role.
#J-18808-Ljbffr
Create a job alert for this search
Database Administrator • Puchong, Selangor, Malaysia
Related jobs
Database Administration : Manage and optimize MS SQL Server and PostgreSQL databases for high availability, performance, and security.
Cloud & RDS Management : Administer databases in hybrid cloud...Show moreLast updated: 30+ days ago)
Achieving resolution for database system outages within defined Service Level Agreements (SLAs).Ensure proper DB capacity management / data growth and threshold alerts are automated.Responsible for c...Show moreLast updated: 30+ days ago
Experiences, Education and Professional Qualification.To have some experience working with the below products.Oracle Databases (EBS & Non EBS Databases).
Oracle Golden Gate / Label Security / Da...Show moreLast updated: 13 days ago 
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...Show moreLast updated: 30+ days ago
Key Responsibilities for DataBase Administrator.Experience in SQL Server, PostgreSQL Administration.Install, configure, and upgrade database servers and related tools (SQL Server, PostgreSQL, or cl...Show moreLast updated: 30+ days ago 
- Promoted
- New!
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...Show moreLast updated: 14 hours ago
- Promoted
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...Show moreLast updated: 28 days ago
- Promoted
Senior SQL Database Administrator
ISJ Technology Sdn BhdPetaling Jaya, Selangor, Malaysia The Senior SQL Database Administrator designs, supports, diagnoses, maintains and optimizes database systems to ensure scalability, reliability, performance and production readiness for the organiz...Show moreLast updated: 4 days ago
- Promoted
- New!
Sr Database Administrator
TechTiera CorporationKuala Lumpur, Kuala Lumpur, Malaysia Database Administration support with main focus on PostgreSQL, Oracle, or MSSQL databases on Google Cloud or Azure cloud.
Database maintenance, housekeeping, and troubleshooting.Identify and resolve...Show moreLast updated: 14 hours ago
- Promoted
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 ...Show moreLast updated: 30+ days ago
Senior Database Administrator
Flintex Consulting Pte LtdKuala Lumpur, 14, myQuick Apply
- Promoted
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...Show moreLast updated: 3 days ago
- Promoted
- New!
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...Show moreLast updated: 14 hours ago
Senior MSSQL Database Administrator
Unison GroupKuala Lampur, Kuala Lumpur, MYQuick Apply
- Promoted
- New!
HPC / AI Solution Architect
Hewlett Packard EnterpriseSeremban, Negeri Sembilan, 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...Show moreLast updated: 14 hours ago
Oracle Database Administrator
Unison GroupKuala Lumpur, Federal Territory of Kuala Lumpur, MYQuick Apply
Database Engineer
Two95 International Inc.Kuala Lumpur, Federal Territory of Kuala Lumpur, MYQuick Apply
- Promoted
- New!
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...Show moreLast updated: 14 hours ago
- Promoted
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 ...Show moreLast updated: 30+ days ago
Senior Database Administrator - SQL Server, PostgreSQL
Flintex Consulting Pte LtdKuala Lumpur, 14, myQuick Apply
- Promoted
- New!
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...Show moreLast updated: 14 hours ago
- Promoted
- New!
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, ...Show moreLast updated: 14 hours ago
- Promoted
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...Show moreLast updated: 4 days ago