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
CAA Club Group seeks a Marketing Database Analyst to enhance marketing strategies through data insights with expertise in SAS and SQL.Shape the future of marketing performance.This senior analytics... Show more
A premier IT staffing and consulting organization in Canada is seeking a Mainframe Architect for a long-term contract role.The successful candidate will design and implement application development... Show more
A consulting firm is seeking an Oracle Financials Lead for a 6-month contract, primarily remote, based in Canada.The role involves leading Oracle Financials implementations and functioning as the p... Show more
A leading machinery manufacturing company is seeking a Programmer Analyst to support their corporate IT team.This hybrid role focuses on designing, developing, and maintaining customized ERP system... 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
Senior Recruitment Specialist at LeverageTek Staffing Solutions.LeverageTek is actively seeking an.Lead the end-to-end project to align Oracle implementation with US Government FAR compliance.Desig... Show more
A leading technology solutions provider is seeking a Senior Solutions Architect specializing in Databricks and AWS.This fully remote role requires 8+ years of experience, where you'll lead the desi... Show more
US IT Recruitment Executive @ Signature IT World Inc | IT Recruitment, Apex Programming.Looking for a Tech BA to work on Derivatives and Fixed Income new products onboarding.OTC derivatives IRD, FX... Show more
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... Show more
Become a Senior Application Support Analyst with a strong focus on COBOL and AS400 at our dynamic Mississauga location.This full-time hybrid position is designed for individuals ready to tackle com... Show more
Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Rivago Infotech Inc.Location : Remote, (Open for Canada only).The DBA position will be responsible f... Show more
Enterprise Data Platform Analyst.Reporting to the Manager, Content and Collaboration Services (CCS), the Application Analyst’s primary role will be responsible for providing technical support, trou... Show more
Be among the first 25 applicants.Direct message the job poster from Themesoft Inc.IT solutions provider and a Woman‑Owned Minority Business Enterprise headquartered in Dallas, TX.With a strong pres... Show more
A leading enterprise software firm is seeking a Technical Solutions Developer to design, build, and enhance database-driven solutions.The ideal candidate should have 3-5 years of experience in Orac... Show more
This range is provided by ArcLight Consulting.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.ArcLight Consulting, an Addison Group Company, is ... Show more
The ideal candidate will require a foundational knowledge of Data Governance practices as well as Data Quality principles, along with a practical knowledge of how to evaluate existing controls, ide... Show more
A tech solutions provider in Canada is seeking an Oracle Database Administrator to maximize value for clients through effective database management.The role entails optimizing internal and client d... Show more
Our Vaughan client is need of an Oracle Fusion/Cloud Administrator for a permanent role.This is a hybrid role, 3 days a week in office.The Application Administrator role is to support the Global IT... Show more
Role: Oracle performance tuning expert.BGV will be done for the selected candidates.Provide expertise on performance tuning, Oracle GoldenGate, and the ability to configure GoldenGate and troublesh... Show more
Reporting to the appropriate business or IT leader, the Business Systems Analyst – Order to Cash is a member of the HSS Business Solutions JD Edwards EnterpriseOne team.The successful candidate wil... Show more
