Developer

Data Architect / Senior SQL Server Developer

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

• 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

• 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

• 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

• 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

• 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)