Recruiter

JOBG8

Location

United States

Job term

Permanent

Job hours

Full time

Java PL/SQL Developer

Chicago, IL

90-110k end of contract

5 month contract to hire

No third party resumes

Major trading firm is seeking a highly skilled and experience Java PL/SQL Developer to design with team lead experience to develop in web based technologies on the Front End, proprietary Java based CORBA distributed Middleware/server component framework and Oracle PL/SQL Scripting on the Back End.

Responsibilities:

* Work with end users to gather and define/refine functional requirements.

* Producing project documentation-high level charter, functional requirements, and technical design and test documents.

* Design, code, test, and implement Java based monitoring systems and PL/SQL batch based surveillance applications with Web GUI components.

* Working closely with infrastructure team on server systems design and DA/DBA/DW teams on the database design and set up.

* Provide ongoing application support to end users and communicating technical information clearly to an end user audience.

* Participate in production 24/7 on call support rotation.

Requirements:

* Min of 8-10 years. of experience in software systems or applications development.

* Must have 8 years. of Java development experience

* Lead experience in a current role.

* 3 years of PL/SQL development experience.

* Strong analytical and design abilities, self motivated, highly multi-tasking, dynamic and adapts to changing business needs.

* Bachelor's degree required.

Please answer the following questions and send back along with an updated Resume.

* Have you used subqueries? In-line views? In what situations did you need to use a subquery rather than just join the tables together in the where clause?

* Have you used cursors?

* Used aggregate functions or analytic functions, If so what's an example of where you used one of each type

* Used merge?

* Developed user-defined data types and records?

* Developed and used packages, procedures, functions? Pass collections or cursors as arguments to procedures, functions?

* How do you verify efficiency of the SQL?

* Have you worked with distributed database environments which required joining tables across the databases?