Database Administrator

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