Job Description :
Job Title: Oracle PL/SQL Developer
Location: Lansing, MI
Duration: 12 Months
Position Type: Contract
Interview Type: In-Person
Required Skills:
Demonstrable working experience in systems design, development, and programming medium-to-large scale internet-based systems. Required 7 Years
Extensive Oracle / PL/SQL programming experience Required 7 Years
UNIX operating system / scripting experience (including JavaScript) Desired 4 Years
Front-end experience designing web-based business applications using Oracle, JSP, JQuery, CSS, and HTML Required 4 Years
Version Control software (i.e. CVS, PVCS, etc Desired 4 Years
Extensive experience writing complex SQL queries and generating analytical reports Required 6 Years
Job Description:
This is an Oracle PL/SQL developer position. This position prefers a Bachelor''s Degree in Computer Science / Information Systems. Plans, develops, tests, and documents computer programs, applying knowledge of programming techniques and computer systems.
Years of Experience:
5-7 years of experience in the field or in a related area.
Job Description:
Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, may lead and direct the work of others, a wide degree of creativity and latitude is expected.
Plans, develops, tests, and documents computer programs, applying knowledge of programming techniques and computer systems. Evaluates user request for new or modified program, such as for financial or human resource management systems, clinical research trial results, statistical study of traffic patterns, or analyzing and developing specifications for bridge design, to determine feasibility, cost and time required, compatibility with current system, and computer capabilities. Consults with user to identify current operating procedures and clarify program objectives. Formulates plan outlining steps required to develop program, using methodologies such as structured analysis and design or object-oriented development.
Work involves assisting in analyzing systems outlines to develop programs for computer applications, writing solution programs, documenting the methods and procedures used in program development, and testing and correcting programs. Works under moderate supervision with limited latitude for the use of initiative and independent judgment. Develops block diagrams and machine logic flowcharts to represent operations and data flow for applications.
Captures requirements using industry standard development frameworks and tools. Designs reports, forms and letters along with computer terminal screen displays to accomplish goals of user request. Reviews screens, reports, forms and letters designs with users. Converts project specifications, using industry standard tools, such as object-oriented tools and code generation, into sequence of detailed instructions and logical steps for coding into language processable by computer, applying knowledge of computer programming techniques and computer languages.
Enters program codes into computer system. Enters commands into computer to run and test program. Reads computer printouts or observes display screen to detect syntax or logic errors during program test, or uses diagnostic software to detect errors. Replaces, deletes, or modifies codes to correct errors. Analyzes, reviews and alters program to increase operating efficiency or adapt to new requirements. Writes documentation to describe program development, logic, coding, and corrections. Writes manual for users to describe installation and operating procedures. Assists users to solve operating problems. Recreates steps taken by user to locate source of problem and rewrites program to correct errors. May use computer-aided software tools in each stage of system development. May train users to use program. May oversee installation of hardware and software. May provide technical assistance to program users. May install and test program at user site. May monitor performance of program after implementation. May specialize in developing programs for business or technical applications.
Duties will include -
Participate in workgroup(s) to determine system requirements based on federal guidelines, state mandates, program-area changes, and user group feedback;
Analyze state and federal reporting requirements, as necessary;
Understand inter-system relationships and determine complex system changes;
Understand performance implications associated with requested and recommended solutions;
Recommend new technology improvements that support requested and recommended solutions;
Determine system architecture changes necessary to implement major project enhancements;
Provide programming expertise to make required architectural changes regarding the PL/SQL programming environment;
Understand and use DTMB SUITE / Systems Engineering Methodology practices and procedures during the application development life cycle.
Assist with testing and provide quality assurance checks for system changes;
Understand and provide solutions for data conversion issues;
Provide documented solutions for migrating changes and enhancements to training and production systems;
Track updates to systems with version control software.
Provide staff training as necessary.
The successful candidates must be able to function as a team member in a group environment, as well as work independently with minimal supervision.
This position requires excellent written and verbal communication skills.
Previous experience with development of both online and reporting systems will be considered a plus;
Previous experience conducting development group walkthroughs is preferred.
Previous experience with State of Michigan SUITE Systems Engineering Methodology (SEM) development practices will be considered a plus.
Ability to demonstrate the capability to learn and adapt new technical strategies and new technologies to business practice will be considered a plus.