We are seeking a highly motivated individual to assume a pivotal role within our organization. The ideal candidate will be responsible for overseeing key operational tasks, driving project execution, and ensuring alignment with strategic objectives. Essential qualifications include a minimum of five years of relevant experience, strong analytical abilities, and proficiency in industry-specific tools and methodologies. Additionally, the position demands excellent communication skills, a collaborative mindset, and the capacity to manage multiple priorities effectively. Responsibilities encompass leading cross-functional teams, developing data-driven solutions, and monitoring performance metrics to enhance overall efficiency.
We are in search of a highly skilled and technically proficient Senior PostgreSQL Database Administrator to strengthen our Database Engineering team. This position will position you as the key steward of our high-volume, mission-critical PostgreSQL databases, where you will be tasked with safeguarding availability, integrity, performance, and security across data infrastructure that facilitates millions of financial transactions daily. Collaboration will be essential, as you partner with software engineers, DevOps and platform engineers, security teams, and business stakeholders to sustain an enterprise-grade database environment with an unwavering commitment to zero downtime and absolute data loss prevention.
Key accountabilities include serving as the primary liaison between departments to streamline communication and enhance cross-functional collaboration. Responsibilities encompass overseeing project timelines, ensuring adherence to deadlines, and monitoring progress through regular updates and milestone evaluations. Additionally, the role requires conducting comprehensive data analysis to identify trends, assess performance metrics, and provide actionable insights to senior leadership. Key tasks also involve managing stakeholder expectations, addressing concerns proactively, and fostering a culture of accountability and continuous improvement. Other duties include facilitating meetings, documenting outcomes, and coordinating with external partners to align on strategic objectives.
Database Administration & Operations professionals oversee the performance, integrity, and security of organizational databases, ensuring efficient data storage, retrieval, and management. They implement, maintain, and optimize database systems, including MySQL, PostgreSQL, and Oracle, while monitoring for performance issues and applying necessary updates or patches. Responsibilities include designing database structures, managing user access controls, ensuring data backup and recovery, and resolving technical issues. Additionally, they collaborate with IT teams to integrate databases with applications, enforce data governance policies, and support compliance with regulatory standards. Strong problem-solving skills, proficiency in SQL, and experience with database monitoring tools are essential, along with a solid understanding of database security principles and backup methodologies.
Oversee, track, and ensure the stability of multiple PostgreSQL database clusters operating in production, staging, and development environments, handling high-transaction volumes.
Responsible for managing and directing daily Database Administrator (DBA) functions, encompassing database provisioning, schema oversight, user access administration, and table space administration.
Develop and administer robust database change management protocols, including rigorous DDL reviews, meticulously crafted migration scripts, and comprehensive rollback strategies.
Proactively monitor systems to maintain an exceptional 99.99% database availability, leveraging advanced alerting mechanisms and swift incident resolution strategies.
Oversee database patching, upgrades, and version migrations while ensuring minimal service disruption.
We are seeking a skilled professional to enhance system efficiency through performance tuning and optimization strategies. The ideal candidate will conduct thorough analysis to identify bottlenecks and implement targeted improvements. Responsibilities include fine-tuning databases, optimizing query performance, and refining infrastructure configurations. Requirements involve expertise in performance monitoring tools, a deep understanding of database management, and proficiency in scripting languages. Strong analytical skills and a proactive approach to problem-solving are essential. This role demands meticulous attention to detail and the ability to collaborate effectively with cross-functional teams.
Consistently evaluate and refine query execution plans, indexing approaches, and table configurations to ensure optimal performance during periods of maximum transactional demand.
Conduct capacity planning and resource forecasting to guarantee the scalability of database infrastructure in alignment with anticipated business expansion.
Optimize PostgreSQL configuration parameters—including memory allocation, connection pooling strategies, WAL settings, autovacuum processes, and checkpoint intervals—to enhance system performance.
Collaborate closely with development teams to design optimized queries, utilize ORM effectively, and conduct thorough schema reviews, thereby mitigating the risk of performance regressions prior to deployment.
Establish and oversee connection pooling mechanisms, such as Pg Bouncer and Pg pool-II, to facilitate high-concurrency workloads efficiently.
Ensures robust operational continuity and resilience against system disruptions through comprehensive high availability and disaster recovery strategies. Implements redundant systems, failover mechanisms, and backup solutions to minimize downtime and data loss. Conducts regular testing and validation of recovery procedures to guarantee swift restoration of services. Monitors system health and performance to proactively identify potential vulnerabilities and mitigate risks before they escalate. Maintains documentation of recovery plans, incident responses, and post-mortem analyses to continuously improve incident management processes. Collaborates with cross-functional teams to align recovery objectives with business continuity goals and regulatory requirements.
Design, develop, and oversee high-availability (HA) architectures, leveraging solutions such as streaming replication, logical replication, and failover clusters—including tools like Patron and Repair—to ensure robust system resilience and continuous operations.
Design, implement, and regularly update disaster recovery (DR) plans to ensure they meet clearly defined and validated Recovery Time Objective (RTO) and Recovery Point Objective (RPO) targets, fully aligned with fintech regulatory requirements.
Develop and implement robust backup strategies—including physical, logical, and point-in-time recovery (PIT) solutions—utilizing tools like pg_base backup, backrest, or Barman, while routinely validating backup integrity and verifying respirability.
Facilitate collaboration with infrastructure teams to execute deployments spanning multiple regions and availability zones, ensuring geo-redundancy.
Overseeing security protocols and ensuring adherence to regulatory standards are central to this role, which demands a meticulous approach to safeguarding organizational assets and mitigating risks. Candidates must demonstrate expertise in cybersecurity frameworks, data protection regulations, and compliance audits, along with the ability to implement robust security measures and maintain up-to-date documentation. Responsibilities include conducting risk assessments, monitoring security incidents, and collaborating with cross-functional teams to enforce policies that align with industry best practices and legal requirements. Strong analytical skills, attention to detail, and effective communication are essential for identifying vulnerabilities, reporting findings, and guiding stakeholders through compliance-driven initiatives.
Implement and uphold the principle of least privilege across all database roles and service accounts to ensure optimal security and access control.
Implement robust monitoring, auditing, and alerting mechanisms for databases to identify and address unusual access patterns or policy breaches effectively.
Ensure adherence to data governance directives issued by the Central Bank of Nigeria, compliance with Payment Card Industry Data Security Standard (PCI-DSS) and Nigeria Data Protection Regulation (NDPR), as well as internal data security policies.
Responsible for overseeing encryption protocols for both in-transit and at-rest data across all database environments, ensuring robust security measures are implemented and maintained.
Work alongside the security team to conduct vulnerability assessments, implement remediation for penetration test findings, and strengthen the security posture of PostgreSQL instances.
We are seeking a skilled professional to spearhead the integration of automation and DevOps practices within our organization, ensuring seamless collaboration between development, operations, and IT teams. The ideal candidate will have extensive experience in designing, implementing, and maintaining robust automation frameworks, CI/CD pipelines, and infrastructure as code (IAC) solutions. Proficiency in cloud platforms such as AWS, Azure, or GCP, along with expertise in containerization technologies like Docker and Kubernetes, is essential. Additionally, the role requires strong scripting skills in languages such as Python, Bash, or PowerShell, as well as a deep understanding of version control systems like Git. Responsibilities include optimizing deployment workflows, enhancing system reliability, and fostering a culture of continuous improvement through best practices in DevOps.
Design and sustain automation scripts for recurring database administration duties utilizing Python, Bash, or Ansible.
Integrate database provisioning and schema migration processes seamlessly into CI/CD pipelines using tools such as Flyway, Liquidate, or alternative custom solutions.
Oversee the infrastructure-as-code configurations for database resources, whether deployed on cloud platforms such as AWS RDS/Aurora PostgreSQL or GCP Cloud SQL, or hosted on-premises.
Develop and sustain robust monitoring dashboards and alerting systems leveraging technologies like Prometheus, pg Badger, or Grafana.
Collaborative leadership is essential, requiring the ability to work effectively with cross-functional teams and guide colleagues toward shared objectives. Strong interpersonal skills, coupled with emotional intelligence, are necessary to foster a productive and inclusive work environment. The role demands proficiency in resolving conflicts, delegating tasks efficiently, and inspiring team members to achieve collective success. Additionally, demonstrated experience in leading projects or initiatives will be highly valued.
Act as the principal PostgreSQL technical expert across the engineering team, offering strategic guidance and mentorship to mid-level and junior database administrators to enhance their skills and ensure optimal database performance.
Work collaboratively with software engineers to develop data models, design database schemas, and establish best practices from the initial phases of product development.
Engage in architecture reviews and collaborate in technical design discussions focused on data storage strategies, access methodologies, and scalability considerations.
Develop and sustain precise, comprehensive documentation detailing database architecture alongside standard operating procedures.
Provide assistance in managing production database incidents, serving as the primary escalation resource for critical database-related problems.
Bachelor’s degree in Computer Science, Engineering, or a related field, along with a minimum of 5 years of hands-on experience in software development. Proficiency in multiple programming languages, including but not limited to Java, Python, or C++, and a strong understanding of algorithms and data structures. Experience with cloud platforms such as AWS, Azure, or Google Cloud is preferred. Excellent problem-solving skills and the ability to work both independently and collaboratively in a fast-paced environment. Strong communication skills to articulate technical concepts to both technical and non-technical stakeholders.
A minimum of eight years of practical PostgreSQL Database Administrator expertise is required, including at least three years spent managing high-transaction-volume environments in enterprise production settings.
Professionals must possess verifiable experience in administering PostgreSQL databases within financial services, payments, banking, or other highly regulated, high-stakes sectors.
Proficient in PostgreSQL internals, including MVCC, WAL, VACUUM, the query planner, locking mechanisms, and the extension ecosystem.
Demonstrated expertise in designing and implementing highly available (HA) and disaster recovery (DR) architectures, utilizing streaming replication, Patron, or comparable solutions.
Proficiency in optimizing database performance is essential, including expertise in tools like EXPLAIN and EXPLAIN ANALYZE, as well as index design techniques such as B-tree, GIN, BRAIN, and partial indexes. Additionally, the role requires a deep understanding of partition strategies and effective statistics management to enhance query efficiency and system responsiveness.
Experienced in implementing and managing robust backup and recovery solutions, including backrest, Barman, and pg_base backup, as well as Point-in-Time Recovery (PIT) workflows.
Skilled in scripting and automation languages such as Python or Bash, with a strong background in incorporating database operations into CI/CD workflows.
Proficiency in containerization and orchestration technologies, including Docker and Kubernetes, as well as experience deploying and managing PostgreSQL within containerized or cloud-native infrastructures, is required.
Proficiency in monitoring and observability tools such as Prometheus, Grafana, pg Badger, or comparable systems is required.
Proficiency in utilizing Pg Bouncer or Pg pool-II for managing connection pooling in high-capacity environments is essential.
Proficiency in executing data migration initiatives for expansive PostgreSQL database environments, particularly those exceeding multi-terabyte scales, is required.
Proficient in PostgreSQL extensions such as Cites (distributed PostgreSQL) or Timescale, with expertise in scalable database solutions.
A minimum of a Bachelor’s or Master’s degree in Computer Science, Information Technology, or a closely related discipline is required.
Core Proficiencies encompass a range of essential skills and attributes, including the ability to proficiently utilize Microsoft Office Suite and advanced knowledge of data analysis tools. Candidates should demonstrate exceptional organizational capabilities, strong problem-solving skills, and effective communication abilities, both written and verbal. A minimum of three years of relevant professional experience is required, along with a bachelor’s degree in a related field. Responsibilities include collaborating with cross-functional teams, managing multiple projects simultaneously, and ensuring timely project delivery. Familiarity with industry-specific software and adherence to compliance standards are also mandatory. The ideal candidate will exhibit leadership qualities, adaptability to evolving priorities, and a commitment to continuous professional development.
Technical Excellence: Demonstrates outstanding expertise in PostgreSQL and its comprehensive ecosystem, consistently remaining abreast of the latest PostgreSQL versions and advancements within the community.
Demonstrates a composed, systematic, and efficient approach to resolving challenges, particularly when addressing critical production incidents.
Demonstrates a strong sense of accountability by assuming full responsibility for maintaining optimal database health and consistently adopts a forward-thinking approach rather than responding after issues arise.
Collaboration is essential to this role, as it involves cultivating productive partnerships and fostering effective communication among engineering, product, and operations teams.
Able to articulate intricate database concepts in a clear and accessible manner, catering to both technical and non-technical stakeholders.
Security Consciousness: Considers data security and adherence to regulatory compliance as essential, uncompromising priorities.
Qualifications
BA/BSc/HND , MBA/MSc/MA
Experience Required
8 years
