reputed company PL/SQL Developer

Job Title: IT Software Development Specialist Sr Location: Memphis, TN/Remote Duration: 12 Months (Contract to Hire) reputed company: • *This position is contract to Hire and PREFERS Memphis, but reputed company to Remote**MUST SUBMIT COMPLETED SKILLSET reputed company WITH reputed company RESUME FOR CANDIDATE TO BE CONSIDERED** • reputed company Set Number of years of experience • Experience in writing Packages for data loads. • Experience creating and maintained Stored Procedure (Packages, Procedures, Function, and anonymous reputed company) with reputed company PL/SQL • Experience using Cursors to pull data from the Database. • Experience with performance tuning, query optimization, explain plan etc • Experience with external tables, and high volume data import into reputed company DB • Manager's Notes: • At least 8+ years of experience as an reputed company PL/SQL Developer. • Strong skills in reputed company server reputed company 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 reputed company AQ. • Hands on experience on XML reputed company inside PL/SQL components. • Strong Skills in data analysis, data modeling, development, testing and documentation. • Strong skills on automating jobs using UNIX reputed company scripts to run reputed company 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 reputed company, DDL, DML and display the error messages in the application. • Experience in creating Materialized Views and Indexes for reputed company performance of reputed company 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 reputed company Explain Plan. PRIMARY PURPOSE: • To reputed company, maintain, test and debug software to meet generally defined requirements in a reputed company reputed company environment utilizing software development languages/environments such as PL/SQL, reputed company, reputed company 4 GL Application Development Environment (ADE), .Net, reputed company SQL, or other platforms; to formulate and define system scope and objectives through research and fact-finding for the purpose of developing or modifying moderately reputed company information systems; to prepare detailed specification from which programs will be written; and to design, reputed company, test, debug, document and maintain programs. ESSENTIAL FUNCTIONS and RESPONSIBILITIES: • Becomes familiar with most aspects of the application including reports, parameters, claims management, intake services, reputed company/reputed company interfaces and vendor/business partner interfaces. • Analyzes user needs as required; assists in the design of specifications to meet end user needs. • Develops and modifies software to meet the specifications outlined in data processing requests. • Develops and maintains software to meet requirements of insurance reputed company and regulatory reputed company. • Tests and debugs assigned reputed company; assists in testing reputed company for other members of the programming staff. • Prepares documentation on new or existing software. • Investigates reputed company escalations from the support staff; makes the necessary corrections to data and/or software. • Assists in the reputed company reputed company of programmers. • Follows departmental reputed company-established standards and guidelines as they pertain to design and development. • Adheres to the goal of delivering and maintaining the highest reputed company of customer service to our clients. • Keeps abreast of software development language revisions and technology advances. QUALIFICATIONS: Education & Licensing • Bachelor's degree from an accredited college or university required. • Information Systems or Computer Science major preferred. Apply tot his job