NU-2024-24 Manager of Planning

The role

Database Administrator & Solutions Analyst

This is a permanent full-time role at the County, with an annual compensation range of $70,689 to $86,013.

The opportunity

We are looking for a skilled Database Administrator & Solutions Analyst to join our Innovation & Technology Services team, where you’ll play a crucial role in ensuring the availability, integrity, and security of databases for use across our division, department, and the wider organization. In this role, you will be responsible for database server activities including implementation, configuration, maintenance, and performance of critical systems to ensure the availability and consistent performance of the Corporate systems, applications and business solutions. You’ll also assist in developing database standards and provide data design and analytics support.

The perks

The County

Haldimand County is a single-tier municipality with a dedicated team of professionals committed to delivering exceptional services to our citizens. With a focus on excellence, our county stands as an outstanding place to work and live. By joining our dynamic team, you open the door to a rewarding career where we prioritize the health and wellness of our employees, their families, and the communities we serve.

At Haldimand County, we believe in the Net Better Off philosophy. This means we’re passionate about helping our staff thrive and advance in an equitable workplace.

Job description

Core Competencies

• Innovation, creativity and originality
• Technology use
• Active learning
• Cognitive flexibility
• Interpersonal communication

Position Summary

Responsible for database server activities including implementation, configuration, maintenance, and performance of critical systems. Additionally, ensuring the availability and consistent performance of Corporate systems, applications, and business solutions, including maintaining the availability, integrity, and security of databases, while also assisting with the development of database standards, by offering database design and analytics support.

Qualifications, Knowledge, and Skills

Education

• Community College Diploma relative to the area of responsibility
• Special consideration will be given to applicants with:
  • Bachelor’s Degree in Data Science or Certified Microsoft Azure Database Administrator Associate

Experience

• Over 2 years and including 3 years of current related experience.
• Special consideration will be given to applicants with:
  • Experience with Local Government Software Applications/Solutions
  • Experience with GIS and ArcGIS Pro

Knowledge/Skills

Responsibilities

The incumbent is responsible for, but not limited to:

Corporate

• Guarantees that corporate goals and objectives are always in consideration and achieved by those working on a project.

People

• Establish and maintain relations with others (County staff, vendors, peers within other organizations) to resolve technology complaints/issues

Timeline

• Prioritize urgent matters to minimize downtime of corporate and department applications for staff
• Support yearly Financial processes with database-level verification of data integrity

Money/Asset

• Information Security (Databases):
  • Provides advice and guidance on security strategies to manage identified risks and ensure adoption and adherence to standards.
  • Obtains and acts on vulnerability information and conducts security risk assessments, business impact analysis and accreditation on complex information systems.
  • Investigates major breaches of security and recommends appropriate control improvements.
  • Contributes to development of information security policy, standards and guidelines.

Functional

Data Management

• Takes responsibility for the accessibility, retrievability, security, quality, retention, and ethical handling of specific subsets of data.
• Manipulates specific data from information services, to satisfy defined information needs.
• Maintains and implements information handling procedures, by enabling the availability, integrity, and searchability of information through the application of formal data and metadata structures and protection measures.
• Develops and maintains specialist knowledge of database and data warehouse concepts, design principles, architectures, software, and facilities

Systems Integration and Build

• Identifies, evaluates and manages the adoption of appropriate tools, techniques and processes (including automation and continuous integration) to create a robust integration framework.
• Leads integration work in line with the agreed system and service design.
• Monitors and reports on the results of each integration and build.
• Designs and builds integration components and interfaces.
• Contributes to the overall design of the service and the definition of criteria for product and component selection.
• Contributes to development of systems integration policies, standards and tools.
• Executes ETL processes to integrate data from separate business applications.

Application Support

• Use various tools to investigate issues, identifies and resolve issues with applications, collect performance statistics and create reports.
• Provides assistance to users in a professional manner following agreed procedures for further help or escalation, followed by maintaining accurate records of user requests, contact details, and outcomes.
• Initiates and monitors actions to investigate and resolve problems in systems, processes, and services
• Assists with the implementation of agreed remedies and preventative measures, by determining problem fixes/ remedies.

Analytics

• Selects, acquires and integrates data for analysis.
• Creates data dashboards, reports, and visualizations to highlight trends and optimize business processes.
• Perform complex research analysis, and reporting of large datasets.

Demonstrate commitment to the Haldimand County Code of Conduct

The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment to the job.