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