Previous Job
Previous
Systems Designer 1 - ORACLE SQL
Ref No.: 17-23302
Location: Chicago, Illinois
Required Skills :
Oracle PL/SQL and familiarity with Oracle Order management, AR, Inventory, and Channel Revenue Management§
Excellent analytical, problem solving, organizational, communication and interpersonal skills
Extensive knowledge of applicable programming languages, tools, and other applicable information technologies
Extensive knowledge of programming methodology, test plan development, development life cycle and testing methods

Basic Qualifications :

Job Description :
Position: Oracle PL/SQL Developer
Location: Chicago, IL
Length: 3+ Month Contracts
POSITION SUMMARY
Analyzes, designs, develops, tests, documents and implements programs, applications and systems that meet the clients business requirements. This would be in the Oracle space developing PL/SQL against Order Management, AR, Inventory, and Channel Revenue Management modules. Coordinates activities that affect availability, reliability, and functionality of delivered products. Reviews work of other development team members in the EDI space. Provides application assistance to business, support, and operations organizations. Collaborates with the business in developing business requirements.
Job Knowledge
· Analyzes, designs, and develops new applications/business systems and application enhancements according to business specifications and technical designs; creates technical specifications and documents deliverables
· Documents application requirements and models current/proposed information and process flows
· Ensures unit, system, and integration test plans exist, performs quality reviews of testing and coordinates testing across all teams
· Reviews work of others to ensure design approach and delivered product is consistent with business requirements
· Ensures all appropriate technical documentation is completed and up-to-date (program, system, change management, etc.)
· Assists in re-engineering system related processes
· Functions as subject matter expert in those areas where extensive knowledge is present
· Proficient in, and assists others in using programming aids and tools, utilities, database access methods, and systems software
· Addresses development issues escalated within the team
· Keeps abreast of current and emerging information technology and trends
· Managing Resources
· Assists in the following project efforts: creating project plans with timelines, resolving problems on scheduling, controlling projects, ensuring deadlines are met
· Assists in overseeing analysis, design, and development of new systems and enhancements according to internal customer expectations and technical design
· Assists in preparation of cost benefit analysis and estimates
· Business Focus
· May be required to staff disaster recovery site
· Assists in determining service level agreements and ensures they are met
· Reviews internal customer materials and training curriculum to ensure content accuracy
· Collaborates closely with the business to ensure that business needs are well understood and are designed into the provided solutions
· Coordinates or leads third level application support efforts
· May be required to provide 24 hour on call support
· Administration/Organization: May be key contact for day-to-day vendor interface
· Communication: Communicates with internal customers in terms that the customer is able to understand (since this is part of the P/A role, do we also need it here if the requirement is to demonstrate all the skills from the P/A role?)
· Decision Making/Problem Resolution: Looks for improvements and recommends/implements innovative solutions
· Developing Others: Trains and mentors new and/or less experienced team members in development related areas
· Developing Others: May provide input into performance reviews and training objectives
· Leadership: May assist in leading design and code reviews, application post-implementation project review meetings, or team meetings
· Work Quality: Analyzes, documents, and resolves problems in accordance with department quality standards and procedures (should this not apply to ALL positions?)
· Performs at a level clearly above that of the related Systems Designer 1 position by demonstrating greater productivity, proficiency, leadership and mastery of job content
· Performs additional responsibilities as assigned
· Expectations associated with this position are outlined further in the IT Job Expectations document – please refer to that document for a detailed list of additional requirements for this position
· Nature and Scope:
· Supervisory role is limited to reviewing work of others, does not conduct performance reviews
· Works under minimal supervision, relying on experience and judgement to plan and accomplish assigned goals
· Leads small to medium projects; participates in projects of all sizes
KEY QUALIFICATIONS:
Education
· Required: Bachelor’s degree in Computer Science or related field
· Years of Experience
· A minimum of 7 years of in-depth applications programming and design experience
Required Skills
· Oracle PL/SQL and familiarity with Oracle Order management, AR, Inventory, and Channel Revenue Management§
· Excellent analytical, problem solving, organizational, communication and interpersonal skills
· Extensive knowledge of applicable programming languages, tools, and other applicable information technologies
· Extensive knowledge of programming methodology, test plan development, development life cycle and testing methods
· Extensive unit and system testing experience
Preferred Skills
· Experience in the design and implementation of complex business applications
· Experience in leading projects
· Solid knowledge of business area supported or similar business experience