Job Description:
Strong understanding of RDBMS concepts with excellent problem-solving skills.
Advanced experience in Data modeling, relational database design and hands on database development using SQL Server.
Expert in writing, debugging, optimizing and performance tuning of stored procedure, views, triggers, UDFs and complex queries.
Expert in Database optimization and performance tuning.
Experience with SQL Server Integration Services (SSIS).
Experience in Data warehouse and reporting & analytical environments.
Experience with both traditional Waterfall SDLC and Agile methodologies.
Good communication and presentation skills: ability to communicate in a clear and concise manner, across all stakeholder groups.
Experience with task management tools such as JIRA.
Key Skill sets.
SQL Server 2012-2019
SQL Server reporting services (SSRS)
SQL Server Integration services (SSIS)
Database performance tuning
SQL server DBA activities
SQL server migration
Writing optimized queries
Troubleshooting data/performance issues
Write database procedures/ functions for new functionality or reports