No more applications are being accepted for this job
- 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.
- Troubleshoot 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.
- 8 to 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 PowerShell, C#, VB Scripts, SSIS, TSQL etc.
- 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.
- Good analytical, problem solving, troubleshooting and automation skills.
- Quick learner, with good communication (verbal/written) skills to be collaborate with other technical teams and business stakeholders. This includes attending meetings and sharing technical documentations.
- Post-secondary education in Computer Science, Math, or related discipline.
Database Administrator – GCP, Azure - Old Toronto, Canada - Finance Professionals Inc.
Description
JOB DESCRIPTIONLocation: Hybrid (Downtown, Toronto)
Duration:12 months
Our client a leading financial institution in Downtown Toronto is looking for a Database Administrator - GCP, Azure toassist in the team effort to maximize the availability, security, and performance of the databases.The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.
Typical Day in role:
#J-18808-Ljbffr