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.