Database And Data Engineer

JOB TITLE: Database And Data Engineer (DBA)

DEPARTMENT: Corporate Support Services

POSTING NUMBER: 106461

NUMBER OF POSITIONS: 1

JOB STATUS & DURATION: Full Time Permanent

HOURS OF WORK: 35 hour workweek

LOCATION: Hybrid Model* when working onsite you will report to the location of West Tower.

SALARY GRADE: 15

SALARY RANGE: 1^ST STEP: $99972 per annum

2^ND STEP: $103971 per annum

3^RD STEP: $108130 per annum

4^th STEP: $112469 per annum

JOB TYPE: Union

POSTING DATE: March 12 2025

CLOSING DATE: March 25 2025

The City of Brampton is currently hiring a DBA Database and Data Engineer! If you have strong production database (Oracle 19 and SQL Server 2019 support & administration experience and excellent understanding with Data technologies (ex. Data Warehousing Data Lakes Data Mesh) lifecycle principles and best practices database utilities (ex. Foglight) and middleware technologies (ex. WebLogic) then check out this opportunity.

AREA OF RESPONSIBILITY:

Under the direction of the Manager Databases and Data Technologies maintains the Corporate and Departmental Level Databases and Data Technologies platforms. This includes collaborating with operating units to implement a comprehensive organizational data strategy enabling accessibility to shared data creating and maintaining enterprise and business operating unit specific data repositories and supporting an organizational transition to big data accessibility.

• Continuously monitors Enterprise Level Databases resizing and tuning various parameters as required.
• Integrates existing systems with new environments in a phased manner.
• Develops databases and data backup/restore procedures in a multivendor environment.
• Execute database cloning migration conversion and normalization procedures for development and production environments.
• Participates in the change management processes to ensure quality of Database and Data Technologies elements.
• Maintains the availability security and performance of the organizations databases and data repositories working in collaboration with other cross platform teams.
• Participates in the development of roadmaps involving database and data technologies and the creation of processes and procedures for the database deployment builds backup and recovery business continuity planning security and monitoring.
• Participates in setting strategies and standards through data modeling and implementation leveraging big data and analytics tools and technologies.
• Designs builds and maintains data frameworks (ingestion processing distribution access) for City of Brampton core data platform.
• Interface with other technology and business teams to extract transform and load data from a wide variety of data sources.
• Implement and support big data solutions for distributed computing.
• Design develop and maintain data pipelines for corporate dashboards and reporting.
• Profiles data to measure quality integrity accuracy and completeness.
• Supports development of comprehensive ongoing platform migration strategy including the identification of additional hardware and software requirements establishing procedures and documentation of overall system design.
• Accountable for the successful and stable coexistence of the Citys Corporate Application solutions on all Enterprise Level Database environments.
• Acts as senior level internal consultant to systems development and project teams.
• Monitors systems usage prepares peak loading reports recommends performance enhancement and provides user support.
• Creates and monitors project plans and timelines for special integration initiatives.
• Maintains development and continuous refinement of documented database and data strategies in order to provide a scalable and manageable environment for future growth.
• Stays informed of industry and product trends and advances.
• Operationalizes onboard processes for new database and data technologies pertain to business solutions in cloud.
• Maintains and meets all audit and regulatory compliance standards and controls including but not limited to user access data restrictions and process controls.
• Participate in Request for Proposals (RFPs) and other Information Technology projects documents reviews for Database and Data Technologies related content.
• Maintains compliance to security confidentiality and privacy policies of section high privileged SMEs handling the sensitive data.
• All other duties as assigned.

SELECTION CRITERIA:

This job has transitioned from nonunion. Upon evaluation through the new job evaluation modernization initiative minimum qualifications will be updated to be representative of the new CUPE criteria.

EDUCATION:

• University degree in computer science or related discipline

EXPERIENCE:

• Minimum of 5 years experience in MS SQL Server and Oracle database administration platform design solution delivery and operations.

OTHER SKILLS AND ASSETS:

• Demonstrated expertise working in a multivendor mixed operating system environment.
• Oracle and MS SQL DBA certifications.
• ITIL certification would be an asset.
• Expert level production experience with RDBMS technologies including MS SQL Server and Oracle.
• Experience with cloud based business solution deployments.
• Successful implementation of at least 5 major systems/applications with demonstrated track record.
• Production experience and excellent understanding with Data Warehousing lifecycle principles and best practices.
• Experience working with virtualized and physical environments including public and private cloud.
• Strong analytical and problemsolving skills.
• Excellent written and verbal communication skills.

**Various tests and/or exams may be administered as part of the selection criteria.

Interview: Our recruitment process may be completed with video conference technology.

Applicants who do not meet the educational requirements but have direct related experience may be considered.

As part of the corporations Modernizing Job Evaluation project this position will undergo an evaluation which may result in a change to the rate of compensation. Any changes affecting this position will be communicated as information becomes available. *Our Hybrid Model is subject to change.

If this opportunity matches your interest and experience please apply online by clicking the button above quoting reference #106461 by March 25 2025 and complete the attached questionnaire. We thank all applicants; however only those selected for an interview will be contacted. The successful candidate(s) will be required as a condition of employment to execute a written employment agreement. A criminal record search will be required of the successful candidate to verify the absence of a criminal record for which a pardon has not been granted.

As part of the application process applicants will be invited to complete a selfidentification survey. The survey is voluntary. Participation in the survey will have no impact on hiring decisions. Should you wish to opt out of completing the survey please select prefer not to answer as a response to each question. All information collected is confidential and will not be shared with the hiring manager. The surveys will be anonymized and will be kept separate from applicant or employee files such that the individuals who completed the surveys will not be identifiable. The results of the survey will assist in the analysis of disaggregated metrics for organizational planning purposes and our commitment to advance and foster diversity equity and inclusion. The City may use anonymized data to produce aggregate reports for internal or external use.

Please be advised the City of Brampton uses email to communicate with their applicants for open job competitions. It is the applicants responsibility to include an updated email address that is checked daily and accepts emails from unknown users. As we send time sensitive correspondence via email (i.e. testing bookings interview dates) it is imperative that applicants check their email regularly. If we do not hear back from applicants we will assume that you are no longer interested in the Job Competition and your application will be removed from the Competition. #LIHybrid

If you would like to request content in an alternate format please contact the Accessibility office by submitting a newAlternate Format Request.