Job Title: SQL Server DB Engineer
Job Overview:
We are seeking a skilled Database Engineer to join our team. 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
Responsibilities:
- 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 otheretrics of benefit to WVOT.
- 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 member
Requirements:
- five years (5) experience in the Microsoft SQL Server 2008 R2 or above versions ,
Microsoft SQL Server Reporting Services 2008 R2 or above and Microsoft SQL Management Studio
- Experience in Microsoft Biztalk Server, Hyland OnBase, Ademero Content Central
IBM Data Studio 4.1
- Google App Sheets, Looker Studio, and Visual Studio 2013 or above
- C#.net, ASP.NET, Entity Framework, ADO.NET
- Adobe ColdFusion 9 or above.
Qualifications Education:
Bachelor's degree in Computer Science, Information Technology, or a related field.
Problem-Solving Skills:
Strong analytical and problem-solving skills with the ability to troubleshoot and resolve complex issues.
Proven track record of optimizing and enhancing database performance.
Communication and Teamwork:
Excellent communication skills with the ability to collaborate effectively within a team.
Proactive and self-motivated, with a commitment to delivering high-quality solutions.
Job Type: Full-time
Pay: $80,000.00 - $95,000.00 per year
Benefits:
- 401(k)
- Health insurance
- Paid time off
Schedule:
- 8 hour shift
Work Location: Hybrid remote in Charleston, WV 25305