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
Shape the future of cloud computing as a Senior Oracle DBA.Spearhead critical Oracle database management and cloud migrations to enhance operational efficiency in a fully remote role.In this strate...Voir plus
Become a vital Oracle DBA and Infrastructure Engineer driving sophisticated cloud solutions.Manage comprehensive database systems while working entirely remote.In this pivotal role, you'll lead the...Voir plus
Avanciers Incorporated is hiring a.Business Systems Analyst – Mainframe.Job Title: Business Systems Analyst – Mainframe.Job Location: Toronto, ON Hybrid (3–4 days onsite).Compensation Range: $100,0...Voir plus
Job Description - Oracle SQL Developer (CREQ254850).Oracle SQL Developer - ( CREQ254850 ).With End to end development life cycles and UI development skills.Design, Development and Unit testing.Opti...Voir plus
Explore a pivotal role as a Database Analyst focusing on data management solutions.Drive the design and development of database architectures in both public and private sectors.As a key player in i...Voir plus
We are on the lookout for a Mid Level Oracle DBA experienced in BRM/ECE support.This remote opportunity requires proficiency in key Oracle technologies, focusing on ensuring database performance an...Voir plus
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...Voir plus
Iris's direct client, one of the leading Banking and Financial Company, is looking to hire a.Job Title: Sr Business Analyst (Portfolio Management).Location: Downtown Toronto, ON (Hybrid).Experience...Voir plus
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...Voir plus
A leading health benefits manager in Mississauga is seeking a highly experienced Senior Database Administrator to join their Production Operations team.The ideal candidate will have over 10 years o...Voir plus
Head of Oracle Technologies at Next Ventures.Our client is seeking a highly experienced.Oracle Cloud ERP and Database Expert.This role requires deep expertise across Oracle technologies, cloud plat...Voir plus
At Pythian, we are experts in strategic database and analytics services, driving digital transformation and operational excellence.Founded in 1997, we quickly earned a reputation for solving tough ...Voir plus
We are looking for an experienced.Our client is a large fintech firm with a product that you've likely used many times before.You'll have the opportunity to work on an extremely large, internationa...Voir plus
New Value Solutions, a national IT consulting company, is building a team to support a major public sector client in delivering mission-critical database services across a complex enterprise enviro...Voir plus
Location : Toronto, ON(Hybrid).Database Development: Design and implement database objects including tables, views, indexes, and sequences.Write and maintain complex PL/SQL packages, stored procedu...Voir plus
Lead a talented database team while managing operations and staying deeply connected with technology.Embrace a flexible work setup that encourages innovation and accountability.As the Team Lead for...Voir plus
Enhance database performance as an Oracle Database Optimization Specialist.Lead migrations to AWS while maximizing data integrity and system efficiency in a remote work environment.With 7+ years of...Voir plus
Une société de technologie recherche un Analyste en administration de bases de données pour rejoindre son équipe de Montréal.Le poste est en télétravail complet et exige plus de 5 années d'expérien...Voir plus
