MSSQL Developer
Posted 1 day ago by 1765517798
Negotiable
Outside
Remote
USA
Summary: The MSSQL Developer role involves designing, developing, and maintaining MSSQL jobs and solutions to support organizational applications and reporting needs. The position requires expertise in T-SQL, database optimization, and experience with PostgreSQL, along with the ability to develop and manage SSIS packages and .NET applications. The developer will also utilize Python for automation and work on data warehousing and analytics initiatives. Strong analytical and communication skills are essential for success in this fast-paced environment.
Key Responsibilities:
- Design, develop, and maintain robust MSSQL Jobs/packages and solutions.
- Write complex T-SQL queries, stored procedures, triggers, and functions.
- Optimize database performance and conduct troubleshooting.
- Work with PostgreSQL databases for migration projects.
- Apply DBMS concepts to support data modeling and schema design.
- Develop, deploy, and manage SSIS packages for ETL operations.
- Utilize Python for automation scripts and data processing.
- Demonstrate knowledge of ETL frameworks for data warehousing.
- Configure and manage IIS for hosting database-driven applications.
- Develop and support .NET applications using C#.
Key Skills:
- Minimum of 5 years of experience as an MSSQL Developer.
- Proficiency in designing and managing MSSQL databases and T-SQL.
- Experience with PostgreSQL and 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.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Job Title: MSSQL Developer
Location: St Louis, MO (Remote)
C2C/W2
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.