Senior Database Consultant-C3IT

With over 20+ years of experience in the IT landscape, we at Saxon.AI have been at the forefront of delivering the transformative power of data, AI & and automation to enterprises of all sizes. Our industry knowledge, diverse skill sets, and next-generation technology applied to each business challenge ensure our customer's technology initiatives are deployed, embraced, and scaled for maximum ROI. Whether it's an actionable dashboard, chatbot, intelligent document processing, or an intelligent enterprise app, we'll help you make the right technology choice with the best-fit application process to drive adoption across your business. By building and transferring digital skills, expertise, and ideas from our innovation ecosystem, we constantly evolve and stay relevant with a learn-it-all culture and continuous improvement attitude.Experience: 5+yrsLocation:PuneNotice Period: Looking for less than 30 days joiners 5+ years of hands on experience in Database design and SQL programming, preferably at least 5 years on Microsoft SQL Server desiginh databases for large enterpise custom applications ensuringhigh performance, data integrity and security. 2. Strong database design concepts, designing for application transaction performance and for optimal reporting performance for reports built in .Net as well as Power BI3. BE(Comp)/MCS/MCA or equivalent degree in Computer Science 4.T-SQL: Working experience on writing Complex SQL queries 5. T-SQL: Working experience of Function/SPs/Trigger Cursor etc. 6. T-SQL: Working experience of identifying and writing indexes against query. 7. T-SQL: Experience in Performance Tuning 8.. Good problem-solving skills to troubleshoot database issues 9. Must have worked with SQL Server 2008/2012 and higher versions 10. Experience with Estimation for projects 11. Meeting project deadlines. Communication with Customers and technical issue resolution 12. Possess positive involvement in work review, documentation and reporting 13. Good written and spoken communication skills 14. Able to work in fast paced environment. Ability to adapt to change and respond quickly 15. Good problem-solving skills to troubleshoot database issues 16. A person who can handle a team and get the best out of everyone. 17. A mature, open and honest individual with a strong sense of personal integrity. Ambitious, hard-working and self motivated. Optional (Preferred)skills 1.SSIS: Working Experience in developing complex SSIS packages, Configuration file, Variables, Parameters 2. SSIS: Working Experience in Error Handling, Logging, Error Notifications, Complex Data Flow Tasks. Deployment techniques 3. SSIS: Working experience in Transformations - LookUp, conditional Split, Data Conversion, Union, Merge, Pivot/UnPivot, Execute Sql 4. Hands on experience on SSAS would be added advantage. PRB