Systems Programmer Analyst - Oracle

RESPONSIBILITIES

- Develop Oracle code that runs at optimal performance utilizing hints, cost-based optimizer, and optimal table join method practices.
- Perform thorough unit testing, system testing, analysis, and debugging.
- Aid in the creation of installation and deployment documentation
- Effectively trouble-shoot the issue and drive to a resolution.
- Perform given assignments with little intervention of others or follow-up - while gaining knowledge of the application in the process.
- Supports many applications simultaneously and quickly change focus, while still not losing site of prior commitments and tasks.
- Gather questions and concerns, note them with appropriate parties - then move onto other assignments while waiting for an answer.
- Gather requirements and identify the needs and details required to complete the task - all the while still being able to see the big picture.
- Analyze and identify issues. Upon identification of issue, use development skills to write code for correction - as well as write effective and complete unit test, perform unit test, and create deployment scripts.
- Effectively communicate with all levels of Company resources. This includes management, peers and business teams. Must be able to clearly state the: current issues (enhancements/projects) at hand; risks associated with the development of and or applying fixes; enhancements/projects) in a timely manner; roadblocks to presenting the fix (enhancements/projects); and status of issue resolutions (enhancements/projects) and time-line to completion{c}

SKILLS

Technical Skills: Strong development experience in PL/SQL using packages, procedures, functions. Experienced in SQL*Plus commands. Practical experience with Oracle database (9i, 10g, 11g). Management of various database objects (eg tables, indexes, views, etc. Familiarity with data dictionaries (eg all_tab_columns, v$ views, etc.) Proficient in the code tuning and optimization. Familiarity with development tools such as TOAD, PL/SQL Developer, SQL Navigator, SQL* loader. Unix Kornshell Scripting (nice to have). Ability to work independently. Excellent communication skills. Demonstrated Initiative - Self-starter: Recognize that a task needs to be accomplished, and takes the initiative to gather the details and see that the necessary points are addressed and carried-out. Must be able to multi-task well. Must be an excellent problem solver.

Synectics is an Equal Opportunity Employer.