Senior SQL DBA — Remote, HA, Power BI Expert

Bilinguallink; Sainte-Marthe-sur-le-Lac; Hybrid; CAD 100,000 - 160,000; Full time

Job summary

Bilinguallink is seeking a Sr. Database Administrator to build, maintain, and tune production databases to meet data availability and performance goals. The role requires designing database structures, enforcing security, and guiding DBMS best practices.

Responsibilities include monitoring performance, implementing upgrades and patches, disaster recovery planning, and collaboration with development teams to optimize SQL Server environments. Hybrid remote/on-site Edmonton setup.

Qualifications

• 8+ years DBA experience in a government-scale environment.
• 2+ years MS SQL Server experience.
• 4+ years SQL Infrastructure DBA experience (Backups, replication, installation, configuration).
• 8+ years SQL Server 2016 or higher experience.
• 4+ years PowerBI, PowerView, SQL Reporting and Analytical Services knowledge.
• 4+ years SQL Server High Availability Groups experience.
• 6+ years querying data with T-SQL.

Responsibilities

• Provide technical expertise in database management systems to support development and operations.
• Create and maintain logical/physical database structures for applications.
• Monitor DBMS statistics and recommend performance improvements.
• Maintain database authorization and security standards.
• Evaluate requirements and recommend database modifications.
• Troubleshoot database and application issues.
• Perform DBMS installations, upgrades & patches.
• Disaster recovery preparation and testing.
• Develop and maintain technical documentation.
• Automate system procedures and scripting.
• Oversee ongoing operations: tuning, capacity planning, archiving, integrity checks, logs, scheduling, change control.

Skills

DBA experience

Microsoft SQL Server

Transact-SQL

PowerBI

PowerView

SQL Server Reporting Services

Analytical Services

High Availability Groups

T-SQL querying

Tools

Azure SQL

AWS databases

PostgreSQL

MySQL

CosmosDB

Job description

Bilinguallink is seeking a Sr. Database Administrator to build, maintain, and tune production databases to meet data availability and performance goals. The role requires designing database structures, enforcing security, and guiding DBMS best practices.

Responsibilities include monitoring performance, implementing upgrades and patches, disaster recovery planning, and collaboration with development teams to optimize SQL Server environments. Hybrid remote/on-site Edmonton setup.