Database Engineer V with Security Clearance

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 Qualifications

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

Preferred Qualifications

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