Database Administrator - 098-WCB-26-018

Amyantek Inc.; Winnipeg; Híbrido; CAD 80 000 - 110 000; Tempo integral

Resumo da oferta

Amyantek Inc. is seeking a Database Administrator in Winnipeg, Manitoba for a 6-month contract with potential extension. Hybrid work schedule requires 25%–50% on-site presence, with mandatory on-site for at least two weeks before remote work may be considered.

36.25 hours per week. Responsibilities include creating and modifying database code and SQL scripts, testing, validation, and overall database administration.

Qualificações

• 3+ years as a Database Administrator.
• Strong SQL and MS SQL Server skills.
• Experience with OLTP/OLAP and SSIS.

Responsabilidades

• Create and modify database code and SQL scripts to meet requirements.
• Perform testing and validation and administer databases.

Conhecimentos

SQL

MS SQL Server

OLTP

OLAP

SSIS

Ferramentas

SQL Server Management Studio

Git/VC

TOAD/RazorSQL/TablePlus

Descrição da oferta de emprego

06 month contract with WCB Manitoba with a possibility of extension

Position title 098-WCB-26-018 - Database Administrator

Working Status: Hybrid – (25% to 50% on Site) - (Required to work onsite for a minimum of two (2) weeks before a remote work option may be considered)

Location: WCB's office facilities in Winnipeg, Manitoba

Hours: 36.25 hours per week

Description

The Database Administrator will create and modify database code and SQL scripts to meet requirements and specifications, perform testing and validation, and administer the databases.

Minimum Relevant Experience:

Three (3) years as a Database Administrator.

Minimum Required Skills:

• SQL;
• MS SQL Server;
• Online Transaction Processing (OLTP);
• Online Analytical Processing (OLAP);
• SQL Server Integration Services (SSIS).

Preferred Skills:

• Experience with architecture design tools (i.e. Eclipse, intelliJ, etc.);
• Experience with team collaboration tools (i.e. Confluence, Jira, Basecamp, Trello, G Suite, etc.);
• Experience with SQL Server Management Studios;
• Experience with Source Code control tools (i.e. Git, BitBucket, PVCS, Streams, etc.);
• Experience with database management tools (i.e. TOAD, RazorSQL, TeamDesk, TablePlus, Knack, etc.).

Additional Skills

• Experience with DB2
• Create and Manage DB2 databases
• Create schemas and database objects in DB2
• Run standard administrative tasks and routine maintenance tasks in DB2.
• Review sizing and growth patterns in DB2
• Implement Database standards for DB2.
• Support environment builds and management for DB2.