Oracle Database PL / SQL Developer, Property & Recording

Tyler Technologies, Inc.; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading company in technology solutions is seeking an Oracle Database PL / SQL Developer in Toronto. This role involves leveraging your expertise in Oracle to develop and optimize database components within a collaborative Agile team. If you have a passion for software development and problem-solving, this is the opportunity to grow and add value to key product components while working in a hybrid environment.

Qualifications

• 3-5 years of experience with Oracle PL / SQL and database performance optimization required.
• Experience in software development with object-oriented design preferred.
• Familiarity with JSON and XML data payloads advantageous.

Responsibilities

• Develop and maintain PL / SQL stored procedures and complex reports.
• Work collaboratively in an Agile environment with cross-functional teams.
• Troubleshoot software issues and ensure code quality through testing.

Skills

SQL

Problem-Solving

Analytical Skills

Communication

Object-Oriented Design

Education

BS / BA in Computer Science or related field

Tools

Oracle PL / SQL

Oracle Reports Builder

SQL Server Reporting Services (SSRS)

Job description

Oracle Database PL / SQL Developer, Property & Recording

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 :
• 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

Create a job alert for this search