Role Summary
We are looking for an experienced L2 Database Administrator with hands-on expertise in managing cloud and hybrid database environments across AWS and Microsoft Azure, along with on-premises MS SQL Server. The role involves database provisioning, access management, maintenance, performance tuning, patching, backup and recovery, and production support to ensure secure, highly available, and optimized database systems.
Required Skills Experience
Must Have
- 3-5 years of experience as a Database Administrator.
- Strong hands-on experience with:
- PostgreSQL
- Microsoft SQL Server
- Azure SQL Database
- MongoDB
- Experience working in AWS and Azure cloud environments.
- Strong understanding of:
- Database Backup Recovery
- Performance Tuning
- Database Security
- Experience working in L2 Production Support roles.
Soft Skills
- Strong troubleshooting and analytical skills.
- Ability to handle production issues under pressure.
- Good communication and coordination skills.
- Willingness to participate in on-call and support rotations.
Nice to Have
- Experience with High Availability (HA) and Disaster Recovery (DR) setups.
Key Responsibilities
- Database Administration Operations
- Create, configure, and manage databases across AWS, Azure, and on-premises environments.
- Implement user provisioning, role-based access control (RBAC), and privilege management.
- Ensure database availability, reliability, and security.
- Perform routine maintenance activities including:
- Index Management
- Statistics Updates
- Space Management
- Monitoring Performance Optimization
- Monitor database health, performance, and capacity.
- Identify and resolve performance bottlenecks.
- Optimize SQL/NoSQL queries and execution plans.
- Patching, Upgrades Compliance
- Perform database patching and version upgrades.
- Support security, audit, and compliance requirements.
- Backup, Recovery Disaster Recovery
- Manage backups, restores, and recovery scenarios.
- Support DR drills and RPO/RTO requirements.
- Production Support
- Act as L2 support for production database issues.
- Perform root cause analysis and implement permanent fixes.
- Coordinate with application, cloud, and infrastructure teams.
- Databases Platforms in Scope
- AWS PostgreSQL (RDS / Managed PostgreSQL)
- Microsoft SQL Server (On-Premises)
- MongoDB (Cloud-Hosted or Self-Managed)