PostgreSQL Database Administrator

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.