Professional Database Engineer - Charleston, United States - Abacus

Abacus Charleston, United States

Found in: Lensa US 4 C2 - 6 days ago

Description

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, 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 the
West Virginia Office of Technology (WVOT) to establish an open-end contract for the services of a
Professional Database Engineer. This Database Engineer will work alongside other Database
Engineers and Database Administrators in Enterprise Solution Services to design, execute, and
maintain Microsoft SQL Server, Microsoft Dynamics, and Hyland OnBase based infrastructure for
the 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 databases
within this environment, as well as applications and reports leveraging them, as needed. Finally, this
Database Engineer will provide support for said infrastructure and developed systems while providing
documentation 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:

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.

Facilitating migration of existing databases or instances from legacy infrastructure into newly established virtual environments.

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.

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.

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.

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.

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.
The Vendor must provide a Database Engineer with at least five years (5) experience in the following applied knowledge and skill sets:
Microsoft SQL Server 2008 R2, 2012, 2014, 2016, 2019, 2022
Microsoft SQL Server Reporting Services 2008 R2, 2012, 2014, 2016,2019,2022
Microsoft SQL Management Studio
Microsoft Windows Server 2008 R2, 2012, 2016, 2019
Microsoft PowerShell 4.0 or greater
Microsoft Dynamics CRM 2011, 2013, and Dynamics 365
Microsoft Dynamics GP 2013, 2016 and 2018
Microsoft Biztalk Server
Hyland OnBase
Ademero Content Central
IBM Data Studio 4.1
Google Workspace
Google Sheets
Google App Sheets
Google Looker Studio
Visual Studio 2013, 2016 and 2019
C#.NET
ASP .NET
Entity Framework
ADO.NET
Adobe ColdFusion 9, 11, 18

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:

Designing, implementation, administration, monitoring, tuning, backup, migration, and providing support for the initial architecture of the database.
Designing and documenting database architecture and data modelling
Building database schemas, tables, procedures, and permissions
Creating T-SQL and PowerShell scripts for task automation
Providing ongoing development, upgrade, modification, and maintenance of a Microsoft SQL Server Database
Authoring reports in Microsoft SQL Server Reporting Services to serve as dashboards in various web-based systems.

Implementing complex business applications against mainframe and SQL Server based databases and data warehouses using ASP .NET and/or Adobe ColdFusion.

Utilizing Biztalk integrations to synchronize data between three or more live systems.
Integrating Ademero Content Central and Google Workspace with MS Dynamics CRM

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.

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.

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:

Implementation of highly available and scalable, single and multi-tenant SQL Server environments.
Migration of Microsoft Access tables to utilization of Microsoft SQL Server backend instead of local file storage.
Reconciliation and remediation of Microsoft Dynamics GP ERP billing tables and general Dynamics GP interfacing.

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.

Knowledge and expertise in Hyland OnBase workflow management and data structuring.

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

Senior .NET Developer

Found in: Zoho Direct Apply - 3 days ago

Novalink Solutions LLC Charleston, United States

SCOPE OF THE PROJECT: · The Division of Technology Services is responsible for developing, implementing, maintaining, and obtaining multiple mission critical applications for the Department of Social Services. · The Department seeks a highly motivated individual with advanced exp ...
Quality Assurance Tester-Medicaid

Found in: Zoho Direct Apply - 4 days ago

Novalink Solutions LLC Charleston, United States

Stay closer to Minimum on the bill rate range. · ICD-10 and Medicaid experience is desirable. · South Carolina seeks experts in Quality Assurance Tester - Advanced Testing of small to large projects for SCDHHS. · Daily Duties / Responsibilities: · Responsible for performing tests ...
Data Analyst

Found in: Appcast US C2 - 1 day ago

Delphi-US, LLC - Peacemakers in the Talent War Virginia, United States

Title: Data Analyst (Contract) - Job#4954 · Location: Remote · W2 Contract - No C2C · Contract length: 6+ months · US Citizenship Required · Job Description: · The Data Analyst is responsible for overseeing our data systems and reporting frameworks, guaranteeing the integrity and ...
Senior Data Engineer

Found in: Appcast US C2 - 1 day ago

The Crox Group Virginia, United States

***********************ONLY USC & GC CANDIDATES*************FULL TIME ONLY************ · Hi, · I have a direct client open for Sr. Data Engineer on Full Time with 100% Remote. Please see the JD below and let me know if you are interested. · Title: Senior Data Engineer · Work Loca ...
Microsoft SQL Server Database Administrator

Found in: Lensa US 4 C2 - 5 days ago

Gainwell Technologies Charleston, United States

** Microsoft SQL Server Database Administrator** · Date: Jan 12, 2022 Location: Charleston, WV, US, · Req ID: 7534 **Essential Job Functions** · **EDUCATION AND EXPERIENCE REQUIRED:** · 5+ years of professional experience and a Bachelor of Arts/Science or equivalent degree in ...
Sr. Linux/AIX Systems Engineer

Found in: Appcast Linkedin GBL C2 - 1 day ago

h3 Technologies, LLC Virginia, United States

