PostgreSQL Database Administrator
First seen by Alion on Aug 17, 2026.
Key Responsibilities:
1. Database Administration:
- Install, configure, administer, and maintain PostgreSQL databases.
- Monitor database health, performance, and availability.
- Perform routine database maintenance and capacity planning.
- Ensure database security, integrity, and compliance with organizational standards.
2. Performance Optimization:
- Analyze and optimize SQL queries.
- Perform database performance tuning and query optimization.
- Identify and resolve database bottlenecks.
- Optimize indexing strategies and database configurations.
3. High Availability & Disaster Recovery:
- Configure and manage High Availability (HA) environments.
- Implement and maintain Streaming Replication.
- Perform database backup and restore operations.
- Manage Point-in-Time Recovery (PITR) strategies.
- Ensure disaster recovery readiness and business continuity.
4. Production Support:
- Provide L2/L3 production support for enterprise databases.
- Troubleshoot database issues and perform root cause analysis.
- Resolve performance and availability issues within SLA timelines.
- Collaborate with application and infrastructure teams during critical incidents.
5. Automation & Scripting:
- Develop automation scripts using Shell Scripting.
- Automate database maintenance and monitoring tasks.
- Support deployment and release activities.
6. Collaboration:
- Work closely with development, infrastructure, and DevOps teams.
- Participate in database architecture discussions.
- Maintain technical documentation and operational procedures.
Required Skills:
1. Database:
- PostgreSQL Database Administration
- SQL
- Performance Tuning
- Query Optimization
- Backup & Restore
- Point-in-Time Recovery (PITR)
- High Availability (HA)
- Streaming Replication
2. Operating Systems:
- Linux
- Unix
3. Scripting:
- Shell Scripting
4. Support:
- L2/L3 Production Support
- Incident Management
- Root Cause Analysis
Preferred Skills:
- DB2 Administration
- DevOps
- CI/CD
- Banking or Financial Services domain experience
Education:
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
Key Skills:
- PostgreSQL, PostgreSQL DBA, SQL, Performance Tuning, Query Optimization, High Availability, Streaming Replication, Backup & Restore, PITR, Linux, Unix, Shell Scripting, Production Support, Database Administration, DevOps, CI/CD.
Skills
PostgreSQL, DBA, Database Performance Tuning, DBA Support, Scripting, Database Maintenance, DB