Senior Oracle DB/BI Developer

6 days ago


Toronto, Ontario, Canada City of Toronto Full time
Job Summary

We are seeking a highly skilled Systems Integrator 1 to join our team at the City of Toronto. As a key member of our Information Technology department, you will be responsible for analyzing and developing standard and ad hoc/BI reports using Oracle tools.

Main Responsibilities
  • Establish and maintain business relationships with clients to discuss and assess their needs.
  • Prepare project charters, statements of work, and project plans.
  • Identify risks and prepare action plans to mitigate.
  • Conduct or lead teams in the delivery of projects or work packages.
  • Liaise and coordinate with internal and external groups on the accomplishment of deliverables.
  • Prepare and present status reports and variance explanations for projects or work packages.
  • Prepare findings and 'Lessons Learned' from post-implementation project reviews.
  • Assess, analyze, evaluate, and recommend process and policy alternatives for projects and work packages.
  • Redesign business principles, processes, policies, and standards by recommending best practices and improvements to current processes.
  • Determine business requirements and build consensus among clients.
  • Prepare business plans, gap analyses, logical data models, and design documents for proposed solutions that leverage information and technology.
  • Provide input to data management teams on the transformation of clients' business requirements.
  • Recommend improvements to current methodology, process, standards, and policies.
  • Assist staff in understanding business processes and logic.
  • Liaise with staff in the development of test strategies, test cases, and test scripts for system, performance, usability, and acceptance testing of system solutions developed.
  • Lead teams to draft implementation and rollout strategies, and plans, and conduct walk-throughs of deliverables to identify potential problems.
  • Prepare training material and documentation for use by clients and staff, and conduct training for clients and their staff.
  • Collaborate with clients on 'Go/No Go' cut-over decisions, such as roll-outs.
Key Qualifications
  • Post-secondary education in computer science or a related discipline, or the equivalent combination of education and/or experience.
  • Considerable experience in Oracle database development, including SQL and PL/SQL (Oracle 19c), data/object modeling, data normalization, ETL processes, application performance optimization, and experience in a high-availability, clustered environment.
  • Considerable experience in data analysis, using SQL and Oracle PL/SQL coding techniques to extract and report upon information, business trends, insights, and metrics from data stored in the database.
  • Considerable experience in large-scale enterprise IT database solutions (both OLTP and OLAP) and sustainment, implementing systems and solutions, and resolving technical, design, and performance issues.
  • Considerable experience in data mining, data analytics, and data visualization, designing and converting reports using industry-standard BI tools such as Tableau, JasperSoft, or equivalent.
