SQL Database Administrator
- Montreal, QC, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Experience
- At least 5 years of experience as a SQL Server DBA.
- Posting language
- English
- Posted
Original job description
We are looking for SQL Database Administrator for one of our leading clients.
Job Title: SQL Database Administrator
Job Type: Full Time/ Contract
Job Location: Montreal (Hybrid – 3 days Onsite, 2 days Remote)
Responsibilities:
- Manage SQL Server databases
- Perform Core SQL DBA tasks.
- Configure and maintain database servers and processes
- Handle Database upgrades and migrations.
- Capacity planning for databases.
- Working in Operations and handling Database alerts.
- Install, patch SQL 2016 through 2019.
- Performance tuning of Queries/applications
- Monitor system's health and performance
- Ensure high levels of performance, availability, sustainability and security
- Analyze, solve, and correct issues in real time
- Provide suggestions for solutions
- Refine and automate regular processes, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Perform scheduled maintenance and support release deployment activities after hours
Requirements and Qualifications:
- At least 5 years of experience as a SQL Server DBA.
- Experience with SQL Server Administration experience required
- Experience with Performance Tuning and Optimization (PTO)
- Hands on experience with backups, restores and recovery models
- Experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
- Critical thinker and problem-solving skills
- Team player
- Good time-management skills
Preferred Skills:
Strong experience with PowerShell and Azure
If you feel you are fit for the role or have someone in your circle with the relevant experience then please apply via LinkedIn or share your profiles with us at hr@cloudvital.ca
More about this job
Responsibilities
Manage and maintain SQL Server databases, including installation, patching, upgrades, migrations, capacity planning, backups, and recovery. Monitor database health and performance, resolve operational issues, tune queries, automate processes, and support developers and after-hours deployments.
Requirements
Requires at least 5 years of SQL Server DBA experience, including SQL Server administration, performance tuning and optimization, backups and recovery, and high availability and disaster recovery. The role also calls for problem-solving, teamwork, and time-management skills; strong PowerShell and Azure experience is preferred.
Skills
- SQL Server Administration
- Database Upgrades And Migrations
- Capacity Planning
- Database Monitoring
- SQL Server Installation And Patching
- Query Performance Tuning
- Database Security
- Troubleshooting
- Process Automation
- PowerShell
- Azure
- Backup And Recovery
- High Availability
- Disaster Recovery
- Schema Refinement
- Release Deployment
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
Keywords
- SQL Server
- SQL Server 2016
- SQL Server 2019
- Database Administration
- Database Upgrades
- Database Migrations
- Capacity Planning
- Database Operations
- Database Alerts
- SQL Server Installation
- Patching
- Performance Tuning
- Query Optimization
- Application Performance
- Database Monitoring
- Availability
- Database Security
- Troubleshooting
- Process Automation
- Backups
- Restores
- Recovery Models
- High Availability
- Disaster Recovery
- PowerShell
- Azure
- Query Tuning
- Schema Refinement
- Release Deployment