Job Title: Database Administrator
Location: Toronto
Contract Duration: 5 months with possibility for extension based on funding and performance
Number of Positions: 2
Please do not submit the same candidates as BNSJP00011701, BNSJP00011700 or candidates that were rejected after being shortlisted or interviewed from BNSP00010734, BNSJP00011933****
Story Behind the Need
• Business group: GTS – ECCO Database Services is seeking an intermediate Database Administrator to provide database support for MSSQL on Windows.
• Reason for request: Workload/Project/Backfill
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
Qualifications:
• Bachelor's degree in a technical field such as computer science, computer engineering or related field required
• 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 2017/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
Interviews:
• 1-Step Process: 1 Technical In-Person Interview with Hiring Manager
• There may be second round interviews
• Interviews to take place ASAP
Additional Notes:
– DBAs title but they’re not actual doing the entire function – they’re only doing part of the functions
– Need someone who takes care of the entire process:
o Database Sub-tier deployment – SQL integration – installing components
o Data Platform/Application Support – DBA should know which technical services need to be provided to get the application running on the database created
o Ongoing support – after goLive, ensuring everything runs smoothly
– not looking for candidate who can only do part of function, can't just be familiar with sub-function of requirements
– need to provide end to support on databases
– need experience with SQL installation and deployment, supporting project before GoLive, working with application teams to get the database customized for the application, managing afterlife after GoLive – manage any issues that arise – need to be able to answer questions such as (need experience with at least 75% of the requirements – Manager will consider candidates who show interest and potential to learn any missing experience)