SQL Database Engineer - SQLDBENGG24-03625

Location

Charleston, WV | United States

Job description

Title: SQL Database Engineer
Contract: 12+ months
Location: Charleston, WV

Description:

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 client, to include all such systems hosted by, and especially those directly managed by the client.
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 employees regarding the particulars thereof.

Responsibilities:

• 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.
• Analysis of complex queries and execution plans for the detennination of need regarding the maintenance of indices to provide optimal perfonnance 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.

Qualifications:

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
• Designing, implementation, administration, monitoring, tuning, backup, migration, and providing support for the initial architecture of the database
• Designing and documenting database architecture and data modeling
• Building database schemas, tables, procedures, and pennissions
• 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
• 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.

Job tags

Salary