MS SQL Database Administrator - Expert
- Toronto, ON, Canada
$65 to $75 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $65 to $75 CAD / hour
- Job type
- Contract
- Apply by
- Working hours
- 37.5 hours/week
- Posting language
- English
- Posted
Original job description
MS SQL Database Administrator - Expert
Location: Toronto, ON
Onsite Flexibility: Hybrid - in office every Tuesday for the time being
Contract Details
- Position Type: Contract
- Contract Duration: 6 months (with possibility for extension or conversion to FTE, depending on budget and performance)
- Pay Rate: C$65.00–C$75.00 / Hour (CAD)
- Shift / Schedule: Monday – Friday, 9:00 AM – 5:00 PM, with a little flexibility with work hours; 37.5 hours/week. Overtime may be required; weekends may be required (on call). 1 person each week is on standby - this is a rotating person each week.
Job Summary
This role provides database support related to Oracle build, migration, performance tuning, and incident resolutions. The contractor will be embedded within a team of 20 DBAs subdivided into two sub-teams that support databases for various lines of business across Capital Market, PBBT, and Retail Banking. The team performs complex troubleshooting, code deployment, and BAU activities. This is a very independent role where strong initiative is required, and the team is known as a close-knit group with strong leadership that supports career growth and provides mentorship throughout. Core values of this team are teamwork, trust, and accountability. The candidate will be working with Solution Design, DB Engineering, Information Security teams, and external vendors.
Key Responsibilities
- 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
- 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
Required Skills
- 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
- 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 a fast-paced environment
- Good integrity
Preferred Skills
- ServiceNow Ticketing System
- SolarWind Performance Tool
- Azure Certification
- FI (Financial Institution) experience
- Medical, Vision, and Dental Insurance Plans
- 401k Retirement Fund
Important Notes
- Interview process: maximum 2 rounds of technical interviews possible with HM and team members; first round via MS Teams, second round in person on a Tuesday, ideally 2:00 PM – 4:00 PM.
About the Client
This client is a large, full-service multinational financial institution offering a comprehensive range of banking, wealth management, and capital markets products and services. It serves millions of clients across its home market and operates internationally, with significant commercial and investment banking presence in the United States and other global markets. The organization employs database administrators, software engineers, business analysts, DevOps engineers, and enterprise technology professionals who collaborate across teams supporting capital markets, retail banking, and institutional client services.
About GTT
GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company in Alaska. We highly value diverse and inclusive workplaces and support Fortune 500 organizations across banking, financial services, technology, life sciences, biotech, utilities, and retail sectors throughout the U.S. and Canada.
Job Number: 26-11759 Industry: Software Engineering
More about this job
Responsibilities
Lead technical resolutions for production database incidents, communicate complex issues to stakeholders, and support change control, on-call operations, disaster recovery, and root cause analysis. Install, configure, secure, maintain, and optimize Oracle and SQL Server databases, including performance tuning, high availability, disaster recovery, and automation.
Requirements
Requires 5–7 years of Azure cloud database experience focused on Microsoft SQL Server, plus two years of PostgreSQL experience. Candidates should have database setup and configuration, tuning, monitoring, troubleshooting, cloud migration, backup and recovery experience, along with strong problem-solving, communication, teamwork, and customer-service abilities.
Skills
- Microsoft SQL Server
- PostgreSQL
- Oracle Database Administration
- Database Installation and Configuration
- Database Performance Tuning
- Query Optimization
- Database Monitoring and Troubleshooting
- Cloud Migration
- Database Backup and Recovery
- Database Security
- High Availability and Disaster Recovery
- Database Automation
- Incident Management
- Root Cause Analysis
- Communication
Benefits
- Medical Insurance
- Vision Insurance
- Dental Insurance
- 401(k) Retirement Fund
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Finance & Accounting
Keywords
- Azure Cloud
- Microsoft SQL Server
- PostgreSQL
- Oracle
- Database Administration
- Database Installation
- Database Configuration
- Performance Tuning
- Query Optimization
- Database Monitoring
- Troubleshooting
- Cloud Migration
- Backup and Recovery
- Database Security
- Transparent Data Encryption
- Data Redaction
- Oracle Database Vault
- Always Encrypted
- High Availability
- Disaster Recovery
- Automation
- Incident Management
- Change Control
- Root Cause Analysis
- ServiceNow
- SolarWinds
- Azure Certification
- Financial Institution
- Capital Markets
- Retail Banking