Sparks - Winston-Salem, NC

posted about 2 months ago

Full-time
Winston-Salem, NC
Administrative and Support Services

About the position

A Sparks Group Partner is seeking a Database Developer to join their SQL development team. This is a hybrid role with Tuesdays and Thursdays on-site, along with a third day of your choice. The Database Developer will be responsible for developing and maintaining large-scale SQL Server database structures, ensuring the integrity and performance of the databases. The role requires proficiency in T-SQL code, including the development and maintenance of stored procedures and functions, as well as conducting code reviews to ensure best practices are followed. In addition to database development, the Database Developer will work on Business Intelligence projects using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). This includes the deployment of SSIS projects and the creation of reports that provide valuable insights to the organization. The developer will also be tasked with creating and maintaining production troubleshooting scripts to assist other internal groups, as well as developing automation and deployment tools for the Operational DBAs, with a preference for PowerShell. The role also involves serving as a technical and research resource for the Operational DBAs, creating and maintaining database servers within the development environment, and managing code and database objects using a source control tool such as TFS. This position is ideal for someone with a strong background in SQL development and a passion for database management and optimization.

Responsibilities

  • Develop/maintain large scale SQL Server Database structures
  • Develop/maintain T-SQL code (Stored Procedures, functions, and reviews)
  • Develop/maintain Business Intelligence SSIS projects (SSIS Project Deployment Preference)
  • Develop/maintain SQL Reporting with SSRS
  • Develop/maintain Production troubleshooting scripts for other internal groups
  • Develop/maintain automation and deployment tools for the Operational DBAs (PowerShell Preference)
  • Serve as a technical/research resource for the Operational DBAs
  • Create/maintain Database servers within Development Environment
  • Manage code/database objects with source control tool (i.e., TFS)

Requirements

  • Bachelor's degree in Computer Science/Information Technology or equivalent experience
  • 8+ years of Microsoft SQL experience with at least 4 years of operation experience in an enterprise database environment and 4 years of programming experience
  • Experience with MS SQL Server 2014, 2016 or newer
  • Worked extensively with complex SSIS and SSRS projects
  • Experience with large data sets (their databases range from 40,000 rows to over a million rows of data)
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service