DPG Solutions LLC
Database Modeler/Database Engineer
DPG Solutions LLC, Richardson, Texas, United States, 75080
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
Bachelor's 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
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
Bachelor's 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