Kforce Oracle PL / SQL DBA in Seaside, California

Kforce is immediately adding a full time Oracle PL/SQL DBA to our team in support of our enterprise technology solutions client in Seaside, California (CA). Our client is an end-to-end services company providing information technology and consulting services to businesses and governments.Essential Job 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

  • 5 - 7 years of 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

  • 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

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

  • Exceptional ETL design/development knowledge

  • Good understanding of Database Design and Data Modeling concepts

  • 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

  • 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

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

  • 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

  • Must be an effective team player

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

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