Hallmark Healthcare

Job brief We are looking for a Full Stack Developer to produce scalable software solutions. Youll be part of a cross-functional team thats responsible for the full software development life cycle, from conception to deployment. As a Full Stack Developer, you should be comfortable around both front-end and back-end coding languages, development frameworks and third-party libraries. You should also be a team player with a knack for visual design and utility. Mandatory Skill : Angular ,.net core,Sql Responsibilities Work with development teams and program managers to ideate software solutions. Define, design, code, build and debug complex object-oriented multi-tier distributed software applications Work with front end developers to design, develop and maintain web-based applications to enhance the performance and reliability of our current applications Participate in the development of new industry-leading products, leveraging technologies such as C#, ASP.NET Core, JavaScript/ Angular/ HTML5 and SQL Server. Strong experience in Angular 8 and .Net core Build the front-end of applications through appealing visual design Develop and manage well-functioning databases and applications Write effective RESTful APIs Test software to ensure responsiveness and efficiency Create security and data protection settings Build features and applications with a mobile responsive design Write technical documentation and properly document code Work with program managers and business analysts to improve software Requirements Proven experience as a Full Stack Developer or similar role Degree in Computer Science, Statistics, or relevant field Experience developing data driven web applications.

Key Responsibilities: Design, develop, and maintain complex stored procedures, functions, views , and business logic using T-SQL. Analyze and optimize existing T-SQL code for performance, scalability, and maintainability. Conduct code reviews of legacy SQL components and implement performance improvements. Create and maintain optimized database schemas , with proficiency in normalization and denormalization techniques . Perform root cause analysis and troubleshooting of issues related to query performance, deadlocks, blocking, and long-running transactions . Utilize tools such as SQL Server Profiler, Execution Plans, Extended Events, DMVs, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor for performance tuning and diagnostics. Collaborate with application teams to design efficient data access patterns and support scalable architectures. Ensure data security through proper user roles, permissions, encryption techniques, and secure development practices. Document database designs, stored procedures, and troubleshooting steps in a clear and standardized format. Stay current with the latest SQL Server features and best practices, recommending adoption where relevant. Develop and maintain error and event handling mechanisms, including precedence constraints, breakpoints, checkpoints, and logging. Experience working with data archival , job scheduling, and integration with legacy systems. Required Qualifications: Minimum 7 years of experience as a SQL Server Developer. Expert-level knowledge of T-SQL programming , stored procedures, and performance optimization. Strong understanding of SQL Server internals , including indexing strategies, transaction management, and execution plans. Proficient in performance analysis and tuning using Profiler, Execution Plans, Extended Events, and DMVs . Solid grasp of database security principles, including access control and encryption. Proven experience working with large and complex T-SQL codebases . Ability to write logical, efficient, and scalable SQL code . Comfortable working independently as well as part of cross-functional teams. Strong troubleshooting and analytical skills. Experience working with Azure SQL Database or other cloud-based deployments. Preferred Qualifications: Experience with CI/CD pipelines for managing database deployments. Familiarity with version control systems for database code (e.g., Git, Redgate SQL Source Control). Domain experience in healthcare or workforce management platforms is a plus. Experience with creating, populating, and maintaining data marts , with strong knowledge of data warehousing structures , including Star and Snowflake schemas .