Client: Government of Alberta
Work Location: 7000 - 113 ST, Edmonton Alberta, CAN, T6H 5T6,
Remote
Estimated Start Date: 15/10/2025
Estimated End Date: 15/04/2026
#Business Days: 126.00
Estimated Hours per Day: 7.25
Maximum Duration of Extension: 06 Months
Description
Project Name:
- License Compliance; Service Management; Project Backfill
Scope
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.
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 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 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.
Deliverable Details
- 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.
- 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.
Note
- Resource will work remotely, though must be available for onsite meetings when required.
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 on-site meetings, nor any expenses related to relocation, commuting, housing/accommodation, food/drink.
Eligibility and Application Steps
If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: hrsmss@smsoftconsulting.com
Without mandatory documents, we cannot submit a candidate.
- Updated Resume in word format (Mandatory)
- Skills Matrix and References (Mandatory)
- Expected hourly rate (Mandatory)
- Visa Status (Mandatory)
- LinkedIn ID (Mandatory)
Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role!
If you have any questions or need further clarification, feel free to call or text at (647) 408-1348.
