Apply on Employer Site

RTX · 3 days ago

Principal Data Modeler and Database Engineer (Onsite)

CO106: 16470 East Hughes Drive,Aurora 16470 East Hughes Drive Building S77, Aurora, CO, 80011 USA

Full-time

Onsite

Lead/Staff

8+ years exp

RTX is a company dedicated to helping the nation and allies defend freedoms and deter aggression. They are hiring a Principal Data Modeler and Database Engineer to design, create, and manage databases and high-performance data models, while collaborating with various stakeholders to meet customer needs.

AerospaceManufacturingSecuritySensorTelecommunications

No H1B

Security Clearance Required

U.S. Citizen Only

Responsibilities

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

Qualification

Database EngineeringRelational Data ModelingOracle SQLPostgreSQLPythonBash ScriptingLinux Command LineSQL TuningAWS RDSMongoDBDynamoDBGitAgile/ScrumSecurity+ Certification

Required

Typically requires a degree in Science, Technology, Engineering, or Mathematics (STEM) and a minimum of 8 years of Database Engineering experience

Relational data modeling experience with Oracle and PostgreSQL Relational Database Management Systems (RDBMS)

Experience with Oracle SQL, PL/SQL, PostgreSQL, and PL/pgSQL

Experience with Bash scripting and Python

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

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

Obtain Security+ certification within 60 days of start

Preferred

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

Existing Security+ Certification (or higher)

Experience using AWS RDS for Oracle and AWS Aurora PostgreSQL database services

Experience with NoSQL database products such as MongoDB and DynamoDB

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 PostgreSQL

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 PostgreSQL PostGIS

Experience using git source control

Experience using Atlassian Jira and Confluence

Benefits

Medical

Dental

Vision

Life insurance

Short-term disability

Long-term disability

401(k) match

Flexible spending accounts

Flexible work schedules

Employee assistance program

Employee Scholar Program

Parental leave

Paid time off

Holidays

Company

RTX

Glassdoor3.8

RTX is comprised of three market-leading businesses – Collins Aerospace, Pratt & Whitney and Raytheon – working as one to answer the biggest questions and solve the hardest problems in aerospace and defense.

Founded in 1922

Arlington, Virginia, USA

10001+ employees