What are the responsibilities and job description for the Principal Data Modeler and Database Engineer-TS/SCI position at Talent Stack LLC?
About the Company
This role is being managed by Talent Stack LLC, a woman-owned recruiting firm specializing in cleared and technical placements. We are proud to represent a confidential, defense-focused client committed to solving meaningful, mission-critical challenges that support national security.
About the Role
We are hiring a Principal Data Modeler and Database Engineer to support teams based in Richardson, TX or Aurora, CO. Relocation assistance is available.
This position comes with a full benefits package, which we’re happy to share upon request.
You’ll have the opportunity to make a direct impact on the world around you by contributing to classified programs and technologies you can be proud of. In this role, you’ll work on designing, creating, updating, and managing high-performance databases and data models in a mission-driven environment.
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.
Qualifications
- 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 PostgreSQL Relational Database Management Systems (RDBMS).
- Eight (8) years of experience with Oracle SQL and PostgreSQL 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 and strong 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.