Talent.com
Macpower Digital Assets Edge Private Limited
Principal Oracle Database Architect (OCM)Macpower Digital Assets Edge Private Limited • Toronto, ON
Principal Oracle Database Architect (OCM)

Principal Oracle Database Architect (OCM)

Macpower Digital Assets Edge Private Limited • Toronto, ON
7 hours ago
Job type
  • Full-time
Job description
Job Summary:
  • As a Principal Oracle Database Architect you will be part of the Administrative Applications Production Data Services team and will be working on the development and implementation of modifications and enhancements to the Financial Data Warehouse.
  • This position will perform the duties of database development will perform advanced database development tasks for databases used by an application with complex data models, workflows, and reports.
  • Enters codes to create production database.
  • Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory.
  • Directs programmers and analysts to make changes to database management system. Reviews and corrects programs.
  • Confers with coworkers to determine impact of database changes on other systems and staff cost for making changes to database.
  • Modifies data base programs to increase processing performance, referred to as performance tuning.
  • Workers typically specialize in one or more types of database management systems.
  • Providing assistance in the planning, development, maintenance, and monitoring of integrated database systems, and ensuring that the conceptual and design phases of new applications are consistent with the structural parameters within the database environment.
  • Evaluates users; requests for new data elements and systems, incorporates them into the existing shared data environment, and provides technical assistance.
  • Coordinates the use of data to ensure data integrity and control redundancy, loads databases, and reorganizes as needed. Performs data modeling and prototyping.
  • Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models. Performs security recovery procedures.
  • Determines and implements database search strategies and storage requirements.
  • Maintains data dictionary ensuring uniformity of definitions and sets standards for use of data dictionary.
  • Monitors database performance and recommends efficiency improvements.
  • Creates test database environment for applications section, including the creation of necessary libraries and procedures.
  • Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures.
  • Assists with determining, implementing, and enhancing standards on database security and with monitoring agency disaster recovery procedures and systems.
  • Assists with the installation of database software and with analyzing, designing, and implementing databases.
  • Assists in benchmarking and threshold testing of databases and with establishing and controlling necessary database security.
  • Assists in the selection of database management software.
  • Experience in computer systems analysis or computer programming work.
  • Knowledge of the principles, practices, and techniques of computer programming and systems design; of computer operations, systems, and procedures; of project control and cost estimating techniques; of computer programming languages; of data processing flowcharting techniques; of database structures and theories; and of current database technologies.
  • Has working knowledge of EIR Accessibility standards and assistive technologies.
  • Ensures that user interfaces for database administration and inputting, viewing, outputting data (via reports) are compliant with accessibility standards.
  • Provides support to users in obtaining data/information when EIR Accessibility issues arise.
Responsibilities:
  • The role will involve working with Oracle databases.
  • May be required to create new logical and physical data models.
  • The candidate will optimize database performance during and after migration, identify and resolve performance bottlenecks, and implement monitoring solutions to track database health and performance metrics.
  • This position will develop new views, tables and PL/SQL code to be used by the customer of the Financial Data Warehouse application.
  • Will work on activities including, but not limited to the design, development, and testing of new tables, views, PL/SQL stored procedures and functions, and necessary loaders to support the project news.
  • Will develop and test Linux shell scripts to invoke database calls.
  • Will develop and test scheduled jobs and shell scripts.
  • May perform performance tuning of new and existing tables, views, PL/SQL code.
  • The role will involve working closely with the team to create and maintain logical and physical data models, with a primary focus on Oracle. This role will require knowledge of Oracle Stored Procedures and Functions.
Years Required/Preferred Experience:
  • 10 Required Experience in Oracle database design, analysis, and performance tuning
  • 10 Required Experience in Oracle database structures and data analysis
  • 10 Required Experience designing enterprise applications and/or services
  • 10 Required Experience creating technical and functional design documentation
  • 10 Required Experience within software development lifecycle using Agile methodology – (Scrum, for example)
  • 6 Required Experience with multi-tier system/application development – (SOA, Microservices, 3-Tier applications, for example)
  • 1 Preferred Jira experience
  • 1 Preferred Oracle Certification
  • 1 Preferred Experience with data warehouse applications and/or database reporting features.
Create a job alert for this search

Principal Oracle Database Architect (OCM) • Toronto, ON

Similar jobs

Oracle DBA / OCAC

BULL-IT SOLUTIONS LTDToronto, ON, CA
Full-time

Oracle 19c db version Candidate should have 3-5 years of experience working on OCAC ( Oracle Cloud At Customer) and Oracle Exadata including a full understanding of its architecture Candidate shoul... Show more

 • Promoted

Oracle DBA: HA & Performance Specialist

Saransh IncToronto
Full-time

A leading technology company located in Toronto is looking for an experienced database administrator focused on Oracle databases.The role involves installing, configuring, and upgrading Oracle data... Show more

 • Promoted

Principal Architect III, FSI, Google Cloud

Google Inc.toronto, on, Canada
Full-time

