Roles and Responsibilities

• Sound knowledge of said technology and experience in development/delivering solution
• Work directly with product owner/ leads and develop and maintain applications that solve customer needs
• Keep track of schedule for on time delivery of assigned tasks as per the defined quality standards - Optimize pace and meet deadlines
• Collaborate with product owners, QA, and other stakeholders to understand requirements and work on user stories/ backlog items and deliver same with highest quality
• Attend stand-up meetings and provide updates
• Develop solutions and POC’s based on customer and project needs
• Conceptualize a new product or, new feature or, new component and to test new technologies or features through PoCs
• Contribute in practice growth initiatives – Interviews, training, mentoring, operational activities etc.
• Plan and grow practice/account through support to proposals and proposal defence
• Provide support to delivery for technical issues, escalations and reviews and to help in deploying in a customer environment.
• Create documentation of operational tasks, procedures and automated processes.
• Fix faults and restore the operability or carry out suitable measures (creation of workaround)

Required Technical and Professional Expertise

• Create, maintain, optimize stored procedures, database and ETL processes
• Work with all levels of development from analysis through implementation and support.
• Proactively monitoring the database's health and taking preventive or corrective action as required
• Interact with report owners to establish/clarify their requirements and develop report specifications.
• Resolve end user reporting problems through collaboration with IT and Operations
• Create database objects such as tables, views, stored procedures, Triggers etc.
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Create functions to provide custom functionality as per the requirements.
• Experience with package writing utilizing SSIS
• Hands on experience in SSIA, SSAS, SSRS