Jobs
>
Mississauga

    Oracle Database Analyst - Mississauga, Canada - CB Canada

    CB Canada
    CB Canada Mississauga, Canada

    4 days ago

    Cb Canada background
    Description

    Oracle Database Analyst

    On behalf of our client in the Banking Sector, PROCOM is looking for an Oracle Database Analyst.

    Oracle Database Analyst – Job Description

    • Vet new database server build requirements and review project docs to ensure design specifications meet application needs
    • Advise on DATABASE standards as required on projects (e.g., Audit processes, database access, job configuration)
    • AWR reporting, Tuning and optimization of Database
    • Create new databases (OCAC PDATABASEs, Standalone)
    • Updates to database schema (create, alter, or drop objects) details
    • Apply database permissions (add, modify or delete logins, grant/revoke permissions to database objects)
    • Deploy code (stored procedures, SQL scripts)
    • Setup database traces for PCOE testing to capture various performance metrics
    • Support testing cycles on projects (e.g., Running scripts, database backup/restores)
    • Updates to database inventory for audit and chargeback (specifically for Shared Gold databases)
    • Preparation for, and participation in, various audits as required (Internal, SOX, PCI)
    • Handover of encryption keys to Enterprise Operations when TDE or SSL is employed
    • Documentation updates (Application Support Portal (ASP), other handover docs)), as required

    Oracle Database Analyst – Mandatory Skills

    • Strong experience and knowledge installing and building OCAC PDBs, Oracle12c/19c & upgrades/in place upgrades and RAC installs
    • Strong experience with AWR reporting, Tuning and optimization of Database
    • Defines the content and structure of the database and advises users on efficient techniques for extracting data
    • Contribute to automation of installs
    • Establish and maintain database support tools
    • Monitors overall standards and procedures and ensures integration of systems through database design
    • Maintains accurate and up to date database system documentation
    • Has awareness of available physical storage and initiates requests for new devices
    • Proposes data standards for both software and physical protection
    • Assists in database reorganization/restructuring
    • Creates new schema for the development of new software products
    • This work involves working with Application Development, the business line customer, and the project management team
    • Informs systems and applications programming staff of any future database changes that might require program modification
    • Assists in the change control process to implement changes
    • Works to achieve a timely and accurate preparation of reorganization/restructuring schedule for completion of department projects
    • Assure timely and accurate processing of all individual and departmental service requests in order to provide consistent, useful service and information to all department personnel
    • Recommends an effective operational procedure in accordance with department goals and application guidelines, in order to effectively utilize the database system and remain within the security and integrity control limits
    • Work as part of a team and provide 7x24 support when required
    • Oracle Database 5 years
    • RAC experience 5 years
    • Strong upgrade experience

    Oracle Database Analyst - Nice to Have Skills

    • Large financial industry experience
    • MS SQL

    Oracle Database Analyst - Assignment Start Date

    ASAP – 6 months to start

    Oracle Database Analyst - Assignment Location

    Mississauga, ON - Work Hybrid

  • R.E. ROYAL TRADING INC.

    database analyst

    5 days ago

    R.E. ROYAL TRADING INC. Vaughan, Canada

    Education: · Expérience: · Education · College/CEGEP · Tasks · Design and develop database · Operate database management systems to analyze data · Collect and document user's requirements · Work conditions and physical capabilities · Fast-paced environment · Work under pressure ...

  • Reiwatakiya

    Database Analyst

    1 week ago

    Reiwatakiya Mississauga, Canada

    Education: Bachelor's degree · - Experience: 2 years to less than 3 years · **Tasks**: · - Collect and document user's requirements · - Data Science · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - O ...

  • I Tech 7 Ltd

    Database Analyst

    3 days ago

    I Tech 7 Ltd Mississauga, Canada

    Education: College/CEGEP · - Experience: 1 year to less than 2 years · - or equivalent experience · **Tasks**: · - Collect and document user's requirements · - Operate database management systems to analyze data · - Research and document data requirements, data collection and adm ...

  • Exioms Canada

    Database Analyst

    4 days ago

    Exioms Canada Mississauga, Canada

    Education: College/CEGEP · - Experience: 1 to less than 7 months · **Tasks**: · - Design and develop database · - Operate database management systems to analyze data · - Research and document data requirements, data collection and administration policy, and data access rules · ** ...

  • GN IT & Management Solutions Inc.

    Database Analyst

    1 week ago

    GN IT & Management Solutions Inc. Mississauga, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 years · **Tasks**: · - Collect and document user's requirements · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Operate database ma ...

  • Exioms Canada

    database analyst

    5 days ago

    Exioms Canada Mississauga, Canada

    Education: · Expérience: · Education · College/CEGEP · Tasks · Design and develop database · Operate database management systems to analyze data · Research and document data requirements, data collection and administration policy, and data access rules · Experience · 1 to less ...

  • Rootways INC.

    Dba (Database Analyst)

    1 week ago

    Rootways INC. Mississauga, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 years · **Tasks**: · - Collect and document user's requirements · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Operate database ma ...

  • Rootways INC.

    Dba (Database Analyst)

    17 hours ago

    Rootways INC. Mississauga, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 years · **Tasks**: · - Collect and document user's requirements · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Operate database ma ...

  • EARLY MAN CONSULTING INC.

    Database Analyst

    3 days ago

    EARLY MAN CONSULTING INC. Brampton, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 years · **Tasks**: · - Collect and document user's requirements · - Data Science · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Op ...

  • Supreme Wire Products Ltd.

    Database Analyst

    4 days ago

    Supreme Wire Products Ltd. Brampton, Canada

    Education: College/CEGEP · - Experience: 1 year to less than 2 years · **Tasks**: · - Collect and document user's requirements · - Design, construct, modify, implement and test data models and database management systems · - Operate database management systems to analyze data · - ...

  • GREENWAYCARRIERS

    Database Analyst

    1 week ago

    GREENWAYCARRIERS Brampton, Canada

    Education: College/CEGEP · - Experience: 2 years to less than 3 years · **Tasks**: · - Collect and document user's requirements · - Design and develop database · - Operate database management systems to analyze data · - Develop and implement data administration policy, standards ...

  • BRISTLEFRONT GLOBAL LTD.

    Analyst, Database

    3 days ago

    BRISTLEFRONT GLOBAL LTD. Brampton, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 years · **Tasks**: · - Collect and document user's requirements · - Design and develop database · - Design, construct, modify, implement and test data models and database management systems · - Operate database ma ...

  • POPURI TECHNOLOGIES INC.

    Database Analyst

    1 week ago

    POPURI TECHNOLOGIES INC. Brampton, Canada

    Education: Bachelor's degree · - Experience: 2 years to less than 3 years · **Tasks**: · - Develop and maintain computer databases · - Document customers' requirements for projects · - Document reporting needs, queries, logic, results and recommendations to other information syst ...

  • Caretek Integrated Business Solutions Inc

    Database Analyst

    5 days ago

    Caretek Integrated Business Solutions Inc Brampton, Canada

    Education: Bachelor's degree · - Experience: 1 year to less than 2 years · - or equivalent experience · **Tasks**: · - Collect and document user's requirements · - Design and develop database · - Design, construct, modify, implement and test data models and database management sy ...

  • RMK INC

    Database Analyst

    1 week ago

    RMK INC Brampton, Canada

    Education: Bachelor's degree · - Experience: 2 years to less than 3 years · **Tasks**: · - Develop and maintain computer databases · - Document reporting needs, queries, logic, results and recommendations to other information systems professionals · - Test data models and databas ...

  • Secure Digital Markets

    Database Analyst

    4 days ago

    Secure Digital Markets Toronto, Canada

    Salary: · **What We Offer** · At Secure Digital Markets (SDM), you can build a career out of making things happen Secure Digital Markets provides institutions, miners and individuals with a custom pathway to digital asset liquidity and off-exchange transactions. As one of Canada' ...

  • Green Bee 3

    Database Analyst

    6 days ago

    Green Bee 3 Vaughan, Canada

    **Database Analyst** · Green Bee 3 Concord, ON · Green Bee 3 has pioneered IT services in the GTA for over 25 years, consistently delivering business value with the latest technology. · **OUR MISSION** · Building on our technologies and competencies creating value for our custome ...

  • TNG

    Database Analyst

    2 days ago

    TNG Burlington, Canada

    **WHO WE ARE**: · For more than a century, TNG has transported millions of pounds of product, from magazines to food and beverage, craft beer and nearly everything in between—onto shelves and into shopping carts. **Our mission is to simplify the complex, deliver the impossible, a ...

  • Canlan Sports

    Database Analyst

    1 week ago

    Canlan Sports North York, Canada

    Canlan Sports is the largest private sector owner and operator of recreational sports complexes in North America. The company's success in the recreation-entertainment & hospitality industry is attributed to a combination of innovative programming, service delivery leadership and ...

  • SMARTWAY TRUCKING INC

    Database Analyst

    5 days ago

    SMARTWAY TRUCKING INC Milton, Canada

    Work Term: Permanent · - Work Language: English · - Hours: 35 hours per week · - Education: Bachelor's degree · - Experience: 1 year to less than 2 years · **Tasks**: · - Design and develop database · - Design, construct, modify, implement and test data models and database manage ...