Job Opportunities Database Analyst

Are you a seasoned technical expert seeking a dynamic opportunity Join our team at the City of Regina where youll 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 youll 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.

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

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