Database Administrator

Requisition ID: 249794 

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

The Team

Scotiabank’s 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 Scotiabank 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, 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.

The Database Administrator is required to work hybrid (on site and work from home) as well as to be on-call for rotational after-hours support of the bank’s databases.  The Database Administrator must be prepared to provide remote dial-in support, in response to routine monitoring alerts and scheduled & unscheduled maintenance tasks occurring after hours and on weekends.

 Is this role right for you? In this role you will:

• Configuration planning & deploying MSSQL servers/components on public cloud and on-premises 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 standards and vulnerability remediations of MSSQL servers and components.
• Involve in Database related incident management, alerts, and business as usual tasks.

Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have:

Must have skills 

• At least 5+ years of progressive technical working experience as a MSSQL Database Administrator.
• MSSQL Server 2022/2019/2017/2016 and prior versions DB Administration