Database Administrator - Toronto, Canada - Arthur Grand Technologies Inc

Arthur Grand Technologies Inc

Verified Company

Toronto, Canada

4 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Position:
Database Administrator - Senior

Location: 595 Bay Street,, Toronto, Ontario

Duration:
Long Term Contract

MUST HAVES:

MANDATORY REQUIREMENTS:

At least 5 years of experience with:

Oracle RDBMS 11-12 in a Windows environment and SQL Server RDBMS
Database installation, upgrade, monitoring, troubleshooting, performance tuning, backup and recovery.

Expertise required with standard database development tools and utilities:
TOAD, SQL Server Management Studio, TFS

SQL Server Integration Services and SQL Server Reporting Services

SKILLS AND KNOWLEDGE:

5+ years' experience and expert knowledge of Oracle RDBMS 1112 in a Windows environment and SQL Server RDBMS
5+ years' experience in database installation, upgrade, monitoring, troubleshooting, performance tuning, backup and recovery.

Expertise required with standard database development tools and utilities:
TOAD, SQL Server Management Studio, TFS

5+ years' experience in using SQL Server Integration Services and SQL Server Reporting Services
Extensive handson experience and expert knowledge with designing and developing data warehouses and data marts.
Extensive knowledge of Windows Server 2012 and later, Windows 10 and later
Extensive knowledge of data and information architecture
Proven analytical and problemsolving skills to provide technical solutions for business requirements; provide technical solutions to infrastructure related issues
Knowledge of IT Service Management best practices (Change, Configuration, Problem and Incident Management).
Excellent oral and written communication skills

Experience and Skill Set Requirements

CRITERIA:

Criteria - Database Administration

Demonstrated experience working within operation systems environments such as Windows 10, Windows Server 2012/201
Demonstrated experience administering database management systems such as SQL Server & Oracle 111
Demonstrated experience in creating user profiles and ensuring system security by allocation of user permissions.
Demonstrated experience in backup and recovery strategy for the database, and regularly testing the backups to ensure usability.

Criteria - Database Development

Demonstrated experience with designing and developing data warehouse and data marts
Demonstrated experience with TOAD, SQL Reporting Services, TFS, VISIO and Share Point
Demonstrated experience in monitoring and optimizing the database's performance using either manual or automated tools

Criteria - SQL Reporting

Demonstrated experience in writing, changing, maintaining and supporting Reports using SQL Reporting Services, SQL Reporting Services deployment and portal customization
Demonstrated experience in producing complex report designs and conducting implementation including drilldown and charting

Criteria - Analytical and Communications Skills