MYSQL and PostgreSQL Database Administrator

Job Description - MySQL & PostgreSQL Database Administrator (L1+)

Role Summary:

Responsible for providing L1+ database administration support for MySQL and PostgreSQL environments, ensuring database availability, performance, security, and operational stability. The role involves monitoring, incident handling, routine maintenance, backup activities, and coordination with senior DBA teams for complex issues.

Key Responsibilities:

• Perform daily monitoring of MySQL and PostgreSQL databases, including health checks, alerts, and job status validation.
• Handle L1/L1+ database incidents, service requests, and troubleshooting activities.
• Perform database user management, access provisioning, and basic security administration.
• Execute database backup validation, restore support, and routine maintenance activities.
• Monitor database performance metrics and assist in identifying performance issues.
• Perform basic SQL query analysis and support database tuning activities.
• Manage database startup/shutdown activities and support patching/upgrades under guidance.
• Monitor replication status and assist with issue resolution.
• Maintain database documentation, operational procedures, and incident reports.
• Collaborate with application, infrastructure, and senior DBA teams for issue resolution and service improvements.

Required Skills:

• Good understanding of MySQL and PostgreSQL database architecture.
• Knowledge of SQL queries, database objects, and administration commands.
• Experience with Linux/Unix environments and basic shell scripting.
• Understanding of backup, recovery, monitoring, and database security concepts.
• Familiarity with database monitoring tools and IT service management processes.
• Ability to work in a 24x7 support environment and handle production incidents.