The Bidder must demonstrate that the proposed resource has a minimum of 10 years experience within the last 15 years, at the time of solicitation closing, performing all of the Database Administrator tasks outlined below:

Note: For a project to qualify, the resource must have performed all of the tasks on the same project.

1. Customize database conversion routines and strategies;
2. Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database;
3. Develop and implement security procedures for the database, including access and user account management;
4. Perform and/or coordinate updates to the database design;
5. Control, configure and coordinate changes to the database, including the deletion of records, changes to the existing records, and additions to the database; and
6. Develop and coordinate back‑up, disaster recovery and virus protection procedures.

The Bidder must demonstrate that the proposed resource has a minimum of 36 months of Database Administration experience within the last 60 months, at the time of solicitation closing, working in a Canadian federal** or provincial department or agency with Microsoft SQL Server 2016 (released June 2016) or higher.

Note: For the experience to qualify, the proposed resource must have performed all the tasks over the 60-month period. Performing only a few of the listed tasks will not be accepted.

i. Customize database conversion routines

ii. Finalize Conversion Strategy

iii. Generate new database with the client

iv. Maintain data dictionaries

v. Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database

vi. Develop and implement security procedures for the database, including access and user account management

vii. Advise programmers, analysts, and users about the efficient use of data

viii. Maintain configuration control of the database

ix. Perform and/or coordinate updates to the database design

x. Control and coordinate changes to the database, including the deletion of records, changes to the existing records, additions to the database

xi. Develop and coordinate back-up, disaster recovery and virus protection procedures

xii. Using SSIS, design, develop Extract Transform Load (ETL) to create reporting datamart

xiii. Coordinate with Shared Service Canada (SSC) when needed

xiv. Write Request For Change (RFC) to perform changes in production

xv. Address reporting requirement using SSRS

xvi. Write stored procedures, functions, triggers as needed

**As defined in schedules l through Vl of the Financial Administration Act

The Bidder must demonstrate that the proposed resource has a minimum of 36 months of experience within the last 60 months, at the time of solicitation closing, providing both proactive* and reactive** data management support of production databases in an Always On High Availability and clustered *** Microsoft SQL Server 2016 (released June 2016) or higher environment.

Note: For a project to qualify the resource must have provided both proactive and reactive data management support on the same project.

*Proactive database management involves anticipating and addressing potential issues before they become problems. This approach focuses on regular maintenance, monitoring, and optimization to ensure the database runs smoothly. Here are some key aspects of proactive management:

Regular Maintenance; Performance Monitoring; Capacity Planning; Security Audits.

** Reactive database management, however, involves responding to issues as they arise. This approach is crucial for addressing unexpected problems that cannot be anticipated. Key aspects of reactive management include:

Incident Response; Troubleshooting; Emergency Support; Post-Incident Analysis.

***A Microsoft SQL Server Cluster is a collection of two or more physical servers with identical access to shared storage that provides the disk resources required to store the database files. These servers are referred to as "nodes”

*** High Availability (HA) in SQL Server refers to the system's ability to remain operational and accessible even in the event of hardware failures, software issues, or network problems. It ensures that databases remain accessible when faced with failures, maintenance, or unexpected disruptions.

a description of the systems in the clustered and Always On High Availabilty MS SQL Server in a production environment.

The Bidder must demonstrate that the proposed resource has a minimum of 36 months of experience within the last 60 months, at the time of solicitation closing, working with an application development team* where the resource performed all of the tasks below in a Microsoft SQL Server 2016 (released June 2016) or higher environment:

Note: For a project to qualify the resource must have performed all the tasks on the same project.

1. Creating SQL Databases and related SQL scripts required by the application developers to connect the newly created databases to their application.
2. Implementing all database script changes as and when required by the development team.
3. Ensuring that the databases are optimized so that there are no performance issues arising once the application is connected to these databases.
4. If a SQL Server needs to be updated with latest patch or upgraded, then after installing and configuring of the new version, the resource should demonstrate what steps, if any, were taken to eliminate any impact these new patches might have on current operational systems
5. Creating SQL Server Integration Services (SSIS) package and developing Extract, Transform. Load (ETL) process to develop reports for the business users.

*Application development Team can comprise of:

i).Net programmer analysts

ii) PowerBuilder application developers

iii) COTS System Analysts.

the specific members (disciplines) of the application development team.

Security Clearance Information

R1

The Bidder should demonstrate the proposed resource has experience within the last 60 months, at the time of solicitation closing, designing and supporting* a Microsoft SQL Server 2016 (released June 2016) or higher High Availability** and a disaster recovery solution using the Microsoft SQL Server Always On Availability groups*** solution in a production environment.

Note: For a project to qualify, the resource must have performed all of the tasks on the same project.