Sr. Linux/AIX Systems Engineer. · ***-Candidates must be local to Wash Dc or Reston VA. Selected candidates will have to travel to client location at least once a week. · This Position is hybrid - Candidates must be local to Wash Dc or Reston VA. Selected candidates will have to ...
Senior / Lead Test Automation Software Developer

Found in: Appcast US C2 - 1 day ago

Premier Group Recruitment Virginia, United States

The Opportunity: · Premier Group is currently recruiting for a Senior / Lead Test Automation Software Developer to join our client's dynamic team. · The successful applicant will play an important and visible role in the company and be integral to the design, build, integration, ...
Programmer Analyst

Found in: Appcast US C2 - 3 days ago

WV Departments of Health, Health Facilities, and Human Services Charleston, United States

Please note, by clicking Apply, you are requesting that a Talent Acquisition Team Member reach out to you regarding further application steps. · Nature of Work · Under limited supervision, assists in the analysis, design, development, installation, and support of business informa ...
Logistics Engineer I

Found in: Lensa US 4 C2 - 4 days ago

KOCHUR TRUMMER CORPORATION Charleston, United States

The Logistics Engineer will report to the Logistics Lead and is responsible for analysis of all material and material conditions for ships assigned. The Engineer maintains a database for feedback and analysis of systems and processes in support of availability planning and execut ...
Senior Principal Software Developer

Found in: Lensa US 4 C2 - 4 days ago

Oracle Charleston, United States

Location field must contain 'city, state' or a zip code to perform a radius search (e.g., · Denver, CO · or · City and state must be separated by a comma followed by a space (e.g., · Houston, TX ) · Oracle · Senior Principal Software Developer (OCI Data) · in · Charleston ...
Sr. Systems Engineer

Found in: Lensa US 4 C2 - 5 days ago

Systems Technology Forum Charleston, United States

** Security Clearance Required · Company Overview · Systems Technology Forum LTD (STF) is an established industry partner with a passion for exceptional performance and an unwavering commitment to our clients. As a premier provider of management, engineering, information technol ...
Data Applications Engineer

Found in: Lensa US 4 C2 - 6 hours ago

Hartzell Propeller Charleston, United States

Hartzell Aviation · With a history dating back to the Wright Brothers, Hartzell Aviation is a growing family of brands committed to innovation and the continuous improvement of general aviation and is owned by Arcline Investment Management, a growth oriented private equity firm w ...
Senior Software Engineer

Found in: Lensa US 4 C2 - 6 hours ago

Teradata Charleston, United States

Location field must contain 'city, state' or a zip code to perform a radius search (e.g., Denver, CO or City and state must be separated by a comma followed by a space (e.g., Houston, TX ) · Teradata Senior Software Engineer in Charleston , West Virginia · What You'll Do · This ...
Ruby on Rails Engineer at Within3

Found in: Lensa US 4 C2 - 4 days ago

HuntsBot Charleston, United States

Ruby on Rails Engineer (Fully Remote, US)RemoteOhio, United StatesEngineeringFull timeDescriptionWithin3 is searching for a Ruby on Rails Engineer with mid-level career knowledge. This Engineer will work within a distributed agile team to implement and maintain secure, scalable, ...
Model Based System Engineer

Found in: Lensa US 4 C2 - 4 days ago

Vosper Thornycroft Group Charleston, United States

Overview · VTG is seeking a Model Based System Engineer to support work in our Charleston, SC office. · Responsibilities · Assisting in the coordination and management of large organizations that require the effective use of money, materials, equipment, and people. · Apply ana ...
Senior Software Developer Clarksburg, WV

Found in: Lensa US 4 C2 - 4 days ago

Tygart Technology Inc Charleston, United States

Tygart is currently seeking a Senior Software Developer to support a Department of Justice (DOJ) component. This is a remote position with some travel to WV. This position requires a · current Secret security clearance. · Responsibilities: · Possesses and applies a comprehensi ...
Senior Support Engineer

Found in: Lensa US 4 C2 - 2 days ago

EDB Charleston, United States

Location field must contain 'city, state' or a zip code to perform a radius search (e.g., · Denver, CO · or · City and state must be separated by a comma followed by a space (e.g., · Houston, TX ) · A Little About Us · Innovative, collaborative minds wanted. The world loves P ...
Model Based System Engineer

Found in: Lensa US 4 C2 - 5 days ago

VT Group Charleston, United States

Overview · VTG is seeking a Model Based System Engineer to support work in our Charleston, SC office. · What will you do? · * Assisting in the coordination and management of large organizations that require the effective use of money, materials, equipment, and people. · * Apply a ...
Sr. Systems Engineer

Found in: ZipRecruiter Test10S US C2 - 6 hours ago

Systems Technology Forum Charleston, United States

Job Description · Job Description** Security Clearance Required · Company Overview · Systems Technology Forum LTD (STF) is an established industry partner with a passion for exceptional performance and an unwavering commitment to our clients. As a premier provider of management, ...
Automation Equipment Engineer

Found in: Lensa US 4 C2 - 1 day ago

Midmark Corporation Charleston, United States

JOB SUMMARY: · Responsible for designing, implementing and maintaining product and component testers. · ESSENTIAL/PRIMARY DUTIES: · •Design and implement product and component testers. · •Maintain existing product and component testers. · •Perform periodic maintenance on product ...