What are the responsibilities and job description for the Oracle PL/SQL Developer position at Motion Recruitment?
Our client is looking for a OIT Software Development Specialist Sr on a 11-month contract in Memphis, TN.
Join over 20,000 employees at this global company specializing in technology-enabled claims and risk management solutions. You will be part of a culture that is constantly recognized for progressive, inclusive employment practices, and be part of a bigger movement to simplify complexities in the areas of workers compensation, liability, property, disability, and absence management.
You will work alongside some of the smartest minds in the industry who are excited to share their knowledge and to learn from you.
Contract Duration: 11 Months
Required Skills & Experience
Join over 20,000 employees at this global company specializing in technology-enabled claims and risk management solutions. You will be part of a culture that is constantly recognized for progressive, inclusive employment practices, and be part of a bigger movement to simplify complexities in the areas of workers compensation, liability, property, disability, and absence management.
You will work alongside some of the smartest minds in the industry who are excited to share their knowledge and to learn from you.
Contract Duration: 11 Months
Required Skills & Experience
- Bachelor's degree from an accredited college or university.
- Strong knowledge of language development and applications design.
- Analytical and interpretive skills
- Strong organizational skills
- Excellent interpersonal skills
- Excellent negotiation skills
- Ability to work in a team environment
- Ability to meet or exceed Performance Competencies
- At least 8 years of experience as an Oracle PL/SQL Developer.
- Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, Job, Schedulers, PL/SQL Web-services, Java Stored Procedures and Oracle AQ.
- Hands on experience on XML generation inside PL/SQL components.
- Strong Skills in data analysis, data modeling, development, testing and documentation.
- Strong skills on automating jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking SQL *Plus.
- Hands on writing Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets, Arrays & Queues.
- Strong Skills in Exception Handling extensively debug PL/SQL Code, DDL, DML and display the error messages in the application.
- Experience in creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
- Experience in SQL Tunning to improve the query performance by identifying key fields, adding/removing tables/fields, and use of indexes.
- Good understanding of Oracle Explain Plan.
- Information Systems or Computer Science major
- Develop, maintain, test and debug software to meet generally defined requirements in a Windows client/server environment utilizing software development languages/environments such as PL/SQL, Oracle, Progress 4 GL Application Development Environment (ADE), .Net, Microsoft SQL, or other platforms.
- Formulate and define system scope and objectives through research and fact-finding for the purpose of developing or modifying moderately complex information systems.
- Prepare detailed specifications from which programs will be written.
- Design, code, test, debug, document and maintain programs.
- Become familiar with most aspects of the application including reports, parameters, claims management, intake services, carrier/client interfaces and vendor/business partner interfaces.
- Analyze user needs as required.
- Assist in the design of specifications to meet end user needs.
- Develop and modify software to meet the specifications outlined in data processing requests.
- Develop and maintain software to meet the requirements of insurance carrier and regulatory groups.
- Test and debug assigned projects.
- Assist in testing projects for other members of the programming staff.
- Prepare documentation on new or existing software.
- Investigate call escalations from the support staff.
- Make the necessary corrections to data and/or software.
- Assist in the professional growth of programmers.
- Follow departmental pre-established standards and guidelines as they pertain to design and development.
- Adhere to the goal of delivering and maintaining the highest quality of customer service to our clients.
- Keep abreast of software development language revisions and technology advances.
- Perform other duties as assigned.
- Support the organization's quality program(s).
