Halifax Water is inviting applicants for one (1) Regular Full Time Database Administrator in theCorporate Services Department. Halifax Water believes a diverse workforce positively contributes to its success, and the success of our community. We encourage applications from qualified African Nova Scotians, LGBTQ+ community, racially visible persons, women in non-traditional positions, persons with disabilities and Indigenous persons. Halifax Water encourages applicants to self-identify in the cover letter.
Interested, qualified candidates are asked to submit a cover letter and resume, stating Competition #HW24-206E confirming their interest by 12:00 pm on December 20, 2024.
- Install, upgrade, and patch the database management software.
- Create and manage database structures to store and manage data effectively.
- Ensure corporate data is readily available to Halifax Water technology systems, permitting Halifax Water to reliably serve its clients and allow timely and accurate decision making.
- Develop, enhance, and optimize database schemas, semantic models, and queries.
- Develop, implement, and maintain database triggers, database links, stored procedures, and interface routines/scripts.
- Design, prepare and execute database backup and recovery, and disaster recovery procedures to ensure Halifax Water is protected against loss of corporate data.
- Monitor system performance and tune databases to optimize responsiveness and efficiency.
- Develop and maintain database documentation.
- Implementation and maintenance of database security protocols to ensure compliance with security standards and protect against cyber threats.
- Develop and implement data administration policy, standards, and models.
- Participate in the creation of policies and procedures for network and/or Internet database access and usage and for the backup and recovery of data.
- Identify opportunities for improvement to other technology systems professionals regarding the collection, availability, security, and suitability of data.
- Other related duties as assigned.
- Education:
- Computer Science / Information Technology technical diploma or related discipline. Other equivalent combinations of education and experience may be considered.
- Experience:
- Minimum of 5 years' experience in database administration and database management systems with emphasis on MS SQL Server.
- Certificates/Licenses/Registrations:
- ITIL Foundations Certification, must be willing to obtain within 1 year of obtaining position.
- Microsoft Certification in Databases considered an asset
- Must be willing to undertake and maintain the following safety training:
- First Aid.
- Globally Harmonized System (GHS) (Formerly WHMIS).
- Additional safety training as identified based on legislative and operational requirements.
Halifax Water invests in its employees by providing competitive salaries, incentive programs, opportunities for advancement, and excellent benefits packages including:
- Pension plan
- Medical, dental and vision benefits
- Paid holidays, vacation, and sick leave
- Family/Employee Assistance Program
- Employee wellness
- Professional development opportunities
- Commitment to providing world-class water, wastewater and stormwater services as leading environmental stewards.
- Opportunity to work remotely