Enable job alerts via email!

MSSQL DBA / Architect

APEX

Calgary

On-site

CAD 80,000 - 120,000

Full time

9 days ago

Generate a tailored resume in minutes

Land an interview and earn more. Learn more

Start fresh or import an existing resume

Job summary

Une entreprise de technologies en Alberta recherche un administrateur de bases de données MSSQL avec une expertise en performance tuning et en Azure. Ce rôle implique la gestion des bases de données, l'optimisation des requêtes, et la mise en œuvre de solutions de haute disponibilité. Le candidat idéal doit avoir d'excellentes compétences en communication et une solide expérience dans la maintenance et le dépannage des bases de données. Une certification DBA MSSQL est un atout.

Qualifications

  • Expertise en T-SQL et optimisation des requêtes.
  • Expérience en administration de bases de données SQL Server.
  • Connaissances des bases de données Azure et stratégies de récupération.

Responsibilities

  • Administration quotidienne des bases de données SQL Server.
  • Tuning de performances et gestion de la sécurité.
  • Développement de stratégies de sauvegarde et de récupération.

Skills

Performance tuning
T-SQL
Database design
Disaster recovery
Automation
Communication
Azure SQL

Education

MSSQL DBA Certification

Job description

1. 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.

2. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools

3. Expert in T-SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and Data Transform Services (DTS).

4. Expert in Log shipping with SQL Server 2012 / 2008 R2.

5. Expert in setting up Snapshot and Transactional Replication

6. Experience in Power shell Scripting, Partitioning

7. Experience in designing databases, creating tables, views, stored procedures and Triggers.

8. Worked on disaster recovery plans and Developed backup and recovery strategies for production environment

10. Knowledge of relational databases, T-SQL, query execution plans, solving concurrency issues and deadlocks

11. Troubleshoot and provide advice on SQL Server performance issues and be able to work with application development teams and provide recommendations.

12. Strong Knowledge of administrating Azure-SQL databases.

13. Good communication skill and experience to handle P1 / P2 outages.

14. MSSQL DBA Certification will be added advantage.

15. Knowledge on the Use of Azure Monitor, Log Analytics, and Azure Automation & Integration with PowerShell and Azure CLI will be an added advantage

Primary Skill Set

MSSQL Database Administrator

Performance tuning (e.g., indexing strategies, query optimization)

High availability and disaster recovery (e.g., Always On Availability Groups, log shipping)

T-SQL and scripting expert

Worked on Azure environment

Automation with SQL Server Agent

Secondary Skill Set

Backup and recovery

Security and permissions

Monitoring and alerts

Database design and normalization

Create a job alert for this search
Get your free, confidential resume review.
or drag and drop a PDF, DOC, DOCX, ODT, or PAGES file up to 5MB.