Oracle PL/SQL Lead

Eviden, part of the Atos Group, with an annual revenue of circa € 5 billion is a global leader in data-driven, trusted and sustainable digital transformation. As a next generation digital business with worldwide leading positions in digital, cloud, data, advanced computing and security, it brings deep expertise for all industries in more than 47 countries. By uniting unique high-end technologies across the full digital continuum with 53,000 world-class talents, Eviden expands the possibilities of data and technology, now and for generations to come.

#Eviden

Oracle Lead:

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, basic shell scripting and toolset.
• Solid SQL query writing and PL/SQL skills, problem solving and performance tuning for OLTP system.
• Experience in working on Unix based OS with some hands-on exposure to Shell scripting.
• 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 and 8+ for Senior/Lead Developer position.
• 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.
• Candidate must have experience in APEX and Oracle Integration Cloud and ORDS (Oracle REST Data services).

Must have hands on experience of developing:

• Advanced SQL, bulk DML and DDL scripts
• 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
• Maintaining ACID properties of transaction management in OLTP system.
• Exception handling and defining debugging points for troubleshooting.
• Tables, constraints, indexes, views, sequences and synonyms.
• Listing direct /indirect dependencies among Oracle objects.
• Data ingestion using sql-loader, external tables and Oracle AQs.
• Performance tuning: explain plans, identifying long running jobs, compare explain/execution plans and review AWRs.
• Creating rerunnable jobs and jobs scheduling using Oracle job scheduler.

• Shell scripting experience to move, compress and archive files (must for lead developer role)
• Worked on source code management such as SVN, GIT, Bit Bucket and pipeline creation using Jenkins.

Let’s grow together