Job Description:
Key Responsibilities:
• Producing high quality software deliverables with limited supervision
• Analyse, design, code, unit-test, document and implement application releases to Live as part of development team
• Perform unit tests on volume datasets to evaluate performance and produce optimised solution
• Ensure timely delivery while complying the organisation standards and given low level designs
• Proactively notify development manager of risks, bottlenecks, problems, issues, and concerns
• Work closely with Quality Analysts to deliver quality solution as per the agreed acceptance criteria and timeline
• Assisting junior developers to overcome technical bottlenecks and perform peer- reviews
• Working in a fast-paced dynamic team following Agile methodology
Essential Experience:
• Proven track record of full life cycle development of large applications using an Oracle database.
• Solid SQL query writing and PL/SQL skills, problem solving and performance tuning for OLTP system
• Experience in working on Unix based OS
• Managing time and changing priorities in a dynamic environment
• Ability to provide quick turnaround to software issues and management requests
• Ability to assimilate key issues and concepts and come up to speed quickly
Technical Competencies
• Minimum of 5 years for Oracle Developer
• Strong experience in Oracle Database preferably 10g or 11g with huge volume (>5 TB)
• Must have solid development experience in Oracle PL/SQL, SQL, Performance tuning and transaction management.
• Must have hands on experience of developing:
o Advanced SQL, bulk DML and DDL scripts
o Packages, procedures, functions, triggers and using cursors, ref cursors, dynamic SQL with bind variable, bulk dml using pl/sql arrays, nested tables and v-arrays
o Maintaining ACID properties of transaction management in OLTP system
o Exception handling and defining debugging points for troubleshooting
o Tables, constraints, indexes, views, sequences and synonyms
o Listing direct /indirect dependencies among Oracle objects
o Data ingestion using sql-loader, external tables and Oracle AQs
o Performance tuning: explain plans, identifying long running jobs, compare explain/execution plans and review AWRs
o Creating rerunnable jobs and jobs scheduling using Oracle job scheduler
Desirable Skills (not mandatory):
• Working experience in Agile methodology
• Jira and Confluence
• Shell scripting experience to move, compress and archive files
• Worked on source code management such as SVN, GIT, Bit Bucket and pipeline creation using Jenkins
basic shell scripting and toolset