Database Administrator - Senior

Project Name:
License Compliance; Service Management; Project Backfill

Project Overview

The Database Administration team is in the process of working on several large projects intended to optimize database operations. These projects are longrunning 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.

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 GOA database environment.
Creating new reporting andor 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.

Deliverable Details:

As this is an operational role and not a projectspecific role the deliverables and due dates will be created on an asneeded basis depending upon the skills of the acquired resource.

IMT recruit for specific needs. However if this original need changes IMT reserves the right to allocate this role across projects within the program and/or information technology service based on approved business program plans and funding aligning to the Sector s priorities.

Equipment requirements:
Resource will require own equipment

Resource must provide their own computer and related equipment. The computers operating system must be a modern version of Windows or MacOS that is compatible with Azure Virtual Desktop (AVD) and related software for remote access. Windows is preferred due to better compatibility. AVD/remoterelated software will be installed on the resources computer.

In the event that the Contractor s resources are directed to work remotely the Contractor shall be responsible for providing all of its equipment including computers software printers supplies desks and chairs. However the Province shall ensure that the Contractor s resources have the necessary access and credentials to the Government of Alberta s system.

In the event that the Contractor s resources are directed to work inperson the Province shall provide the requisite office space furniture and office supplies. However the Contractor shall continue to be responsible for providing computers and software and the Province shall continue to ensure that the Contractor s resources have the necessary access and credentials to the Government of Alberta s system.

The fixed rate quoted must be inclusive of all overhead office space and equipment including supplies administrative burden markup and all other costs to perform the Services for the duration of the Contract.

Working Hours:
Standard Hours of work are 08:15 16:30 Alberta time Monday through Friday excluding holidays observed by the Province
Work must be done from within Canada due to network and data security issues.
It is anticipated the role will be 100% remote however in the event of an onsite meeting the GoA does not pay for travel to attend onsite meetings nor any expenses related to relocation commuting housing/accommodation food/drink.

Notes on Location:
Resource will work remotely though must be available for onsite meetings when required.

Onsite meetings include but are not limited to strategic architectural and technical discussions meeting with team members senior managers directors executive directors and business clients. Frequency of meeting could be up to 34 times per month.

Incumbency:
Previously this role was filled by a contractor however for this and all other opportunities the Ministry seeks the best person to fill the role.

Standard Background check required
The Supplier shall prior to commencement of the Services provide the Province on its request and at no cost to the Province with criminal record checks.

Enhanced Background check required
A standard criminal record check will be required before we start the Enhanced Security Clearance process.
An Enhanced Security Clearance will be required for this position which will be coordinated by GoA only for this position.

Mandatory Training Courses:
Once hired the resource will be required to complete all mandatory training which includes but not limited to Freedom of Information and Protection of Privacy Act and Security awareness training. There may also be some optional courses as well.

Anticipated Interviews dates
will be held between Oct 12
Refer to the Job Posting attachments for the proposed form of contract applicable to this Contingent Resource Request

Scoring Methodology:
Financial/Pricing: 20%
Resource Qualifications: 20%
Interview Process: 60%

SUBMISSION MUST INCLUDE:
RESUME
ALL REQUIRED EXPERIENCE MUST BE DESCRIBED IN RESUME UNDER THE JOB/PROJECT WHERE EXPERIENCE WAS ATTAINED.
EACH JOB/PROJECT MUST CONTAIN THE TERM OF THE JOB/PROJECT IN THE FORMAT MMM/YYYY to MMM/YYYY.
RESOURCE REFERENCES
o Three references for whom similar work has been performed must be provided. The most recent reference should be listed first. Reference checks may or may not be completed to assist with scoring of the proposed resource.

Yes/No The proposed resource must meet or exceed one of the following combinations of...

Other Eligibility for Enhanced Security Clearance Yes/No

Duration DBA experience within an environment of similar size and complexity of Government of...

8 years

Duration Experience and technical knowledge of Microsoft SQL Server.

2 years

Duration Experience as a SQL Infrastructure DBA (Backups replication installation configuration)

4 years

Duration Experience with Microsoft SQL Server 2016 or higher.

8 years

Duration Experience with PowerBI PowerView Microsoft SQL Reporting and Analytical Services.

4 years

Duration Experience with SQL Server High Availability Groups

4 years

Duration Experience working with querying data with Microsoft TransactSQL Server.

6 years

Yes/No Ability to manage stress and conflict.

Yes/No Excellent verbal and written communication skills and the ability to interact...

Yes/No The ability to establish and maintain effective working relationships with team members...

Yes/No The ability to learn quickly problem solve/troubleshoot work independently and in a team.

DurationExperience with Amazon Web Services databases

1 years

Duration Experience with Azure SQL

1 years

Duration Experience with migrating onpremise databases to Azure or AWS

1 years

DurationExperience with opensource databases such as PostgreSQL MySQL MariaDB CosmosDB etc.

1 years

DurationExperience with PowerBI querying Azure SQL

1 years

DurationExperience with SQL Server Integration Services

1 years

Duration Experience with SQL Server replication

4 years

Duration Experience with troubleshooting performance issues within SQL Server 2016 or higher.

2 years

DurationExperience working in a Help Desk type of environment where the work...

4 years

DurationExperience working in a multitenancy environment where developers...

4 years

DurationExperience working with Oracle 19c or higher

1 years