Expires 3 days from now
Database Administrator
SQL
full-time
| Assistant Executive - Senior Executive
Lagos,
Lagos
Share this job
Job Summary
The Database Administration (DBA) function ensures the availability, performance, security, and reliability of AIICO’s enterprise database and system platforms. The DBA team manages core operational databases, data warehouse environments, and underlying infrastructure (Linux servers, virtualization, and cloud platforms). responsible for the design, installation, configuration, maintenance, and reliable operation of all database systems (production and non-production). This includes high availability, backup and recovery, performance optimization, and compliance with governance standards.
Job Details
Data Availability & Uptime
- Installation & Configuration: Install and configure Oracle, SQL Server, and PostgreSQL servers across production and non-production environments.
- Patching & Upgrades: Apply patches, hotfixes, and service packs, and perform major version upgrades to keep databases secure and current.
- High Availability (HA): Implement and manage HA solutions such as Oracle Data Guard, SQL Server AlwaysOn, and clustering to minimize downtime.
- Monitoring: Proactively monitor database systems using tools like OEM 13c, Grafana, and Prometheus to detect and resolve issues before they impact users.
- Uptime Assurance: Ensure 100% uptime of critical databases supporting core insurance operations.
Performance & Optimization
- Performance Tuning: Analyze and tune performance bottlenecks, including SQL execution plans, index usage, and resource utilization.
- Indexing & Query Optimization: Create, modify, and manage indexes; collaborate with developers to optimize poorly performing SQL queries.
- Capacity Planning: Monitor disk space, memory, CPU usage, and storage growth to forecast hardware and scalability needs.
- System Optimization: Conduct regular health checks to maintain high efficiency and user experience.
Backup, Recovery & Continuity
- Backup Strategy: Define and implement comprehensive full, incremental, and differential backup procedures.
- Recovery Planning: Configure and validate Point-in-Time Recovery (PITR) and other recovery strategies.
- Disaster Recovery (DR): Design and test disaster recovery plans, including replication to standby/DR sites.
- Validation: Conduct quarterly restoration tests to confirm backup integrity and recovery viability.
- Archival: Ensure backup files are securely archived and accessible for audit and compliance.
Data Security
- Access Control: Manage user accounts, roles, privileges, and enforce “least privilege” principles.
- Auditing: Implement auditing frameworks to track access, changes, and security-relevant events.
- Compliance: Ensure adherence to regulatory standards and internal audit frameworks.
- Data Integrity: Safeguard consistency and accuracy of data across environments.
- Credential Security: Enforce secure password storage and rotation using Passbolt or equivalent solutions.
Database System Infrastructure Administration (DBA-Specific Scope)
- Administer Linux servers (Oracle Linux, Ubuntu) hosting critical databases.
- Manage Oracle Virtualization environments (OVM/OVMM) and related VMs supporting database and application workloads.
- Manage and administer Oracle Weblogic, deploying new application changes and managing TurnQuest APIs
- Implement monitoring for storage utilization on database, application, and web servers.
- Apply critical patchset updates to Oracle Database, Grid Infrastructure, and WebLogic Homes.
Requirements
- HND/BSC Computer Science or any related field
- 3-5 years of experience as a database administrator
- Microsoft DP-900
- OCA
Benefits
Thrive Professionally and Personally at AIICO Insurance Plc.
At AIICO Insurance Plc., we believe in fostering an environment where individuals excel, both personally and professionally. We offer a comprehensive employee value proposition designed to empower you, support your well-being, and fuel your career aspirations.
We offer:
Stress-Free Work-Life: Hybrid work schedules, competitive leave, and reliable transportation.
Holistic Wellbeing: Health & and wellness programs, and subsidized gym memberships.
Grow with Us: Sponsorship for professional certifications, coaching, learning and development opportunities, and more.
At AIICO, we recognize that our employees are our greatest asset. We are committed to fostering a supportive culture where you feel valued, respected, and empowered to achieve your full potential.
Join us and embark on a rewarding career journey that makes a difference.
About Company
AIICO Insurance Plc
AIICO Insurance Established in 1963, AIICO Insurance Plc (NSE Ticker: “AIICO”) is a financial services group with market-leading positions in its key business lines; Insurance, Health Maintenance and Asset Management. Background AIICO commenced operations in Nigeria in 1963 as an Agency office of American Life Insurance Company (“ALICO”) – at the time, a subsidiary of American International Group (“AIG”). The Company was incorporated, registered and licensed in Nigeria as American Life Insurance Company Limited – as a wholly owned subsidiary of ALICO/AIG – in 1970 – to offer Life and insurance services. The Company was renamed American International Insurance Company Limited (“AIICO”) upon the acquisition of a 60% stake by the Federal Government of Nigeria, and later listed on the Nigerian Stock Exchange in 1990, after which both shareholders – the Federal Government of Nigeria and AIG divested. 1. Life and general insurance are strategic business divisions within AIICO. 2. AIICO Capital Limited – a subsidiary of AIICO providing asset management services for AIICO and 3rd parties. 3. AIICO Multishield Limited – a leading health maintenance organisation. Following the insurance industry's consolidation in 2007, the Company acquired NFI Insurance PLC and Lamda Insurance Company Limited (both cumulatively accounting for less than 30% of AIICO's pre-acquisition gross premiums). The Company subsequently re-certified as both a General Insurance and Life Assurance Company – taking advantage of its legacy, brand, franchise and strong retail distribution network to grow a leading General Insurance business.