Senior Database Consultant-C3IT - Pune, India - Saxon AI

    Saxon AI
    Saxon AI Pune, India

    Found in: Appcast Linkedin IN C2 - 1 week ago

    Default job background
    Description

    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+yrs

    Location:Pune

    Notice 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 BI

    3. 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.