Database Analyst

Position Summary

Are you a seasoned technical expert seeking a dynamic opportunity? Join our team at the City of Regina, where you'll play a pivotal role in advising and supporting the selection, installation, and maintenance of our corporate databases. As a key member of the Technology team, you'll be responsible for the seamless operation of software and have the chance to demonstrate your expertise while enjoying the challenges of a role that demands excellence around the clock. Embrace the opportunity to work in a dynamic environment where no two days are the same, and where your skills will be valued and rewarded.

Note: This position may be on call and may be required to work irregular shifts from time to time.

Key Duties & Responsibilities

• Provides technical support to Client Departments in the effective use of their database systems including monitoring overall performance, troubleshooting, modification, improvement and maintenance.
• Develops and monitors time-lines and budgets for projects.
• Develops and maintains documentation of all corporate database procedures, problem logs and solutions.
• Follows ITIL framework with respect to IT Service Management.
• Responsible for the effective installation of new software products
• Assists in the development of standards and procedures for all database operations.
• Assists the development of implementation plans for new database and database related software and hardware.
• Assists in the evaluation of new technological advancements in database hardware and software and participates in recommending modifications and enhancements.
• Performs related duties as required.

Key Qualifications

• Typically the knowledge, skills, and abilities required are obtained through a University degree in Computer Science (or other related discipline) -or- a two (2) year diploma in Computer Information Systems from a recognized post-secondary institution coupled with formal training in systems analysis and design. In addition, a minimum of three (3) years’ experience in a technical support role within a computer services environment with one (1) year directly related to the duties and responsibilities specified. Experience in Oracle and SQL Server, MySQL, PostgreSQL, Azure, and Linux would be considered an asset.
• Knowledge of information resource management and data administration theory, concepts, techniques and tools.
• Knowledge of programming and analytical techniques, systems development processes, and innovations in systems and database technology.
• Ability to install database software, create and configure databases, load and manage data for all databases, set up and manage user access and accounts, manage routine activities, such as backups, upgrades, patching, monitoring and performance checks.
• Demonstrated problem solving skills and ability to apply principles of logical thinking to define problems, analyze, evaluate and interpret information and make effective recommendations.
• Ability to work independently with minimal supervision in a team environment, demonstrating sound judgement and initiative to establish priorities, meet users’ expectations and meet deadlines.
• Ability to communicate effectively both orally and in writing demonstrated tact and diplomacy in order to establish effective working relationships with external and internal stakeholders as necessitated by work assignments.