25-067- Database Administrator 1

City of Maple Ridge; Maple Ridge; On-site; CAD 60,000 - 90,000; Full time

Job summary

An exciting opportunity awaits in the Information Technology Department for a Temporary Full-Time Database Administrator 1. This role involves supporting a large-scale ERP implementation project by planning, designing, and optimizing corporate database systems. You will collaborate with various stakeholders to ensure seamless data transfers and system integrations, while also managing database performance and upgrades. Join a forward-thinking municipality that values diversity and offers competitive compensation, professional growth opportunities, and a commitment to service excellence.

Benefits

Municipal Pension Plan

Employee wellness program

Professional growth opportunities

Qualifications

• Bachelor's degree in Computer Science with database management courses.
• Experience in a municipal environment is preferred.

Responsibilities

• Support ERP implementation by managing corporate database systems.
• Ensure data consistency, security, and compliance during migrations.

Skills

Database Management

Data Migration

System Integration

Data Analysis

Communication Skills

Education

Bachelor's degree in Computer Science

Tools

MS Azure DBaaS

Job description

Database Administrator 1

POSITION OVERVIEW

We have an exciting opportunity in our Information Technology Department for a Temporary Full-Time Database Administrator 1. Reporting to the Project Manager, ERP System, you will play a key role in supporting a large-scale ERP implementation project. This includes planning, designing, developing, installing, monitoring, and optimizing the City’s corporate database systems, with a focus on data migration and integration, particularly between financial, HR, and other critical systems.

You will collaborate with internal and external stakeholders to deliver business technology solutions, ensuring seamless data transfers and system integrations during the ERP implementation. This includes developing strategies for data management, maintenance, environment growth, and the implementation of new technologies such as MS Azure DBaaS. Additionally, you will perform tests, maintain database performance, and manage upgrades to replace aging business systems.

You will ensure proper resource allocation (disk space, memory, CPU, etc.) and recommend changes to optimize performance. Maintaining accurate test, development, and staging environments to match production will also be key. You will compile and maintain documentation on existing and proposed database environments and work with IT teams to implement and support database technologies. You will also assist with data modeling and development, ensuring optimized design, data consistency, security, and compliance with privacy policies during migration and integration phases of the ERP project.

EDUCATION AND EXPERIENCE

Bachelor’s degree in Computer Science, including or supplemented by courses in database management and administration, plus sound related experience preferably in a municipal environment; or an equivalent combination of training and experience.

KNOWLEDGE, SKILLS AND ABILITIES

• Thorough knowledge of problem definition and analysis related to business processes and systems planning.
• Considerable knowledge of the principles and techniques associated with database fundamentals, including administration, development, and design and management.
• Considerable knowledge in establishing standards, procedures, and policies that ensure the integrity, security, availability, and recovery of all data resources.
• Considerable knowledge of the operating techniques and procedures used in server installations and upgrades and computer installation.
• Considerable knowledge of the operations and functions of departments served and their requirements as applied to the work performed.
• Ability to analyze and evaluate data requirements and to prepare recommendations regarding the advisability and feasibility of incorporating changes or additions to the corporate data model.
• Ability to prepare detailed designs for all databases including physical and logical data structures, and to control shared usage of data throughout the corporation to maintain optimal performance.
• Ability to read and understand computer programs, combining creativity with technical and analytical elements with a focus on continuous improvement.
• Ability to establish and maintain effective working relationships with a variety of contacts and to provide advice and assistance on matters related to the work.
• Ability to communicate effectively orally and in writing.

Additional Information: This is a 1-year temporary assignment. Duration may be shortened or extended based on organizational needs.

EQUITY STATEMENT

At the City of Maple Ridge, we are dedicated to cultivating an inclusive culture that actively values and embraces diversity. We strive to attract and retain a talented, diverse workforce that is broadly reflective of the community we serve. Accommodations are available on request for candidates taking part in all aspects of the selection process by contacting [e-mail].

WHAT WE OFFER YOU

The City of Maple Ridge offers competitive compensation packages, including the Municipal Pension Plan, a strong employee wellness program, and opportunities for professional growth and development. If you want to help shape a growing community in a municipality that strives for service excellence, then this is the position for you. We thank all applicants for their interest; however, only those under consideration will be contacted.