Database Analyst

Inclusionregina; Regina; Hybrid; CAD 70,000 - 110,000; Full time

Benefits offered by this job

Health benefits

Educational support

Job summary

City of Regina seeks an experienced database administrator to advise on selection, installation, and maintenance of corporate databases. You'll ensure seamless software operation and contribute to a dynamic IT team with responsibilities that include monitoring, documentation, and upgrades.

The role may require on-call duties and irregular shifts. Strong knowledge of Oracle/SQL databases and Linux is expected, with a focus on reliability and continuous improvement.

Qualifications

• University degree in Computer Science or related field or a 2-year diploma with systems analysis training and 3+ years in technical support.
• Knowledge of information resource management and data administration theory and tools.
• Experience with programming, analytics, and system development processes.
• Ability to install, configure, and manage database software and user access.
• Strong problem solving and analytical skills to define problems and recommend solutions.
• Ability to work independently within a team with sound judgment and initiative.
• Effective written and oral communication with stakeholders.

Responsibilities

• Provide technical support for database systems, monitor performance, troubleshoot, and maintain.
• Develop timelines and budgets for projects.
• Document corporate database procedures and logs.
• Follow ITIL framework for IT service management.
• Install new software products and ensure smooth deployment.
• Develop standards and procedures for database operations.
• Plan and implement new database and related software/hardware.
• Evaluate new database technologies and propose enhancements.
• Perform related duties as required.

Skills

Database administration

ITIL framework

Problem solving

Independent work

Communication skills

Systems analysis

SQL concepts

Linux

Education

University degree in Computer Science or related

Two-year Diploma in Computer Information Systems

Tools

Oracle

SQL Server

MySQL

PostgreSQL

Azure

Linux

Job description

Select how often (in days) to receive an alert:

We are proud to reside on Treaty 4 Territory and the traditional lands of the Cree, Saulteaux, Dakota, Nakota, Lakota, and Métis Nation, honoring and respecting these Nations and ancestors of this territory and grateful to be here. Regina is committed to building trust and creating true partnerships with Indigenous peoples.

Equity, Diversity & Inclusion

The City of Regina is an equal opportunities employer dedicated to fostering a respectful, collaborative, inclusive, and barrier-free workplace, allowing everyone to achieve their full potential. We value diversity as a key to our success and encourage all qualified candidates, including Indigenous peoples, people of colour, 2SLGBTQIAP+ individuals of all genders, people of disabilities, and members of equity-deserving communities, to apply.

The City of Regina is committed to ensure accessible and accommodating processes during the application and selection phases. If you need accommodation at any point during the recruitment process, please inform our Talent teamand we'll collaborate with you to address your requirements.

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.

Additional Requirements:

• Successful candidates may be required to provide a satisfactory criminal record check per the City of Regina's Criminal Record Check Policy.
• Proof of education is required.
• Additional assessments may be conducted to evaluate competencies, skills, and knowledge.

At City of Regina, we offer competitive compensation, health and wellness benefits, and growth through educational support and in-house courses.

Note: Only applications submitted via our online application system are accepted