Analyst, Database Administrator

Location: Lagos

Job Summary

The Analyst, Database Administrator (DBA) is responsible for the administration, performance, security, availability, and integrity of the organization’s database environments. The role supports multiple database platforms - including Oracle, Microsoft SQL Server, MySQL, and PostgreSQL, and works closely with application, infrastructure, and security teams to ensure reliable database services that meet business and operational requirements.

Key Responsibilities

Database Administration & Operations

• Install, configure, maintain, and upgrade database systems across Oracle, SQL Server, MySQL, and PostgreSQL platforms.
• Ensure high availability, reliability, and optimal performance of all production and non‑production databases.
• Monitor database health, capacity, and resource usage; proactively identify and resolve performance bottlenecks.
• Perform routine maintenance tasks, including patching, indexing, statistics management, and housekeeping.

Backup, Recovery & Business Continuity

• Design, implement, and manage backup and recovery strategies for all supported databases.
• Regularly test database restores and disaster recovery procedures to ensure data integrity and recoverability.
• Support database failover, replication, and high‑availability solutions where applicable.

Security & Compliance

• Implement database security best practices, including access controls, encryption, auditing, and vulnerability remediation.
• Ensure compliance with organizational policies, regulatory requirements, and data protection standards.
• Support database user management and privilege reviews.

Performance Tuning & Optimization

• Analyze SQL queries, execution plans, and database workloads to improve performance and efficiency.
• Work with development and application teams to optimize SQL code, database design, and indexing strategies.
• Provide recommendations for database architecture and scalability improvements.

Support & Collaboration

• Provide first‑ and second‑level database support for incidents, service requests, and problem resolution.
• Collaborate with application, DevOps, infrastructure, and business teams to support existing and new applications.
• Participate in change management, release planning, and system upgrades.

Documentation & Reporting

• Maintain accurate documentation for database configurations, procedures, and operational standards.
• Prepare reports on database performance, capacity planning, incidents, and improvements.

Required Qualifications & Experience

• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• Proven experience administering enterprise databases, including Oracle, SQL Server, MySQL, and PostgreSQL.
• Strong knowledge of SQL, database architecture, and relational database concepts.
• Hands‑on experience with backup/recovery, performance tuning, and database monitoring tools.
• Experience supporting production environments with high availability and uptime requirements.

Technical Skills & Competencies

• Database platforms: Oracle, Microsoft SQL Server, MySQL, PostgreSQL
• Operating systems: Linux/Unix and Windows Server
• Backup and recovery strategies and tools
• Performance monitoring and tuning
• Database security and access control
• Basic scripting skills (Shell, PowerShell, or similar)
• Familiarity with cloud or virtualized environments is an advantage

Soft Skills & Attributes

• Strong analytical and problem‑solving skills
• Excellent communication and documentation abilities
• Ability to work independently and as part of a team
• High attention to detail and commitment to data integrity
• Ability to manage multiple priorities in a fast‑paced environment

Preferred Certifications (Optional)

• Oracle Certified Professional (OCP)
• Microsoft SQL Server Certification
• MySQL or PostgreSQL certification
• ITIL or equivalent operational framework knowledge