Huntington Ingalls Industries Oracle PL/SQL Developer - 19161 in Merrifield, Virginia
Oracle PL/SQL Developer - 19161
Position Location Merrifield, VA
Requisition # 19161
# of Openings 3
HII – Mission Driven Innovative Solutions Inc. (HII-MDIS) provides mission-critical engineering and technical service to Information Technology, Federal Civilian, and National Security, Aerospace & Defense and International government and commercial customers at over 100 locations worldwide.
HII - MDIS is currently seeking an Oracle PL/SQL Developer to work out of their client's Merrifield, VA office.
Roles and Responsibilities:
Develop complex database processes with PL/SQL containing batch or ETL functionality
Develop and enhance an existing DataMart in an OLAP schema
Requirements gathering, design, development, testing and documentation
Design logical and physical ERD diagrams, process flow diagrams, or related data processing documentation
Leverage Oracle 11G/12C features to their fullest on a large-scale multi-terabyte system
Assist Decision Support team members including DBAs, database developers, requirements analysts, and others, in understanding data and meeting user requirements
Participate in project work groups with Subject Matter Experts and stakeholders to understand data specific needs
Participate in performance tuning activities
Provide 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; demonstrate abilities to learn both the business processes as well as new and existing technologies
Work on sprint team in agile, rapid development and deployment environment.
Support production application - investigate and resolve production inquiries and issues. Requires flexible schedule.
Other duties as assigned
Qualifications and Experience:
Bachelor’s Degree plus a minimum of 10 years of applicable experience.
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
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
Excellent analytic, troubleshooting and performance tuning skills
Detail oriented with strong problem solving skills
Ability to analyze complex and large amounts of data
Strong communications skills (both verbal & written)
12 years of IT experience.
Postal or mailing industry experience
Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information
Must be able to obtain and keep a USPS Sensitive Clearance
Must be a U.S. Citizen or Green Card holder and have been living in the U.S. for at least the last five years
Must not have traveled outside of the United States for more than 180 days in the last five years
All candidates will be subject to a pre-employment background investigation and drug screening per HII requirements.
Huntington Ingalls Industries is proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected class.