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
Oracle Database Analyst • Mississauga, Ontario, Canada
Duckcreek Billing Business Analyst.We at Coforge are hiring Duckcreek Billing Business Analyst with the following skillset :.Business Requirements & Documentation Gather, analyze, and document busi...Show more
Step into a Senior Business Analyst position, focusing on innovative solutions for a government client in the GTA.This hybrid role is perfect for professionals with a strong background in business ...Show more
A reputable technology services company in Peel Region, Mississauga is seeking a Database Administrator to provide technical support and ensure database integrity.Responsibilities include daily mai...Show more
Location: Toronto, 3 days in office.The Business Analyst is a critical lead in driving the end-to-end expense allocation lifecycle.In this role, you will design, maintain, and optimize Oracle EPCM/...Show more
Hiring: BSA – SailPoint | Brampton (Hybrid 2–3 Days Onsite).We are looking for an experienced.Business Systems Analyst (BSA).SailPoint IdentityIQ / IdentityNow.BSA/IAM Analyst in enterprise environ...Show more
Building the space between proven and possible, MDA Space (TSX:MDA) is a trusted mission partner to the global space industry.A robotics, satellite systems and geointelligence pioneer with a 55-yea...Show more
We are seeking a Business Analyst in Toronto, Montreal, or Halifax to support a critical migration initiative from FenE to FenX.This role is essential to meeting key project milestones and will foc...Show more
Become a key player in optimizing Oracle database performance as a tuning expert.Utilize your skills in Oracle GoldenGate and troubleshooting to enhance critical database systems.This role requires...Show more
Senior Business Systems Analyst.Contract Opportunity | Hybrid (2 days onsite per week).April 1, 2026 to September 1, 2026.We are seeking a highly analytical and technically strong Business Systems ...Show more
SAP Business Analyst SD/MM with SAP ECC and S4/HANA systems for a 3 month ONSITE in Toronto.TasksGather, analyze and challenge business requirementsPropose appropriate solutions and configure them ...Show more
Job Description:Production Monitoring and SupportExperience in Linux Shell commands & scriptingKnowledge in WebSphere Application server/console/configuration Knowledge in Apache Web server Hands...Show more
Oracle Solution Architect / Technical Lead (Onshore).Lead Oracle Cloud (SaaS/PaaS) implementations, integrations, and support.Design and develop integrations using Oracle Integration Cloud (OIC), R...Show more
Senior Business Systems Analyst – Capital Markets & Liquidity.Contract Length: End of October (high likelihood of extension - multi year project).Industry: Banking / Financial Services.Senior Busin...Show more
Role SummaryThe Business Systems Analyst will design, document, and support integrations between Salesforce and RBCs core banking systems, data platforms, and third-party applications.This role bri...Show more
Elevate your career as a Sales Database Associate specializing in SQL.Embrace a hybrid work model while leveraging your analytical skills to transform data for enhanced sales analytics.In this pivo...Show more
Role: Senior Business AnalystLocation: Must be based in Canada (available EST hours)Work Arrangement: Remote or hybrid options availableAb...Show more
Job Title:Senior Business Systems Analyst – Compensation & Claims Systems (Contract or Permanent | Canada | Remote)Job DescriptionWe are looking for an experience...Show more
The Product Specialist for Oracle EPM Cloud PBCS is responsible for overseeing and managing the implementation, customization, and support of the Oracle Enterprise Performance Management Cloud Plan...Show more
