MSSQL Developer

TechDigital Group; St. Louis (MO); On-site; USD 110,000 - 140,000; Full time

Job summary

TechDigital Group in St. Louis, MO, is seeking an experienced MSSQL Developer to design, implement, and optimize database solutions. The role covers MSSQL, T-SQL, SSIS ETL, Python scripting, and cross-platform PostgreSQL projects, with IIS management and .NET/C# application work.

The ideal candidate has 5+ years in MSSQL development, strong SQL and data modeling skills, and the ability to work independently in a fast-paced team environment.

Qualifications

• 5+ years hands-on MSSQL development experience.
• Proficiency in designing and managing MSSQL databases and writing T-SQL code.
• Experience with PostgreSQL and understanding of DBMS concepts.
• Hands-on experience with SSIS, ETL processes, and Python scripting.
• Basic knowledge of IIS configuration and management.
• Experience developing applications using the .NET platform, especially C#.

Responsibilities

• Design, develop, and maintain robust MSSQL Jobs/packages and solutions to support organizational applications and reporting needs.
• Write complex T-SQL queries, stored procedures, triggers, and functions to ensure efficient data manipulation and extraction.
• Optimize database performance, conduct troubleshooting, and perform regular maintenance to ensure high availability and reliability.
• Work with PostgreSQL databases for cross-platform or migration projects as needed.
• Apply broad DBMS concepts to support data modeling, normalization, and schema design.
• Develop, deploy, and manage SSIS packages for ETL operations, data integration, and transformation tasks.
• Utilize Python for automation scripts, data processing, and integration scenarios.
• Demonstrate knowledge of ETL frameworks and practices to support data warehousing and analytics initiatives.
• Configure and manage IIS for hosting database-driven web applications and services including the SSL Certificates update.
• Develop and support .NET applications, primarily using C# like Dino app that interact with databases and deliver business logic.

Skills

MSSQL

T-SQL

PostgreSQL

SSIS

Python

IIS

.NET/C#

ETL

Data modeling

Tools

CI/CD pipelines

IIS administration

Job description

Job Description:

• Design, develop, and maintain robust MSSQL Jobs/packages and solutions to support organizational applications and reporting needs.
• Write complex T-SQL queries, stored procedures, triggers, and functions to ensure efficient data manipulation and extraction.
• Optimize database performance, conduct troubleshooting, and perform regular maintenance to ensure high availability and reliability.
• Work with PostgreSQL databases for cross-platform or migration projects as needed.
• Apply broad DBMS concepts to support data modeling, normalization, and schema design.
• Develop, deploy, and manage SSIS packages for ETL operations, data integration, and transformation tasks.
• Utilize Python for automation scripts, data processing, and integration scenarios.
• Demonstrate knowledge of ETL frameworks and practices to support data warehousing and analytics initiatives.
• Configure and manage IIS for hosting database-driven web applications and services including the SSL Certificates update.
• Develop and support .NET applications, primarily using C# like Dino app that interact with databases and deliver business logic.

Required Qualifications

• Minimum of 5 years of hands-on experience as an MSSQL Developer or in a similar role.
• Proficiency in designing and managing MSSQL databases and writing T-SQL code.
• Experience with PostgreSQL and understanding of DBMS concepts.
• Hands-on experience with SSIS, ETL processes, and Python scripting.
• Basic knowledge of IIS configuration and management.
• Experience developing applications using the .NET platform, especially C#.
• Strong analytical, problem-solving, and communication skills.
• Ability to work independently and as part of a team in a fast-paced environment.

Preferred Skills

• Experience in data migration between MSSQL and PostgreSQL.
• Knowledge of data security best practices and regulatory compliance (GDPR, HIPAA, etc.).
• Exposure to DevOps tools and CI/CD processes for database deployment.