Database L2 Engineer at Blue Pearl Consulting Services

Job Overview

Location
Lagos, Lagos
Job Type
Full Time
Date Posted
1 year ago

Additional Details

Job ID
106247
Job Views
59

Job Description






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.



Similar Jobs

Cookies

This website uses cookies to ensure you get the best experience on our website. Cookie Policy

Accept