Senior Oracle PL/SQL Developer

Russell Tobin

Toronto

On-site

CAD 110,000 - 117,000

Full time

32 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Russell Tobin & Associates is hiring on behalf of a public sector client for a Senior Oracle PL/SQL Developer in Toronto, Ontario. The contract runs for 305 business days with a possible extension and pays CAD 80–85 per hour.

The role requires extensive Oracle 12c OLAP/OLTP design and development, PL/SQL development, data warehouse design, and advanced SQL. You will work with business analysts to translate requirements into robust IT solutions and leverage Informatica and Cognos for ETL and

Qualifications

  • Design and development of Oracle 12c for OLAP/OLTP with PL/SQL, stored procedures, packages, functions and triggers.
  • Advanced SQL, data architecture, and data modeling for OLTP/OLAP databases.
  • Data Warehouse design, performance tuning, and automation.
  • Collaborate with business analysts to translate requirements into designs for business/IT needs.
  • Experience with Informatica for ETL and Cognos reporting tools (Query Studio/Reports Studio).
  • Knowledge of Java, JSON, XML, API calls, HL7/FHIR, Restful web services.

Skills

Oracle PL/SQL
Advanced SQL
Data Warehouse design
Business analyst collaboration
SDLC / DevOps
Public sector/domain knowledge
System architecture
Leadership / mentoring
CI/CD
Web services/API (HL7/FHIR)

Tools

Informatica
Cognos (Framework Manager/Query Studio/Reports Studio)
Crystal Reports
Business Objects
Java
JSON / XML / REST

Job description

Russell Tobin & Associates is hiring on behalf of one of its esteemed clients.

Job Title: Senior Oracle PL/SQL Developer

Duration: 305 Business days with possible extension

Client: Public Sector

Pay Rate: $80 - $85/hour [CAD]

Must Have:
  • Design and development of Oracle(12c) for OLAP and OLTP applications, including PL/SQL, Oracle stored procedure, packages, functions, triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
  • Advanced SQL skills, optimized database queries, and data architecture, database design, database modeling
  • Data Warehouse design and development, Database performance tuning, Automation
  • Working with business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs
Public Sector Experience:
  • Experience working with federal/provincial/broader public-sector healthcare providers
  • Knowledge of the provincial immunization system and OPS large complex IT Health related projects or equivalent
  • Experience with integration of Clinical IT Systems such as Client and Provider Registries
  • Knowledge of OPS Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices
  • Knowledge of industry standard such as Project Management Institute (PMI)
  • Experience adopting and adhering to OPS Unified I&IT Project Methodology, OPS Enterprise Architecture and OPS Gating process, and OPS Standard Systems Development Methodologies.
Technical Skills:
  • 10+ years of experience with:
  • Design and development of Oracle(12c) for OLAP and OLTP applications, including PL/SQL, Oracle stored procedure, packages, functions, triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
  • Demonstrated ability to create normalized database schemas utilizing data modeling discipline. Understanding of normalization, de-normalization, and the difference between the two. Ability to create schemas for both OLTP and OLAP databases.
  • Advanced SQL skills, optimized database queries, and data architecture, database design, database modeling
  • Data Warehouse design and development, Database performance tuning, Automation
  • Informatica for data extraction, transformation, and loading, initial setup and other data management purposes
  • Cognos report design and development, Framework manager, Query Studio, Reports Studio, creation of dashboards, etc. Other reporting tools would also be an asset, particularly Crystal Reports and Business Objects
  • Knowledge of Java, JSON, XML, API calls, HL7/FHIR, Restful web services
  • Knowledge of the provincial immunization system.
Core Skills and Experience:
  • 10+ years of experience with:
  • Working with business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs
  • Working with technical systems specifications and translating them into working, tested applications for large, complex, mission critical applications
  • Analysis, design and development work on complex, multi-tier web-based applications, micro-services architecture, mobile, and off-the-shelf solutions
  • Proven technical leadership skills with ability to identify areas for improvement, and recommend solutions
  • Using and applying extensive knowledge of User Interface (UI) design principles across a variety of applications, platforms and devices
  • Technical analysis, program code, detailed programming and reports specifications, program design, writing and/or generating code, and conducting tests
  • Developing and maintaining system design models, technical documentation and specifications
  • Conducting technical evaluation and assessment of options for technical design issues, application figuration aspects and integration capabilities, related tools and utilities, gap analysis of integration components to technical requirements/specifications/documentation
  • Developing medical and clinical based systems
  • Web performance optimization
  • Various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
  • Conducting technical analysis, trouble-shooting, and issue resolutions for production operational support of reports, and other components and utilities
  • Knowledge of recognized accessibility laws, regulations, and standards (e.g., W3C, WCAG) or other specific accessibility standards, and experience in usability, accessibility and compliance testing
  • Ensuring compliance with architecture framework and system standards, and Agile Development Methodology
  • Project management practices, and ability to contribute to design/development project plans, including work breakdown, resource estimates, and status reports
  • Experience with Software Development Lifecycle (SDLC)
  • Continuous Integration (CI) practice and DEVOPS methodologies and technologies
  • Knowledge and experience with leading-edge technologies, design criteria including usability, security, and privacy for web and mobile applications.
General Skills :
  • Demonstrated strong leadership and people management skills
  • Exceptional analytical, problem solving and decision-making skills
  • Demonstrated strong interpersonal, verbal and written communication, and presentation skills
  • Proven troubleshooting and critical thinking experience
  • Demonstrated ability to apply strong listening skills to facilitate issue resolution
  • Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships
  • Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectively
  • A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

RQ11901 - Software Developer(Oracle) - Senior Shweta
RQ11901 - Software Developer(Oracle) - Senior Shweta

A.T. Consulting & Recruiting Inc. • Toronto

On-site
CAD 110,000 - 160,000
11951
11951

Maarut • Toronto

On-site
CAD 110,000 - 150,000
IT26 32654FG Sr Software Dev (x2) Voluntary Mergers PHUs (RQ11901)
IT26 32654FG Sr Software Dev (x2) Voluntary Mergers PHUs (RQ11901)

Health Services Cluster • Toronto

On-site
CAD 110,000 - 150,000
RQ11508 - Software Developer - Senior I 1+ Year I Toronto ON
RQ11508 - Software Developer - Senior I 1+ Year I Toronto ON

Analyst Technical Solutions • Toronto

On-site
CAD 131,000 - 139,000
RQ08949 - Software Developer - Senior
RQ08949 - Software Developer - Senior

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000
Senior Software Developer - North York
Senior Software Developer - North York

Randstad Canada • Toronto

On-site
CAD 150,000 - 190,000
Long-term engagement
Onsite workspace in Toronto
Healthcare/enterprise impact
+1
Senior Software Engineer – Hybrid Health IT Systems
Senior Software Engineer – Hybrid Health IT Systems

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000
RQ11860 – Database Administrator – Senior (Onsite)
RQ11860 – Database Administrator – Senior (Onsite)

S M Software Solutions Inc • Toronto

On-site
CAD 120,000 - 150,000
RQ08570 - Technology Architect - Senior
RQ08570 - Technology Architect - Senior

Rubicon Path • Toronto

Hybrid
CAD 100,000 - 130,000
RQ08836 - Software Developer - Senior
RQ08836 - Software Developer - Senior

Rubicon Path • Toronto

Hybrid
CAD 100,000 - 120,000