Oracle performance tuning expert - Brampton, ON
Contract
IT
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 :
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 independently.With broad and expert-level database technical knowledge and skills on Oracle databases, provide database technical evaluation and recommendation on database design and architecture, integration, database high availability solution, database replication architecture.Monitor and manage proactively mission‑critical production databases.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, 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 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. Experience with database links and Oracle heterogeneous services.Write 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 :
All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr