Solidus Technical Solutions
Principal Database Engineer- TS Clearance
Solidus Technical Solutions, Aurora, Illinois, United States, 60505
Overview
Principal Database Engineer - TS Clearance. This is an on-site role based in Aurora, CO. Active Top Secret Clearance required to be eligible for hire. Responsibilities
Identify and understand customer needs and apply database principles to translate those needs into 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 and communicate concepts clearly; apply problem-solving and analytical skills. Work in an Agile/Scrum environment. 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 RDBMS. 8 years of experience with Oracle SQL and PL/SQL, and PostgreSQL SQL and PL/pgSQL. Experience with bash scripting and Python. Experience working with Systems and Software Engineers to design, implement, and modify backend databases to interact with applications. Strong Linux command line skills to perform database administration activities and deployment automation. Preferred Qualifications & Experience
Active TS/SCI is preferred; existing Security+ Certification (or higher). Experience with AWS RDS for Oracle and AWS Aurora PostgreSQL. Experience with NoSQL databases (MongoDB, DynamoDB). Data architecture experience for critical design decisions. Experience troubleshooting database issues (DR, replication, backups) and performance issues. Strong SQL tuning experience in Oracle and PostgreSQL. Database security controls and audit/compliance requirements. Virtualizing or containerizing databases; automating routine tasks. Oracle Spatial and/or PostgreSQL PostGIS; using git; Atlassian Jira and Confluence. What We Will Bring
Solidus offers an exciting opportunity to tackle national challenges with innovation and expertise. We provide outstanding benefits, generous PTO, and more. Apply today. Req ID: 5039 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. Reasonable accommodation is available for applicants with disabilities. Please contact us to request an accommodation. Click to review - Federal Job Notices for Job Applicants. Note: Solidus does not accept applications from agencies or third-party vendors with incomplete information. #J-18808-Ljbffr
Principal Database Engineer - TS Clearance. This is an on-site role based in Aurora, CO. Active Top Secret Clearance required to be eligible for hire. Responsibilities
Identify and understand customer needs and apply database principles to translate those needs into 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 and communicate concepts clearly; apply problem-solving and analytical skills. Work in an Agile/Scrum environment. 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 RDBMS. 8 years of experience with Oracle SQL and PL/SQL, and PostgreSQL SQL and PL/pgSQL. Experience with bash scripting and Python. Experience working with Systems and Software Engineers to design, implement, and modify backend databases to interact with applications. Strong Linux command line skills to perform database administration activities and deployment automation. Preferred Qualifications & Experience
Active TS/SCI is preferred; existing Security+ Certification (or higher). Experience with AWS RDS for Oracle and AWS Aurora PostgreSQL. Experience with NoSQL databases (MongoDB, DynamoDB). Data architecture experience for critical design decisions. Experience troubleshooting database issues (DR, replication, backups) and performance issues. Strong SQL tuning experience in Oracle and PostgreSQL. Database security controls and audit/compliance requirements. Virtualizing or containerizing databases; automating routine tasks. Oracle Spatial and/or PostgreSQL PostGIS; using git; Atlassian Jira and Confluence. What We Will Bring
Solidus offers an exciting opportunity to tackle national challenges with innovation and expertise. We provide outstanding benefits, generous PTO, and more. Apply today. Req ID: 5039 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. Reasonable accommodation is available for applicants with disabilities. Please contact us to request an accommodation. Click to review - Federal Job Notices for Job Applicants. Note: Solidus does not accept applications from agencies or third-party vendors with incomplete information. #J-18808-Ljbffr