Database Administration

Role : Database Administration

Location : Edmonton, AB Remote

Type : Contract

Project Overview

The Database Administration team is in the process of working on several large projects intended to optimize database operations. These projects are long-running and could potentially impact most applications across the GOA. The effort needed, per application, can be quite large and can impact operational duties of the team. By acquiring contingent labor the team will be able to provide more effort in these initiatives and avoid costs faster or even reduce licensing costs overall. This resource will provide the labor while the staff members will provide the strategy and tactical thinking necessary to succeed.

Required Experience

8+ years of DBA experience in large or government-scale environments.

8+ years with Microsoft SQL Server (2016 or higher).

4+ years as a SQL Infrastructure DBA (backups, replication, installation, configuration).

4+ years with Power BI, PowerView, SSRS, and SSAS.

4+ years with SQL Server High Availability Groups.

6+ years with Microsoft Transact-SQL.

Eligibility for Enhanced Security Clearance (mandatory).

Nice to Have

Experience with AWS and Azure SQL databases.

Experience with open-source databases (PostgreSQL, MySQL, MariaDB, CosmosDB).

Experience migrating on-prem databases to cloud (AWS / Azure).

SQL Server Integration Services and replication experience.

Familiarity with Power BI querying Azure SQL and Oracle 19c+.

Duties :

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.

Please share your updated resume at shweta.sharma@msrtechnologies.com