Software Developer II - Oracle Plsql
FedEx
Hyderabad, Telangana, India
Job Description The Software Developer III will be responsible for analysis, design, coding, testing, and implementation of existing and new applications. The ideal candidate will have experience in developing PLSQL based packages as per the business requirements. Develops solutions leveraging a diverse range of technology. Apply modern principles, methodologies, tools, and systemic processes to support the launch new business capabilities. 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 Good To Have Experience in Warehouse management domain The above information is only an illustration of the general nature and level of work performed by the employee within this classification. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment to the position. The job description does not constitute an employment agreement between the Company and employee and is subject to change by the Company as the needs of the Company and requirements of the job change.