Professional Database Engineer

Candidates Request Form 1 Job Title Professional Database Engineer 2 Client Company/Dept. Name DEPARTMENT OF ADMINISTRATION 3 ddress 2019 WASHINGTON ST E City Name CHARLESTON State Name WV-West Virgini Zip Code 25305 If others (Address) 4 5 Mark up % (if any) 6 Duration of the project Project Start Date pril 01, 2024 Project End Date March 31, 2025 Due date for Resume submission Mar 05, 2024 7 No. of Openings 1 No. of Maximum Submissions 1 8 Job Description PURPOSE AND SCOPE: The West Virginia Purchasing Division is soliciting bids on behalf of theWest Virginia Office of Technology (WVOT) to establish an open-end contract for the services of aProfessional Database Engineer. This Database Engineer will work alongside other DatabaseEngineers and Database Administrators in Enterprise Solution Services to design, execute, andmaintain Microsoft SQL Server, Microsoft Dynamics, and Hyland OnBase based infrastructure forthe WVOT, to include all such systems hosted by, and especially those directly managed by WVOT.This Engineer will also, and more primarily, develop and ensure the proper functioning of databaseswithin this environment, as well as applications and reports leveraging them, as needed. Finally, thisDatabase Engineer will provide support for said infrastructure and developed systems while providingdocumentation and training to current WVOT employees regarding the particulars thereof. 4. MANDATORYREQUIREMENTS:4.1 Mandatory Contract Services Requirements and Deliverables: Contract Services must meet or exceed the mandatory requirements listed below.4.1.1 Contract Services Deliverable# 1- Professional Database Engineer: The Vendor must provide a Professional Database Engineer to provide design, implementation, and maintenance of complex SQL Server based infrastructure and database solutions, along with training and knowledge transfer to current employees working for the Office of Technology in Enterprise Solution Services. The Database Engineer provided will be additionally, or more specifically, responsible for the following:4.1.1.1 Design and implementation of multiple highly available, and scalable, single and multi-tenant SQL Server environments, with a preference for SQL Server 2019 or newer.4.1.1.2 Facilitating migration of existing databases or instances from legacy infrastructure into newly established virtual environments.4.1.1.3 Developing procedures, documentation, training, and execution of knowledge transfer to at least two other WVOT staff for all developed and maintained systems within the WVOT hosted SQL Server, OnBase, and Dynamics environments.4.1.1.4 Providing analytics regarding system health, growth capacity, and other metrics of benefit to WVOT and our customers.4.1.1.S Analysis of complex queries and execution plans for the determination of need regarding the maintenance of indices to provide optimal performance for various use-cases, whether by creation, alteration, or deletion.4.1.1.6 Use and instruction in the SQL Server Reporting Services, Power BI, and Google Looker Studio to develop specialized reports both for our customers and for internal reporting.4.1.1.7 Use and instruction in the SQL Server Integration Services, Azure Data Factories, Biztalk, and other such tools to migrate and transform data through complex ETL.4.1.1.8 Maintain and enhance ASP.NET and ColdFusion applications leveraging database systems supported by the Engineer, when necessary, alongside other project development team members. 9 Skill set info 3.1. The Vendor must provide, upon request, a resume for its proposed personnel for the WVOT's review. The WVOT reserves the right to independently verify any information.3.1.1. The Vendor must provide a Database Engineer with at least five years (5) experience in the following applied knowledge and skill sets:3.1.1.1. Microsoft SQL Server 2008 R2, 2012, 2014, 2016, 2019, 20223.1.1.2. Microsoft SQL Server Reporting Services 2008 R2, 2012, 2014, 2016,2019,20223.1.1.3. Microsoft SQL Management Studio3.1.1.4. Microsoft Windows Server 2008 R2, 2012, 2016, 20193.1.1.5. Microsoft PowerShell 4.0 or greater3.1.1.6. Microsoft Dynamics CRM 2011, 2013, and Dynamics 3653.1.1.7. Microsoft Dynamics GP 2013, 2016 and 20183.1.1.8. Microsoft Biztalk Server3.1.1.9. Hyland OnBase3.1.1.10. Ademero Content Central3.1.1.11. IBM Data Studio 4.13.1.1.12. Google Workspace3.1.1.12.1. Google Sheets3.1.1.12.2. Google App Sheets3.1.1.12.3. Google Looker Studio3.1.1.13. Visual Studio 2013, 2016 and 20193.1.1.13.1. C#.NET3.1.1.13.2. ASP .NET3.1.1.13.3. Entity Framework3.1.1.13.4. ADO.NET3.1.1.14. Adobe ColdFusion 9, 11, 183.1.2. The Vendor must provide a Database Engineer with a minimum of five (5) years of paid experience working on projects in the Government sector and a minimum of three (3) years in health care, insurance, or related sector. The Database Engineer must provide details in their resume of experience in participating in the following:3.1.2.1. Designing, implementation, administration, monitoring, tuning, backup, migration, and providing support for the initial architecture of the database.3.1.2.2. Designing and documenting database architecture and data modelling3.1.2.3. Building database schemas, tables, procedures, and permissions3.1.2.4. Creating T-SQL and PowerShell scripts for task automation3.1.2.5. Providing ongoing development, upgrade, modification, and maintenance of a Microsoft SQL Server Database3.1.2.6. Authoring reports in Microsoft SQL Server Reporting Services to serve as dashboards in various web-based systems.3.1.2.7. Implementing complex business applications against mainframe and SQL Server based databases and data warehouses using ASP .NET and/or Adobe ColdFusion.3.1.2.8. Utilizing Biztalk integrations to synchronize data between three or more live systems.3.1.2.9. Integrating Ademero Content Central and Google Workspace with MS Dynamics CRM3.1.3. The Vendor must provide, upon request, a Database Engineer with a Bachelor of Science degree from an accredited college or university in computer science or related field including but not limited to designing, implementation, administration, monitoring, tuning, backup, migration, and support of the initial architecture database.3.1.3.1. If the Vendor is providing a Database Engineer with a Bachelor of Science degree in Computer Science, then they must submit a copy of their diploma upon request.3.1.3.2. If the Vendor is providing a Database Engineer with a Bachelor of Science degree related field, then they must provide transcripts highlighting the applicable courses upon request.3.2. The Database Engineer must have a working knowledge of, and experience in, each of the following use cases:3.2.1. Implementation of highly available and scalable, single and multi-tenant SQL Server environments.3.2.2. Migration of Microsoft Access tables to utilization of Microsoft SQL Server backend instead of local file storage.3.2.3. Reconciliation and remediation of Microsoft Dynamics GP ERP billing tables and general Dynamics GP interfacing.3.2.4. Knowledge and expertise in the Ademero Content Central Document Management System for the establishment of scanning/document management workflows and secure system integration with Dynamics CRM and other solutions.3.2.5. Knowledge and expertise in Hyland OnBase workflow management and data structuring.3.2.6. Proper implementation within ASP .NET applications of Entity Framework and ADO.NET (OLE DB and ODBC) data access paradigms appropriate to their intended use cases. 10 Education 11 Certifications (if required) 12 Documentation Required for submission 4.2 Health Insurance Portability and Accountability Act: In addition to what is covered by the Confidentiality in the General Tenns and Conditions included with this solicitation, Vendor and any candidate they provide are required to sign the HIP AA/Business Associate Addendum (BAA) with an Appendix 1, which indicates the specific Protected Health Information (PHI), specifically written for the project for which WVOT is requesting the candidate, prior to the start of the contract. The BAA is included with this solicitation. 13 Work Hours 7:30 am to 4:30 pm Monday through Friday 14 15 Work authorization required US Citizen Only 16 Relocation is accepted Yes 17 Remote work Yes 18 dditional Notes if any Remote will be allowed but candidate needs to be onsite when required by the client