Job Title: MSSQL Developer
Location: St Louis, MO(Remote)
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