Oracle performance tuning expert - Brampton, ON

Info-Ways; Brampton; On-site; CAD 96,432 - 123,984; Full time

Job summary

A technology consulting firm is seeking an Oracle performance tuning expert for a contract position in Brampton, Ontario. The role requires over 13 years of database administration experience, focusing on performance tuning and Oracle GoldenGate. Responsibilities include managing mission-critical databases, troubleshooting PL/SQL issues, and producing documentation. Ideal candidates will have experience with Oracle versions from 9 to 12c and Oracle tools like RAC and Exadata. Strong Linux skills are also essential.

Qualifications

• Minimum 13 years' experience with database administration.
• Recent experience in Performance Tuning, Oracle GoldenGate, RAC, Exadata.
• Experience with Oracle versions 9-12c.

Responsibilities

• Provide expertise on performance tuning and GoldenGate configuration.
• Monitor and manage production databases.
• Develop and troubleshoot PL/SQL scripts.

Skills

Performance Tuning

Oracle GoldenGate

PL/SQL

SQL Performance Tuning

Linux

Tools

Oracle RAC

Oracle Exadata

Data Guard

Grid Control

Job description

Overview

Role: Oracle performance tuning expert
Location: Brampton, ON
Duration: 6+ Months
Employment type: Contract
Industry: IT

BGV will be done for the selected candidates.

Responsibilities

• Provide expertise on performance tuning, Oracle GoldenGate, and the ability to configure GoldenGate and troubleshoot related issues independently.
• With broad and expert-level database technical knowledge, provide database technical evaluation and recommendations on database design and architecture, integration, and database high-availability solutions.
• Monitor and proactively manage mission-critical production databases with strong database administration skills.
• Experience with PL/SQL development, implementing new stored procedures and scripts, resolving complex PL/SQL compilation issues, and fixing errors due to object grants/dependencies.
• Work with SQL queries and SQL Trace/Explain plans, perform SQL performance tuning, set Oracle parameters, and optimize options.
• Knowledge of creating and maintaining tables, partitioning, indexes, triggers, and stored procedures in a large-terabyte database environment.
• Hands-on experience with installation, configuration, and troubleshooting of Oracle products and patches, including Exadata, RAC, ASM, Clusterware, Data Guard, OID, Grid/Cloud Control, and DBaaS environments.
• Solid experience in Linux, Linux shell scripting, and experience with database links and Oracle heterogeneous services.
• Produce database documentation, including data standards, procedures, and definitions for the data dictionary.
• Plan growth and changes (capacity planning) and apply sound SDLC knowledge; experience in code migration, database change management, and data management.

Profile

Oracle Performance tuning expert

Primary Functions

• Engagement Experience: Systems Design and Architecture (Performance Tuning, Maximum Availability Architecture, GoldenGate administration, RAC clustering, ASM, Database & Application Server, Disaster Recovery using Data Guard, Backup and Recovery)
• Systems Analysis and Performance tuning (Oracle Database 12c, 11g, 10g, 9i; Application SQL and PL/SQL code tuning)
• Provide ORACLE engineering, design and administration services to several large-scale mission-critical ORACLE-based applications and environments

Qualifications

• Minimum ten (13) years’ database administration experience with recent experience in the following areas: Performance Tuning, Oracle GoldenGate, Oracle RAC, Oracle Exadata
• Experience with Oracle 9-12c (Oracle 12c, Oracle 11g, Oracle 10g R2, Oracle 9i); GoldenGate, RAC, Grid Control under HP-UX, AIX or Red Hat Linux

Desirable

• Oracle technical certifications with rich experience in performance tuning and GoldenGate

Application/Response Details

Please respond with your word resume and requested details:

• Full Name
• Work Authorization
• Contact Number
• Email ID
• Skype ID
• Current location
• Willing to relocate
• Rate/hr

All your information will be kept confidential according to EEO guidelines.