*Designing and supporting SQL High Availability (HA) involves implementing strategies and technologies to minimize downtime and ensure continuous operation of SQL Server databases.

** Microsoft high availability refers to the strategies and technologies used to ensure that applications and services remain operational with minimal downtime. This is achieved through various methods like redundancy, failover mechanisms, and robust infrastructure design.

*** Microsoft SQL Server Always On Availability Groups is a high availability and disaster recovery solution that provides enhanced data protection and performance for databases. It allows for automatic failover to a secondary replica in case of failure, minimizing downtime and data loss.

R2

The Bidder should demonstrate the proposed resource has experience within the last 60 months, at the time of solicitation closing, in database concepts*, performance tuning**, and troubleshooting SQL related incidents encountered in an application within Clustered and Always On High Availability groups*** in a Microsoft SQL Server 2016 (released June 2016) or higher environment.

Note: For a project to qualify, the resource must have performed both tasks on the same project.

* Database Concepts such as Indexing, Query Optimization; Resource management, concurrency and blocking, monitoring and diagnostics, database design and normalization, statistics

** SQL Server performance tuning is the process of ensuring that the SQL statements issued by an application run in the fastest possible time

*** Microsoft SQL Server Always On Availability Groups is a high availability and disaster recovery solution that provides enhanced data protection and performance for databases. It allows for automatic failover to a secondary replica in case of failure, minimizing downtime and data loss.

R3

The Bidder should demonstrate the proposed resource has experience within the last 60 months, at the time of solicitation closing, performing database configuration and query optimization* in a Microsoft SQL Server 2016 (released June 2016) or higher environment

Note: For a project to qualify, the resource must have performed both tasks on the same project

*Query optimization is when a database developer / administrator changes a query in such a way that SQL Server is able to return the same results more efficiently.

R4

The Bidder should demonstrate the proposed resource has experience within the last 60 months, at the time of solicitation closing, creating and modifying and troubleshooting all of the following in Microsoft SQL Server 2016 (released June 2016) or higher environment.

1. stored procedures
2. functions
3. triggers and
4. dynamic SQL

Note: For a project to qualify, the resource must have performed creating and modifying and troubleshooting in the items listed in i to iv on the same project.

R5

The Bidder should demonstrate the proposed resource has experience within the last 48 months, at the time of solicitation closing, working within Team Foundation Server (TFS) 2017 or more recent Azure Devops as well as demonstrated experience leveraging its features and functions.

description of the functionalities and features of the program (TFS, Azure Devops)

R6

The Bidder should demonstrate the proposed resource has experience within the last 60 months, at the time of solicitation closing, providing Level 2** technical support for enterprise databases, including the use of a ticket system and working with Level 1* support (mandatory) and with clients and Management (as required).

Note: For a project to qualify, the resource must have performed all three tasks on the same project.

*Level 1 support is defined as the initial support level responsible for basic customer issues.

**Level 2 support is defined as a more in-depth technical support than Level 1 and involves more advanced troubleshooting and analysis methods to resolve more complex issues.

R7

The Bidder should demonstrate that the proposed resource has experience within the last 60 months, at the time of solicitation closing, creating complex SQL Reports from various data sources (like MS Excel, MS Access) using Microsoft SQL Server Reporting Services (SSRS)*.

*SSRS stands for SQL Server Reporting Services. It's a server-based software system from Microsoft designed for creating, deploying, and managing reports.

AND

f) Provide a description of the SSRS report built

AND

g) the business objective met using the report.

R8

The Bidder should demonstrate that the proposed resource has experience within the last 60 months, at the time of solicitation closing, creating SQL scripts including all 4 items listed below for data migration from an in-house developed application* to an externally hosted application.

1. stored procedures
2. functions
3. triggers and
4. dynamic SQL

*An in-house developed application refers to software that is created and maintained by an organization's internal team. This type of application is tailored to meet specific business needs and is developed using the organization's resources, including its own developers.

AND

f) Provide a description of the Data Migration work done

AND

g) the objective it met.

R9

The Bidder should demonstrate that the proposed resource has Hands-on experience* within the last 60 months, at the time of solicitation closing, creating PowerShell** scripts to automate database tasks and procedures

**PowerShell is a cross-platform task automation solution made up of a command-line shell, a scripting language, and a configuration management framework.

*For the experience to qualify, the proposed resource must have performed all the tasks below over the 60-month period. Performing only a few of the listed tasks will not be accepted.

1. Data collection of all SQL instances for storage and statistical information
2. Database health checks
3. Database backup and restores
4. Data exporting, file manipulation and configuration used for data migration tasks
5. Database migrations
6. Transfers logins between servers with SID, password, and permissions intact
7. Deployment of new SQL Instance and configuration.

AND

f) Provide a description where the PowerShell scripts were implemented

AND

g) what objectives it met.