Database Architect - MS SQL Server

5 years

0 Lacs

Posted:3 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

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.

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You