DBA

ROSS; Mississauga; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading database solutions provider in Peel Region, Mississauga is looking for a Database Administrator to manage data modeling and ensure database stability. The ideal candidate will have DBA Certification in DB2/SQL Server, experience in Unix and .Net application development, and strong troubleshooting skills. This role involves performance tuning, policy development, and ensuring compliance with corporate data standards.

Qualifications

• DBA Certification in DB2/SQL Server is required.
• Must have training in Unix/NT.
• Experience in Web Based Application Development with VB/C# .Net.

Responsibilities

• Perform data modeling based on business requirements.
• Develop and maintain policies and standards for database development.
• Provide development support for all database application development.

Skills

DBA Certification – DB2/SQL Server

Data modeling Relational modeling and dimensional modeling

Application development and design Familiar with .Net, VB Script, T-SQL, SSIS, SSAS

Advanced troubleshooting skills for Web based environment

Education

2 years Community College Diploma or related academic computer training

Tools

DB2

SQL Server

VB/C# .Net

Job description

Key Accountabilities / Activities

1. Performs data modeling based on business requirements. Ensure the data model will be flexible enough to cater for current requirement and future needs as documented in the business requirement.
2. Develops and maintains policies and standards on areas related to database development activities.
3. Provides development support to all database application development including performance tuning. Ensure codes developed follow internal standards and executed efficiently.
4. Works closely with data steward to ensure corporate data standards are followed and no violation on the usage of data.
5. Performs technical administrative tasks relative to the environments on a daily basis to ensure the databases are accessible and stable via the applications. Provides assistance and technical support to other staff members/vendors to ensure the design and management of the databases are operational.
6. Prevents security breaches, intrusions or attacks to the environment by ensuring appropriate measures are in place to allow for auditing, alerts and reporting on a daily basis.
7. Investigates with vendor support any patches or upgrades that apply permanent fixed to current versions of software/hardware. Performs risk mitigation steps as it related to these types of changes to ensure the environments are stable on a scheduled basis.
8. Develops and maintains strategic plans for upgrades to the environments to ensure high levels of standards are achieved.

Requirements

• DBA Certification – DB2/SQL Server
• Unix/NT Training
• Web Based Application Development Training – VB/C# .Net
• 2 years Community College Diploma or related academic computer training
• Database administration Product knowledge, vendor interaction and end user support
• Data modeling Relational modeling and dimensional modeling
• Application development and design Familiar with .Net, VB Script, T-SQL, SSIS, SSAS
• Advanced troubleshooting skills for Web based environment