Company Biography
As Ontario's only multi-utility provider, we offer a comprehensive range of services, including water, wastewater, natural gas, electricity, and telecommunications - all under one roof. This integrated approach empowers us to deliver innovative solutions, exceptional customer service, and operational efficiencies that set us apart in the industry.
With over 150 years of commitment to the Kingston community, we work every day to provide the safe, reliable utility services our customers rely on. Our efforts go beyond keeping the lights on and the water flowing. We’re driving progress through projects that create lasting, positive change. At the heart of everything we do is our vision to advance our unique utility model to benefit our customers and build better communities.
At Utilities Kingston, we believe that strong communities are built by strong teams. By joining us, you'll be part of a collaborative and dynamic environment where your skills and ideas will contribute to enhancing safety, driving reliability, and building a resilient future for our community.
Primary Duties
The Database Administrator (DBA) is responsible for the reliability, performance, security and availability of Utilities Kingston’s database platforms and system integrations. The DBA manages databases, integration and reporting environments and optimizes performance to support critical business and operational systems and enables application and system development through sound data management practices and automation.
Major Responsibilities:
1. Administer Oracle, Microsoft SQL Server, Azure Cloud Databases and other relational database platforms, ensuring high availability, reliability and performance of business-critical systems through proactive monitoring, maintenance and adherence to change management standards.
2. Analyze system performance and workloads to identify and resolve bottlenecks, applying tuning strategies to queries, indexes, database structures and high-volume transactional processes in collaboration with infrastructure and application teams.
3. Support application development and business operations by designing and maintaining database objects, schemas and automated data processes, while ensuring database changes are properly tested and documented through deployment.
4. Safeguard data integrity and security by implementing access controls, encryption, and auditing practices that meet cybersecurity, regulatory and municipal compliance requirements.
5. Maintain accurate documentation of data governance standards and operational procedures to support consistency and compliance across database environments.
6. Provide technical support for database dependent systems, participating in incident response, root cause analysis and continuous improvement initiatives to enhance database architecture and automation.
7. Support the Information Systems analysts with data reporting, system integrations, and solution development in support of strategic departmental objectives.
8. Contribute to IT projects, system upgrades and modernization initiatives that align with organizational priorities and long-term technology planning.
Education, Certification and Other Qualifications Required
Skills & Abilities:
- Advanced skills in database performance optimization & query tuning
- Advanced skills in scripting, automation and batch processing (e.g. SQL, Powershell, scheduling tools) to support automated workflows and system integrations
- Advanced skills in backup, recovery and high availability implementation to ensure business continuity
- Intermediate skills in systems integration and application support to maintain reliable interfaces between business applications
- Advanced analytical thinking and problem-solving skills
- Intermediate documentation and technical writing skills
- Intermediate communication and collaboration skills to align technical teams and stakeholders on project impacts
Knowledge:
- Advanced knowledge of database management systems (Oracle, MS SQL Server, Azure Cloud relational databases) to ensure high availability and performance
- Intermediate knowledge of the Microsoft 365 ecosystem, including Power Apps, Power Automate, Power BI, etc.
- Intermediate knowledge of data security, access control and compliance standards
- Intermediate knowledge of change management and IT service management practices
- Basic knowledge of Occupational Health and Safety requirements as it relates to individuals, the organization, and operational requirements
Experience:
- Post secondary diploma in Computer Science/Engineering or a related technical field
- 3-5 years’ experience working in a Database Administrator role
Special Working Conditions/Conditions of Employment
- Maintain a valid Class “G” driver’s license throughout employment
- A Criminal Record Check, to the satisfaction of Utilities Kingston, will be required at the successful candidate’s expense
- This job description indicates the general nature and level of work expected of the incumbent. It is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities required of the incumbent. The incumbent may be asked to perform other duties which may be assigned from time to time.
- This position is a hybrid role, with a portion of the work week on-site in Kingston, Ontario
Closing Statement
Your resume and/or cover letter must clearly demonstrate how you meet the requirements of the position.
Accessibility Statement
Appropriate accommodations will be provided as required by the Accessibility for Ontarians with Disabilities Act (AODA) upon request.
Employment Equity
Utilities Kingston is committed to employment equity and we encourage applications from all designated group members. Our goal is a diverse, inclusive workforce that reflects the Kingston community.
Utilities Kingston thanks all candidates that apply; however, only those selected for further consideration will be contacted.
Internal applicants must inform their supervisor or manager of their application and subsequent status
