Junior Database Administrator
Summary
L2 database administrator managing cloud and hybrid database environments across AWS, Azure, and on-premises MS SQL Server. Day-to-day work includes provisioning, access control, patching, backup and recovery, performance tuning, and L2 production support for PostgreSQL, SQL Server, and MongoDB.
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 such as:
- 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)
- Azure SQL Database
- MongoDB (Cloud-Hosted or Self-Managed)
Required Skills & Experience
- 2-3 years of experience as a Database Administrator.
- Strong hands-on experience with:
- PostgreSQL
- MS SQL Server
- MongoDB
- Experience working in AWS and Azure cloud environments.
- Strong understanding of:
- 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.