Lead and architect complex data solutions using Microsoft SQL Server technologies.
Design, develop, implement, and optimize high-performance and scalable SQL Server databases.
Perform data modeling, normalization, and ensure data integrity.
Implement and manage high availability and disaster recovery solutions for SQL Server environments.
Write efficient T-SQL queries, stored procedures, functions, and views.
Manage and optimize database performance, including troubleshooting and performance tuning.
Stay up-to-date with the latest advancements in SQL Server technologies and best practices.
Mentor and guide junior team members on SSRS reports and SQL Server best practices.
Participate in code reviews and ensure adherence to coding standards.
Work effectively with cross-functional teams (developers, system administrators, business analysts) to understand data requirements and deliver solutions.
Document technical designs ( ERD, Data model), architecture decisions, and procedures.
Minimum 10+ years of experience in designing, developing, and managing complex SQL Server databases.
Proven experience as a SQL Server architect or lead.
Strong understanding of relational database concepts, data modeling, normalization, and data integrity principles.
In-depth knowledge of T-SQL, stored procedures, functions, views, and triggers.
Experience with performance tuning techniques and query optimization.
Experience with high availability and disaster recovery solutions for SQL Server (e.g., AlwaysOn Availability Groups, Failover Clustering).
Experience with cloud-based deployments of SQL Server (Azure SQL Database) and MongoDB is a plus.
Excellent communication, collaboration, and problem-solving skills.
Ability to lead and mentor junior team members.
Strong analytical and problem-solving skills.
Experience working in an Agile development environment is a plus.
Certifications: MCSA/MCSE in SQL Server or equivalent experience is highly preferred.
