ICF has a long history of providing a broad range of skills to the US Postal Service including project management, process improvement consulting, analytical services, modeling and statistical analysis, marketing and communications, and systems development across the organization. We have an opportunity for an Oracle PL/SQL Database Developer to develop new business intelligence applications! Are you interested in making your next BIG move? This role works from client site in Fairfax, VA.
What you will be doing:
- Developing complex database processes with PL/SQL containing batch or ETL functionality
- Developing and enhancing an existing DataMart in an OLAP schema
- Requirements gathering, design, development, testing and documentation
- Designing logical and physical ERD diagrams, process flow diagrams, or related data processing documentation
- Leveraging Oracle 11G/12C features to their fullest on a large-scale multi-terabyte system
- Assisting Decision Support team members including DBAs, database developers, requirements analysts, and others, in understanding data and meeting user requirements
- Participating in project work groups with Subject Matter Experts and stakeholders to understand data specific needs
- Participating in performance tuning activities
- Providing production deployment and production support as needed
- Analyzing and converting business requirements to technical requirements, followed by designing and implementing the solutions
- Involved in all aspects of the software development life cycle; - and demonstrate abilities to learn both the business processes as well as new and existing technologies
What you will need to have:
- 5+ years of experience in designing, creating and developing Oracle database systems
- Strong programming/development skills using PL/SQL (package, procedures, functions, triggers) and batch coding skills such as Bulk collections, dynamic SQL, and parallel processing
- Big data experience, the ability to manage large datasets, how to query, extract, and organize data in useful ways to reduce performance related issues
- Solid experience designing partitioned and non-partitioned tables, indexes, temporary tables and external tables to maximize storage and performance
- Experience in developing logical and physical data models
- Experience designing OLAP systems
- Strong SQL development, SQL analytics and tuning skills
- Ability to analyze complex and large amounts of data
Professional Skills:
- Excellent analytic, troubleshooting and performance tuning skills
- Detail oriented with strong problem solving skills
- Strong communications skills (both verbal & written)
About ICF:
ICF offers an excellent benefits package, an award winning talent development program, and fosters a highly skilled, energized and empowered workforce.
ICF is an equal opportunity employer that values diversity at all levels. (EOE – Minorities/Females/Veterans/Individuals with Disabilities/Sexual Orientation/Gender Identity)
ICF is an equal opportunity employer that values diversity at all levels. (EOE – Minorities/Females/Veterans/Individuals with Disabilities/Sexual Orientation/Gender Identity)
Pay Transparency Statement: For more information, please click here: https://www.dol.gov/ofccp/pdf/pay-transp_formattedESQA508c.pdf
