Remote Sr. Database Administrator - GOAPRDJP00000706

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

Sr. Database Administrator – GOAPRDJP00000706

9942 – 108 ST
Edmonton

Remote work –however, in the event of an on-site meeting

Standard Background &Enhanced Background check required

This role is responsible for building, maintaining, and performance tuning production databases to deliver databases with appropriate levels of data availability and performance. This role is also responsible for developing, implementing, and overseeing database procedures and standards.

• Provide technical expertise in database management systems to support systems development and operational activities.
• Create and maintain the logical and physical structures of databases and related structures required by database applications.
• Monitor database applications, databases and DBMS statistics and recommend the appropriate changes to improve performance.
• Maintain database authorization requirements.
• Maintain and enforce database security standards and procedures.
• Evaluate application and user requirements and recommend appropriate database modifications.
• Provide technical expertise to development teams, Application Maintenance Services and business teams if engaged.
• Perform troubleshooting activities for database problems, database software problems and database application problems.
• Perform DBMS software installations, plan and test upgrades.
• Plan, test and implement software patches and application updates or upgrades.
• Disaster recovery preparation and testing.
• Develop and maintain technical documentation.
• Develop and automate system related procedures.
• Perform problem diagnosis, troubleshooting and resolution.
• Monitor on-going operations and perform on-going system administration tasks: release new versions; database tuning; capacity planning; historical archiving; database consistency and integrity checking; log file analysis; job scheduling; scripting; indexes; reorganizations; change control; and server requirements analysis.

Must-Have’s:

• DBA experience within an environment of similar size and complexity of Government of Alberta –8 years
• Experience and technical knowledge of Microsoft SQL Server –2 years
• Experience as a SQL Infrastructure DBA (Backups, replication, installation, configuration) –4 years
• Experience with Microsoft SQL Server 2016 or higher –8 years
• Experience with PowerBI, PowerView, Microsoft SQL Reporting, and Analytical Services –4 years
• Server High Availability GroupsExperience with SQL Server High Availability Groups –4 years
  
• Experience working with querying data with Microsoft Transact-SQL Server –6 years

Nice-to-Have’s:

• Experience withAmazon Web Services databases –1 years
• Experience with Azure SQL–1 years
• Experience with migrating on-premise databases to Azure or AWS –1 years
• Experience with open-source databases such as PostgreSQL, MySQL, MariaDB, CosmosDB, etc. –1 years
• Experience with PowerBI querying Azure SQL –1 years
• Experience with SQL Server Integration Services –1 years
• Experience with SQL Server replication –4 years
• Experience with troubleshooting performance issues within SQL Server 2016 or higher –2 years
• Experience working in a Help Desk type of environment where the work is delivered through a ticket or email –4 years
• Experience working in a multi-tenancy environment where developers do not have access to secured environments like User Acceptance Test or Production –4 years
• Experience working with Oracle 19c or higher –1 years