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.