The selected individual will perform the following tasks Design, develop, implement, and maintain relational database capabilities in an Enterprise Table Oracle 11g environment in support of enterprise reporting requirements. Design, develop, maintain Extract, Transform, and Load (ETL) interface code for enterprise business data. Support an enterprise data warehousing environment.
Analyze new requirements to build capabilities in an enterprise environment, and will provide enhancements and bug fixes to existing database objects. Be responsible for meeting with project representatives to understand their data requirements.
Develop Entity Relationship Diagrams (ERDs) using data modeling software such as Oracle Designer, Erwin or Power Designer. Transform ERDs into a physical database design and produce build scripts for the database objects following project specifications. Follow the standards for the enterprise warehouse database environment. Process change requests as assigned, including but not limited to complex queries, PL/SQL packages, views, ETLS, and SQL tuning.
***** All positions require a Active (TS/SCI) Clearance with a Polygraph to be considered*****
Mandatory Skills:
Demonstrated full lifecycle development experience of large, mission-critical databases, that have intersecting data.
Demonstrated software engineering and database development skills.
Demonstrated relational database design skills.
Demonstrated experience with database design/CASE tools such as Oracle Designer, Erwin or Power Designer.
Demonstrated experience in SQL and PL/SQL i.e. procedures, functions, exception handling and triggers.
Experience in writing and tuning complex queries.
Demonstrated experience implementing medium to complex security policies in Oracle, such as with Fine-Grained Access Control.
Demonstrated understanding and ability to work under established configuration management practices and policies.
Demonstrated experience in coding ETL interfaces.
Demonstrated experience working in an agile development environment.
Optional Skills:
Familiarization with various business data and how data is shared across business areas.
Experience working with multiple customers with competing delivery timelines & needs.
Demonstrated ability to effectively plan workload and meet established deadlines.
Demonstrated effective problem solving skills.
Demonstrated background and experience in Oracle Relational Database Management Systems.