Oracle Database Developer Job in Oakland, California Us
Major agency is looking for an Oracle Database Developer. Candidate will be responsible for PL/SQL Database design and development to enhance a system to support the latest standards and requirements. Agency is looking for hands on support to assist State Staff in implementing this change.
Essential Duties and Responsibilities:
* Consults with clients and gathers information about program needs, objectives, functions, features, and input and output requirements. Writes and maintains technical specifications. Develops and maintains plans outlining steps and time tables for developing programs.
* Researches and evaluates software and hardware to assist in programming or to use as program platforms. Creates test transactions and runs tests to find errors and confirm programs meet specifications.
* Writes and maintains documentation to describe program development, logic, coding, testing, changes and corrections.
Mandatory Quals:
* At least five years experience with data warehouse design and development : extracting, cleaning, conforming, and delivering source data into a dimensional data store
* At least seven years experience with PL/SQL application programming for an Oracle relational database and with Oracle systems development
* At least seven years experience with code management and release management.
* Ability to work in a team environment, both as team member and team lead.
* At least five years experience with and knowledge in database and application design using RDBMS Oracle 9 or higher.
* Experience with knowledge transfer and writing detailed documentation.
Desirable Quals:
* At least five years experience with Unix operations and development.
* At least one major project using medical billing data, ANSI ASC X12 837 and 824 standards and the IAIABC EDI transmission standards for medical billing and injury reports.
* At least one major project developing or maintaining database applications handling one or more of the following categories of data: medical billing, insurance claims, medical care, social service case management, workers compensation claims.
* At least one major project automating batch processes.
* At least one major project working on database schema migration.
