Database Architect â MS SQL Server

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.
  
  

Skills:- MS SQLServer, SQL, Stored Procedures, triggers, Query optimization, Database Design, Data modeling, Normalization and Database normalization