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
- 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.
This job was posted by Shweta Lochan from Becker Alliance.