Database Administrator

Halifax Water is inviting applicants for one (1) Regular Full Time Database Administrator in the Corporate 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.

Qualifications

• 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.

Responsibilities

• 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.

Additional Information

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