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.
