Cloud Database Administrator (DBA)

Job Requirements:
• 3+ years of experience managing PostgreSQL and MySQL databases on AWS RDS.
• 2-3 years of experience managing database infrastructure on AWS and/or Azure.
• Cloud database administration certification in either AWS or Azure.
• Experience with administering Oracle and SQL Server databases is a plus.

Key Responsibilities:

• Configure and maintain PostgreSQL and MySQL database servers on AWS RDS
• Maintain and enhance the existing AWS/Azure database infrastructure and services
• Design and execute overall cloud database architecture strategy, standards and practices
• Monitor production and non-production environments, troubleshoot and resolve incidents
• Usage of Pg Admin, Pg dump, Pg restore, Pg upgrade, Pg Badger, Pg Backrest, mysqldump, Percona Xtrabackup, SQL/PLSQL, shell and/or python scripting and other tools to proactively identify areas of optimization and troubleshoot database performance issues
• Manage database schema maintenance and migrations
• Improve service availability and scalability through tuning, automation, tools and process
• Implement and maintain database backup and recovery, disaster recovery procedures
• Attend service request ticket queue regularly and resolve the tickets
• Manage tenant rebalancing across multiple databases during weekly maintenance window
• Work closely with various stakeholders to ensure feature enhancements, security, uptime and scalability requirements
• Participate in 24x7 on-call rotation schedule and respond to occasional off-hour outages and take part in subsequent service restoration efforts.