Senior Sql Database Administrator

Akkodis; Calgary; On-site; CAD 80,000 - 110,000; Full time

Job summary

Akkodis is seeking a skilled Database Administrator for a contract position in Calgary. The role involves comprehensive database administration, performance tuning, and developing disaster recovery strategies. Ideal candidates will be proficient in SQL Server technologies and Azure-SQL databases. Strong communication skills are essential for managing production outages effectively.

Qualifications

• Experience in day-to-day database administration tasks.
• Ability to troubleshoot SQL Server performance issues.
• Good communication skill to handle outages.

Responsibilities

• Perform database administration tasks with SQL Server internals.
• Optimize database performance and troubleshoot issues.
• Design and implement backup and recovery strategies.

Skills

SQL Server internals

Performance Tuning

Query Optimization

T-SQL

Disaster recovery

Azure-SQL databases

Communication

Education

MSSQL DBA Certification

Tools

SQL Profiler

PowerShell

Job description

Akkodis is seeking a Database Administrator for a contract position with a client in Calgary, AB. The ideal candidate will have experience performing day-to-day database administration tasks with a deep understanding of SQL Server internals, including indexing, partitioning, FILESTREAM, Always On, replication, CCTV integration, and mirroring technologies.

Position : Database Administrator

Long-Term Contract

Job Description

• Ability to perform day to day database administration tasks with deep understanding of SQL Server internals e.g. Indexing, partitioning , filestream , Always-On , replication cctv and Mirroring technologies.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
• Expert in T-SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and Data Transform Services (DTS).
• Expert in Log shipping with SQL Server 2012 / 2008 R2.
• Expert in setting up Snapshot and Transactional Replication
• Experience in Power shell Scripting, Partitioning
• Experience in designing databases, creating tables, views, stored procedures and Triggers.
• Worked on disaster recovery plans and Developed backup and recovery strategies for production environment
• Knowledge of relational databases, T-SQL, query execution plans, solving concurrency issues and deadlocks
• Troubleshoot and provide advice on SQL Server performance issues and be able to work with application development teams and provide recommendations.
• Strong Knowledge of administrating Azure-SQL databases.
• Good communication skill and experience to handle P1 / P2 outages.
• MSSQL DBA Certification will be added advantage.
• Knowledge on the Use of Azure Monitor, Log Analytics, and Azure Automation & Integration with PowerShell and Azure CLI will be an added advantage

Create a job alert for this search