Essential Skillset:
- Development and maintenance of all T-SQL objects (Stored Procedures, Functions, Tables, Views, triggers, index)
- Experience in performance analysis, Query Optimization using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.
- Optimize complex SQL statements / Stored Procedures / Views
- Knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering database, mirroring & replication
- Hands-on experience of DMV’s(Database Management Views) and DBCC commands.
- Good at requirement analysis, data design, and modeling.
- Troubleshooting of SQL Server issues, finding the Root cause and resolution on Production
- Working knowledge of DWH & ETL process and development in SSIS, SSAS, SSRS AND POwerBI.
- Core Development :
- Display your readiness to change and work on new technologies and bring in innovation based on need
- Your flair for active development will allow you to engage in related tasks
- Performance and Quality:
- You will troubleshoot and address Performance challenges
- · You will drive process culture and enforce Best Practices to formulate Quality Standards
- · Explore your passion for people development implement code review practices and mentor team member to upskill
- Product / Project Support:
- You will Troubleshoot Escalations/Change Request and Production support
- You will focus on continuous improvement – Quality of Product /Project
- Drive the culture of data protection and facilitate the preparation of data fix scripts
To apply for this job email your details tosajal.ghosh@excelindia.com