Database Consultant & Team Coach @ Helm Analytics

Technical Skills:
1. Requires a minimum of 2 years working/training experience in Microsoft SQL Server technology.
2. Experience working in SQL Server 2012/2008/2008 R2
3. Expertise in creating views, functions, Stored procedures, Triggers, cursors is required
4. Strong experience in Indexes, execution plans, performance tuning, SQL Profiler is a must.
5. Expertise in Microsoft BI stack- SSIS, SSRS, SSAS/MDX is required.
6. Should be familiar with SQL Server DBA skills. (Plus)
7. Should be familiar with .Net programming skills. (Plus)
8. Candidate should be proficient with tools like Erwin, Visual Studio, VSS, TFS and SharePoint.
9. Experience in reporting tools such as Power BI and Tableau
10. Knowledge of scripting languages such as Python, Ruby, Perl, PowerShell, and Golang
11. Knowledge of MS Azure services such as Azure SQL, Azure Data Warehouse and Azure Data Factory
12. Proficiency in one of the IaaS cloud platforms such as Microsoft Azure or Amazon Web Services (AWS)
13. Experience in any of the following automation tools such as Chef, Puppet, Jenkins Ansible, and Terraform will be a plus
14. Post Graduate degree in computer science or Information sciences preferred.

Non-Technical Skills:
1. Candidate will be working in overlapping/extended shift from Noida office.
2. Proven experience as trainer or relevant position
3. Can work independently without supervision.
4. Resourceful and result oriented in getting things done from matrixed teams
5. Stay composed and maintain a professional demeanour amidst a fast-changing work environment
6. Ability to work with diversity and multi-disciplinary teams
7. Excellent time-management and organizational skills
8. Outstanding verbal and written communication skills

Job Responsibilities:
Writing TSQL and Dynamic SQL.
Developing SSIS packages
Performance Tuning (Query and Database).
DBA Activities
Design and create new courses, quizzes, labs, and learning paths for our training candidates
Provide in-classroom remote training and practical hands-on support to candidates undergoing the boot camp programs
Work in tandem with the US Trainers in preparing/updating candidates with mocks/ assignments/interview preparations.
Phone /Skype interview candidates.
Preparing/Mocking candidates for client project assignment.
Tailoring candidates resumes as per the open client requirements.
Preparing Project Scenarios for each candidates project as listed on the resume.
Preparing project assignments /check assignments and provide feedback to the candidates and US trainers on a daily basis.