2+ MS SQLServer Jobs in Chandigarh | MS SQLServer Job openings in Chandigarh

Solution Architect – .NET & Angular

Location: Chandigarh (with frequent onsite Jaipur)

Experience: 10+ years (3+ in architecture roles)

Employment Type: Full-Time (Contractual- 3-5 months)

Role Overview:

We are seeking a hands-on Solution Architect with deep expertise in the .NET and Angular stack to lead technical design and implementation for complex government IT projects. The role is focused on system architecture, integrations, performance, and code quality, working alongside an established project management team.

Key Responsibilities:

• Define and own solution architecture, including component design, data flow, integration patterns, and deployment topology.
• Lead preparation of HLD, LLD, and technical documentation as per government standards.
• Review and guide implementation of modules built on ASP.NET Core, Angular, and MSSQL.
• Ensure compliance with security, scalability, GIGW, and NIC integration standards.
• Conduct code reviews, resolve architectural blockers, and guide the team on tech decisions.
• Collaborate with DevOps on CI/CD, containerization, and infrastructure design.

Technical Skills:

• ASP.NET Core, Angular 12+, TypeScript
• MS SQL Server
• REST API design, JWT/OAuth2, caching, queues
• Govt Cloud
• Knowledge of government integration protocols (Aadhaar, DigiLocker, eOffice, etc.)

Preferred:

• Prior experience in at least 2 government/PSU projects
• Familiarity with STQC, GIGW, data residency, and compliance mandates
• Architecture certifications (e.g., TOGAF, Microsoft Azure)

Job Summary:

We are looking for a highly skilled and detail-oriented Database Architect – MS SQL Server with 5+ years of hands-on experience to lead the design, development, optimization, and maintenance of robust and scalable database solutions. You will play a key role in defining database architecture and standards, supporting development teams, and ensuring high performance, data integrity, and availability across our SQL Server environments.

Key Responsibilities:

• Architect, design, and implement secure and scalable database solutions using Microsoft SQL Server.

• Support software developers by writing complex T-SQL scripts, DML tuning, and stored procedure creation.

• Develop and maintain high-performance queries, views, triggers, and user-defined functions.

• Analyze and optimize existing SQL queries for performance improvement and resource efficiency.

• Collaborate closely with application developers, product managers, and DevOps teams to align data architecture with business and technical needs.

• Monitor, maintain, and troubleshoot database systems to ensure optimal performance and uptime.

• Design and implement solutions for database backup, restoration, migration, and replication.

• Enforce data integrity, access control, and user permission strategies across all environments.

• Create and manage constraints, indexes, and partitioning to support performance at scale.

• Document database architecture, configurations, and best practices.

• Plan and execute database upgrades, version control, and migration strategies.

Requirements:

• 5+ years of proven experience in SQL Server database development and administration.
• Strong command of T-SQL programming and query optimization techniques.
• Deep understanding of database design principles, normalization, and data modeling.
• Experience working with high availability and disaster recovery strategies (e.g., AlwaysOn, log shipping, mirroring).
• Strong experience with indexes, constraints, triggers, and performance tuning tools.
• Familiarity with SQL Server Agent, SSIS, and automation of routine tasks.
• Solid understanding of data security, compliance, and role-based access controls.
• Ability to work independently and collaboratively in agile, cross-functional teams.
• Excellent analytical, problem-solving, and communication skills.
• 
  

Preferred Qualifications:

• Bachelor's degree in Computer Science, Engineering, or a related technical field.
• Microsoft certifications (e.g., Microsoft Certified: Azure Database Administrator Associate or equivalent).
• Experience with cloud-based SQL Server instances (Azure or AWS) is a plus.
• Exposure to DevOps practices, CI/CD pipelines, or Infrastructure as Code tools.