Principal Architect III, FSI, Google Cloud.The Google Cloud Platform team helps customers transform and build what’s next for their business — all with technology built in the cloud.Our products ar... Show more

 • Promoted

Senior Database Architect / Developer (MSSQL)

CI FinancialToronto, ON, CA
Full-time

Senior Database Architect / Developer (MSSQL).Senior Database Architect / Developer (MSSQL).At CI, we see a great place to work as one that is a safe place for everyone to have a voice, where peopl... Show more

 • Promoted

Senior Oracle DBA: Exadata, RAC & Cloud (Contract)

BuzzClanToronto, ON, CA
Full-time

A leading IT consulting firm in Toronto is seeking a Senior Database Administrator with extensive experience in Oracle DB for a long-term contract.This role demands expertise in complex database ma... Show more

 • Promoted

Senior Dba For Oracle Systems At Tangerine

Tangerine BankToronto, Canada
Full-time

Drive database efficiency and reliability as a Senior Oracle Database Administrator at Tangerine in Toronto, Ontario.Oversee database architecture while enhancing system performance and data availa... Show more

 • Promoted

Principal Architect, Azure Solutions

TTEC Digitaltoronto, on, Canada
Full-time

At TTEC Digital, we coach clients to ensure their employees feel valued, and fully supported, because an amazing customer experience is an employee first process.Our vision is the same, a place whe... Show more

 • Promoted

Senior Oracle Data & Cloud Integration Architect

Rubicon PathToronto
Full-time

A leading consulting firm in Toronto is seeking a Specialized IT Consultant to provide expert guidance on information technology solutions, focusing on Oracle database management and cloud integrat... Show more

 • Promoted

Oracle 11g DBA

ROSSmarkham, york region, Canada
Temporary

Our client is a medium sized software vendor.They are located in Markham and looking for an Oracle 11g DBA for a three month contract to ideally start immediately.Part of your work will be onsite a... Show more

 • Promoted

Oracle Database Administrator

Insight GlobalToronto, Ontario, Canada
Full-time +1

This range is provided by Insight Global.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Direct message the job poster from Insight Global.Regio... Show more

 • Promoted

Oracle/MS SQL Database Engineer – Performance

ScotiabankToronto, ON, CA
Full-time

A leading North American bank is seeking a Database Developer to maintain and optimize applications on Oracle and MS SQL databases.The ideal candidate will have 6-10 years of experience, strong ski... Show more

 • Promoted

Principal Enteprise Architect

Canadian-Tire-Corporation,-Ltd.-1toronto, on, Canada
Full-time

Reporting to the Associate Vice President, Enterprise Architecture, the Principal Enterprise Architect will play a key role in shaping the organization’s technology strategy, with a primary focus o... Show more

 • Promoted

Senior Data Architect: Oracle EBS & Cloud Integrations

Stantec Consulting International Ltd.markham, york region, Canada
Full-time

A leading consulting firm is seeking a Senior Data Architect to enhance and simplify collaboration between project managers and accountants through data integration and architecture.This role empha... Show more

 • Promoted

Senior DBA for Oracle Systems at Tangerine

Tangerine BankToronto
Full-time

Drive database efficiency and reliability as a Senior Oracle Database Administrator at Tangerine in Toronto, Ontario.Oversee database architecture while enhancing system performance and data availa... Show more

 • Promoted

Principal Solution Architect - Up To C$150,000 A Year

SynpulseNorth York, Canada
Full-time

Principal Solutions Architect to guide development teams in transforming digital customer journeys for financial institutions, applying agile principles and technical expertise. Show more

 • Promoted

Principal Solution Architect - Data

CDW Canadatoronto, on, Canada
Full-time

At CDW, we make it happen, together.Trust, connection, and commitment are at the heart of how we work together to deliver for our customers.It’s why we’re coworkers, not just employees.Coworkers wh... Show more

 • Promoted

Hybrid Toronto Senior Data Architect – Azure Lakehouse

Apex Systemstoronto, on, Canada
Full-time

A leading technology services firm is seeking a Senior Data Architect in Toronto.This hybrid role requires extensive experience in data architecture, management, and design.The ideal candidate will... Show more

 • Promoted

Senior Microsoft Azure and Databricks Architect

Adastra Corporationmarkham, on, Canada
Full-time +1

We are seeking a Senior Microsoft Azure & Databricks Architect to provide technical and sales leadership and evangelism across complex, enterprise-scale data, analytics, and AI modernization initia... Show more

 • Promoted

Senior Application Architect: Cloud & Oracle EBS Lead

StantecMarkham, York Region, CA
Full-time

A leading engineering firm is seeking a Senior Application Architect in Markham, Canada, to design and oversee software systems architecture.The role involves ensuring scalability, security, and in... Show more

 • Promoted

Oracle DBA - Canada

Saransh IncToronto, ON, CA
Full-time

Install, configure, and upgrade Oracle databases and related tools.Perform database administration tasks including backup, recovery, and disaster recovery planning.Monitor database performance and ... Show more