Description

You will lead the design and optimization of SQL Server database environments for Tier 1 and Tier 2 applications.

Responsibilities

• Design OLAP database schemas, tables, stored procedures, views, indexes, and user-defined functions.
• Analyze and tune SQL queries to reduce response times while maintaining application stability.
• Implement and document standards for DB object creation, maintenance, and performance optimization.
• Mentor the team on database design patterns and implementation best practices.
• Develop measures for data quality, data discovery, and data lineage.

Required Skills

• 10+ years of SQL Server development experience.
• Expertise in designing and implementing complex database objects.
• Proven experience in performance tuning and query optimization.
• Experience with CI/CD deployment processes using Jenkins and DACPAC.
• Strong understanding of OLAP database schema design.
• Bachelor's degree or equivalent experience.

Preferred Skills

• Informatica development experience.
• SSIS development experience.

Key Skills

Education

Any Graduate