PL SQL Java Developer job vacancy

Vacancy expired!

Detailed Job Description:

Mandatory Skills:

Java (batch experience; not UI) 3+ years:

using java to invoke JDBC call to execute PL/SQL Procedure and Functions; and generate report files.

JDBC API (Oracle, Sybase, Sybase IQ, MS-SQL Server)

Pipe Streaming to Linux binary

Oracle 3+ years:

Write PL/SQL to handle large volume of data (A few hundred million records table)

Interpret oracle query plans (including parallel execution plan)

Oracle Optimizer Hints

Linux (2+ years):

Must have Linux experience and running batch java code in Linux invoked by shell script

Linux Shell command like awk, ls, cut, sort, ps, etc.

Linux Library APIs - Java Native Interface (Optional)

Design processes and workflows to model business processes (2+ years):

Design table structure and indexes.

Table partitions design and operation

Relational Data Model

Release Control (1+ year):

Using maven to build jar libraries via artifacts

Use of GitHub as source control

Use of Jenkin to compile and source code

Use of SonarQube on source code scanning

Personality and Interpersonal Skill:

Strong communication skill

Good documentation skill

A good team player

Proactive

Education:

Prefer computer science undergraduate (with Database course, Algorithm course, Data Structure course)

Certification (Optional):

Java certification from Oracle (Optional)

Oracle Database PL/SQL Developer Certified Professional Certification (Optional)

PL/SQL + Java Developer