Senior Oracle DBA

IBM Computing; Old Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a seasoned Oracle Database Expert to lead the management and optimization of core databases. This role is pivotal in ensuring data integrity, availability, and performance tuning within a high-reliability environment. You'll be responsible for implementing disaster recovery plans and monitoring database performance while collaborating with internal teams to resolve critical issues. Join a forward-thinking company that values innovation and diversity and take your career to the next level in a dynamic team setting.

Qualifications

• 10+ years experience in Oracle Database management and performance tuning.
• Strong problem-solving skills with attention to detail.

Responsibilities

• Design and maintain core Oracle databases ensuring high availability.
• Monitor performance and implement disaster recovery plans.

Skills

Oracle Database Management

Performance Tuning

SQL/PLSQL

Unix/Linux

Disaster Recovery Planning

Data Security

Oracle GoldenGate

Education

Oracle Database Certification

Tools

Oracle Data Guard

RMAN

Data Pump

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.