MSSQL Developer
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