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

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

  • NetSuite Functional Support Analyst

    4 weeks ago

    Mississauga, Canada Oracle Full time

    Applicants are required to read, write, and speak the following languages:  English Job Title:  Functional Support Analyst (ERP/Accounting) Division:  Oracle NetSuite Global Business Unit Locations:  Mississauga, ON, CAN Preferred Qualifications: Bachelor's/College Degree in Accounting/Finance/Business Management or relevant field Solid...

  • Technical Analyst 4-support

    4 weeks ago

    Mississauga, Canada Oracle Full time

    Technical Analyst 4-Support-230001DO **Applicants are required to read, write, and speak the following languages***: English **Preferred Qualifications** The Fusion SCM Cloud Support Team is expanding to support our rapidly increasing customer base. The team partners with development in supporting new and existing customers. It is a unique opportunity to...

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

  • Intern/Co-op Functional Support Analyst

    4 weeks ago

    Mississauga, Canada Oracle Full time

    Intern/Co-op - Functional Support Analyst (ERP) – Fall Term (September – December 2024) Do you have an educational background in business?  Are you looking to gain first-hand experience to interact with business customers and develop your client relations skills?  Do you aspire to explore a career in tech and help customers leverage technology to...

  • NetSuite Technical Support Analyst

    2 weeks ago

    Mississauga, Ontario, Canada Oracle Full time

    Preferred Qualifications: Bachelor's/College Degree in Computer Science/Information Technology or equivalent, 0-2 Years of Experience Language Proficiency in English is crucial Experience working with Single Sign-On, , JQuery and/or Bootstrap is a plus Solid understanding on Java, C#, .NET, PHP or other programming language would be helpful ...

  • NetSuite Technical Support Analyst

    4 weeks ago

    Mississauga, Canada Oracle Full time

    Preferred Qualifications: Bachelor's/College Degree in Computer Science/Information Technology or equivalent, 0-2 Years of Experience  Language Proficiency in English is crucial Experience working with Single Sign-On, , JQuery and/or Bootstrap is a plus Solid understanding on Java, C#, .NET, PHP or other programming language would be helpful ...

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

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

  • Oracle Database Architecture with Delivery

    1 week ago

    Mississauga, Canada Epsilon Solutions Full time

    **Job Title: Oracle Database Architecture With Delivery Frameworks (TOGAF, eTOM, ITIL, CoBiT, etc)** **Location: MISSISSAUGA, ON** **Duration : Full Time** **Job duties/accountabilities** - Responsible for providing leadership and design initiatives for the creation of technology solutions. - Develops architecture and integration to support medium and...

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

  • NACI, Cloud Account Manager

    3 weeks ago

    Mississauga, Canada Oracle Full time

    Oracle is a fast-paced, collaborative environment passionate about crafting customer success. We offer the most comprehensive, cloud-based technology. At Oracle, learning is constant. We develop our workforce through training, mentoring and internal mobility opportunities to help everyone succeed and achieve their aspirations. Join us in identifying,...

  • NACI, Cloud Account Manager

    2 weeks ago

    Mississauga, Ontario, Canada Oracle Full time

    Oracle is a fast-paced, collaborative environment passionate about crafting customer success. We offer the most comprehensive, cloud-based technology. At Oracle, learning is constant. We develop our workforce through training, mentoring and internal mobility opportunities to help everyone succeed and achieve their aspirations. Join us in identifying,...

  • Oracle Dba

    2 weeks ago

    Mississauga, Ontario, Canada Cognizant Full time

    We are seeking a passionate, high energy, Oracle DBA. Our strength is built on our ability to work together. Our diverse set of backgrounds offer different perspectives and new ways of thinking. It encourages lively discussions, inspires thought leadership, and helps us build better solutions for our people and clients. We are looking for someone who thrives...

  • Oracle Dba Admin

    5 days ago

    Mississauga, Canada Arisoft Inc Full time

    **Job Title: Oracle DBA Admin** **Location: Mississauga, ON (Hybrid, 2 days onsite)** **Top 3 Required Skills**: 1. Strong knowledge of SQL and PL/SQL programming languages 2. stored procedures, functions, triggers, and packages 3. Experience managing Oracle database performance and tuning SQL queries for optimal efficiency **Requirements**: - 7+ years of...

  • Oracle Dba Admin

    2 weeks ago

    Mississauga, Ontario, Canada Arisoft Inc Full time

    Job Title: Oracle DBA AdminLocation: Mississauga, ON (Hybrid, 2 days onsite)Top 3 Required Skills:Strong knowledge of SQL and PL/SQL programming languages2. stored procedures, functions, triggers, and packagesExperience managing Oracle database performance and tuning SQL queries for optimal efficiencyRequirements: 7+ years of experience as an Oracle Database...

  • Oracle Developer with Java

    3 weeks ago

    Mississauga, Canada Atikatechnologies Full time

    Position: Oracle DeveloperLocation: Mississauga, Canada Onsite PL SQL L3 support role. Core Java is required7+ years of working experience with Oracle PL/SQL. Experience developing database applications in PL/SQL-Triggers, Packages, Functions, Procedures, Complex SQL, Oracle Collection, Object Type

  • Oracle Developer with Java

    2 weeks ago

    Mississauga, Ontario, Canada Atikatechnologies Full time

    Position: Oracle DeveloperLocation: Mississauga, CanadaOnsite PL SQL L3 support role. Core Java is required7+ years of working experience with Oracle PL/SQL.Experience developing database applications in PL/SQL-Triggers, Packages, Functions, Procedures, Complex SQL, Oracle Collection, Object Types knowledge and experience.SQL Query tuning using different...

  • Oracle Developer with Java

    3 weeks ago

    Mississauga, Canada Atikatechnologies Full time

    Position: Oracle DeveloperLocation: Mississauga, CanadaOnsite PL SQL L3 support role. Core Java is required7+ years of working experience with Oracle PL/SQL.Experience developing database applications in PL/SQL-Triggers, Packages, Functions, Procedures, Complex SQL, Oracle Collection, Object Types knowledge and experience.SQL Query tuning using different...

  • Oracle Developer with Java

    3 weeks ago

    Mississauga, Canada Atikatechnologies Full time

    Position: Oracle DeveloperLocation: Mississauga, CanadaOnsite PL SQL L3 support role. Core Java is required7+ years of working experience with Oracle PL/SQL.Experience developing database applications in PL/SQL-Triggers, Packages, Functions, Procedures, Complex SQL, Oracle Collection, Object Types knowledge and experience.SQL Query tuning using different...