PLSQL Developer

Roles and Responsibilities :

• Design, develop and maintain database objects like complex PL/SQL functions, procedures, packages, etc.
• Build SQL queries and procedures for data maintenance/fixes, analysis of application and system data and ad hoc reporting. Optimize SQL queries for performance and scalability.
• Provide Production support for batch processes and troubleshoot issues in a time-sensitive environment. Monitor and manage job schedules using Autosys.
• Develop, analyze, and maintain application code written in high level programming languages (like Java, Microfocus COBOL). Build and maintain Shell scripts for application code execution.
• Collaborate with business analysts and QA teams to understand requirements and ensure robust solutions.
• Document solutions and procedures for support and knowledge sharing.

Key Skills :

• Strong knowledge of RDBMS and 5+ years of hands-on experience with SQL and PL/SQL development

• Strong logical reasoning and critical thinking. Should be able to develop algorithms for solving business problems.
• Strong debugging and analytical skills in real time incident resolution.
• Proficient in SQL optimization and database performance tuning.
• Proficiency in analyzing and developing code using one of the programming languages (like Java, C#, Python, COBOL, etc).
• Batch production support experience in enterprise environments
• Basic knowledge of Shell scripting and Unix or Linux OS.
• Must be open to work in late shifts for partial overlap with US team working in Central time zone until ready to work independently.
• Familiarity with Oracle Forms and reports.
• Experience in supporting IT systems pertaining to Insurance domain
• Exposure to Autosys or equivalent job schedulers.
• Experience working in Agile/Scrum environments.