Database Analyst

2 weeks ago

Mississauga, Canada GTT, LLC Full time

Database Analyst - Oracle (Remote)
Contract Duration 6 months

**Job Description**:
Job Accountabilities:
Advise on our client's DB standards as required on projects (eg. Audit processes, database access, job configuration)
The Database Analyst will create new databases (OCAC PDBs - CDBs)
AWR reporting, tuning, and optimization of Database
Updates to database schema (create, alter, or drop objects) details
Deploy code (stored procedures, SQL scripts)
Setup DB traces for Performance Testing to capture various performance metrics
The Database Analyst will support testing cycles (eg. Running scripts, database backup/restores)
Documentation updates, as required

Job Requirements
Work as part of a DBA team providing the project 24/7 support through rotating shifts.
Strong experience and knowledge installing and building OCAC (DBs, OAS, ODI, Oracle19c upgrades/in-place upgrades and Clustered RAC installs
Strong experience with AWR, ADDM reporting, SQL Tuning Advisor, SQL Trace & TKProf, and optimization of Database/VLDBs.
Strong experience and knowledge with SQL Developer, Clustered RAC, Active/Normal Data Guard, RMAN, Data Pump, SQL loader, and export/import
Knowledge of related tasks like DR switchover, converting to read/write mode without interrupting primary production database
Defines the content and structure of the database and advises users on efficient techniques for extracting data
Contribute to the 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.
Assists in the change control process to implement changes.
Assure timely and accurate processing of assigned tasks.

Must-Have:
Oracle 19c
ODI /ODS
AWR /ADDM reporting
SQL tuning
Export /import

About The Company:
As a top 10 North American bank, our client aims to stand out from its peers by having a differentiated brand - anchored in a proven business model and rooted in a desire to give its customers, communities, and colleagues the confidence to thrive in a changing world.
Our client engages in providing financial products and services. They offer various financial products and services, telephone, Internet, and mobile banking services, retail and commercial banking services, and wealth management services. The Wholesale Banking segment provides capital markets, investment banking, corporate banking products, and investment needs to companies, governments, and institutions in financial markets.

  • Database Analyst

    2 weeks ago

    Mississauga, Ontario, Canada GTT, LLC Full time

    Database Analyst - Oracle (Remote)Contract Duration 6 monthsJob Description:Job Accountabilities:Advise on our client's DB standards as required on projects (eg. Audit processes, database access, job configuration)The Database Analyst will create new databases (OCAC PDBs - CDBs)AWR reporting, tuning, and optimization of DatabaseUpdates to database schema...

  • Oracle Database Analyst

    4 weeks ago

    Mississauga, Canada CB Canada Full time

    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...

  • Database Analyst

    5 days ago

    Mississauga, Canada GN IT & Management Solutions Inc. Full time

    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 management systems to analyze data **Computer and technology knowledge**: - Internet -...

  • Analyst, Database

    3 weeks ago

    Mississauga, Canada 1702858 Ontario Inc OA Eurocan Srl Full time

    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 management systems to analyze data - Lead and co-ordinate teams of data administrators in the...

  • Database Analyst

    1 week ago

    Mississauga, Canada IT DECK SYSTEMS Full time

    Education: College/CEGEP - Experience: 2 years to less than 3 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 management systems to analyze data - Develop and implement data administration policy, standards...

  • Analyst, Database

    2 weeks ago

    Mississauga, Canada A.P.H INTERNATIONAL LTD. Full time

    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 management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document data...

  • database analyst

    3 days ago

    Mississauga, Canada Chase Auto Parts Inc. Full time

    Education: College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 yearsExperience: 1 to less than 7 months or equivalent experienceTasksCollect data to identify areas for improvement within an organization's IT infrastructureDevelop and maintain computer databasesDocument customers' requirements for projectsDocument...

  • Database Analyst

    2 weeks ago

    Mississauga, Ontario, Canada GN IT & Management Solutions Inc. Full time

    Education: Bachelor's degree Experience: 1 year to less than 2 yearsTasks: Collect and document user's requirements Design and develop database Design, construct, modify, implement and test data models and database management systems Operate database management systems to analyze dataComputer and technology knowledge: Internet Database software Data analysis...

  • Database Analyst

    2 weeks ago

    Mississauga, Canada ABS Tech Solutions Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years **Work setting**: - Computer hardware or software retailer/wholesaler **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 management systems to...

  • Database Analyst

    4 weeks ago

    Mississauga, Canada Reiwatakiya Full time

    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 - Operate database management systems to analyze data - Develop and implement data...

  • Database Analyst

    2 weeks ago

    Mississauga, Canada EPIC - Educational Program Innovations Center Full time

    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 management systems to analyze data - Develop and implement data administration policy,...

  • Database Analyst

    2 weeks ago

    Mississauga, Canada EPIC - Educational Program Innovations Center Full time

    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 management systems to analyze data - Develop and implement data administration policy,...

  • analyst, database

    4 weeks ago

    Mississauga, Canada A.P.H INTERNATIONAL LTD. Full time

    Education: Bachelor's degreeExperience: 1 year to less than 2 yearsTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for...

  • analyst, database

    4 weeks ago

    Mississauga, Canada A.P.H INTERNATIONAL LTD. Full time

    Education: Expérience: EducationBachelor's degreeTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for network access...

  • analyst, database

    4 weeks ago

    Mississauga, Canada Tyson IT Solutions Inc Full time

    Education: Bachelor's degreeExperience: 1 year to less than 2 yearsTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for...

  • analyst, database

    4 weeks ago

    Mississauga, Canada Tyson IT Solutions Inc Full time

    Education: Expérience: EducationBachelor's degreeTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for network access...

  • database analyst

    2 weeks ago

    Mississauga, Ontario, Canada Technology Solutions Full time

    Education: Bachelor's degreeExperience: 1 year to less than 2 yearsTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for...

  • database analyst

    4 weeks ago

    Mississauga, Canada Technology Solutions Full time

    Education: Bachelor's degreeExperience: 1 year to less than 2 yearsTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for...

  • database analyst

    2 weeks ago

    Mississauga, Ontario, Canada Technology Solutions Full time

    Education: Expérience: EducationBachelor's degreeTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for network access...

  • database analyst

    4 weeks ago

    Mississauga, Canada Technology Solutions Full time

    Education: Expérience: EducationBachelor's degreeTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for network access...