Job Description

Role & responsibilities Administer, monitor, and manage PostgreSQL and MySQL databases, ensuring high availability, security, and performance. In-depth understanding of MySQL and PostgreSQL architecture, internals, and optimizations. Design, implement, and maintain database systems on AWS platforms (including RDS, EC2, S3, DocumentDB, DynamoDB, etc.). Deploy standard security patches and ensure all security measures are correctly applied to the databases. Check and ensure all security aspects of the database environment are deployed and maintained (e.g., encryption, access control, vulnerability assessments). Perform production upgrades and updates to MySQL/PostgreSQL environments while minimizing downtime. Execute ALTER , DDL , DML , online DDL , and handle large updates , deletes , archiving , and purging tasks for large datasets. Perform routine AWS DMS (Database Migration Service) tasks, including migration and replication setups. Write and manage automation scripts using Shell scripting , PowerShell , Terraform , and Python for operational tasks such as backups, monitoring, provisioning, and deployments. Implement database backup and recovery strategies, high availability solutions, and disaster recovery processes. Manage schema changes and database migrations using Liquibase or Flyway to automate versioning and deployments. Troubleshoot and resolve database-related issues including performance problems, query tuning, and system failures. Collaborate with the development and operations teams to ensure database designs are aligned with system architecture. Preferred candidate profile Experience: 2-4 years of relevant experience as a Database Administrator or in a similar database role. MySQL Expertise: In-depth understanding of MySQL internals, performance tuning, replication, backup and recovery strategies, and high-availability setups. PostgreSQL Expertise: Strong expertise in PostgreSQL , including its internals, architecture, and performance tuning. Cloud Knowledge: Hands-on experience with AWS services, especially with RDS , EC2 , and S3 , and cloud-native databases like DocumentDB and DynamoDB . Security Management: Experience deploying security patches and ensuring the correct application of security controls across the database environment. Production Upgrades & Maintenance: Ability to perform production upgrades and regular database maintenance , including DDL , DML , large updates , and deletes . Automation Skills: Experience in writing automation scripts using Shell scripting , PowerShell , Terraform , and Python . NoSQL Knowledge: Experience with Aerospike , MongoDB , DocumentDB , or DynamoDB is a plus. Database Migration (DMS): Experience working with AWS DMS for database migrations and replication. Version Control & CI/CD: Experience with Liquibase or Flyway for managing database schema versions and deployments. Performance Optimization: Strong skills in optimizing database queries, indexing, and understanding of query execution plans. Backup & Recovery: Experience with database backup strategies, disaster recovery, and failover management. Problem-Solving: Excellent troubleshooting and problem-solving skills with the ability to identify, diagnose, and resolve database issues quickly. Communication: Strong verbal and written communication skills to collaborate with team members and stakeholders effectively.