Software Developer III - Oracle Plsql

Primary Responsibilities

• Encode, test, debug and document associated, complex software/programs. Review, analyze, troubleshoot, and modify complex core and customized software. Be the single point of contact for the application, respond to complex, escalated customer inquiries/requests for technical/operational support. Resolve complex technical matters to meet customer service level agreements. Analyze and/or implement corrective action for root cause analysis/fixes or corrective action of defects. Follow documented Software Development Life-Cycle standards. May provide consultation on complex projects and is considered to be the top-level contributor or specialist. Point of contact for higher level or complex issues and will work with senior levels for resolution. This position is full-time and may require after hours or on-call support including, but not limited weekends and evenings. Education/Experience Bachelor’s Degree or equivalent in Computer Science, Information Systems, or related field and 10-12 years of relevant experience. Excellent verbal and written communication skills. Ability to effectively present information and respond to questions from a variety of internal and external customers. Ability to handle parallel tasks and solving challenging problems Strong experience in delivering optimal solutions considering the design principles Should be excellent at debugging skills. Should have hands on experience with following tech stack – Strong knowledge and experience in creation/modification of database objects like Tables, Procedures, Functions, Packages, Triggers, views, sequences and synonyms Good Experience with key concepts like Oracle Collection, Cursors, Ref cursors, Bulk collect, Pragma autonomous transaction and oracle supplied packages Good exposure in creating Dynamic SQL and Ref Cursor Optimize and tune SQL queries for improved performance and scalability Involved in resolving production problems for application and ensure all support to all stakeholders Strong Experience in Performance tuning and Analyzing AWR reports В Expertise in using SQL Developer for Oracle for development, debugging, and optimization of database code
• Encode, test, debug and document associated, complex software/programs. Review, analyze, troubleshoot, and modify complex core and customized software. Be the single point of contact for the application, respond to complex, escalated customer inquiries/requests for technical/operational support.
• Resolve complex technical matters to meet customer service level agreements. Analyze and/or implement corrective action for root cause analysis/fixes or corrective action of defects.