Sr. Specialist Database Administration
CityofOttawa
Special Constable
CityofOttawa • Ottawa, ON, Canada • via City Of Ottawa
17 hours ago
Full–time
No Degree Mentioned
Apply on City Of Ottawa
Apply on Eluta.ca
Apply on Indeed
Apply on Glassdoor
Apply on LinkedIn
Apply on SimplyHired
Apply on Workopolis
Apply on Jobs.ca
Job description
Requisition ID: 16+47
Department: Transit Services Dept.
Service: Safety, Regulatory, Trng & Dev Service
Branch: Special Constable Branch
Employment Type: Multiple Full-time Temporary Positions (Up to 2 years)
Work Hours: 40.00 hours per week
Affiliation: CUPE 5500
Salary Information: $36.455 - $42.888 per hour (2025 rates of pay)
Location: Transit Service, 1500 St.Laurent
City: Ottawa, ON
Job Category: Transit Services - OC Transpo
Application Close: 31/12/2025
NOTE: Applications / resumes received will be used to staff current and on-going requirements until December 31, 2025
JOB SUMMARY
Transit Operations provides safe, reliable and courteous transit services and excellence in customer service delivery to 100 million transit customers per year, by means of conventional bus, para transit and rail operations. The Transit Special Constable Unit manages the Special Constable and Fare Enforcement Programs, Transit revenue loss and fare enforcement programs, property protection and law enforcement programs, the transit emergency response and preparedness programs, communications equipment/systems, processes and sectional records activities.
You are responsible for security and law enforcement duties involving passengers, employees, Transit Services facilities/vehicles/assets and the general public.
You execute the duties of a Sworn Special Constable/Peace Officer, agent and occupier of City of Ottawa Transit Services*, in accordance with:
• Federal/Provincial/Municipal laws
• Special Constable contract with the Ottawa Police Services Board
• Rules and regulations governing a Special Constable appointment (as amended from time to time)
• Corporate/Branch/Division policies and standards
• Corporate/Branch Code of Ethics, Core Values and Mission Statement, that is consistent and compatible with Ottawa Police Service policies and standards
• The Police Services Board grants an Officer’s Special Constable status for Ottawa, with an approval from the Minister of Community Safety and Correctional Services, in accordance with the Police Services Act, R.S.O. 1++0. Special Constables are Peace Officers as defined in the Criminal Code of Canada.
EDUCATION AND EXPERIENCE
Completion of community college Police Foundations or Law and Security Certificate.
Minimum of 2 years of security experience in a transit environment.
Related experience in dealing with people and enforcement procedures may be considered as alternate relevant experience.
CERTIFICATIONS AND LICENCES
Must obtain and maintain Special Constable designation
KNOWLEDGE
• Good knowledge of security or law enforcement operations, as well as the duties of a Special Constable with Peace Officer authority, including the use/application of the Criminal Code of Canada, Controlled Drugs and Substances Act, Trespass to Property Act, Provincial Offences Act, Liquor Licence Act, Safe Streets Act, MFIPPA, as well as related Federal and Provincial Statutes, and Transit By-law
• City/Branch/Division policies and procedures affecting Transit operations including standard operating procedures and emergency standing orders
• Court processes and procedures
• Investigative and evidence gathering techniques
• Crowd control and emergency response techniques
• Dispute resolution techniques
• Personal and physical security methods
• Electrical and computerized security equipment
• Knowledge of applicable health and safety legislation, including the rights and duties of workers.
COMPETENCIES, SKILLS AND ABILITIES
• Work independently, with minimal supervision, and collaboratively with peers and managers as part of a team
• Capable of relating to transit customers, while working in a public environment, and of dealing with difficult or confrontational behaviors
• Possess leadership and negotiation skills
• Possess analytical and problem solving skills
• Possess demonstrated assertiveness and self-control
• Possess strong conflict/dispute/crisis resolution skills
• Able to exercise sound judgement and to make authoritative decisions where time may not permit soliciting advice from senior staff
• Possess computer literacy in MS Office Suite in a Windows environment, including use of Ozone and the Internet
• Able to build and maintain relationships within the community, with stakeholders and other agencies
• Able to demonstrate sensitivity to the needs of all people and cultures
• Possess organizational and time management skills to deal effectively with multiple demands, conflicting priorities, and deadlines
• Possess excellent interpersonal, communication, and report writing skills
• Possess neat and legible handwriting
• Possess effective public relations and public speaking skills
• Able to use portable corporate communications technologies, such as 2-way radio, etc.
• Able to drive a City vehicle
• Possess a work record of good attendance/job performance
• Be of good moral character and habits
• Able to be respectful, to relate to Transit customers, co-workers and the general public, and to work in a non-confrontational manner
• Possess cultural awareness, value diversity and be sensitive to others
• Able to display tact and diplomacy
• Able to deal with physical situations and physically control/restrain others when necessary
• Able to work outside in all weather conditions
• Able to be available for unplanned overtime, work a variety of scheduled shifts, including split shifts, weekends and evenings
WHAT YOU NEED TO KNOW
• Language Requirement: Various language requirements.
Some positions require English oral, reading, and writing.
Some positions Designated Day 1 Ready – immediate requirement for language proficiency: French: oral, English: oral, reading, writing. Candidates must meet language requirement for position upon hire.
Some positions Designated Bilingual - Specific level of language proficienty: French: oral, English: oral, reading, writing. Candidates who do not meet language requirements will be required to participate in training.
• Police Record Check: The successful candidate will be required to complete a Vulnerable Sector Check with the Police Services detachment in their jurisdiction to the City of Ottawa’s satisfaction.; Police record checks completed by a third-party company will not be accepted.
• Driver’s License Requirement: A valid Ontario unrestricted G class driver’s license (or provincial equivalent) with no more than 6 demerit points accumulated
• Meet eligibility requirements for appointment as a Special Constable, which are:
• Canadian Citizen or permanent resident of Canada
• Lawfully eligible to work in Canada
• At least 18 years of age
• Not been convicted of a criminal offence or been convicted of an offence for which a pardon has been granted.
• Proof of valid Standard First Aid Certificate and valid CPR-Level C
• Must learn, meet and maintain Transit Special Constable Services standard in the use of oleoresin capsicum (OC) spray, baton and the use of force continuum
• Candidates will be required to undergo physical fitness testing with the Transit Special Constable Recruiters. Candidates will be required to successfully complete the Ontario Police Fitness PIN test.
• Candidates will also be required to undergo other investigations/checks to include:
• Fingerprinting
• Driver's licence history
• Credit check
• Background reference check
• Written MMPI
• Interview with Psychologist
• Experience and formal training combined with demonstrated performance and ability may substitute for stipulated academic requirements.
• Please save a copy of the job poster. Once the closing date has passed, it will no longer be available.
We wish to thank all applicants for their interest and effort in applying for this position. Only candidates selected for interviews will be contacted.
The City of Ottawa promotes the principles of diversity and inclusion and adheres to the tenets of the Canadian Human Rights Act and the Ontario Human Rights Code. We encourage applications from members of Indigenous, Black and other racialized communities, persons with disabilities, women and non-binary persons, persons of all ethnic origins, religions, ****** orientations, classes, gender identities and expressions.
Candidates are encouraged to self-identify as a member of one or more designated employment equity groups in the self-identification questionnaire.
The City of Ottawa provides accommodation during all parts of the hiring process, upon request, to applicants with disabilities. If contacted to proceed to the selection process, please advise us if you require any accommodation.
Accessible formats and communication supports are available upon request. Please contact the HR Service Centre at 613-580-2424, extension 47411.
Report this listing
CityofOttawa
Glassdoor
4.1/5
674 reviews
Payscale
3.5/5
2 reviews
ottawa.ca
More jobs at CityofOttawa
See web results for CityofOttawa
Bank of Montreal
Sr. Specialist Database Administration
Bank of Montreal • Toronto, ON, Canada • via BMO Careers
1+ hours ago
Part-time
Apply on BMO Careers
Apply on LinkedIn
Apply on Indeed
Apply on Jobillico
Apply on Eluta.ca
Apply on Built In Toronto
Apply on Jobs.ca
Apply on Built In
Job description
Application Deadline:
06/2+/2025
Address:
33 Dundas Street West
Oversees the development of methods, practices, policies, tools, and processes to collect, store, access, and use data securely, efficiently, and cost-effectively. Supports the full lifecycle of data assets. Ensures the quality of data collection, including the adequacy, accuracy, and legitimacy of the data. Identifies ways to manage data across a diverse but unified data tier. Plans and supports the implementation of cloud data management platforms and tools, policies, and procedures, giving the organization control of business data, both in cloud applications and hybrid cloud/ on-premise setups. Manages data integration by applying relevant data governance and management practices.
Responsibilities:
• Creates and maintains an optimal data pipeline architecture.
• Assembles large, complex data sets that meet functional / non-functional business
requirements.
• Identifies, designs, and implements internal process improvements: automating manual processes, optimizing data delivery, and re-designing infrastructure for greater scalability.
• Builds the infrastructure required for optimal extraction, transformation, and loading of
data from a wide variety of data sources.
• Builds analytics tools that utilize the data pipeline to provide actionable insights into
customer, operational efficiency, and other key business performance metrics.
• Works with different stakeholders and teams to assist with data-related technical issues and support their data infrastructure needs.
• Works with experts in data strategy and data governance to suggest quality
enhancements.
• Operates at a group/Digital US Domain level and is a specialist resource for senior leaders and stakeholders.
• Applies expertise and thinks creatively to address unique or ambiguous situations and
to find solutions to problems that can be complex and non-routine.
• Implements changes in response to shifting trends.
• Broader work or accountabilities may be assigned as needed.
Qualifications:
• Typically, 7+ years of relevant experience and a post-secondary degree in a related field of study or an equivalent combination of education and experience.
• Intermediate level of proficiency: Creative thinking.
• Advanced level of proficiency:
• Data architecture design and modeling.
• Cloud computing architecture.
• Data security.
• Machine learning.
• Computational thinking and programming.
• Deep learning.
• Decision making.
• Critical thinking.
• Data integration.
• Data warehousing.
• Enterprise data management.
• Data mining.
• Big data.
• Streaming / Real-time.
• Verbal & written communication skills.
• Analytical and problem-solving skills.
• Collaboration & team skills, with a focus on cross-group collaboration.
• Able to manage ambiguity.
• Data-driven decision making.
• Seasoned professional with a combination of education, experience, and industry knowledge.
Grade:
8
Job Category:
Individual Contributor / Collaborateur
Salary:
$+2,400.00 - $171,600.00
Pay Type:
Salaried
The salary range provided reflects BMO Financial group’s compensation range for the grade band associated with this position.
Salary placement within the range outlined above is role-based and will vary based on factors such as location, skills, experience, education and qualifications for the role, and may include a commission structure. These ranges were determined by a market-based compensation approach; we used data from trusted third-party compensation sources to set consistent, and competitive ranges. We regularly evaluate compensation, identify any changes in the market and adjust our ranges and existing employee compensation as needed.
Salaries for part-time roles will be pro-rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position.
BMO’s comprehensive total compensation package will vary based on the pay type of the position and may include performance-based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit: https://jobs.bmo.com/global/en/Total-Rewards
About Us
At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.
As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.
BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.