Database Analyst Full-time Job

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.

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

Knowledge, Skills & Abilities

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

Education & Experience

• 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, Azure, and Linux would be considered an asset.

The Good Stuff

• Designated Day Off every 3rd week.
• Robust Benefits package (no waiting period!) which includes, but is not limited to:
  • Health Coverage (employer paid)
  • Dental Coverage
  • Basic Group Life & Options
  • Long Term Disability
  • Civic Pension Plan with Employer Contributions
• Supported educational programs to enhance employee knowledge and skills through our Educational Assistance Program. Options for Long-term learning programs to provide opportunities for employees to work towards a designation, degree, etc.,
• 50% off admission to City leisure facilities (Swimming, etc.),
• An inclusive and diverse work culture