Description
We are looking for an experienced Database Administrator (DBA) responsible for the installation, configuration, performance tuning, security, backup, recovery, and high availability of MySQL, Microsoft SQL Server, and PostgreSQL databases.
The role involves ensuring database reliability, scalability, and performance in production and non-production environments.
Key Responsibilities Administration
- Install, configure, upgrade, and maintain MySQL, MS SQL Server, and PostgreSQL databases.
- Manage production, staging, and development database environments.
- Perform capacity planning and monitor database growth.
Performance Tuning & Optimization
- Monitor database performance and identify :
- SQL queries
- Indexes
- Stored procedures
- Analyze execution plans and resolve slow-running queries.
- Handle high-load and large-volume databases.
Backup & Recovery
- Design and manage backup and recovery and validate :
- Full, incremental, and transaction log backups
- Point-in-time recovery
- Regularly test backup restoration to ensure data safety.
High Availability & Disaster Recovery
- Implement and support :
- MySQL Replication
- SQL Server Always On / Log Shipping
- PostgreSQL Replication / Streaming Replication
- Participate in DR drills and failover testing.
- Ensure minimal downtime and data loss.
Security & Compliance
- Manage database users, roles, and permissions.
- Implement security best practices :
- Encryption (at rest & in transit)
- Auditing and access controls
- Handle vulnerability fixes and security patches
- Ensure compliance with organizational and regulatory standards.
Monitoring & Troubleshooting
- Proactively monitor database health using monitoring :
- Performance issues
- Locking and blocking
- Replication issues
- Space and storage problems
- Provide root cause analysis (RCA) for incidents.
Automation & Maintenance
- Automate routine DBA tasks using scripts (Shell, PowerShell, and maintain :
- Index maintenance
- Statistics updates
- Database housekeeping jobs
Good To Have
- Cloud & Managed Databases
- Experience with cloud databases such as :
- AWS RDS / Aurora
- Azure SQL Database
- Cloud SQL
- Understanding of cloud monitoring, scaling, and cost optimization.
(ref:hirist.tech)
