Oracle performance tuning expert - Brampton, ON

Company Description

IT

Job Description

Role: Oracle performance tuning expert Location: Brampton, ON Duration: 6+ Months

BGV will be done for the selected candidates.

Candidate should be expert in Performance Tuning, Golden Gate administration, RAC clustering, ASM, Database & Application Server, Disaster Recovery using DataGuard, Backup and Recovery.

Profile: Oracle Performance tuning expert

Primary Functions:

Engagement Experience: Systems Design and Architecture (Performance Tuning, Maximum Availability Architecture, Golden Gate administration, RAC clustering, ASM, Database & Application Server, Disaster Recovery using DataGuard, 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.

Duties & Responsibilities:

Provide expertise on performance tuning, Oracle Golden Gate and be able to configure Golden Gate and troubleshoot the issues related to Golden Gate independently. With broad and expert-level database technical knowledge and skills on Oracle databases, be able to provide database technical evaluation and recommendation on database design and architecture, integration, database high availability solution, database replication architecture, With strong database administration skills, be able to monitor and manage proactively of mission-critical production and Experience with PL/SQL development, implementing new stored procedures and scripts, resolve complex PLSQL compilation issues, and fix errors due to object grants/dependencies. Experience and knowledge of SQL queries and SQL Trace/Explain plans, SQL performance tuning. Setting Oracle parameters, and options. Knowledge of creating and maintaining Tables, Partitioning, indexes, Triggers, stored procedures, etc. in a large terabyte database environment. Hands-on experience on installation and configuration and trouble shooting 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 Experience with Database links and Oracle heterogeneous services. Writes database documentation, including data standards, procedures and definitions for the data dictionary. Plan growth and changes (capacity planning) Sound knowledge of the SDLC, and experience in code migration, database change management and data management.

Qualifications

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

Desired Oracle technical certifications with rich experience in performance tuning and Golden Gate

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 :

Additional Information

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