Database Administrator - MySQL/PostgreSQL

Description :

The role involves ensuring database reliability, scalability, and performance in production and non-production environments.

Key Responsibilities :

- Manage production, staging, and development database environments.

- Perform capacity planning and monitor database growth.

Performance Tuning & Optimization :

Optimize :

- Indexes

- Stored procedures

- Analyze execution plans and resolve slow-running queries.

- Handle high-load and large-volume databases.

Backup & Recovery :

Perform and validate :

- Point-in-time recovery

- Regularly test backup restoration to ensure data safety.

High Availability & Disaster Recovery :

1. MySQL Replication

2. SQL Server Always On / Log Shipping

3. PostgreSQL Replication / Streaming Replication

- Participate in DR drills and failover testing.

- Ensure minimal downtime and data loss.

Security & Compliance :

- Implement security best practices :

1. Encryption (at rest & in transit)

2. Auditing and access controls

- Handle vulnerability fixes and security patches

- Ensure compliance with organizational and regulatory standards.

Monitoring & Troubleshooting :

Troubleshoot :

- Locking and blocking

- Replication issues

- Space and storage problems

- Provide root cause analysis (RCA) for incidents.

Automation & Maintenance :

Schedule and maintain :

- Statistics updates

- Database housekeeping jobs

Good to Have :

- Experience with cloud databases such as :

1. AWS RDS / Aurora

2. Azure SQL Database

3. Cloud SQL

- Understanding of cloud monitoring, scaling, and cost optimization.