Blue Pearl is a market-leading CLOUD Solutions developer with extensive knowledge and insight into the latest technologies, standardised processes, advanced technical capabilities and consulting processes available, ensuring wholistic success for our clientele. We offer professional consulting to compliment your business strategy and overall management and make it our priority to add value to any business by listening, analysing and creating a conducive solution that will empower our client.
We are recruiting to fill the position below:
Job Title: Database L2 Engineer
Location: Lagos, Nigeria
Job type: Contract
Job Description
We are looking for an experienced Database L2 Engineer with strong expertise in Oracle Database Administration to support, maintain, and optimize our Oracle database environments.
The role involves performing daily database operations, troubleshooting complex issues, and ensuring high availability and performance of our databases.
Key Responsibilities
Database Administration and Maintenance:
Manage and maintain Oracle database instances across development, testing, and production environments.
Perform routine database maintenance tasks such as backup, recovery, patching, and upgrades to ensure data integrity and availability.
Monitor database health and performance, optimizing configurations for optimal database response times.
Troubleshooting and Incident Management:
Provide Level 2 support for database-related incidents, diagnosing and resolving issues promptly to minimize downtime.
Work with Level 1 support to handle escalated database issues and provide technical guidance.
Collaborate with Level 3 or vendor support for complex issues that require further escalation.
Performance Monitoring and Tuning:
Use monitoring tools to track database performance, identifying and addressing potential bottlenecks.
Conduct regular performance tuning on SQL queries, indexing, and storage optimization.
Perform capacity planning and forecasting to ensure the database infrastructure can scale with organizational growth.
Backup and Recovery:
Implement and manage database backup and recovery procedures in line with business continuity requirements.
Perform regular testing of backups to ensure data recoverability and integrity.
Implement disaster recovery plans for Oracle databases, including testing failover and failback procedures.
Security and Compliance:
Apply and enforce database security measures, including user roles, privileges, and auditing.
Ensure databases comply with relevant security policies, industry regulations, and best practices.
Participate in database security assessments, audits, and vulnerability management.
Documentation and Reporting:
Maintain accurate documentation of database configurations, procedures, and troubleshooting steps.
Prepare regular reports on database health, performance, capacity planning, and security compliance.
Document incident response and resolutions to build a knowledge base for future reference.
Qualifications
Education: Bachelor's Degree in Computer Science, Information Technology, or a related field (preferred).
Experience: Minimum of 3 years of experience in Oracle Database Administration, with at least 1-2 years in an L2 support role.
Certifications: Oracle Database certification (e.g., Oracle Certified Associate - OCA or Oracle Certified Professional - OCP) is a plus.
Skills and Competencies:
Technical Skills:
Proficiency in Oracle Database architecture, installation, configuration, and management.
Strong experience with Oracle backup and recovery tools such as RMAN.
Knowledge of database performance tuning, query optimization, and troubleshooting.
Familiarity with Oracle database security features, including roles, privileges, and auditing.
Experience with high availability solutions like Oracle Data Guard and RAC (Real Application Clusters) is a plus.
Soft Skills:
Excellent problem-solving skills with a strong analytical mindset.
Strong verbal and written communication skills to effectively collaborate with IT teams and stakeholders.
Ability to work independently and manage time effectively in a fast-paced environment.