TS/SCI AWS Data Engineer – Oracle/PostgreSQL

Associates Systems LLC; Richardson (TX); On-site; USD 150,000 - 190,000; Full time

Job summary

Associates Systems LLC seeks a TS/SCI cleared AWS Database Engineer to design and manage databases in Richardson, TX. You will model data, implement changes, and work with engineers in an Agile environment on classified programs.

Requirements include 8+ years in database engineering, Oracle/PostgreSQL expertise, and Linux skills. Security clearance and US citizenship are mandatory.

Qualifications

• Typically requires a degree in STEM and a minimum of 8 years of Database Engineering experience.
• Five years of relational data modeling with Oracle and PostgreSQL RDBMS.
• Eight years of Oracle SQL and PL/SQL, and PostgreSQL SQL/plpgsql skills.
• Experience with bash scripting and Python.
• Experience with interacting with Systems/Software Engineers to design, implement, and modify backend databases.
• Strong Linux command line skills for database administration and deployment automation.
• Active TS/SCI clearance with ability to obtain TS/SCI; US citizenship required.

Responsibilities

• Identify and understand customer needs and translate them into viable database design solutions.
• Translate requirements into physical data models and structures.
• Analyze requirements, RFCs, and specs to identify data modeling impacts.
• Collaborate with engineers, product owners, architects and stakeholders to validate data needs.
• Design new database structures (tables, indexes, constraints, views) and modify existing models.
• Author and implement database data model changes (DDL) using change control automation.
• Work with developers on best practices for database interaction and SQL writing.
• Utilize data modeling tools such as Oracle SQL Developer Data Modeler and Oracle Designer.
• Demonstrate critical thinking and strong communication of concepts.
• Apply problem solving and analytical skills in an Agile/Scrum environment.
• Must obtain and maintain SCI program access and TS/SCI clearance.

Skills

Database design

Data modeling

SQL/PLSQL

Bash scripting

Python

Linux CLI

Agile/Scrum

Team collaboration

Education

STEM degree

Tools

Oracle SQL Developer Data Modeler

Oracle Designer

Job description

TS/SCI AWS Database Engineer- Multiple Locations TX PA CO VA

• RICHARDSON, TX

Active TS/SCI is a must - this effort is on Site
All qualified candidates will be responded to in 24 hrs or less.
Employment type: Full Time w-2 or C2C or 1099.
Rate: open to Negotiation

Location:Richardson TX,
• 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).

Principal Data Modeler and Database Engineer to support our teams in Richardson TX or Aurora CO. 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.
• Must be able to obtain and maintain SCI program access and complete polygraphs.
• 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 Top Secret U.S. government issued security clearance is required prior to start date with the ability to obtain a TS/SCI prior to start date. U.S. Citizenship is required as only U.S. Citizens are eligible for a clearance.
#CJ