Job Description |
A bank in Downtown Toronto is looking for a couple of MS-SQL DBA's.
The main function of a Database Administrator is to provide database support for MSSQL and PostgreSQL on Windows and Linux.
• Provide on-site and remote database and system support 24x7
• 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 Requirements |
Qualifications:
• Bachelor's degree in a technical field such as computer science, computer engineering or related field required
• over 5 years Database Administration experience
• Experience in providing technical support, covering database administration and operations to include monitoring maintenance capacity, performance monitoring/planning and incident/problem troubleshooting and resolution
• Experience with MSSQL 2016/2014/2012/2008R2/2008
• Experience with Windows server 2012/2008R2/2008.
• Experience with Windows 10/8/7 client operating systems.
• Experience with SQL Always-On, mirroring, clustering and data replication.
• Experience with MSSQL services (SSRS/SSAS/SSIS/Fulltext/Polybase/R) and OLAP.
• Experience with application side tuning versus server side tuning.
• Experience with VB, C#, Power shell, Azure Cloud would be an asset to the role.
• Experience with use of PostgreSQL and Linux, ksh
Must Have Skills:
1) DBA within MS SQL environment with production support (over 5 years)
2) Experience with SQL Always-On, mirroring, clustering and data replication
3) Experience with MSSQL services (SSRS/SSAS/SSIS/Fulltext/Polybase/R) and OLAP
4) Experience with Windows server 2012/2008R2/2008
5) Nice to have: FI/Banking, Experience with Windows 10/8/7 client operating systems, Experience with application side tuning versus server side tuning.
, Experience with VB, C#, Power shell, Azure Cloud would be an asset to the role, Experience with use of PostgreSQL and Linux, ksh
|