Sr. MS SQL Server TSQL Developer

The hiring establishment is a technology services company specializing in delivering advanced IT solutions that streamline business processes and optimize data management. Known for its commitment to innovation and excellence, the company operates in the IT development sector with a strong focus on database management, software development, and cloud technologies. This organization values highly skilled professionals who contribute to the design, development, and maintenance of complex information systems that drive business success. The work environment is remote, offering flexibility to talent located anywhere within the United States. Employment classification for this role is Computer Professional Exempt, requiring candidates to be either U.S. citizens or Green Card holders.

The position available is for a Senior MS SQL Server TSQL Developer, a critical role responsible for optimizing SQL queries and overseeing backups and audits to ensure that SQL databases remain accessible, secure, and stable. The developer will work closely with a team of SQL professionals to design database schemas, create stored procedures, and develop complex queries to handle large volumes of data efficiently. The role involves comprehensive participation throughout the software development lifecycle, including gathering and analyzing business system requirements, designing application models, responding to outages, and contributing to performance testing and maintenance activities for both in-house and third-party purchased applications.

This position demands a deep understanding of Microsoft SQL Server technologies, including experience with SQL Server 2014 and 2016 editions. The senior developer will also be adept in leveraging T-SQL language features to craft high-performance queries and SQL Server Integration Services (SSIS) packages for data cleansing and transformation. A strong emphasis is placed on database monitoring and performance tuning, requiring the candidate to evaluate database performance continually and make appropriate adjustments to optimize system efficiency. Providing production support, including managing outage recovery events, forms an essential part of the responsibilities.

Beyond the technical skills in database management, this role requires proficiency in application programming within the .NET framework, including C#, ASP.NET, and MVC 5, as well as front-end scripting languages such as JavaScript and JQuery. The developer is expected to engage in unit testing, release procedures, and adhere to coding design and documentation protocols, ensuring robust change management practices. Experience with version control using Git, debugging tools, and flow-charting applications like MS Visio is essential.

The ideal candidate will have a high-level critical thinking ability to evaluate multiple alternatives and present solutions aligned with business objectives and strategy. Leadership qualities are also highly valued, including mentoring junior staff, facilitating discussions, and resolving conflicts efficiently. Experience supporting production environments on a 24x7 basis and working with complex indexing strategies such as column store indexing is required, along with knowledge of securing Protected Health Information (PHI) data and utilizing SQL Server Analysis Services (SSAS) with MDX or DAX. Familiarity working within cloud environments, particularly Microsoft Azure Data Factory and Synapse, is mandatory.

This senior role demands 5-8+ years of professional IT development or programming experience, a Bachelor’s degree in Computer Science, Mathematics, or related fields, and proven expertise in SQL Server query tuning, BI development with Tableau, and SQL Server Reporting Services (SSRS). Candidates with relevant development certifications are preferred, enhancing their qualifications further. Overall, the Senior MS SQL Server TSQL Developer will play an instrumental role in driving the success of database projects and IT initiatives, helping the company maintain its reputation as a leader in technology services.