Location: WFH – Toronto
Contract Duration: 6 months
• Business group: Seeking an intermediate Database Administrator to provide database support for MSSQL on Windows.
Story Behind the Need
• Project Summary : The main function of a Database Administrator is to provide database support on a variety of hardware and software platforms and peripherals.
Candidate Value Proposition
The successful candidate will have the opportunity for growth while working with a supportive team.
Typical Day in Role:
• Monitor the system, and act upon system and application automated alerts
• Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues
(ex. correcting installation, configuration, or data problems)
• Plan and perform software installation, configuration, upgrade and patching
• Plan and perform database configuration, maintenance, upgrade and patching
• Perform and manage system and database backups
• Perform manual switch to redundant system / database components, in case of system failure
Job Responsibilities:
– Provide on-site database and system support
– Monitor, collect statistical information, and provide reporting on capacity and system performance Based on statistics, make recommendations to maintain and improve capacity and system performance
– Monitor the system, and act upon system and application automated alerts
– Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems)
– Plan and perform software installation, configuration, upgrade and patching
– Plan and perform database configuration, maintenance, upgrade and patching
– Perform and manage system and database backups
– Perform manual switch to redundant system / database components, in case of system failure
Must Have Skills/Requirements:
1. Experience around 5 years on MSSQL data platform component deployment, monitoring, maintenance, performance and Tuning and troubleshooting.
2. Experience with MSSQL 2019/2017/2016/2014/2012 on Windows server 2016/2012/2008 and Windows 10/8/7 client operating systems.
3. Experience with SQL Always-On, mirroring, clustering and data replication.
4. Experience with MSSQL services (SSRS/SSAS/SSIS/Fulltext/Polybase/R) and OLAP.
5. Experience with SSIS packages, VB scripting, C#, Power shell
Nice to have Skills:
1. DB change management, Problem management and Incident management.
2. Database migration from Other databases ( Oracle/Sybase/DB2) to MSSQL
3. Azure SQL MI & DBaaS support
Education:
• Bachelor's degree in a technical field such as computer science, computer engineering or related field required