Talent.com
Database Administrator
Database AdministratorUpscale Sdn Bhd • Kuala Lumpur, Malaysia
Database Administrator

Database Administrator

Upscale Sdn Bhd • Kuala Lumpur, Malaysia
17 jam yang lalu
Jenis pekerjaan
  • Quick Apply
Penerangan pekerjaan

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
  • Buat amaran kerja untuk carian ini

    Database Administrator • Kuala Lumpur, Malaysia

    Pekerjaan berkaitan
    Senior Database Administrator (DBA)

    Senior Database Administrator (DBA)

    HOTKEY STUDIOS SDN. BHD. • Kuala Lumpur, Kuala Lumpur, Malaysia
    Configure, monitor, upgrade and maintain MySQL databases in all environments.Develop database solutions in terms of architecture and design, database security, migration, upgrade, backup and recove...Tunjukkan lagi
    Kemas kini terakhir: 5 hari yang lalu • Dinaikkan pangkat
    Database Administrator - Banking Industry

    Database Administrator - Banking Industry

    Talent Recruit • Kuala Lumpur, Malaysia
    We are representing our client, a proud subsidiary of a prestigious conglomerate in Laos with a legacy spanning nearly 50 years. As part of their ongoing regional expansion, they are currently seeki...Tunjukkan lagi
    Kemas kini terakhir: 30+ hari yang lalu • Dinaikkan pangkat
    Senior Administrator, Planning Operations

    Senior Administrator, Planning Operations

    Vans • Kuala Lumpur, Kuala Lumpur, Malaysia
    Conduct regular data accuracy checks and collaborate with global teams to ensure data integrity before Purchase Order creation in SAP. Generate and analyze reports to verify data, support timely del...Tunjukkan lagi
    Kemas kini terakhir: 5 hari yang lalu • Dinaikkan pangkat
    Database Administrator - Mongo DB

    Database Administrator - Mongo DB

    Avensys Consulting • Kuala Lumpur, Kuala Lumpur, Malaysia
    Global Recruitment Head at Avensys Consulting.Avensys is a reputed global IT professional services company, and our service spectrum includes enterprise solution consulting, business intelligence, ...Tunjukkan lagi
    Kemas kini terakhir: 18 jam yang lalu • Dinaikkan pangkat • Baharu!
    MSSQL Database Adminstrator

    MSSQL Database Adminstrator

    Oxydata Software • Kuala Lumpur, Malaysia
    Jalan Yap Kwan Seng, Kuala Lumpur.Our client is a global financial services group with over 3,500 employees and more than 1 million clients worldwide. With headquarters in Singapore, they operate ac...Tunjukkan lagi
    Kemas kini terakhir: 30+ hari yang lalu
    Cloud Administrator

    Cloud Administrator

    Hunters International Sdn Bhd • Petaling Jaya, Selangor, Malaysia
    The role as system administrator is to work directly with senior and solution architect.Systemadministrator is responsible for all aspects of systems administration in establishing a resilientand s...Tunjukkan lagi
    Kemas kini terakhir: 2 hari yang lalu • Dinaikkan pangkat
    Database Support Engineer (Fintech)

    Database Support Engineer (Fintech)

    Beyondsoft • Kuala Lumpur, Kuala Lumpur, Malaysia
    Database Administrator - Fresh Grads are Welcome.Beyondsoft, Federal Territory of Kuala Lumpur, Malaysia.Direct message the job poster from Beyondsoft. We are looking for an experienced Engineer to ...Tunjukkan lagi
    Kemas kini terakhir: 1 hari yang lalu • Dinaikkan pangkat
    System Integration & Database Developer

    System Integration & Database Developer

    Hunters International Sdn Bhd • Puchong, Selangor, Malaysia
    About the job System Integration & Database Developer.Our client is a boutique Software House that offers unique IT products and services tailored to your business needs and requirement.Develop and...Tunjukkan lagi
    Kemas kini terakhir: 3 hari yang lalu • Dinaikkan pangkat
    Senior Administrator, Planning Operations

    Senior Administrator, Planning Operations

    VF Corporation • Kuala Lumpur, Kuala Lumpur, Malaysia
    Conduct regular data accuracy checks and collaborate with global teams to ensure data integrity before Purchase Order creation in SAP. Generate and analyze reports to verify data, support timely del...Tunjukkan lagi
    Kemas kini terakhir: 3 hari yang lalu • Dinaikkan pangkat
    Databricks Architect

    Databricks Architect

    Avanade Inc. • Kuala Lumpur, Kuala Lumpur, Malaysia
    Our talented Data & AI Practice is made up of globally recognized experts - and there’s room for more analytical and ambitious data professionals. If you’re passionate about helping clients make bet...Tunjukkan lagi
    Kemas kini terakhir: 3 hari yang lalu • Dinaikkan pangkat
    Senior Database Administrator

    Senior Database Administrator

    CXC • SelangorMalaysia, Selangor, Malaysia
    Analyze and optimize expensive SQL queries to improve database performance and reduce load times.Provide comparison reports detailing loading and processing times for optimized SQL queries.Develop ...Tunjukkan lagi
    Kemas kini terakhir: 16 hari yang lalu • Dinaikkan pangkat
    Database Administrator

    Database Administrator

    Captiv 8 Consulting • Petaling Jaya, Selangor, Malaysia
    We are hiring on behalf of a fast growing fintech company that is seeking a skilled Database Administrator to support and strengthen its core data infrastructure. In this role, you will help ensure ...Tunjukkan lagi
    Kemas kini terakhir: 1 hari yang lalu • Dinaikkan pangkat
    Senior Database Administrator

    Senior Database Administrator

    Oxydata • Kuala Lumpur, Kuala Lumpur, Malaysia
    About the job Senior Database Administrator.Job Opening : Senior Database Administrator.We are seeking a highly skilled.This role is pivotal in ensuring database performance, high availability, and ...Tunjukkan lagi
    Kemas kini terakhir: 5 hari yang lalu • Dinaikkan pangkat
    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 lagi
    Kemas kini terakhir: 30+ hari yang lalu
    Senior Database Administrator - SQL Server, PostgreSQL

    Senior Database Administrator - SQL Server, PostgreSQL

    Flintex Consulting Pte Ltd • Kuala Lumpur, 14, my
    Quick Apply
    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...Tunjukkan lagi
    Kemas kini terakhir: 30+ hari yang lalu
    Database Administrator

    Database Administrator

    MVC Resources • Kuala Lumpur, 14, my
    Quick Apply
    Database environment planning, implementation, testing, maintenance & support for in-house database.Provide speedy resolution or escalation of operational incident / problem.Setup database engine...Tunjukkan lagi
    Kemas kini terakhir: 4 hari yang lalu
    Database Administrator

    Database Administrator

    Avanade • Kuala Lumpur, Kuala Lumpur, Malaysia
    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 techno...Tunjukkan lagi
    Kemas kini terakhir: 18 jam yang lalu • Dinaikkan pangkat • Baharu!
    SAP Basis Administrator

    SAP Basis Administrator

    Swisslog • Petaling Jaya, Selangor, Malaysia
    Direct message the job poster from Swisslog.Talent Acquisition Specialist | Global Talents Hunting | We believe TALENTS are the key for successful organization. Swisslog is shaping the future of int...Tunjukkan lagi
    Kemas kini terakhir: 30+ hari yang lalu • Dinaikkan pangkat