Senior SQL Database Administration to provide database support for Oracle builds, migration, performance tuning and incident resolutions - 90145-1

Position Title: SR. SQL DBA

Duration: 6 months

Location: 81 Bay 16th Floor, Hybrid -

Hybrid Model: In office every Tuesday for the time being.

Work Schedule: Monday - Friday, 9:00 am - 5:00 pm. 37.5hours/week. Overtime may be required; weekends may be required (on call) *1 person each week is on standby - this will be a rotating person each week.

Project the contractor will be working on: providing database support related to Oracle build, migration, performance tuning and incident resolutions.

The Candidate will Be Working with: Solution Design, DB Engineering, Information Security teams and external vendors.

Daily Job Duties/Activities:

- Taking ownership of and leading technical resolutions for production incidents

- Communicating clearly complex technical issues to stakeholders and Lines of Business partners

- Complying with The Bank's standards for change control and overall database security policies

- Analyzing recurring incidents and identifying service improvements where possible

- Providing on-call rotational/pager support where required

- Participating in Incidents and Changes as part of BAU Operational activities

- Participating in Scheduled Disaster Recovery or SCM activities

- Participating in post-mortems and RCAs (Root Cause Analysis) of critical incidents

Install, configure, and maintain Oracle and SQL Server databases.

Optimize database performance, including indexing, query tuning, and resource management.

Ensure database security by implementing best practices for user access control, encryption, and auditing.

Implement native security features in Oracle (TDE, Data Redaction, Database Vault) and SQL Server (TDE, Always Encrypted).

RAC, high availability (HA), and disaster recovery (DR) strategies.

Automate database monitoring and maintenance tasks.

Must Haves:

- 5-7 years of experience in SQL as DBA

- MS SQL experience

- POSTGRE experience

- Setup/Installation and configuration of DB products

- Experience in Tuning, Query Optimization, Monitoring and Troubleshooting database issues

- Cloud migration experience

- Exhibit knowledge of DB backup restore and recovery

Nice to have:

- ServiceNow Ticketing System

- SolarWind Performance Tool

- Azure Certification

- FI experience