Data Modeler

US Citizenship is required.

An active TS/SCI is required.

An active CI Polygraph is required.

Security required.

Key Responsibilities

• Identify and understand customer needs and translate them into effective database design solutions
• Create logical and physical data models aligned with business and technical requirements
• Analyze business requirements RFCs and technical specifications for data impacts
• Collaborate with systems engineers software developers product owners and architects to validate and refine data requirements
• Design and implement new database structures (tables views indexes constraints)
• Manage and automate database schema changes using DDL and change control processes
• Provide guidance to developers on SQL best practices and database interactions
• Utilize data modeling tools such as Oracle SQL Developer Data Modeler Oracle Designer etc.
• Contribute to Agile development teams and participate in sprint planning reviews and retrospectives
• Apply critical thinking and problem-solving skills to troubleshoot database and performance issues

Required Qualifications

• Bachelors degree in STEM (Science Technology Engineering Math) and 8 years of database engineering experience
• 5 years of experience in relational data modeling with Oracle and PostgreSQL RDBMS
• 8 years of experience with Oracle SQL PL/SQL PostgreSQL SQL and pl/pgsql
• Proficiency with bash scripting and Python
• Experience working closely with Systems and Software Engineers on backend database integration
• Strong Linux command-line skills for administration and deployment automation
• Active and transferable Top Secret clearance with the ability to obtain SCI access and pass a polygraph
• Ability to obtain Security certification within 60 days of hire

Preferred Qualifications

• Active Security (or higher-level) certification
• Experience with AWS RDS for Oracle and Aurora PostgreSQL
• Familiarity with NoSQL technologies such as MongoDB or DynamoDB
• Experience with data architecture design and selecting appropriate technologies for various use cases
• Experience with database performance tuning replication disaster recovery and backup strategies
• Strong understanding of database security controls compliance and audit practices
• Experience with containerized or virtualized database environments
• Proficiency in automating database tasks using scripts and tools
• Familiarity with Oracle Spatial or PostGIS (PostgreSQL)
• Version control experience using Git
• Experience using Atlassian tools like Jira and Confluence
• 
  

Why DPG Solutions

• 25% company-funded 401(k) Vested day one!
• 100% company-paid health benefits HSA
• Quarterly equity bonuses
• 250 hours PTO annually
• Education reimbursement
• Family-friendly company events

Required Experience:

Senior IC