Database Administrator

Job Description

Database Administrator:
On behalf of our public sector client, Procom is searching for a Database Administrator for a 6-month role. This position is a hybrid position with 2 days onsite at our client’s Winnipeg office.

Job Description:
The Workers Compensation Board (WCB) requires a Database Administrator to create and modify database code and SQL scripts to meet specific requirements and specifications. The role involves testing, validation, and administration of databases, which may include both existing platforms and new developments.

Responsibilities:
• Create and modify database code and SQL scripts to meet requirements and specifications
• Test and validate database code and scripts
• Administer the databases
• Create and manage DB2 databases, build schemas and objects, run routine maintenance, and review sizing and growth

Mandatory Skills:
• Three years of experience as a Database Administrator
• Proficiency in SQL
• Experience with MS SQL Server
• Knowledge of Online Transaction Processing (OLTP)
• Understanding of Online Analytical Processing (OLAP)
• Experience with SQL Server Integration Services (SSIS)

Nice-to-Have Skills:
• Experience with architecture design tools (e.g., Eclipse, IntelliJ)
• Familiarity with team collaboration tools (e.g., Confluence, Jira, Basecamp)
• Experience with SQL Server Management Studio
• Experience with source code control tools (e.g., Git, BitBucket)
• Experience with database management tools (e.g., TOAD, RazorSQL)

Assignment Length:
This is a 6-month contract with the option to extend twice, up to 3 months each time.

Start Date:
ASAP

Assignment Location:
Winnipeg, Manitoba, Canada. This is a hybrid role requiring 2 days onsite per week.