Postgresql Jobs in Aurora, CO (NOW HIRING)

Please find below the job details:
Title: Database Engineer - Cleared – (14999912)
Client: Aerospace & Defense client
Location: Richardson, TX
Duration: 12 months + with CTH (Performance Based)
Clearance: TS/SCI required
Salary: Open Description/Comment:
• On-Site Means they will be working at a Facility.
• Contractor or Contract to Hire. • At Facility, 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. • Client is hiring a Principal Data Modeler and Database Engineer to support our teams in Richardson TX. • 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. • 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 PostgreSQL Relational Database Management Systems (RDBMS). • Eight (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. • Active and transferable TS/SCI CI Poly 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 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.