What are the responsibilities and job description for the Oracle Database Architect position at Software People, Inc.?
Phone/Skype Hire. Onsite from day 1
Location: Albany, NY
Duration: 12 months
Responsibilities
- Creation/Enhancement of Software used to collect, submit, view, and extract data regarding managed care costs and statistics to be used for various purposes including setting Medicaid rates.
- The candidate will be responsible for, but not limited to; writing and modifying Oracle database procedures and functions to support the applications (including coding, testing, and implementation); understanding and translating historical data, now in Sybase, to Oracle; Preparing technical and user documentation.
Skills Needed
- 84 Months Experience interpreting physical database models including experience with relational database concepts such as indexes, primary/ foreign keys, and constraints using Oracle version 9i or later. This includes experience creating database objects such as Tables, Indexes, Views, Sequences, Primary/Foreign keys, Constraints and Triggers.
- 84 Months Experience in using ORACLE programming tools (SQL Plus, PL/SQL, SQL Loader or other ORACLE database programming tools).
- 60 Months Experience writing, optimizing, and troubleshooting dynamically created SQL within procedures.
- 60 Months Experience in database optimization
- 60 Months Experience in database analysis and design.
- 36 Months Experience working with Sybase.
- Bachelor's degree in computer science or a comparable field
