Jobs
>
Toronto

    Oracle Apex Developer - Toronto, Canada - HCLTech

    HCLTech
    Default job background
    Technology / Internet
    Description

    Role: Senior Oracle Apex Developer

    Location: Ontario. Canada

    Remote -

    JOB SUMMARY

    We are seeking a highly skilled and experienced Senior Oracle Developer to join our dynamic IT team. The successful candidate will be responsible for designing, developing, and maintaining Oracle database solutions to support our organization's critical business applications. The Senior Oracle Developer will collaborate with cross-functional teams to analyze requirements, design efficient database structures, write complex SQL queries, optimize performance, and ensure data integrity. This role requires strong technical expertise in Oracle database development, excellent problem-solving skills, and the ability to work independently as well as part of a team.

    JOB RESPONSIBILITIES

    · Design, develop, and maintain Oracle APEX application to meet business requirements

    · Collaborate with business analysts and stakeholders to understand application requirements and translate them into efficient database designs.

    · Write complex SQL queries, stored procedures, functions, triggers, and packages to implement business logic. Optimize database performance by analyzing query execution plans, indexing strategies, and tuning SQL statements.

    · Ensure data integrity and security by implementing appropriate data validation rules and access controls.

    · Perform database migrations, upgrades, and patching as required.

    · Develop and maintain technical documentation including data models, schema diagrams, and standard operating procedures.

    · Stay up-to-date with the latest Oracle technologies and best practices

    · Review and validate solution design and ensure it covers all the technical aspects

    · Coordinate with the offshore teams on the development activities and participate in solution design discussions

    Other Responsibilities:

    · Perform other work-related duties as assigned. Participates as a member of a high-performance team for targeted / strategic initiatives. Attends training or learning opportunities to broaden knowledge.

    · Work on internal and external demos for various project POC's

    · Work closely with Azure data bricks team to get the necessary attributes for data scientists for their data modelling

    · Work with data analysts to analyze and locate the correct data for data modelling purposes

    · Test Applications as needed and work with the test leads to analyze /address issues

    · Overseeing daily technical operations

    · Coordinating with the software development team in addressing technical debt

    Qualifications

    Proven work experience as an Oracle APEX Developer or similar role.

    · Implementing Rest webservices to Fetch and push data

    · Experience dealing with large data and developing complex application and have understanding creating data model, DDL and also using Oracle Database 19c

    · Evaluate and validate solution interfaces, integration points and dependencies

    · Liaising with the engineering team for project completion

    · Reviewing ongoing operations and rectifying any issues

    · Understanding project requirements and developing detailed structure

    · Implementing best practices and coding standards

    · Proficiency in performance tuning techniques and query optimization

    Technologies: Oracle APEX, API's, Workflows, Lists, Microsoft Azure, Databricks, Oracle Apex, SQL, PL/SQL, Node JS, Javascript, CSS, HTML, JQUERY and AJAX

    Preferred Qualifications:

    · Oracle Certified Professional (OCP) certification.

    · Experience with Oracle Application Express (APEX).

    · Knowledge of data warehousing concepts and ETL processes.

    · Familiarity with healthcare or clinical research industry.

    · GxP, Life Science domain knowledge, Clinical Trials



  • LRI Invest S.A. Toronto, Canada

    Location: Toronto, ON, Canada · Date Posted: Mar 15, 2023 · **Description** · - The Apex Group was established in Bermuda in 2003 and is now one of the world's largest fund administration and middle office solutions providers. Apex has continually improved and evolved its product ...


  • Breakthru Beverage Group Toronto, Canada

    Overview: · **Purpose**: · This Portfolio Manager-Contract role will be at the heart of collaborating with suppliers and key internal and external stakeholders to create and execute plans and promotions that lead to market share growth. · **Department: Apex Portfolio** · **Report ...


  • Compest Solutions Inc Toronto, Canada

    Minimum of 3+ years of experience in Salesforce Loyalty Management development and implementation · Experience and knowledge in Salesforce Loyalty Management various modules such as Core Data Model, DPE, Apex coding, Transaction Journal · Strong experience in Salesforce Loyalty M ...


  • Merican Inc Toronto, Canada

    Merican Inc. is a staffing firm that offers recruitment solutions to large clients across the United States. · Job Role: Salesforce Tech Lead · Location: Remote (PST Timezone) · Type: Contract · - Minimum 8+ years of Salesforce projects execution with at least 3+ years in lead ro ...


  • AstraNorth Toronto, Canada

    **Responsibilities**: · - Design PDD and BRD's for the requirements · - Analyze the code and work with Developers for customized solutions within the Salesforce platform. · - Minimum 5 years Experience in Salesforce Financial Services Cloud. · - Troubleshooting and fixing bugs wi ...


  • LRI Invest S.A. Toronto, Canada

    Location: Toronto, ON, Canada · Date Posted: Mar 15, 2023 · **Description** · - The Apex Group was established in Bermuda in 2003 and is now one of the world's largest fund administration and middle office solutions providers. Apex has continually improved and evolved its product ...


  • Apex Clearing Toronto, Canada

    Apex Fintech Solutions (AFS) powers innovation and the future of digital wealth management by processing millions of transactions daily, to simplify, automate, and facilitate access to financial markets for all. Our robust suite of fintech solutions enables us to support clients ...


  • Peak6 Toronto, Canada

    Apex Fintech Solutions (AFS) powers innovation and the future of digital wealth management by processing millions of transactions daily, to simplify, automate, and facilitate access to financial markets for all. Our robust suite of fintech solutions enables us to support clients ...

  • Electronic Arts

    Technical Artist

    1 week ago


    Electronic Arts Toronto, Canada

    **Technical Artist - Rigging ( EA Create : Rigging ) - Temporary**: · **EA Create**: · EA Create is a collective of content production teams partnering with EA Studios game teams to bring outstanding visuals, audio and technology to life. Our teams consist of artists, engineers, ...


  • OTT Financial Group Toronto, Canada

    OTT Financial Group is the parent organization of a group of financial services and investment companies. We leverage cutting-edge fintech innovations to bring excellent financial advice and best-in-class wealth management to our customers and business partners. Empowering 5,000+ ...


  • Aliant Resources Toronto, Canada

    **Posting Status**:Upcoming Jobs with University · **Organization**: Aliant Resources · **Location**: Toronto · **Position**:CRM SOLUTIONS SUPPORT ASSISTANT*** · **Job Category**: Information Technology / Telecom*** · **Total Weekly Hours of Work**:24 hours(as per schedule) · **C ...


  • Canada Life Assurance Company Toronto, Canada

    **Job Description**: · As a Lead, Application Security within the Canada Life Information Security Department, you will be responsible for the security posture of the products your team supports. You will grow your team through hiring, develop the team through coaching, act as a ...


  • Royal Bank of Canada Toronto, Canada

    **Come Work with Us** · At RBC, our culture is deeply supportive and rich in opportunity and reward. You will help our clients thrive and our communities prosper, empowered by a spirit of shared purpose. · Whether you're helping clients find new opportunities, developing new tech ...


  • Drake Hotel Properties Toronto, Canada

    The Drake is a growing Canadian hospitality brand focused on lifestyle hotels, food + drink and special events. We wholeheartedly believe that culture and community are the apex of our purpose and are passionate about revitalizing character properties as inclusive hubs for unique ...

  • Tata Consultancy Services

    Salesforce Lead

    1 week ago


    Tata Consultancy Services Toronto, Canada

    **About TCS** · TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide t ...

  • Starcom

    Media Planner

    23 hours ago


    Starcom Toronto, Canada

    Company Description · We are the Human Experience Company · We know brands will only thrive if they anticipate people's desires. We create experiences people love and actions brands need. We are stronger because our commitment to human outcomes is proven to drive better business ...


  • University of Toronto Toronto, Canada

    **Date Posted**:08/04/2023 · **Req ID**: 33268 · **Faculty/Division**: Ofc of the Chief Information Officer · **Department**: Enterprise Apps & Solutions Integration · **Campus**: St. George (Downtown Toronto) · **Position Number**: · **Description**: · **About us**: · **Your op ...

  • Canada Life Assurance Company

    Penetration Tester

    1 day ago


    Canada Life Assurance Company Toronto, Canada

    **Job Description**: · As a Penetration Tester within the Canada Life Information Security Department, you will be responsible for driving our **Offensive Security** initiatives. You will be both hands-on technical and influential, where you will be expected to directly communica ...


  • SkipTheDishes Toronto, Canada

    **Description**: · We have something other delivery apps don't have: exclusive partnerships with some of the largest and most popular restaurants in Canada. More and more brands each day, both independent and national chains, choose to deliver with Skip. With your passion for bui ...


  • Altair Engineering Toronto, Canada

    **Transforming the Future with the Convergence of Simulation and Data** · **We are looking for our next** **Salesforce** **Administrator** · ***_Job Summary:_** · ***_What You Will Do:_** · - Maintain user roles and profiles, permission sets, security settings, sharing rules, etc ...