Data Modeler Job at DPG Solutions LLC, Richardson, TX

RjJGQVlEWHBweTJTc3FQYU41NWgyaWV6NkE9PQ==
  • DPG Solutions LLC
  • Richardson, TX

Job Description

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

Job Tags

Similar Jobs

Ancora Education

Remote Admissions Executive: Student Growth Advocate Job at Ancora Education

 ...An education institution is seeking an Executive Admissions Representative to support prospective students in their decision to enroll. Responsibilities include guiding students through admissions while meeting performance standards. Candidates should have a high school... 

Amazing Lash Studio Oxnard

Lash Stylist Job at Amazing Lash Studio Oxnard

 ...extension appointments during any given shift Educate the client about lash upgrades and our exclusive aftercare products Attend industry-related events, training, and product sessions Maintain a clean and well-stocked eyelash application room Be responsible... 

Talking Tree

Volunteer Campus Startup Connector & Legal Tools Advocate Job at Talking Tree

 ...organization in Mountain View is seeking a University/Startup Community Ambassador. In this volunteer role, you will connect with student founders and entrepreneurship centers to promote affordable legal resources. Responsibilities include sharing Talking Trees mission... 

ESRhealthcare and EXEC STAFF RECRUITERS

New Patient Coordinator Clinic - United States (Remote) Job at ESRhealthcare and EXEC STAFF RECRUITERS

 ...Description Job Description New Patient Coordinator Clinic - United States (Remote) About the Role We are seeking an extremely positive,...  ...-oriented professional who is passionate about health, healthcare, and helping individuals take meaningful steps toward... 

Better Talent Advisors

Regional Director of Solar Sales Job at Better Talent Advisors

 ...ABOUT US We are an established sales organization specializing in residential solar and roofing sales. We are an independent dealer network which allows us to sell all 5 of the top 5 solar products in the industry (Sunrun, Vivint Solar, Sunnova, Sunpower, and Tesla...