SQL Database Administrator
About the role
TekStaff's Client has a current vacancy for "SQL Database Administrator"
Job Description Typical Day in Role:
- Configuration planning & deploying MSSQL servers on public cloud and on-premise
- servers.
- Performance tunning, capacity planning and monitoring.
- Database maintenance/housekeeping including database rebuilds/re-indexing/expansion and
- archiving.
- Trouble-shoot MSSQL server problems and assist in the resolution of application problems.
- MSSQL Server Software currency resolution including Patching/Upgrades/Migrations.
- Assist in database code promotions & data fixes following internal change control process.
- Disaster Recovery/High Availability (DR/HA) support with backup, recovery and
- failover/failback of local and remote replicated databases.
- Provide DBA support to development/implementation projects as assigned, doing
- installations, database loading, migrations, testing, and go live support etc.
- Follow Database best practices, security and change control process of the bank.
Candidate Requirements/Must-Have skills:
- 8-10+ years of progressive technical working experience as a Database Administrator.
- 5+ years of experience with Public Cloud including GCP Cloud SQL (MSSQL) and Azure MI/DBaaS/IaaS database administration.
- Hands on experience with MSSQL Services (SSRS/SSAS/SSIS/PolyBase, R Service, Power BI etc.) and MSSQL Instance/Database Installation/Configuration/Hardening.
- Hands on experience with MSSQL Servers 2022/2019/2017, Database Security, HA/DR, Performance & Tuning, Database Backup, and prior versions DB Administration.
- Hands on experience with Scripting and Automation with Power Shell, C#, VB Scripts, SSIS, TSQL etc.
Nice-To-Have Skills:
- Microsoft and/or Google Data Platform certification.
- Windows Servers 2019/2016 and prior versions.
- AD, Firewall IP/Port, domain trust/authentication methods related to MSSQL/Windows database connectivity.
- Application side tuning vs. server-side tuning.
- Setup MSSQL Always-On, Availability groups & Database Replication.
- Logical & Physical Backup/Recovery/Compression techniques.
TekStaff may use artificial intelligence (AI) tools as part of the applicant screening process. However, applications will also be reviewed by a member of our Recruitment team to ensure a fair and thorough assessment.
Not the right fit? Search for SQL Database Administrator jobs in Toronto, Ontario, Canada
About TekStaff IT Solutions
Just over 15 years ago TekStaff IT Solutions Inc was founded based on the need for a localized, professional staffing firm in the Greater Toronto Area. After gaining much recognition, and achieving a solid reputation, TekStaff has become a leading supplier of placement services. Today, we are acknowledged as a top leader in Canadian recruiting and have crossed borders securing contracts throughout the United States. We remain focused on developing long-term relationships with client companies and professionals looking for employment. At TekStaff, we are proud of our contributions to the business and IT industry and excited to continue assisting individuals with leveraging their careers. TekStaff family thrives in an environment of teamwork and growth. Our client-focused, professional culture focuses on continuous learning and collaboration and provides opportunities for personal and professional development. We value and encourage collegiality and work-life balance. TekStaff IT Solutions Inc. is an equal opportunity employer committed to diversity in the workplace. In addition, TekStaff IT Solutions Inc. is committed to providing accommodations for people with disabilities during the recruitment and selection process. In the event you require any accommodations, please advise us in advance and we will work with you to meet your needs.
Similar Jobs
SQL Database Administrator
About the role
TekStaff's Client has a current vacancy for "SQL Database Administrator"
Job Description Typical Day in Role:
- Configuration planning & deploying MSSQL servers on public cloud and on-premise
- servers.
- Performance tunning, capacity planning and monitoring.
- Database maintenance/housekeeping including database rebuilds/re-indexing/expansion and
- archiving.
- Trouble-shoot MSSQL server problems and assist in the resolution of application problems.
- MSSQL Server Software currency resolution including Patching/Upgrades/Migrations.
- Assist in database code promotions & data fixes following internal change control process.
- Disaster Recovery/High Availability (DR/HA) support with backup, recovery and
- failover/failback of local and remote replicated databases.
- Provide DBA support to development/implementation projects as assigned, doing
- installations, database loading, migrations, testing, and go live support etc.
- Follow Database best practices, security and change control process of the bank.
Candidate Requirements/Must-Have skills:
- 8-10+ years of progressive technical working experience as a Database Administrator.
- 5+ years of experience with Public Cloud including GCP Cloud SQL (MSSQL) and Azure MI/DBaaS/IaaS database administration.
- Hands on experience with MSSQL Services (SSRS/SSAS/SSIS/PolyBase, R Service, Power BI etc.) and MSSQL Instance/Database Installation/Configuration/Hardening.
- Hands on experience with MSSQL Servers 2022/2019/2017, Database Security, HA/DR, Performance & Tuning, Database Backup, and prior versions DB Administration.
- Hands on experience with Scripting and Automation with Power Shell, C#, VB Scripts, SSIS, TSQL etc.
Nice-To-Have Skills:
- Microsoft and/or Google Data Platform certification.
- Windows Servers 2019/2016 and prior versions.
- AD, Firewall IP/Port, domain trust/authentication methods related to MSSQL/Windows database connectivity.
- Application side tuning vs. server-side tuning.
- Setup MSSQL Always-On, Availability groups & Database Replication.
- Logical & Physical Backup/Recovery/Compression techniques.
TekStaff may use artificial intelligence (AI) tools as part of the applicant screening process. However, applications will also be reviewed by a member of our Recruitment team to ensure a fair and thorough assessment.
Not the right fit? Search for SQL Database Administrator jobs in Toronto, Ontario, Canada
About TekStaff IT Solutions
Just over 15 years ago TekStaff IT Solutions Inc was founded based on the need for a localized, professional staffing firm in the Greater Toronto Area. After gaining much recognition, and achieving a solid reputation, TekStaff has become a leading supplier of placement services. Today, we are acknowledged as a top leader in Canadian recruiting and have crossed borders securing contracts throughout the United States. We remain focused on developing long-term relationships with client companies and professionals looking for employment. At TekStaff, we are proud of our contributions to the business and IT industry and excited to continue assisting individuals with leveraging their careers. TekStaff family thrives in an environment of teamwork and growth. Our client-focused, professional culture focuses on continuous learning and collaboration and provides opportunities for personal and professional development. We value and encourage collegiality and work-life balance. TekStaff IT Solutions Inc. is an equal opportunity employer committed to diversity in the workplace. In addition, TekStaff IT Solutions Inc. is committed to providing accommodations for people with disabilities during the recruitment and selection process. In the event you require any accommodations, please advise us in advance and we will work with you to meet your needs.