L2 Database Administrator
First seen by Alion on Sep 3, 2026.
Total Experience: 3 - 7 years
Key Responsibilities:
- Administer and support PostgreSQL databases and clusters in production environments.
- Manage PostgreSQL users, roles, permissions, database files, and configurations.
- Perform routine database maintenance, monitoring, and health checks.
- Manage and monitor database backups and recovery processes.
- Troubleshoot database-related incidents and provide L2 support within defined SLAs.
- Perform query tuning and performance optimization.
- Analyze and optimize indexes to improve database performance.
- Fine-tune PostgreSQL configuration parameters based on workload and performance requirements.
- Support PostgreSQL database migrations and version upgrades as required.
- Participate in DC/DR drills and validate database recovery and operational procedures.
- Provide database support during weekend mock drills and planned maintenance activities.
- Perform root-cause analysis for recurring database issues and recommend corrective actions.
- Maintain technical documentation, operational procedures, and database support runbooks.
- Coordinate with application, infrastructure, and other technical teams to resolve database-related issues.
Mandatory Technical Skills:
PostgreSQL Administration:
- 3+ years of hands-on PostgreSQL DBA experience.
- Strong knowledge of PostgreSQL database and cluster administration.
- Experience managing users, roles, permissions, database files, and configurations.
- Good understanding of PostgreSQL backup, restore, and recovery mechanisms.
- Experience with routine database maintenance and monitoring.
Performance Tuning:
- Hands-on experience with SQL/query performance tuning.
- Knowledge of index optimization and execution plans.
- Ability to identify performance bottlenecks and make appropriate PostgreSQL configuration adjustments.
Security & Connectivity:
- Working knowledge of Foreign Data Wrappers (FDW).
- Knowledge of SSL and TLS authentication.
- Experience with passwordless authentication and secure database connectivity.
- Understanding of PostgreSQL security, roles, privileges, and authentication mechanisms.
Migration & Disaster Recovery:
- Experience supporting PostgreSQL migrations and upgrades.
- Knowledge of DC/DR environments and disaster recovery procedures.
- Ability to participate in DC/DR drills, weekend mock activities, and planned maintenance exercises.
Key Skills:
- PostgreSQL DBA
- PostgreSQL Cluster Administration
- Backup & Recovery
- Query Tuning
- Index Optimization
- PostgreSQL Configuration
- Database Migration & Upgrade
- Foreign Data Wrappers (FDW)
- SSL / TLS Authentication
- Passwordless Authentication
- DC/DR Support
- L2 Production Support
- Incident & Problem Management
Skills
PostgreSQL, Performance Tuning, DBA, DB, IT Operations, DBMS, SQL