The Database Administrator (DBA) is responsible for the design, implementation, maintenance, and performance optimization of all production, staging, and development databases supporting mission-critical financial applications. This includes ensuring data integrity, high availability, security, and disaster recovery for systems handling digital banking, payment processing, wallets, and agency transactions.
The ideal candidate has strong expertise in PostgreSQL and MySQL, with experience managing large-scale databases in Fintech or financial services environments, where uptime, data accuracy, and compliance are paramount.
Key Responsibilities:
Database Management & Operations
- Design, install, configure, and maintain database systems (PostgreSQL, MySQL, or MSSQL) for production and staging environments.
- Monitor database performance, implement tuning and optimization strategies, and manage indexing, query plans, and caching mechanisms.
- Ensure 24/7 database uptime, high availability, and fast recovery from incidents through clustering, replication, and backup strategies.
- Manage and monitor database backup, restore, and disaster recovery (DR) processes using enterprise tools or cloud-native solutions.
Security & Compliance
- Enforce data access controls, encryption standards, and user permissions in line with regulatory and internal security policies (CBN, NDIC, PCI-DSS, ISO 27001).
- Conduct periodic data integrity and audit checks to ensure compliance with organizational standards.
- Collaborate with the Security and Compliance teams to ensure secure data storage and transmission.
Performance & Optimization
- Analyze slow queries, optimize schema design, and collaborate with backend teams to improve application performance.
- Use monitoring tools (e.g., pgAdmin, Grafana, Prometheus, Cloud SQL Insights) to proactively identify and resolve bottlenecks.
- Support database migration, scaling, and replication across multi-environment (Dev/Staging/Production) setups.
Development & Collaboration
- Support developers with SQL query optimization and stored procedure development.
- Participate in system architecture reviews and contribute to design decisions impacting data storage and flow.
- Work closely with the DevOps team to integrate database management into CI/CD pipelines for seamless deployments.
- Document all database configurations, policies, and procedures for operational continuity.
Backup, Recovery & Disaster Preparedness
- Develop, test, and maintain backup and recovery plans for all databases and ensure RPO/RTO compliance.
- Perform regular recovery simulations to validate backup reliability and completeness.
- Manage database replication and failover strategies across clusters and regions to ensure business continuity.
Requirements
- Bachelor’s degree in Computer Science, Information Technology, or a related discipline.
- 5+ years of professional experience as a Database Administrator in a high-availability production environment.
- Proven expertise in PostgreSQL and MySQL administration, optimization, and replication.
- Strong understanding of SQL query optimization, database normalization, indexing, and partitioning strategies.
- Experience managing databases supporting Fintech systems (digital banking, wallet, agency, or payment platforms).
- Familiarity with cloud database services such as AWS RDS, Google Cloud SQL, or Azure Database.
- Knowledge of backup and recovery tools, performance tuning, and database monitoring frameworks.
- Strong scripting skills (Python, Bash, or PowerShell) for automation of administrative tasks.
- Understanding of security compliance frameworks (PCI-DSS, ISO 27001, CBN standards).
- Experience working with microservices architectures and data replication across distributed systems is a plus.
Preferred Skills:
- Exposure to NoSQL databases (MongoDB, Redis, or Cassandra).
- Experience with ETL pipelines, data warehousing, and business intelligence integrations.
- Familiarity with containerized environments (Docker, Kubernetes) and CI/CD pipelines.
- Certification in database administration (PostgreSQL, Oracle, AWS, or Azure) is an added advantage.
Gmail
Yahoomail