Additional Requirements
  • Knowledge of Oracle APEX to develop and sustain medium to large-scale systems.
  • Ability to lead projects or teams in all phases of the project or system development life cycle, using software development and project management methodologies to ensure deliverables are met.
  • Ability to work with competing demands, prioritizing and meeting deadlines.
  • Ability to work effectively with a group of multidisciplinary staff in a project team setting.
  • Ability to effectively communicate both orally and in writing.
  • Strong analytical and problem-solving skills, listening and interacting skills are essential.
  • Strong customer service orientation.
  • Understanding of application deployment approaches and standard dev-QA-Production cycles.
  • Understanding of privacy, security, and auditing, and how these can be reviewed, monitored, and enhanced with regards to systems implementation.


  • Old Toronto, Ontario, Canada City of Toronto Full time

    Job Title: Senior Oracle DB/BI DeveloperJoin the City of Toronto's team as a Senior Oracle DB/BI Developer and play a key role in analyzing and developing standard and ad hoc/BI reports using Oracle tools. We are looking for your expertise and advice related to the development, implementation, configuration, and sustainment of the Toronto Shelter and Support...


  • Old Toronto, Ontario, Canada City of Toronto Full time

    Job Title: Senior Oracle DB/BI DeveloperJoin the City of Toronto's team as a Senior Oracle DB/BI Developer and play a key role in analyzing and developing standard and ad hoc/BI reports using Oracle tools. We are looking for your expertise and advice related to the development, implementation, configuration, and sustainment of the Toronto Shelter and Support...


  • Toronto, Ontario, Canada Oracle Full time

    Job SummaryWe are seeking an experienced PeopleSoft Techno-Functional Analyst to join our Support organization at Oracle. As a member of our team, you will be responsible for delivering Techno-Functional Support to our Oracle customer base while serving as an advocate for customer needs.Key ResponsibilitiesAct as a main point of contact for customers,...


  • Toronto, Ontario, Canada Oracle Full time

    Job SummaryWe are seeking an experienced PeopleSoft Techno-Functional Analyst to join our Support organization at Oracle. As a member of our team, you will be responsible for delivering Techno-Functional Support to our Oracle customer base while serving as an advocate for customer needs.Key ResponsibilitiesAct as a main point of contact for customers,...


  • Toronto, Ontario, Canada Capleo Global Full time

    Job Title: Senior DBACapleo Global is seeking a highly skilled Senior Database Administrator (DBA) to join our team. As a Senior DBA, you will be responsible for designing, implementing, and maintaining our Oracle database infrastructure.Key Responsibilities:Design and implement Oracle database solutions to meet business requirementsDevelop and maintain...


  • Toronto, Ontario, Canada Capleo Global Full time

    Job Title: Senior DBACapleo Global is seeking a highly skilled Senior Database Administrator (DBA) to join our team. As a Senior DBA, you will be responsible for designing, implementing, and maintaining our Oracle database infrastructure.Key Responsibilities:Design and implement Oracle database solutions to meet business requirementsDevelop and maintain...


  • Toronto, Ontario, Canada Capleo Global Full time

    Job Title: Senior Full Stack DeveloperCapleo Global is seeking a highly skilled Senior Full Stack Developer to join our team.Job Summary:We are looking for a seasoned developer with 10+ years of experience in Java, J2EE, JSF, Hibernate, Oracle DB, and MySQL. The ideal candidate will have a strong background in supporting and maintaining large, complex legacy...


  • Toronto, Ontario, Canada Capleo Global Full time

    Job Title: Senior Full Stack DeveloperCapleo Global is seeking a highly skilled Senior Full Stack Developer to join our team.Job Summary:We are looking for a seasoned developer with 10+ years of experience in Java, J2EE, JSF, Hibernate, Oracle DB, and MySQL. The ideal candidate will have a strong background in supporting and maintaining large, complex legacy...


  • Toronto, Ontario, Canada Capleo Global Full time

    Job Description**Job Title:** Senior Full Stack Developer**Job Summary:** We are seeking a highly skilled Senior Full Stack Developer to join our team at Capleo Global. As a Senior Full Stack Developer, you will be responsible for designing, developing, and maintaining large-scale, complex applications using Java, J2EE, JSF, Hibernate, Oracle DB, and...


  • Toronto, Ontario, Canada Capleo Global Full time

    Job Description**Job Title:** Senior Full Stack Developer**Job Summary:** We are seeking a highly skilled Senior Full Stack Developer to join our team at Capleo Global. As a Senior Full Stack Developer, you will be responsible for designing, developing, and maintaining large-scale, complex applications using Java, J2EE, JSF, Hibernate, Oracle DB, and...


  • Toronto, Ontario, Canada Capleo Global Full time

    Job Title: Senior Full Stack DeveloperWe are seeking a highly skilled Senior Full Stack Developer to join our team at Capleo Global. As a key member of our development team, you will be responsible for designing, developing, and maintaining complex software systems using Java, Oracle DB, and MySQL.Key Responsibilities:Design and develop large-scale software...


  • Toronto, Ontario, Canada Capleo Global Full time

    Job Title: Senior Full Stack DeveloperWe are seeking a highly skilled Senior Full Stack Developer to join our team at Capleo Global. As a key member of our development team, you will be responsible for designing, developing, and maintaining complex software systems using Java, Oracle DB, and MySQL.Key Responsibilities:Design and develop large-scale software...


  • Toronto, Ontario, Canada S.i. Systèmes Full time

    S.i. Systèmes Seeks Experienced Oracle EBS HCM ExpertWe are looking for a highly skilled Senior Oracle EBS HCM Techno-Functional Consultant to join our team. As a key member of our team, you will be responsible for designing, developing, testing, and implementing solutions within the Oracle EBS environment.Key Responsibilities:Design, develop, test, and...


  • Toronto, Ontario, Canada S.i. Systèmes Full time

    S.i. Systèmes Seeks Experienced Oracle EBS HCM ExpertWe are looking for a highly skilled Senior Oracle EBS HCM Techno-Functional Consultant to join our team. As a key member of our team, you will be responsible for designing, developing, testing, and implementing solutions within the Oracle EBS environment.Key Responsibilities:Design, develop, test, and...


  • Old Toronto, Ontario, Canada BeachHead Inc. Full time

    Senior Power BI Developer OpportunityWe are seeking a highly skilled Senior Power BI Developer to join our team at BeachHead Inc. as part of our currency initiative. The successful candidate will be responsible for converting SportFire reports to Power BI, re-engineering reports to enhance performance and usability, and collaborating with team members using...


  • Old Toronto, Ontario, Canada BeachHead Inc. Full time

    Senior Power BI Developer OpportunityWe are seeking a highly skilled Senior Power BI Developer to join our team at BeachHead Inc. as part of our currency initiative. The successful candidate will be responsible for converting SportFire reports to Power BI, re-engineering reports to enhance performance and usability, and collaborating with team members using...


  • Toronto, Ontario, Canada Capleo Global Full time

    Capleo Global is seeking a seasoned Senior DBA to lead our database administration efforts. As a key member of our team, you will be responsible for designing, implementing, and maintaining our Oracle database infrastructure. Your expertise in Oracle 12c and 19c, including multi-tenant architecture, RAC Grid infrastructure, and ASM, will be instrumental in...


  • Toronto, Ontario, Canada Capleo Global Full time

    Capleo Global is seeking a seasoned Senior DBA to lead our database administration efforts. As a key member of our team, you will be responsible for designing, implementing, and maintaining our Oracle database infrastructure. Your expertise in Oracle 12c and 19c, including multi-tenant architecture, RAC Grid infrastructure, and ASM, will be instrumental in...


  • Old Toronto, Ontario, Canada Bevertec CST Inc. Full time

    Software Developer - Senior - PowerBI, ETLWe are seeking a highly skilled Senior Software Developer to join our team at Bevertec CST Inc. in Toronto, ON. This is a 6-month contract position, requiring 3 days of onsite work per week.Key Responsibilities:Design and develop interactive reports and dashboards using Power BI, including data modeling and advanced...


  • Old Toronto, Ontario, Canada Bevertec CST Inc. Full time

    Software Developer - Senior - PowerBI, ETLWe are seeking a highly skilled Senior Software Developer to join our team at Bevertec CST Inc. in Toronto, ON. This is a 6-month contract position, requiring 3 days of onsite work per week.Key Responsibilities:Design and develop interactive reports and dashboards using Power BI, including data modeling and advanced...