Senior Cloud SQL Database Administrator
Location : Toronto, ON - (Remote)
Contract Length : 12 months.
We at Raise are hiring a Senior Cloud SQL Database Administrator for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising demand.
We’re hiring right now; if you’re interested, apply below for your chance to join a great place to work.
Responsibilities :
- 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.
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.
- Previous experience working in Financial Industry with regulatory / compliance environment.
Education :
- Post-secondary education in Computer Science, Math, or related discipline.
Il y a 23 heures