Search jobs > Toronto, ON > Database developer

Oracle Database PL/SQL Developer

Tyler Technologies
Old Toronto, ON, Canada
$32-$37 an hour (estimated)
Full-time

Are you tired of managing databases and operational issues and want to focus more on solving problems and adding value through product development?

This position allows you to leverage all of your Oracle expertise to produce complex, highly optimized PL / SQL programs.

The ideal candidate would have a passion for developing great software in a highly collaborative agile team environment with a hunger to continuously learn, grow, and improve.

Note : This is a hybrid position that requires the individual to be in the North York office 3 days per week and work remotely 2 days.

Responsibilities

  • Take ownership of the maintenance and development of key database product components within including PL / SQL stored procedures, functions, triggers, packages, and complex analytical and financial reports
  • Analyze, design, and develop lean, secure, well-documented and testable code of moderate complexity using modern design techniques that conform to the requirements, established technical architecture, and industry best practices
  • Produce written test cases, unit tests, and integration tests and perform necessary application testing to ensure code quality and adherence to requirements
  • Collaborate with product managers, business analysts, developers, and QA in an Agile development process to ensure effective communication among all stakeholders
  • Troubleshoot software issues to determine root causes and provide solutions

Qualifications

  • BS / BA in computer science, computer engineering, math, or relevant coursework; or comparable work experience.
  • At least one year of experience in software development, including object-oriented design and programming.
  • 3-5 years of proven experience and deep knowledge of SQL, development of Oracle PL / SQL stored procedures and database performance optimization.

Equivalent experience with T-SQL may be considered.

  • Exposure to Oracle PL / SQL Collections, Bulking techniques, Analytical Functions, and other 12c functionality is highly desirable.
  • Experience with reporting tools such as Oracle Reports Builder or Oracle BI Publisher and SQL scripting. SQL Server Reporting Services (SSRS) experience is a plus.
  • Familiarity with any of the following is desirable :
  • ASP.NET, C#, JavaScript, Angular, Bootstrap, and CSS.
  • Web services and working with JSON and XML data payloads.
  • Excellent analytical, problem-solving, and communication skills.
  • Ability to work independently and as part of a team.

J-18808-Ljbffr

30+ days ago
Related jobs
Promoted
Iris Software Inc.
Toronto, Ontario

Associates of Iris work on mission-critical applications supported by a workplace culture that has won numerous awards in the last few years, including Certified Great Place to Work in India; Top 25 GPW in IT & IT-BPM; Ambition Box Best Place to Work, #3 in IT/ITES; and Top Workplace NJ-USA. Skills:...

Promoted
Tata Consultancy Services
Toronto, Ontario

PL SQL Knowledge, Package, Functions, Triggers, Views Autosys SQL / Stored Procedure Development. Supporting tools like JIRA Portal, Toad or SQL Developer. Participate in all aspects of software development, including design, implementation, deployment & beyond. TCS' proactive stance on climate chan...

Promoted
Iris Software Inc.
Toronto, Ontario

Java Full Stack Developer with PL/SQL @ Toronto ON. Title: Java Full Stack Developer with PL/SQL. Experience developing and deploying Cloud based applications. Please share your updated resume to nakka. ...

Tyler Technologies
Toronto, Ontario

Are you tired of managing databases and operational issues and want to focus more on solving problems and adding value through product development? This position allows you to leverage all of your Oracle expertise to produce complex, highly optimized PL/SQL programs. SQL, development of Oracle PL/SQ...

Intact Financial Corporation
Toronto, Ontario

The ideal candidate will be a fast learner with industry knowledge and a minimum of 10 years of experience with Oracle SQL language, using Toad for Oracle and/or PL/SQL. Minimum of 10 years of experience working with Oracle SQL language, using Toad for Oracle and/or PL/SQL. We are seeking a highly s...

Randstad Canada
Mississauga, Ontario

Responsible of the architecture, design, implementation and ongoing operations of MS SQL and Oracle databases under the leadership of application architects. MS SQL and Oracle database administration and design. Strong experience with MS SQL SSIS package design and execution, MS SQL Management Studi...

Randstad Canada
Mississauga, Ontario

Responsible of the architecture, design, implementation and ongoing operations of MS SQL and Oracle databases under the leadership of application architects. MS SQL and Oracle database administration and design. Strong experience with MS SQL SSIS package design and execution, MS SQL Management Studi...

S.i. Systems
Toronto, Ontario

Int Snowflake and IICS Developer to support multiple ETL projects for the data migration of Oracle database to Snowflake. Responsible for utilizing SnowSQL and Python scripting to assist in the migration process, demonstrating proactive, driven, and capable of managing multiple projects simultaneous...

CB Canada
Toronto, Ontario

On behalf of our client in the Banking Sector, PROCOM is looking for a Database Developer - SQL, ETL. Database Developer - SQL, ETL – Job Description. Database Developer - SQL, ETL – Mandatory Skills. Database Developer - SQL, ETL - Nice to Have Skills. ...

Promoted
Synechron
Toronto, Ontario

Experience building data pipelines using Azure Data Factory and Databricks. ETL developers are responsible for designing and creating the data warehouse and all related extraction, transformation and load of data functions. Looking for an Integration engineer responsible for daily support and projec...