PLSQL Developer

• 6 years of experience in PL/SQL development.
• Proficiency in writing complex SQL queries and stored procedures.
• Experience with performance tuning and optimization techniques.
• Strong knowledge on Datawarehouse concepts.
• Good development experience on ETL tool like Informatica.
• Should be good at SQL queries and PL/SQL concepts.
• Knowledge on Unix shell scripting and python is added advantage.
• Experience working on scheduling tools like Autosys.
• Experience working in agile model.
• Strong analytical and problem-solving skills..
• Hands on experience on IICS is added advantage.

Areas of responsibility

Triaging and resolution of tickets-Perform initial triage for high priority incident tickets (P2 tickets) which may have an impact across one or more processes and resolve priority incident (P3) tickets within defined SLAs.

Create log of incidents and Document observations and related root causes to support in evaluation of mitigation measures.

Resolution of service Requests-Fulfil software/hardware/network service requests within agreed timeline ensuring timely completion and adherence to SLAs while maintaining quality and accuracy in request handling.

SLA Monitoring-Monitor SLA timelines for entire lifecycle of high priority incident tickets (P2 tickets). Escalate as needed and participate in weekly or monthly service review meetings with clients and internal teams.

Change request execution-Create change requests as per the priority of the incident tickets in adherence with the defined guidelines.

Present changes for approval with rollback plans in change approval meetings. Execute approved changes and document post-implementation outcomes.

Incident Analysis-Analyse nature of incidents to support root cause analysis and related service improvement plans.

Contribute towards development of mitigation action to reduce repeat incidents by identifying patterns of issues noted.