Database Administrator & Solutions Analyst, PFT

Job Description

Database Administrator & Solutions Analyst, Innovation & Technology Services

Posting #: NU-2024-24

Posting Period: October 31 - November 21, 2024

Employer Group: Non-Union

Reporting to: Supervisor, Business Solutions, GIS & Data

Grade: 8

Wage Range Annually: $70,689 - $86-013

Position Status: Permanent full-time

Work Hours: 35 per week

Location: Cayuga, ON (Haldimand County Administration Building)

Core Competencies

• Innovation, Creativity & 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 the 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

• Database Administration:
  • Manages database configuration including installing and upgrading software and maintaining relevant documentation
  • Develops and maintains procedures and documentation for databases,
  • Identifies, evaluates, and manages the adoption of appropriate database administration tools and processes, including automation.
  • Provide technical support to corporate project implementation
• 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.