Network Designs, Inc. ยท 5 hours ago
Lead DB Engineer
Network Designs, Inc. (NDi) is a leading Federal contractor that specializes in designing and delivering IT and network solutions for government customers. The Lead DB Engineer will lead database design and optimization for the Enterprise Data Base, ensuring high-performance data operations while providing technical leadership across Oracle-based platforms.
Information ServicesInformation Technology
Responsibilities
Lead the design and evolution of Oracle database schemas, structures, and data models supporting EDB
Define database architecture standards to support scalability, performance, and data integrity
Design, develop, and review advanced SQL and PL/SQL code, including stored procedures, functions, and packages
Establish best practices for reusable, maintainable, and performant database code
Lead query optimization efforts using indexing strategies, execution plan analysis, and performance diagnostics
Design and manage materialized views and partitioning strategies to support high-volume and high-concurrency workloads
Oversee ETL and ELT data transformation processes supporting eligibility, enrollment, and downstream integrations
Ensure database structures and transformations support accurate and efficient data exchange across systems
Define and implement data validation and reconciliation frameworks to ensure data accuracy and completeness
Lead data quality profiling initiatives and support resolution of data anomalies
Lead schema and metadata management practices, including versioning, documentation, and traceability
Ensure alignment with data governance, audit, and compliance requirements
Ensure database security controls are implemented and maintained, including access controls and audit mechanisms
Support database reliability, availability, and recoverability in alignment with operational requirements
Provide technical leadership and mentorship to database engineers and SQL developers
Collaborate with application engineers, integration teams, and stakeholders to align database solutions with system needs
Maintain comprehensive documentation for database designs, standards, and operational procedures
Continuously improve database performance, maintainability, and operational efficiency
Qualification
Required
U.S Citizenship required
Must be able to obtain and maintain a Public Trust clearance
This position is remote but may require occasional onsite meetings in McLean, VA
You can be based out of following states: AZ, DC, FL, GA, OH, ME, MD, SC, TX, UT, VA, NC, OK, WV
Bachelor's Degree in Computer Science, Information Technology, or a related field
At least 7 years of experience in database engineering or a related role
Strong expertise with Oracle RDS and Oracle database platforms
Advanced proficiency in SQL and PL/SQL
Extensive experience with stored procedures, functions, and packages
Demonstrated experience with indexing strategies, query optimization, and execution plan analysis
Experience designing and maintaining materialized views and partitioning strategies
Experience supporting ETL and ELT data transformations
Experience implementing data validation, reconciliation, and data quality profiling frameworks
Experience with schema and metadata management
Strong analytical and problem-solving skills
Strong attention to detail and commitment to data accuracy
Excellent communication skills and the ability to work collaboratively in a team environment
Benefits
Comprehensive health, dental, vision, pet, and legal insurance
401(k) retirement matching
Paid leave
Paid holidays
Health and wellness programs
Employer-paid life and disability insurance
Professional development
Education benefits