TQUSI0045_4649 - Database Administrator (MySQL & PostgreSQL Expert)

Key Responsibilities

• Database Administration: Install, configure, upgrade, and maintain MySQL, PostgreSQL, Redis, and MongoDB in both on-premise and AWS environments.
• High Availability & Replication: Implement and manage replication strategies tailored to application requirements.
• Cloud Optimization: Administer and optimize AWS-managed database services for performance, reliability, and cost efficiency.
• Automation & Infrastructure: Automate provisioning, configuration, and routine tasks using Ansible, AWS CloudFormation, or similar tools.
• Monitoring & Performance Tuning: Design and implement monitoring/alerting solutions (CloudWatch, PMM, Datadog, MonYog) and proactively address performance bottlenecks.
• Maintenance & Reliability: Conduct daily health checks, perform capacity planning, and ensure consistent database uptime.
• Collaboration: Partner with application developers to design efficient schemas, tune queries, and improve performance.
• Security & Compliance: Work with DevSecOps to apply patches/upgrades and ensure database security.
• Backup & DR: Develop and maintain robust backup and disaster recovery strategies to minimize downtime and data loss.
• Reporting & Insights: Generate ad-hoc reports and provide actionable insights to internal teams and stakeholders.

Mandatory Skills

• Strong expertise in MySQL and PostgreSQL (hands-on experience required).
• Experience with AWS database services: RDS, Aurora, ElastiCache, DynamoDB, S3, EC2.
• Proficiency in Linux administration, Shell scripting or Python.

Preferred Experience

• Multi-database administration (MySQL, PostgreSQL, Redis, MongoDB).
• Strong troubleshooting skills in high-volume, mission-critical environments.
• Prior experience with cloud migration and hybrid (on-prem + AWS) database environments.