HireFT
Browse JobsHow it worksPricingSuccess Stories
    Back to jobs
    IN

    Info-Ways

    Staffing

    Oracle performance tuning expert - Brampton, ON

    Brampton, CanadaOn-SiteContractPosted 2mo ago
    All Info-Ways jobs

    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 :

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

    Job details are sourced from the employer's original posting.

    Open job posting
    IN

    About the company

    Info-Ways

    Info-Ways helps major clients in the United States fulfil their technical staffing needs

    View all Info-Ways jobs
    Industry
    Staffing
    Open roles
    275

    Interested in this role?

    Apply with HireFT

    Free to start — no card required.

    Your fit

    How well do you match?

    Sign in to see how your résumé lines up with this role.