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 :
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.
Experience using large scale Hadoop environments including SQOOP, HIVE, FLUME, and SPARK.
Experience with SAS, R, Python, SPSS, etc.
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.