Oracle Database Analyst

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