Job Description :
Job Title: Oracle Software Engineer
Location: Smithfield, RI
Duration: 6-12 Months
Summary:
Corporate Technology Security Services - CLRS (Compliance, Legal, Risk and Security) team is responsible for designing, building and maintaining the Corporate Surveillance systems for the firm using vendor platforms like Actimize. The CLRS team seeks an experience, skilled and energetic Oracle software engineer to fill this need. The selected candidate will be tasked with providing the team with PL/SQL querying, performance tuning, in collaboration of their design efforts in support of laundering and excessive trading compliance and surveillance. This database developer will possess a combination of technical skills, communication skills and business knowledge.
This developer will be able to take oral and written business requirements and develop efficient code to meet deliverable''s.
Responsibilities:
Participate in the development, enhancement and maintenance of database applications both as an individual contributor and as a team member.
Drives stored procedure design for projects
Create SQL database packages and procedures.
Designs batch cycle procedures on major projects using Unix shell scripting and Control M.
Performs functional analysis for major projects supporting several corporate initiatives Acts as an expert technical resource across functional organizations and monitors performance of project plans.
Works with IT partners and user community for project definition.
Works on multiple platforms and multiple projects concurrently.
Performs independent technical analysis on complex projects.
Performs code and unit testing for complex scope modules, and projects.
Acts as a technical resource for others.
Required Qualifications:
A minimum of 5 years of experience in database development (primary focus is Oracle
Solid PL/SQL programming skills
Experience in the following areas - UNIX Shell Scripting, Netezza, and Informatica ETL.
Comprehensive experience with database systems and related software Experience with Control M (or similar job scheduling AutoSys
Ability to read and interpret physical data models
Solid knowledge of DBMS optimizer and performance tuning techniques.
Ability to translate requirement documents into DBMS language.
Experience with regression testing and stored procedure development.