Kforce Oracle PL / SQL DBA in Seaside, California

Kforce Inc. is immediately adding a full time Oracle PL/SQL DBA to our team in support of our enterprise technology solutions client in Seaside, CA. Our client is an end-to-end services company providing information technology and consulting services to businesses and governments.Essential Functions:

  • Support the derivation, definition, and capture of project, application and/or system requirements during the business or requirements analysis phases which include: identifying possible technical solutions and best value alternatives; identifying and documenting the requirements traceability throughout the project/product lifecycle; and the development of functional and/or technical specifications as required by the Government

  • Identify and translate business requirements into functional and system requirements, information requirements, reporting requirements, interface requirements, data formats, operational characteristics, information flows, and security and accreditation considerations

  • Develop use cases to capture the various ways that the system will be used and develop a requirements traceability matrix (RTM) specification document, including use cases where applicable and review/assist with development of technical requirements

  • Document the relationships between requirements and other development lifecycle artifacts to ensure thorough coverage and functionality of all government requirements via a published traceability matrix

  • Produce a technical design to specify the technical architecture, technical functionality, DODAFs and other technical documentation required by the DoD; user interfaces and interfaces as required by the project/product

  • Conduct system analysis support to ensure requirements compliance, identify problems of the existing application, correctly attribute them to automated processes and/or submission data and develop solutions

  • Document the software release scope correlating the business requirements

  • 10 years' experience with Complex SQL queries, and generating reports using PL/SQL against Oracle Database

  • Strong background with OLTP databases and OLAP (Data Warehouse and Data Marts) databases

  • Ability to develop and test Oracle PL/SQL procedures and triggers; perform SQL tuning and re-write code as necessary; Develop and maintain functional and technical documentation

  • Exceptional ETL Design/Development knowledge

  • Strong experience in analyzing complex data, and entity relationships in Oracle tables to develop processes, and oracle components to identify, document and fix data discrepancies

  • Strong scripting skills to perform data/file management (e.g. PERL, Python, Shell, etc.)

  • Good understanding of Database Design and Data Modeling concepts

  • Extensive experience in Data Migrations, Data Quality and Data Maintenance

  • Knowledge of BI/Data Warehouse concepts, including star schema, aggregation processes

  • Good knowledge of Cursors, collections and Advanced PL/SQL concepts

  • Understand and interpret customer requirement and develop solutions to meet requirements

  • Able to function independently with minimal oversight and direction

  • Must be able to effectively articulate complex, technical concepts to on-site clients, non-technical management and co-contractors

  • Applicants must be fully authorized to work in the U.S. without sponsorship

Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information. Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.Compensation Type:Hours