SQL and Zudy Specialist

You should have a minimum of 3 years of technical expertise in SQL/Oracle development, support, analysis, design, installation, and migration. Additionally, you should possess at least 1 year of experience in Zudy development and support. Your responsibilities will include analyzing MS SQL backend packages and procedures, as well as managing job scheduling, particularly during failures. You should have extensive hands-on experience with analytical functions, windowing functions, PL/SQL functions, procedures, triggers (including compound triggers), packages, external tables, PL/SQL arrays, and the use of the imp utility to address performance issues during bulk file imports. You must be skilled in performance tuning and query optimization, with experience in automating daily production data change jobs and daily production database data extracts. You should have the ability to design and create business logic and implement new applications using Zudy. Furthermore, you must demonstrate a strong ability to understand and troubleshoot complex customer issues in a production environment. Excellent communication skills are essential, with the ability to understand, present, and plan effectively. Experience in REST API, webhook technologies, and C plugins would be advantageous for this role.,