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.
#J-18808-Ljbffr
Oracle performance tuning expert - Brampton, ON employer: Info-Ways
Join a leading financial services firm in Toronto that values innovation and collaboration, offering a dynamic work culture where your expertise in Java API and trading applications will thrive. With a strong commitment to employee growth, we provide ongoing training and development opportunities, ensuring you stay at the forefront of technology in the capital markets sector. Enjoy competitive benefits and a supportive environment that fosters teamwork and professional advancement.
