Logo
Clearance Jobs

Principal Database Engineer- TS Clearance

Clearance Jobs, Aurora, Colorado, United States, 80010

Save Job

Principal Database Engineer

Solidus is hiring a Principal Database Engineer. This is an on-site role based in Aurora, CO. Day in the life includes: 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 Familiar with designing, creating, updating, and managing databases and high-performance data models Required Qualifications & Experience: US Citizen with an active Top Secret Clearance Must be able to obtain and maintain SCI program access and complete polygraphs Ability to obtain Security+ Certification within 60 days of hire Undergo a comprehensive background investigation Bachelor's Degree in Science, Technology, Engineering, or Mathematics (STEM) and 8 years of Database Engineering experience 5 years of experience performing relational data modeling with Oracle and PostgreSQL Relational Database Management Systems (RDBMS) 8 years of experience with Oracle SQL and PL/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 Apply a sound, demonstrable understanding of database principles, theories, and concepts related to software engineering to translate those needs to viable design solutions based on customer needs. Translate needs and design requirements into physical data models Analyze business requirements, RFCs, and technical specifications to identify data modeling impacts and design needs 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 Utilize data modeling tools such as Oracle SQL Developer Data Modeler, Oracle Designer, and others Design, create, update, and manage databases and high-performance data models Preferred Qualifications & Experience: Active TS/SCI is preferred 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 Database security controls and audit & compliance requirement Virtualizing or containerizing databases Automating routine tasks Oracle Spatial and/or PostgreSQL PostGIS Using git source control Using Atlassian Jira and Confluence Benefit selections, customer contractual specifications, relevant work experience, skills, competencies, certifications, and clearance status will influence the final salary. Full benefits salary range: $138,000 to $173,000 annually Reduced benefits salary range: $150,000 to $190,000 annually What we will bring: Solidus offers you an exciting opportunity to tackle the nation's greatest challenges applying innovation and expertise to produce cutting-edge results that have a long-lasting impact. We offer outstanding benefits, generous PTO and much more! Apply today to learn why Solidus has a 4.9/5 Star rating on Glassdoor! Solidus is an Equal Opportunity Employer and provides equal employment opportunities regarding all terms and conditions of employment to all employees and qualified applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. The Company will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application and interview process, to perform essential job functions, and to receive other benefits and privileges of employment.