MSSQL Developer

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.

• 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.

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