Database Engineer

22nd Century Technologies, Inc.
Richardson, TX, United States
1 day ago
Apply on www.clearancejobs.com
Prepare application

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours

Tech stack

Systems Engineering Confluence JIRA Bash Shell Databases Data Architecture Relational Databases Database Queries Database Security Database Storage Structures Disaster Recovery Amazon DynamoDB
+21 more
Python (Programming Language) PostgreSQL Linux Commands MongoDB NoSQL Oracle (Applications) Oracle SQL Developer PostGIS Scrum Methodology Software Engineering PL-SQL SQL Databases Database Performance Backend Git Oracle Designer Amazon Relational Database Service AWS Aurora Deployment Automation Physical Data Models Software Version Control

Job description

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

Requirements

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

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.clearancejobs.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · World Congress 2021

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

3:05 min

Integrating an assistant application with Jira software

Felix Augenstein · LIVE

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

1:20 min

Identifying multi-disciplinary talent for developer experience engineering roles

Hazal Mestci +1 · Coffee With Developers

56 sec

Favorite git commands and the importance of patch commits

Eileen Uchitelle Eileen Uchitelle +1 · Coffee With Developers

Videos

See all

Related articles

See all