Database Administration Senior Engineer

JOB PURPOSEManage the design, implementation, performance tuning, security hardening and high-availability management of enterprise-grade PostgreSQL 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 & OperationsInstall, configure, and maintain PostgreSQL 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 & OptimizationAnalyze and optimize slow queries using the diagnostic tools.Design and maintain optimal indexing strategies to maximize query performance.Tune PostgreSQL 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 RecoveryDesign and manage HA solutions using PostgreSQL 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 & ComplianceImplement 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 & DevOps IntegrationDevelop and maintain database automation scripts for operations.Integrate PostgreSQL operations into CI/CD pipelines and infrastructure-as-code frameworks.Implement database change management and version control practices.Participate in Agile/DevOps ceremonies and contribute to infrastructure improvement initiatives.Documentation & Knowledge TransferMaintain 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 BackgroundBachelor’s degree in computer science, Information Technology, or related technical discipline.Advanced degrees or equivalent professional certifications are a strong advantage.CompetenciesAnalytical 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 SkillsFluent English (Written & Spoken)Years of Experience5+ years of overall database administration experience with minimum of 3 years specializing in PostgreSQL.Internal StakeholdersJava Architect / Software Engineering & Digital / QA / DevOps / Product Owners / InfoSecExternal StakeholdersTechnical contacts / Payment schemes / Third-party vendors / Integration Partners