Senior Database Administrator

GuuZ Consulting Services Inc; Edmonton; Hybrid; CAD 85,200 - 142,000; Full time

Job summary

An established industry player is seeking a Senior Database Administrator to enhance database operations for a government client. This role involves optimizing SQL Server environments, ensuring data availability, and implementing robust security measures. You will leverage your extensive experience in database management to support critical applications and provide technical expertise across teams. The position offers a blend of operational responsibilities, including performance tuning, disaster recovery planning, and database monitoring. If you thrive in a dynamic environment and are passionate about optimizing database systems, this opportunity is perfect for you.

Qualifications

• 8+ years of DBA experience in a public service environment.
• Expertise in Microsoft SQL Server and Transact-SQL.

Responsibilities

• Build and maintain production databases for optimal performance.
• Monitor and recommend changes for database applications.

Skills

Microsoft SQL Server

Transact-SQL

Database Performance Tuning

Database Security Standards

Disaster Recovery

PowerBI

SSIS

Cloud Migration

Tools

Microsoft SQL Server 2016

Azure SQL

Amazon Web Services

PostgreSQL

MySQL

MariaDB

CosmosDB

Job description

Our government client is looking to contract a Senior Database Administrator to join their team to work on several projects intended to optimize database operations that impact most applications across the operations of the government entity. These projects include:

• Reviewing and consolidating SQL Server licensing costs or reducing licensing costs in the long term.
• Implementing Database monitoring for the vast majority of the public sector database environment.
• Creating new reporting and/or reporting options to highlight and elevate critical database issues to management.

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 ongoing operations and perform ongoing 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.

As this is an operational role and not a project-specific role, the deliverables and due dates will be created on an as-needed basis depending upon the skills of the acquired resource.

Requirements - Experience

• 8 years of DBA experience within an environment of similar size and complexity of public service entity.
• 2 years of experience and technical knowledge of Microsoft SQL Server.
• 4 years of experience as a SQL Infrastructure DBA (Backups, replication, installation, configuration).
• 8 years experience with Microsoft SQL Server 2016 or higher.
• 4 years experience with PowerBI, PowerView, Microsoft SQL Reporting, and Analytical Services.
• 4 years experience with SQL Server High Availability Groups.
• 6 years experience working with querying data with Microsoft Transact-SQL Server.
• 1 year of experience with SSIS, Azure SQL, Amazon Web Services, migrating on-prem databases to cloud (Azure or AWS).
• 1 year experience with open-source databases such as PostgreSQL, MySQL, MariaDB, CosmosDB, etc.

Location

Edmonton/Remote

Contract

6 months contract with a potential of another 6 months extension.

Hourly Rate

$45 to $75 per hour (Negotiable)