JOB PURPOSEManage the design, implementation, performance tuning, security hardening and high-availability management of enterprise-grade Postgre SQL database environments supporting mission-critical financial and payment processing systems. through complex database architectures, disaster recovery planning and compliance with industry regulatory standards including PCI-DSS and ISO 27001. KEY ACCOUNTABILITIESDatabase Administration & Operations Install, configure, and maintain Postgre SQL database servers across development, staging, and production environments. Monitor and manage database health, performance, availability, and capacity to ensure SLAs are consistently met. Develop, implement and test backup and recovery strategies including Point-in-Time Recovery and continuous archiving. Perform regular database maintenance tasks. Manage database schemas, users, roles, and access permissions in alignment with least-privilege principles. Performance Tuning & Optimization Analyze and optimize slow queries using the diagnostic tools. Design and maintain optimal indexing strategies to maximize query performance. Tune Postgre SQL configuration parameters based on workload profiles. Conduct capacity planning, workload forecasting, and database growth analysis. Collaborate with application development teams on schema design, query optimization, and best practices. High Availability & Disaster Recovery Design and manage HA solutions using Postgre SQL Streaming Replication, logical replication, and auto failover. Configure and maintain connection pooling for scalable application connectivity. Participate in Active-Active and Active-Passive datacenter architecture design and implementation. Execute and validate DR failover/failback procedures ensuring RTO and RPO targets are achieved. Maintain and test disaster recovery runbooks and business continuity plans. Security & Compliance Implement and enforce database security controls in compliance with PCI-DSS, ISO 27001, and applicable CBE regulations. Manage database encryption, audit logging, and data masking for sensitive financial data. Conduct periodic database security assessments, vulnerability scans, and remediation activities. Ensure access control policies, privileged user monitoring, and audit trails are in place and operational. Support internal and external audit activities by providing evidence and documentation as required. Automation & Dev Ops Integration Develop and maintain database automation scripts for operations. Integrate Postgre SQL operations into CI/CD pipelines and infrastructure-as-code frameworks. Implement database change management and version control practices. Participate in Agile/Dev Ops ceremonies and contribute to infrastructure improvement initiatives. Documentation & Knowledge Transfer Maintain documentation for database architectures, configurations, runbooks and standard operating procedures. Mentor and coach junior DBA team members, fostering knowledge transfer and skills development. Prepare and present technical reports, capacity plans, and performance dashboards to management.
KNOWLEDGE, SKILLS & COMPETENCIESEducation Background Bachelor’s degree in computer science, Information Technology, or related technical discipline. Advanced degrees or equivalent professional certifications are a strong advantage. Competencies Analytical Thinking: Diagnose complex database issues and derive root causes quickly under pressure. Proactive Ownership: Takes full responsibility for database availability and performance, with a continuous improvement mindset. Communication: Communicates technical concepts clearly to technical & non-technical business stakeholders. Security Awareness: Strong understanding of data security principles and a compliance-first approach to all database activities. Team Collaboration: Works effectively across DBA, development, infrastructure, and security teams in a matrixed environment. Mentorship: Demonstrates leadership by guiding junior DBAs and promoting best practices. Language Skills Fluent English (Written & Spoken) Years of Experience5+ years of overall database administration experience with minimum of 3 years specializing in Postgre SQL. Internal Stakeholders Java Architect / Software Engineering & Digital / QA / Dev Ops / Product Owners / Info Sec External Stakeholders Technical contacts / Payment schemes / Third-party vendors / Integration Partners