Database Analyst, Project Development

2 weeks ago

Aurora, Canada York Regional Police Full time

**Job Description**:
**Job Title**:Database Analyst, Project Development

**Posting Start Date**:5/14/25

**Closing Date**:**05/27/2025

**Requisition ID**:**1620

**Title**:**Database Analyst, Project Development

**Branch**:**Support

**Service**:**Technology Services

**Bureau**:**Information Technology

**Salary**:**108,523.00 - 113,969.00 per annum

**Status**:**Temporary, Full-Time

**Openings**:**1

**Vacancy Type**:**This job has been posted to fill a current vacancy

**Location**:**Headquarters

**Position Purpose**

**Major Duties & Responsibilities**

Monitor and maintain Oracle database objects, server configuration, replication, backup, partitions, storage and permissions for Mugshot, YRP PeopleSoft, Store and Forward and all systems using an Oracle database.
Monitor and maintain Informix and PostgreSQL database objects, service configuration, set up custom file structures and database objects, grant permission to users regarding this data.
Design and establish strategies back up databases and maintain logs.
Analyze business intelligence requirements and design, create and maintain the data loaded from various sources.
Create, schedule and monitor automatic daily scripts using Unix Cron utility and Windows Task Scheduler or other task scheduling solution.
Develop, maintain, schedule execution and distribution of customer reports.
Estimate data growth trends and plan storage capacity for database servers.
Review projects and task timetables and provide weekly status reports to the supervisor.
Configure, maintain, troubleshoot and tune cloud client APIs on security, performance and connections.
Maintain GPS over speed monitoring process and provide GPS and officer activity data for BI and crime analysis.
Coordinate specific assigned system developments and implementation activities, including preparation of the system analysis as well as general and detail design documents and prototype development.
Understand and respond to clients’ inquiries and requests, provide solutions to clients.
Design, implement and maintain data life cycles management within organizational policies.
Review and update procedural manuals as required.

**Education, Licensing & Certifications**

Four (4) year university degree in Computer Science or a related field.

**Experience**

Four (4) years of previous job experience in database administration, script programming or performance tuning.

**Skills**

Oracle Database or Microsoft SQL Server Administration certification required.
Database administration skills in Oracle, SQL Server, Informix, PostgreSQL and My SQL in on-premises, hybrid and on cloud environments.
Operating System scripting skills for Unix/Linux Shell script, DOS batch script and Windows PowerShell.
Troubleshooting skills on server resources: CPU, memory, I/O, disk space on Windows and Linux Operating Systems.
Report-generator tools and Programming languages including 4GL, FourJs, SQL Server Reporting Service, JSON, Python, C++, JavaScript and.net.
Proven problem solving, communication and interpersonal skills.
Skills with research design and methodologies, data collection and statistical analysis techniques.
Demonstrated problem solving, decision making and project management skills with the ability and desire to self-learn.

**How to Apply**

Please submit your cover letter and resume as one PDF document,

  • Project Analyst

    3 days ago

    Aurora, Canada JANA Corporation Full time

    JANA has a progressive culture of personal and professional growth. With a vested interest in each employee’s professional growth and continuous improvement as an individual, JANA supports professional development, continuous education, industry participation and technical accreditations. Other Perks that come with joining JANA’s Team include: -...

  • Database Analyst

    1 week ago

    Aurora, Canada Goldenhome Cabinetry Eastern Canada Inc. Full time

    Education: College/CEGEP - Experience: 2 years to less than 3 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards...

  • Planner and Project Analyst

    6 days ago

    Aurora, Canada York Catholic District School Board Full time

    YORK CATHOLIC DISTRICT SCHOOL BOARD PLANNER AND PROJECT ANALYST Exempt Level 5 - Salary Range: $34.11 to $43.85 (hourly rate) This is a 17-month contract position : Under the direction of the Manager, Accommodation Planning and Property, the Planner and Project Analyst will actively participate in the creating and updating of enrolment...

  • Planner and Project Analyst

    1 week ago

    Aurora, Canada York Catholic District School Board Full time

    **YORK CATHOLIC DISTRICT SCHOOL BOARD** **PLANNER AND PROJECT ANALYST** **Exempt Level 5 - Hourly Rate: $38.77 to $49.84** **Contract Position to August 31, 2026** **Position Summary**: **Major Responsibilities**: - Review, analyze and update school boundaries, report findings and prepare revised boundary maps as required. - Prepare maps, charts,...

  • Project Accounting Analyst

    1 week ago

    Aurora, Canada Powell Group of Companies Full time

    **Powell Contracting**, a division of **RSG International**, was established in 1967. With over 50 years’ experience, we are the industry leader in providing Ontario with the supply and installation of temporary concrete barriers, noise barriers, crash cushions, guide rails, ground mount signs, overhead signs and sign structures. Our integrated solutions...

  • Integrity Analyst

    3 days ago

    Aurora, Canada JANA Corporation Full time

    JANA has a progressive culture of personal and professional growth. With a vested interest in each employee’s professional growth and continuous improvement as an individual, JANA supports professional development, continuous education, industry participation and technical accreditations. Other Perks that come with joining JANA’s Team include: -...

  • Edi Analyst

    2 weeks ago

    Aurora, Canada Commport Communications Full time

    **About us** Commport Communications is a technology firm located in Aurora, Ontario. We have been in business since 1985 and are one of North America’s original EDI network providers! Commport specializes in helping small and medium-sized businesses establish reliable data transfer processes. These, in turn, help our customers build strong relationships...

  • Integrity Analyst

    5 days ago

    Aurora, Canada JANA Corporation Full time

    As an entrepreneurial company, we provide an exciting, dynamic and respectful work environment where you will be an important contributor to the JANA Team. Our Mission at JANA is “Better Pipelines for a Better World” - we are true believers and inspire our employees to join us in this Mission! - High-energy Collaborative Environment: JANA combines the...

  • SAP Analyst

    5 days ago

    Aurora, Canada York Catholic District School Board Full time

    **YORK CATHOLIC DISTRICT SCHOOL BOARD** **SAP Analyst** **Exempt Level 7c -**$93,203 - $114,768** **Position Summary**: Reporting to the SAP Program Supervisor, the SAP Analyst will be responsible for configuring and optimizing SAP modules to meet evolving business needs, while also supporting custom development using ABAP programming. The role involves...

  • GIS Analyst

    2 days ago

    Aurora, Ontario, Canada JANA Corporation Full time $60,000 - $120,000 per year

    JANA is focused on improving the integrity of gas pipeline systems through the application of advanced risk modeling technologies. Our models and software are defensible and highly predictive, allowing gas pipeline operators to take actions to reduce risk in their systems. And our Integrity Data suite enables pipeline operators to finally capture their...