Huntington Ingalls Industry Jobs

Job Information

Huntington Ingalls Industries Database Developer - 18572 in Raleigh, North Carolina

Database Developer - 18572

Position Location Raleigh, NC

Requisition # 18572

# of Openings 1

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 a Database Developer to work out of their client's Raleigh, NC office.

Duties and Responsibilities (to include but not be limited to the following):

  • Experience with relational database design, implementation and/or data load experience on large database implementations

  • Design, develop, test, performance tune, deploy and support Teradata database components.

  • Develop complex database processes with BTEQ containing batch or ETL functionality

  • Responsible for performing performance tuning Teradata, SQL, Unix shell Scripting

  • Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD

  • With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc) etc.

  • In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.

  • Requirements gathering, design, development, testing and documentation

  • Design logical and physical ERD diagrams, process flow diagrams, or related data processing documentation

  • Debug, troubleshoot, root cause analysis and resolve issues within SLA

  • 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 and unit testing

  • 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; - and demonstrate abilities to learn both the business processes as well as new and existing technologies

Qualifications and Experience :

Required –

  • Bachelor’s degree (focus in technical field a plus, for example: engineering, mathematics, statistics, computer science or related field) plus at least 7 years of professional experience

  • 3+ years of experience in designing, creating and developing with Teradata

  • Experience in developing logical and physical data models using data modeling tools such as Rational Data Architect, Erwin, Oracle Developer, other tools

  • Strong programming/development skills using BTEQ and SQL (Procedures, functions, Macros) and batch coding skills, and parallel processing

  • 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)

  • Please note this is not a database administration position

  • Skill using SQL sufficient to mine, extract and produce complex data sets to meet analytic business requirements.

  • Familiarity with RDBMS technologies like Oracle and Teradata.

  • Ability to model data to meet input and output performance requirements.

  • Ability to merge data from internal and external sources to provide new insights and capabilities.

  • Ability to provide technical guidance related to data design, data collection, and data governance.

  • Ability to communicate orally and in writing to provide feedback, technical guidance, and instruction to cross functional teams in the development of data mining, provisioning and modeling tools and processes

  • Ability to solve problems using analytical skills.

  • Ability to work without immediate supervision.

​Preferred

  • Experience using large scale Hadoop environments including SQOOP, HIVE, FLUME, and SPARK.

  • Experience with SAS, R, Python, SPSS, etc.

Security:

  • 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.

DirectEmployers