Database Administrator

PrecisionERP / PrecisionIT; Winnipeg; Hybrid; CAD 83,000 - 124,000; Full time

Job summary

PrecisionERP / PrecisionIT is seeking an Intermediate Database Administrator in Winnipeg, MB for a hybrid 36.25-hour work week. The contract runs 6 months with two optional 3-month extensions.

Responsibilities include developing and modifying database code, testing SQL scripts, and administering SQL Server databases with a focus on OLTP/OLAP workloads and SSIS integration.

Qualifications

• Minimum 3 years of experience as a Database Administrator.
• SQL Server experience including MS SQL Server.
• Proficiency with OLTP/OLAP concepts.
• Experience with SQL Server Integration Services (SSIS).

Responsibilities

• Develop and modify database code and SQL scripts.
• Test and validate database changes and SQL scripts.
• Administer SQL Server databases, including maintenance, backups and performance tuning.
• Support data management, integrity, and security across environments.

Skills

SQL

OLTP

OLAP

SSIS

Tools

Confluence

Jira

Basecamp

Trello

G Suites

Git

Bitbucket

PVCS

Streams

TOAD

RazorSQL

TeamDesk

TablePlus

Knack

Job description

Job Title: Database Administrator (Intermediate)

Location: Winnipeg, MB (Hybrid)

Duration: 6 months + two optional 3-month extensions

Hours: 36.25 hours/week

Job Description:

We are seeking a Database Administrator to develop and modify database code and SQL scripts, test and validate, and administer SQL Server databases.

Mandatory Requirements:

• Minimum 3 years of experience as a Database Administrator.
• SQL and Microsoft SQL Server.
• Online Transaction Processing (OLTP).
• Online Analytical Processing (OLAP).
• SQL Server Integration Services (SSIS).

Preferred Skills:

• Collaboration tools (Confluence, Jira, Basecamp, Trello, G Suite).
• Source control tools (Git, Bitbucket, PVCS, Streams).
• Database management tools (TOAD, RazorSQL, TeamDesk, TablePlus, Knack).

Additional Assets:

• IBM DB2 administration, including database/schema creation, maintenance, sizing, standards, and environment management.
• SQL database encryption and encryption key management.
• Data classification.
• Test Data Management (TDM) tools and technologies.