datatrota
Signup Login
Home Jobs Blog

Database L2 Engineer at Blue Pearl Consulting Services

Blue Pearl Consulting ServicesLagos, Nigeria Data and Artificial Intelligence
Contract
Blue Pearl Consulting is a boutique management consulting firm with a focus on helping businesses achieve sustainable competitive advantages. Mission: To be fanatical about solving problems and delivering superior solutions to our clients that maximize bottom line results. Vision: To be the go-to trusted partner for our clients, providing strategies and actionable solutions that position them for sustainable growth. Values: Integrity - We do the right thing, without compromise and without regards to consequences.

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.

Method of Application

Signup to view application details. Signup Now
X

Send this job to a friend