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 Golden Gate, and the ability to configure Golden Gate 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 solid 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, Golden Gate 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 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

Desirable

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

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.

#J-18808-Ljbffr

📌 Oracle performance tuning expert - Brampton, ON
🏢 Info-Ways
📍 Brampton