MS SQL Developer

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. HCLTech is not the employer for this role. This work is contracted through a third-party whose employees provides services to HCLTech and/or its clients. Candidates interested in applying for this Contract opportunity must have a valid work authorization to work in the United States. We do not accept agency resumes and are not responsible for any fees related to unsolicited resumes. Candidates who are currently employed by a client of HCLTech may not be eligible for consideration, as decided on an individualized basis depending upon business considerations. The expected pay range for this contract assignment is shown above with the Job details. The exact pay rate will vary based on skills, experience, and location and will be determined by the third-party employer. HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to for investigation. Apply tot his job