Database Architect – MS SQL Server at Panchkula, Chandigarh Full Time

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.