Database Engineer V

Cornerstone Defense LLC; Richardson (TX); On-site; USD 140,000 - 170,000; Full time

Job summary

Cornerstone Defense LLC in Richardson, TX is seeking a Database Engineer with TS/SCI w/ Poly to translate customer needs into robust relational models. You will design database structures, implement changes, and collaborate with engineers and stakeholders in an Agile setting.

Applicants should have 8+ years in database engineering, strong Oracle/PostgreSQL SQL/PLSQL, bash scripting, and Python. Security+ readiness and U.S. citizenship are required.

Qualifications

• STEM degree and 8+ years in Database Engineering.
• 5+ years relational data modeling with Oracle and PostgreSQL.
• 8+ years Oracle SQL/PLSQL and PostgreSQL SQL/plpgsql.
• Experience with bash scripting and Python.
• Linux CLI and deployment automation experience.
• Active TS/SCI CI Poly; U.S. Citizenship required.

Responsibilities

• Identify and translate customer needs into viable database design solutions.
• Translate needs and design requirements into physical data models.
• Analyze requirements to identify data modeling impacts.
• Collaborate with engineers, product owners, and stakeholders to gather data requirements.
• Design new database structures (tables, indexes, constraints, views) and modify existing models.
• Implement data model changes (DDL) using change control automation.
• Work with developers on SQL best practices.
• Use data modeling tools such as Oracle SQL Developer Data Modeler and Oracle Designer.
• Communicate concepts clearly; apply critical thinking.
• Use analytical skills for problem solving.
• Work in an Agile/Scrum environment.
• Obtain Security+ certification within 60 days.

Skills

Relational data modeling

Oracle SQL & PL/SQL

PostgreSQL SQL & pl/pgsql

Bash scripting

Python

Agile/Scrum

Linux command line

Data modeling tools

Communication of concepts

Problem solving

Security+ pursuit

Education

BS in STEM

Tools

AWS RDS for Oracle

AWS Aurora PostgreSQL

NoSQL: MongoDB

NoSQL: DynamoDB

Git

Jira & Confluence

PostGIS

Docker

Oracle Spatial

Job description

Database Engineer

Richardson, TX

TS/SCI w/ Poly

Compensation Range: $140,000 - $170,000

Company Overview:

Cornerstone Defense is the Employer of Choice within the Intelligence, Defense, and Space communities of the U.S. Government. Realizing early on that our most prized assets are our employees, we continually focus our attention on improving the overall work/life experience they have supporting the mission. Our Team is pushed every day to use their industry leading knowledge to provide end-to-end solutions to combat our nation’s toughest and most secure problems. If you are looking for a place to not only be professionally challenged, but encouraged and supported by a company that cares, don’t look any further than Cornerstone Defense.

Job 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.
• Obtain Security+ certification within 60 days of start.

Basic Quals:

• 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.

Preferred Quals:

• 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.