Mssql Dba Jobs in Toronto, Ontario, Canada
Create alert for “MSSQL DBA”
Toronto, Ontario, Canada
About the role
An Initial AI Screening will be conducted for this role.
Contract Duration: 6 months
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
- 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
- 8+ years Database Administration experience with MSSQL (combined experience with the following 2022/2019/2017/2016/2014/2012)
- 8+ years experience in providing technical support, covering database administration and operations to include monitoring maintenance capacity, performance monitoring/planning and incident/problem troubleshooting and resolution
- 5+ years of Experience with SQL Always-On, mirroring, clustering and data replication, and experience with MSSQL components (SSRS/SSAS/SSIS/Fulltext/Polybase/R).
- 3+ years of Experience with application side tuning versus server-side tuning
- 5+ years of Experience with Windows server 2012/2016/2019
Nice-To-Have Skills
- Experience with Windows 10/8/7 client operating systems.
- Experience with VB, C#, Power shell, Azure Cloud
- Experience with use of PostgreSQL and Linux, ksh
- Experience providing DBA support for Public Cloud MSSQL offerings such as Azure MI, Azure SQL Databases, and GCP Cloud SQL MSSQL.
Soft Skills Required
- Strong Communication skills
- team player
- Time management skills
Education: Bachelor's degree in a technical field such as computer science, computer engineering or related field required
FP Inc. is committed to creating an inclusive environment where all team members and clients feel like they belong. In accordance with the requirements set out in the Employment Standards Act, FP Inc. hereby declares that AI is utilized in the screening process for this position. The compensation range for this role is C$50-69/hr. We seek applicants with a wide range of abilities, and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, colour, religion, national origin, sex, physical or mental disability, or age.
Not the right fit? Search for MSSQL DBA jobs in Toronto, Ontario, Canada
About Finance Professionals Inc.
WHO WE ARE
We are a specialist FinTech and Financial Services recruitment consultancy. We have been helping clients attract, hire and retain staff across all areas from technology to finance. By being specialists in our sectors, we are able to use our deep and active network of professionals to quickly match the best people with great permanent and contract job opportunities.
WHAT WE DO:
We deliberately work on a small number of assignments allowing us the time to deeply search for talent for your business. By partnering with an excellent client base including Banks, Financial Services Firms, FinTech companies at various stages and established multinationals, we are able to present compelling career opportunities to industry professionals.
SECTORS WE WORK IN: -FinTech -Infrastructure -Financial Systems -Banking & Securities -Wealth Management & Advisory -Fund Management -Fund Services -Payment Services -Financial Services -Insurance -Real Estate Investment Trusts -Real Estate Development -Construction Finance and Private Equity
SKILLS WE PLACE: -Accounting & Finance -Banking Operations & Middle Office -Risk & Compliance -Fund Accounting -PMO -Business Analysts -IT Manager -Cloud Professionals -DBA -Data Specialists -Design -QA & Testing -Developers