Senior Application Database Developer

DRPS- Durham Regional Police Service; Whitby; On-site; CAD 118,000 - 144,000; Full time

Benefits offered by this job

Competitive Salary

OMERS Pension Plan

Health & Dental Benefits

Generous Paid Time Off

Professional Development & Growth

Wellness Programs

Job summary

DRPS - Durham Regional Police Service is seeking an IT professional to design, develop, administer, and enhance databases and software applications (Web, SQL, Azure, Python, JavaScript, Perl, C, C#) to support policing services.

This full-time role requires a university IT degree, at least five years of progressive database and application experience, and strong problem-solving and communication skills for collaboration with technical and non-technical stakeholders.

Qualifications

• Completion of a University degree in Information Technology or related field.
• Minimum 5 years' progressive experience in database positions and with multiple programming applications.
• Familiarity with SQL, Microsoft Azure, Power Apps, Python, JavaScript, Perl, C, C# is an asset.
• Strong leadership in planning, designing, developing and testing new systems and applications.

Responsibilities

• Administers, maintains, develops, and implements procedures for ensuring security and integrity of databases.
• Plans and coordinates database security measures.
• Collaborates in designing and developing databases for users responding to technological innovations.
• Implements data models and database designs, data access and table maintenance, transferring/replicating data and resolving performance issues.
• Designing, developing, testing, and implementing software applications (Web, SQL, Microsoft Azure, Python, JavaScript, Perl, C, C#) ensuring applications meet requirements.
• Researches, examines, and evaluates solutions to business problems; communicates risks and impacts.
• Provides technical support for application users and staff.
• Engages in varied, complex tasks across multiple databases and clients.

Skills

Database design

Programming languages

Communication skills

Time management

Diplomacy & confidentiality

Interpersonal skills

Education

University degree in IT or related field

Tools

SQL

Microsoft Azure

Power Apps

Python

JavaScript

Perl

C

C#

Job description

We value our employees and provide a comprehensive benefits package designed to support your well-being and future.

Our offerings include:

• Competitive Salary - Your expertise is valued. We offer a strong, competitive salary that reflects your skills and experience.
• OMERS Pension Plan - Secure your future with our employer-supported pension plan.
• Comprehensive Health & Dental Benefits - Extensive coverage for you and your family.
• Generous Paid Time Off - Vacation, sick leave, and parental leave.
• Professional Development & Growth - Access opportunities for training, professional development, and specialized career pathways to help you excel.
• Dedicated Wellness Programs - Your mental and physical health are essential. Benefit from wellness resources, mental health supports, and programs designed to help you thrive.

Branch and Unit

Administrative Support / Information Technology

Employment Type

This is a full-time, regular position.

Posting

Reporting to the Manager of Information Technology, this position is responsible for designing, developing, administrating, and enhancing databases and various software applications (ex: web, console, windows, system service, shell scripts).

DUTIES & RESPONSIBILITIES

• Administers, maintains, develops, and implements procedures and plans for ensuring security and integrity of the databases.
• Plans and coordinates database security measures.
• Collaborates in designing and developing of databases for users responding/anticipating technological innovations.
• Implements data models and database designs, data access and table maintenance codes transferring /replicating data, resolving database performance issues, dataset capacity issues, replication, and other distributed data issues.
• Designing, developing, testing, and implementing software applications (Web, SQL, Microsoft Azure, Python, Java Script, Perl, C, C# & Gen AI Programming) ensuring applications meet requirements.
• Researches, examines, and evaluates solutions and alternatives to business problems using work diagrams, structure/state charts, predicting risks and impacts.
• Provides technical support for application users and members.
• Job tasks are varied and complex (multiple databases, multiple clients, data warehouse) and contain new elements (design, maintenance). Judgment, research and analysis are required for design, debugging and testing.
• Other duties, projects, as assigned (individual or group responsibilities).

QUALIFICATIONS & SKILLS

• Completion of a University degree in Information Technology or related field.
• Minimum 5 years' progressive experience (ex. database position, related design requirement) and with multiple programming applications, including architecture and database infrastructure.
• Familiarity with SQL, Microsoft Azure, Power Apps, Python, Java Script, Perl, C, C# will be considered an asset.
• Responsible for project leadership on planning, designing, developing and testing of new systems and applications using various programming languages and database schemas. DBA development and presenting the storyboard/mock up and design to the end users.
• Ability to provide technical advice to users/stakeholders with explanations of technical matters in nontechnical terms, and relaying of unwelcome information.
• Demonstrated effective interpersonal and communication skills with multiple levels and sources for listening and comprehension.
• Well-developed time management, prioritization, multi-tasking and organizational skills.
• Proven ability to interact diplomatically, tactfully and confidentially with all levels of the service and the public.

Hours

Monday to Friday / Day Shift (may occasionally require flexibility in hours or overtime)

Salary Level

This is a Level 11 position $131,056 (2025-2029 Collective Agreement)

Selection

As part of the selection for this position, qualifications and skills listed in the posting will be assessed to measure the suitability of all applicants. Assessments may include, but not be limited to: resume review, skills assessment (s), interview(s), medical assessment, psychological assessment, functional abilities testing and/or background investigation.

Note: If you require accommodation at any time during the recruitment process, please advise the Human Resources contact on the posting. Appropriate assistance will be provided pursuant to the Service's Accessibility directive.

Durham Regional Police is an equal opportunity employer.

We thank all applicants for their interest; however, only those selected will be contacted.

Applications for the above position will be accepted until 1600 hours on the closing date of this posting. Questions may be directed to Ema Williams at [e-mail]