Principal Data Modeler and Database Engineer; Onsite Security Clearance

Position: Principal Data Modeler and Database Engineer (Onsite) with Security Clearance
Date Posted:

Country:
United States of America

Location:

TX234:
Richardson 1717 City Line 1717 East City Line Drive Building C17, Richardson, TX, 75082 USA
Position Role Type:
Onsite U.S. Citizen, U.S. Person, or Immigration Status Requirements:
Active and transferable U.S. government issued security clearance is required prior to start date. U.S. citizenship is required, as only U.S. citizens are eligible for a security clearance
Security Clearance: TS/SCI without Polygraph At Raytheon, the foundation of everything we do is rooted in our values and a higher calling - to help our nation and allies defend freedoms and deter aggression. We bring the strength of more than 100 years of experience and renowned engineering expertise to meet the needs of today's mission and stay ahead of tomorrow's threat.

Our team solves tough, meaningful problems that create a safer, more secure world. Raytheon is hiring a Principal Data Modeler and Database Engineer to support our teams in Richardson TX or Aurora CO. You will have the opportunity to directly impact the world around you and contribute to classified programs and technologies you are passionate about. In this position you would be familiar with designing, creating, updating, and managing databases and high performance data models.

What You Will Do
* Identify and understand customer needs and apply sound, demonstrable understanding of database principles, theories, and concepts related to software engineering to translate those needs to viable design solutions.

* Translate needs and design requirements into physical data models.

* Analyze business requirements, RFCs, and technical specifications to identify data modeling impacts and design needs.

* Collaborate with systems engineers, product owners, architects, and stakeholders to gather and validate data requirements.

* Design new database structures (tables, indexes, constraints, views) and modify existing models to accommodate program needs.

* Author and implement database data model changes (DDL) using database change control automation.

* Work with developers on best practices for interacting with databases, writing and maintaining SQL statements.

* Utilize data modeling tools such as Oracle SQL Developer Data Modeler, Oracle Designer, and others.

* Demonstrate critical thinking skills with the ability to communicate concepts and ideas clearly.

* Use proven problem solving and analytical skills.

* Work in an Agile/Scrum environment.

* Must be able to obtain and maintain SCI program access and complete polygraphs.

* Obtain Security+ certification within 60 days of start. Qualifications You Must Have
* Typically requires a degree in Science, Technology, Engineering, or Mathematics (STEM) and a minimum of 8 years of Database Engineering experience.

* Five (5) years of experience performing relational data modeling with Oracle and Postgre

SQL Relational Database Management Systems (RDBMS).

* Eight (8) years of experience with Oracle SQL and PL/SQL and Postgre

SQL SQL and pl/pgsql skills.

* Experience with bash scripting and python.

* Experience working with Systems and Software Engineers to design, implement, and modify backend databases to interact with applications.

* Experience with Linux command line skills to perform database administration activities, deployment automation.

* Active and transferable Top Secret U.S. government issued security clearance is required prior to start date with the ability to obtain a TS/SCI prior to start date. U.S. Citizenship is required as only U.S. Citizens are eligible for a clearance. Qualifications We Prefer
* Existing Security+ Certification (or higher).

* Experience using AWS RDS for Oracle and AWS Aurora Postgre

SQL database services.

* Experience with No

SQL database products such as Mongo

DB and Dynamo

DB.

* Data architecture experience for critical design decisions (such as the suitability of a product/technology for a given use case).
* Experience troubleshooting database issues such as Disaster Recovery, replication & backups and other related issues.

* Experience troubleshooting database performance issues.

* Strong SQL tuning experience in Oracle and Postgre

SQL.

* Experience with database security controls and audit & compliance requirements.

* Experience virtualizing or containerizing databases.

* Experience with automating routine tasks.

* Experience using Oracle Spatial and/or Postgre

SQL PostGIS.

* Experience using git source control.

* Experience using Atlassian Jira and Confluence.

What We Offer
* Whether you're just starting out on your career journey or are an experienced professional, we offer a total rewards package that goes above and beyond with compensation; healthcare, wellness, retirement, and work/life benefits; career development and recognition programs. Some of the benefits we offer include parental (including paternal) leave, flexible work schedules, achievement awards, educational assistance, and child/adult backup care.

* Relocation Eligibility - Relocation assistance is available.…