Senior Database Administrator

Role Summary

L2 Database Administrator

• 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.

• 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.

• Experience with High Availability (HA) and Disaster Recovery (DR) setups.

• 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)