Job Title: Database Administrator
Location: Downtown Toronto
Duration: 12 month contract
Description:
• Business group: Global Technology Services' Enterprise Cloud Computing Operations team is seeking a Database Administrator to support day-to-day operations. They will provide database support for MSSQL and PostgreSQL on Windows and Linux. They will be responsible for providing technical support, covering database administration and operations to include monitoring maintenance capacity, performance monitoring/planning and incident/problem troubleshooting and resolution
• Reason for request: Maternity Leave
Typical Day in Role
• Provide on-site and remote database and system support 24×7
• 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
Candidate Requirements/Must Have Skills:
1) Core Database Administration (5-10 years experience in a DBA capacity)
2) MSSQL 2017/2016/2014/2012/2008R2/2008 (5+ years hands-on experience)
3) Windows server 2012/2008R2/2008 (5+ years hands-on experience)
4) Windows 10/8/7 client operating systems (5+ years hands-on experience)
5) MSSQL services and OLAP (5+ years experience with SSRS/SSAS/SSIS/Fulltext/Polybase/R)
6) FI/Banking industry experience
Nice-To-Have Skills:
– SQL Always-On, mirroring, clustering and data replication
– Application side tuning versus server side tuning
– VB, C#, Power shell, Azure Cloud
– PostgreSQL and Linux, ksh
Degrees or certifications:
• Bachelor's degree in a technical field such as computer science, computer engineering or related field required