SQL Server Database Expert

You will be responsible for designing and implementing logical and physical data models to meet application requirements. This includes developing and maintaining relational database structures using SQL Server. You will create and optimize stored procedures, views, functions, and triggers to ensure data integrity, consistency, and scalability. Performance tuning, query optimization, and indexing strategies will be within your scope, along with analyzing execution plans and troubleshooting slow-running queries. Collaboration with developers, analysts, and DevOps teams is essential to deliver high-performing solutions. Furthermore, you will maintain and enhance existing database systems while adhering to best practices and security standards. To excel in this role, you should possess 6-10 years of hands-on experience with Microsoft SQL Server. A strong background in data modeling, including ER diagrams, normalization, and schema design, is required. You must have in-depth knowledge of T-SQL and database development best practices. Experience in database performance tuning, index design, and execution plan analysis is crucial. Proficiency in database design tools such as ER/Studio, ERwin, or Visio is expected, along with familiarity with version control and CI/CD practices for database changes. Desirable skills include experience with SSIS, SSRS, or Power BI, as well as exposure to cloud database platforms like Azure SQL or AWS RDS. Possessing Microsoft certifications in SQL Server technologies would be an added advantage.,