Database Architect - MS SQL Server

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.

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

Preferred Qualifications

This job was posted by Shweta Lochan from Becker Alliance.

Skills Required

T-sql, Microsoft Sql Server, Triggers, Ssis, Indexes, Constraints