Oracle Database Development Lead Job in Oakland, California Us
Major agency is looking for a Oracle Database Development Project Lead for a 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 management and reviews project proposals to determine goals, time frame, funding limitations, procedures for accomplishing project, staffing requirements, and allotment of resources.
* Formulates and defines technical scope and objectives of project.
* Identifies and schedules project deliverables, milestones and required tasks
* Coordinates and responds to requests for changes form original specifications.
* Develops and maintains technical and project documentation. Develops quality assurance test plans. Directs quality assurance testing.
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.
