Database Administrator

Tasks:Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database;Implement security measures to safeguard sensitive data, including user access controls, encryption, and compliance with data protection regulations.Work closely with software developers, data architects, and other IT professionals to design and implement solutions that integrate with databases;Modify and improve the performance of the SQL scripts that interface between SAP and Licensing Operations User Integrated System (LOUIS);Modify and improve the performance of the SQL scripts used in the Human Resources Information System (HRIS);Perform Data Migration tasks from the current Human Resources application which involves writing new stored procedures, views, creating tables to enable the migration of the application data to other organizations facilitating the transition to Dayforce.Monitoring the performance of databases, identifying any problems or inconsistencies, performing corrective measures, and devising security measures to keep data safe from any cyber-attacks. Work with the Data Modelers to help design and create SQL Server Reporting Objects for the end users to derive custom reports.The DBA will also work with the Data Modelers in assisting them create PowerBI models for reporting purposes.Creating and modifying scripts and SQL nightly jobs;Control and coordinate changes to the database, including the deletion of records, changes to the existing records, and additions to the database;Develop and implement backup and recovery strategies to protect data from loss or corruption. This includes regular testing of backup procedures to ensure data can be restored effectively.Install and configure SQL Server instances and databases when needed by the Developers;Build, convert, test, repair, configure and document all objects in the database environment, including but not limited to, tables, indexes, views, stored procedures, triggers and agent jobs;Identify requirements for improvements to existing databases by determining users’ information requirements and system performance and functional requirements;Ensure data consistency with IMTD data model standards and best practices;Analyze and tune databases for optimal efficiency;Provide database support and advice to the developers;Migration of SQL Server databases to Azure Cloud infrastructure when required by the Enterprise Architecture (EA) team;Interpret systems requirements documents to develop IT solutions;Maintain comprehensive documentation of database configurations, procedures and standards. This documentation is essential for troubleshooting and ensuring consistency in database management practices.Using Powershell scripts to automate database tasks and procedures and keeping a detailed documentation on the objective of the script and the results achieved.Reuse existing standard modules, developed by IMTD;Create/perform unit testing of the solution modules during development;Respond to bug reports and fix issues;Minimize database downtime and manage parameters to provide fast query responses and query optimization;Determine, enforce and document database policies, procedures and standards;Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products;Provide 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;Design and support High Availability disaster recovery solutions using SQL Server Always On Availability groups;Work with application development team (.Net programmer analysts; ColdFusion Developers; PowerBuilder application developers and COTS System Analysts) to build, monitor, maintain, patch, implement database script changes, work with SQL Server Integration Services (SSIS) package and developing ETL process, create SQL Server Reporting System to create SQL reports;Create complex SQL Reports from various data sources (MS Excel, MS Access) using Microsoft SQL Server Reporting Services (SSRS);Create, modify and troubleshoot stored procedures, functions, triggers and dynamic SQL;Providing Level 2 technical support for enterprise databases, including the use of a ticket system and working with Level 1 support and with clients and Management as required;Assist the developers, Quality Assurance (QA) and SSC during LAB and PROD patching cycles;Provide knowledge transfer to client staff and should always save all his process and work documentation in SharePoint within the Team’s Site location;Submit timesheets that identify time allocated to each project or initiative at the end of each week;Draft and submit reports which may include but not limited to: Project reports;Submit status reports which may include: Tasks and activities completed in the last reporting period; Planned activities to be completed in the next reporting period; Status and flow of work activities/deliverables; and Potential Issues/Outstanding issues.Mandatory: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:Customize database conversion routines and strategies;Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database;Develop and implement security procedures for the database, including access and user account management;Perform and/or coordinate updates to the database design;Control, configure and coordinate changes to the database, including the deletion of records, changes to the existing records, and additions to the database; andDevelop 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 or higher.Customize database conversion routines;Finalize Conversion Strategy;Generate new database with the client;Maintain data dictionaries;Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database;Develop and implement security procedures for the database, including access and user account management;Advise programmers, analysts, and users about the efficient use of data;Maintain configuration control of the database;Perform and/or coordinate updates to the database design;Control and coordinate changes to the database, including the deletion of records, changes to the existing records, additions to the database;Develop and coordinate back‑up, disaster recovery and virus protection procedures;Using SSIS, design, develop Extract Transform Load (ETL) to create reporting datamart;Coordinate with Shared Service Canada (SSC) when needed;Write Request For Change (RFC) to perform changes in production;Address reporting requirement using SSRS;Write stored procedures, functions, triggers as needed.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 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.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.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.Additional description of the systems in the clustered and Always On High Availability 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 or higher environment:Creating SQL Databases and related SQL scripts required by the application developers to connect the newly created databases to their application.Implementing all database script changes as and when required by the development team.Ensuring that the databases are optimized so that there are no performance issues arising once the application is connected to these databases.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.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: Net programmer analysts; PowerBuilder application developers; COTS System Analysts.Security Clearance InformationRating R1The Bidder should demonstrate that the proposed resource has experience within the last 60 months, designing and supporting a Microsoft SQL Server 2016 or higher High Availability and a disaster recovery solution using SQL Server Always On Availability groups in a production environment.Note: For a project to qualify, the resource must have performed the tasks on the same project.Designing and supporting SQL HA involves implementing strategies and technologies to minimize downtime and ensure continuous operation.Microsoft high availability refers to the strategies and technologies used to ensure that applications and services remain operational with minimal downtime.SQL Server Always On Availability Groups is a high availability and disaster recovery solution that provides enhanced data protection and performance for databases.Rating R2The Bidder should demonstrate that the proposed resource has experience within the last 60 months, in database concepts, performance tuning, and troubleshooting SQL related incidents encountered in an application within Clustered and Always On High Availability groups.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.SQL Server Always On Availability Groups is a high availability and disaster recovery solution.Rating R3The Bidder should demonstrate the proposed resource has experience within the last 60 months, performing database configuration and query optimization in a Microsoft SQL Server 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 to return the same results more efficiently.Rating R4The Bidder should demonstrate the proposed resource has experience within the last 60 months, creating and modifying and troubleshooting all of the following in Microsoft SQL Server 2016 or higher environment:Stored proceduresFunctionsTriggers andDynamic SQLNote: For a project to qualify, the resource must have performed creating and modifying and troubleshooting in the items listed on the same project.Rating R5The Bidder should demonstrate the proposed resource has experience within the last 48 months, working within Team Foundation Server or Azure Devops as well as demonstrated experience leveraging its features and functions.Description of the functionalities and features of the program.Rating R6The Bidder should demonstrate the proposed resource has experience within the last 60 months, providing Level 2 technical support for enterprise databases, including the use of a ticket system and working with Level 1 support and with clients and management.Note: For a project to qualify, the resource must have performed all three tasks on the same project.Rating R7The Bidder should demonstrate that the proposed resource has experience within the last 60 months, creating complex SQL Reports from various data sources using SSRS.Rating R8The Bidder should demonstrate that the proposed resource has experience within the last 60 months, creating SQL scripts including stored procedures, functions, triggers and dynamic SQL for data migration.Rating R9The Bidder should demonstrate hands‑on experience performing PowerShell scripts to automate database tasks and procedures. Note: for the experience to qualify, the resource must have performed all the tasks over the 60‑month period. Performing only a few of the listed tasks will not be accepted. #J-18808-Ljbffr