Database Administrator (MS SQL/Azure)
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
Rate: $70.00 – $78.00 /hr Inc.
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 CIBC standards for change control and overall database security policies
– Analysing 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 Azure Cloud database (Focus on MSSQL)
– Experience with PostgreSQL – 2+ years
– 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
Soft Skills
Strong critical thinking, problem solving and communication skills Demonstrated ability to work collaboratively in a team Demonstrated ability to deliver results and provide good customer experience Thrive in fast paced environment Good integrity
More about this job
Responsibilities
Lead technical resolutions for production database incidents, communicate complex issues to stakeholders, and participate in operational changes, on-call support, disaster recovery activities, and post-incident reviews. Install, secure, monitor, and optimize Oracle and SQL Server databases, while automating maintenance and supporting high availability and disaster recovery strategies.
Requirements
Candidates must have 5–7 years of Azure database experience focused on Microsoft SQL Server, at least 2 years of PostgreSQL experience, and experience installing, configuring, tuning, monitoring, and troubleshooting databases. Cloud migration experience and knowledge of database backup, restore, and recovery are also required; Azure certification and financial institution experience are considered assets.
Skills
- Azure Database Administration
- Microsoft SQL Server
- PostgreSQL
- Oracle Database
- Database Installation and Configuration
- Database Performance Tuning
- Query Optimization
- Database Monitoring
- Database Troubleshooting
- Cloud Migration
- Backup and Recovery
- Database Security
- Disaster Recovery
- High Availability
- Incident Management
- Communication
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Security & Safety
Keywords
- Azure
- Microsoft SQL Server
- PostgreSQL
- Oracle
- Database Administration
- Database Engineering
- Cloud Migration
- Query Tuning
- Indexing
- Performance Optimization
- Database Monitoring
- Database Security
- User Access Control
- Encryption
- Auditing
- Transparent Data Encryption
- Data Redaction
- Oracle Database Vault
- Always Encrypted
- Oracle RAC
- High Availability
- Disaster Recovery
- Backup and Recovery
- Incident Management
- Change Control
- Root Cause Analysis
- ServiceNow
- SolarWinds
- Azure Certification
- Financial Institutions