Write T-SQL queries Create Stored Procedure, Functions, and Triggers etc. Process data migration to SQL Server from various sources Verify and execute scripts developed by teams in Staging and Production environments Diagnose and resolve production issues Design, test and deploy database schemas Database performance tuning including identifying bottlenecks with suitable workarounds Create & Implement custom SQL scripts to automate various database operations including data migration Create and maintain database documentation Create performance benchmark conformance report for newly developed and altered functions. Assist software developers to achieve performance benchmark. Optimization of exiting database & business logic source code. 3+ years of Microsoft SQL Server Development experience including 2008 and/or 2014 MYSQL PREFERRED Strong experience in T-SQL, Indexing, Functions & Stored Procedures Ability to write SQL scripts for data migration from sources like excel, MS Access, csv/text file etc. Should be able to troubleshoot SQL queries for performance tuning Experience with SQL Profiler Good problem solving abilities Good written and verbal communication skills Ability to work in a team and individually Experience in DTS, SSIS, SSRS, SSAS Familiarity with .net technologies (No development experience required) Database analysis and Designing & database design methodologies
Heaven Techno System Pvt.Ltd. is a leading company in Consulting, Technology Outsourcing and Next generation services. It has its custom software development firm in Bhopal and has been serving clients globally since 2008 . We enable our clients to surpass the competition and stay ahead on the variation curve. We help our clients to transform themselves while also creating new avenues to generate value globally. We provide enterprises with strategic insights on what lies ahead and help them transform and improve their business processes in this fast changing world through strategic consulting operational leadership, and the co-creation of breakthrough solutions, including those in mobility, sustainability, and system integrity.
Job Description :
To ensure customer service and support all operations. To create customer delight at every interaction.
Interacting with external customers and internal customers and addressing their queries, requests and complaints.
Committed TATs are met consistently
Complaints Management- addressing customer complaints at the branch, system updation, coordination with Sales/HUB/ other functions for resolution.
Refunds processing and dispatch
Undelivered policy documents tracking and management.
Maintenance of all files and registers.
New Business Processing:-
Handling end to end New business processing starting from creation of Client id,Case start up, New business login, Follow up for policy issuance, Quality Check
Follow up with HUB for policy issuance of pending cases