Oracle Database Analyst - Jobs in Mississauga

Job 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/19camp; 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