DPG Solutions LLC
Database Modeler/Database Engineer
DPG Solutions LLC - Richardson
Work at DPG Solutions LLC
Overview
- View job
Overview
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
- 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
- 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