30 Oct
|
Utilities Kingston
|
Kingston
30 Oct
Utilities Kingston
Kingston
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 creative 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 satisfactory to Utilities Kingston at the successful candidate's own expense
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 candidate that apply, however, only those selected for further consideration will be contacted.
📌 Database Administrator (Oracle/SQL Server) (Kingston)
🏢 Utilities Kingston
📍 Kingston