Senior Oracle DBA

IBM Computing; Ottawa; On-site; CAD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a seasoned Oracle Database Administrator to lead the design and maintenance of core databases. This role involves ensuring database availability, performance tuning, and contributing to disaster recovery planning. With a commitment to innovation and excellence, this forward-thinking company offers an opportunity to tackle complex challenges in a diverse and inclusive environment. If you're passionate about database management and ready to make a significant impact, this position is perfect for you.

Qualifications

• 10+ years of Oracle database experience with advanced performance tuning skills.
• Strong knowledge of disaster recovery and database reliability.

Responsibilities

• Design and maintain core Oracle databases ensuring high availability.
• Monitor database performance and troubleshoot issues proactively.

Skills

Oracle Database Management

Performance Tuning

SQL/PLSQL

Unix/Linux

Disaster Recovery Planning

Storage Management

Problem Solving

Education

Oracle Database Certification

Bachelor's Degree in Computer Science

Tools

Oracle Data Guard

RMAN

Data Pump

Oracle GoldenGate

Job description

Introduction

At IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you've never thought possible. Are you ready to lead in this new era of technology and solve some of the world's most challenging problems? If so, lets talk.

Your role and responsibilities

• Design, develop, implement and maintain our core Oracle databases.

• Maintain our SQL/PLSQL scripts.

• Ensure DB availability. Take ownership of performance monitoring of the DB.

• Contribute to the creation and maintenance of disaster recovery plans.

• Determine and document DB policies, procedures and standards.

• Performance testing and evaluation to ensure data security, privacy and integrity.

• Identification of bottle necks and deadlock issues.

• Ensure SLA's & operational PI's are met, working as necessary with internal and external support functions when major incidents occur.

• Will also be the primary SME for our Oracle Goldengate system.

Required technical and professional expertise

• Ideally Oracle Database Certified with 10+ years or more experience.

• Advanced expertise in performance tuning and troubleshooting database performance issues.

• Other experience should include storage management, managing schemas, report generation.

• Operating system experience with Unix/Linux.

• Oracle management tools (Data Guard, RMAN, Data pump).

• Partitioning, good problem solver focused with strong attention to detail.

• Experience with an organization with a key reliance on 24X7 reliability on its database.

Preferred technical and professional experience

• Experience with Oracle GoldenGate, knowledge of Oracle Multitenant (CDB/PDB)

IBM is committed to creating a diverse environment and is proud to be an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, caste, genetics, pregnancy, disability, neurodivergence, age, veteran status, or other characteristics. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.