Database L2 Engineer at Blue Pearl Consulting Services

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.