Database Engineer V Security Clearance

Database Engineer, Richardson, TX
TS/SCI clearance with polygraph
Compensation Range: $140,000 - $170,000

• 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.
• 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 Postgre
  
  SQL RDBMS.
• Eight (8) years of experience with Oracle SQL and PL/SQL and Postgre
  
  SQL 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 and 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.

• Existing Security+ Certification (or higher).
• Experience using AWS RDS for Oracle and AWS Aurora Postgre
  
  SQL database services.
• Experience with No
  
  SQL database products such as Mongo
  
  DB and Dynamo
  
  DB.
• 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 and backups and other related issues.
• Experience troubleshooting database performance issues.
• Strong SQL tuning experience in Oracle and Postgre
  
  SQL.
• 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 Postgre
  
  SQL PostGIS.
• Experience using git source control.
• Experience using Atlassian Jira and Confluence.