Senior MS SQL Server Database Administrator to support on prem and public cloud projects for one our major banking clients- 35059
S.i. Systems
Toronto, ON-
Number of positions available : 1
- Salary To be discussed
-
Contract job
- Published on September 17th, 2024
-
Starting date : 1 position to fill as soon as possible
Description
Senior MS SQL Server Database Administrator to support on prem and public cloud projects for one our major banking clients- 35059
Location Address: Remote - Toronto
Contract Duration: 12 months
Scheduled Hours: 37.5 Hours Per Week
Story Behind the Need:
- Banks Global Technology and Enterprise Platform (GTEP) Database operations (MSSQL) team takes care of end-to-end support for Microsoft data platform products across the globe where bank is present. Physical & logical database services, from deployment, project support and after go live steady state support is the essence of what we do.
- Reporting to the DBA Manager/Lead, the Database Administrator would be supporting the MS SQL Server on-premises as well as on public cloud. As a member of the database administration group, you will assist in the team effort to maximize the availability, security, and performance of the databases.
Typical Day in Role:
- Configuration planning & deploying MSSQL servers on public mostly on cloud and on-premise servers.
- Performance tuning, 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.
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.
Best vs. Average Candidate:
- Must meet the must-have requirements.
- Previous experience working in FI with regulatory/compliance environment.
Education:
- Post-secondary education in Computer Science, Math, or related discipline.
Candidate Review & Selection
- One round interview - Hiring manager & team member (1 hour) - Teams -
- 90% of the interview will be assessing technical skills listed in the must-have requirements such as Public Cloud, Database Security, etc. and 10% will be assessing soft skills/team fit.
Requirements
undetermined
undetermined
undetermined
undetermined
Other S.i. Systems's offers that may interest you