a {
text-decoration: none;
color: #464feb;
}
tr th, tr td {
border: 1px solid #e6e6e6;
}
tr th {
background-color: #f5f5f5;
}

Job Title: Data Architect / Senior SQL Server Developer

Location:

Rockville, MD / Hybrid / Remote (as applicable)

Employment Type:

Full-Time

Experience Level:

X+ years (customizable)

Job Summary

We are seeking an experienced Data Architect / Senior SQL Server Developer to design, develop, and optimize enterprise‑grade data solutions. The ideal candidate has strong expertise in data architecture, relational data modeling, and SQL Server, along with a solid foundation in software engineering principles, Agile development, and object‑oriented design best practices. This role requires excellent problem‑solving skills and the ability to thrive in a fast‑paced, collaborative environment.

Key Responsibilities

Data Architecture & Design

• Design and maintain robust data architectures to support scalable, high‑performance applications
• Develop and manage relational data models, ensuring normalization, integrity, and performance
• Define database standards, naming conventions, and best practices
• Collaborate with application and business teams to translate requirements into effective data designs

SQL Server Development & Optimization

• Lead SQL Server architecture and design, including schema design and performance strategies
• Develop and maintain complex SQL queries, views, functions, and stored procedures
• Perform query tuning and performance optimization using indexes, execution plans, and monitoring tools
• Ensure data reliability, security, backup, and recovery best practices

Software Engineering & Agile Practices

• Apply Agile development principles in cross‑functional teams
• Follow established software design patterns
• Implement and advocate for Dependency Injection and modular design
• Apply SOLID object‑oriented design principles to ensure maintainable and extensible solutions
• Participate in code reviews, sprint planning, and retrospectives

Collaboration & Problem Solving

• Work closely with developers, architects, product owners, and QA teams
• Diagnose and resolve complex data‑related issues
• Communicate technical concepts clearly to both technical and non‑technical stakeholders

Required Qualifications

Technical Skills

• Strong expertise in Data Architecture and Relational Data Model Design
• Deep hands‑on experience with Microsoft SQL Server
• Advanced skills in SQL development and Stored Procedures
• Thorough understanding of SQL Server architecture and design principles
• Solid experience with software development lifecycle and Agile methodologies
• Strong knowledge of design patterns, Dependency Injection, and SOLID principles

Soft Skills

• Excellent problem‑solving and analytical abilities
• Strong verbal and written communication skills
• Ability to thrive in a fast‑paced, collaborative, Agile environment
• High attention to detail and commitment to quality

Preferred / Nice‑to‑Have Skills

• Experience with performance monitoring and database optimization tools
• Knowledge of cloud‑based database platforms
• Exposure to data governance or data quality frameworks

Education

• Bachelor’s degree in Computer Science, Engineering, or a related field (or equivalent experience)