Sr. Database Designer

1 month ago


Arlington, Virginia, United States Trilogy Federal Full time

Trilogy Federal provides financial management, information technology (IT) consulting, program management services, and strategic consulting to federal agencies. Trilogy has an extensive history helping federal clients achieve their most ambitious business modernization and optimization goals with the ability to deliver targeted subject matter expertise and full life cycle support.

We are seeking a highly skilled and experienced Senior Database Designer to lead the design and support of complex databases within a critical program at the Department of Veterans Affairs (VA). This position demands extensive knowledge of VA systems, enterprise data reporting, and the ability to manage sensitive healthcare data securely. The ideal candidate will have a robust background in database technologies, experience with Electronic Health Records (EHR) systems, and proficiency in Structured Query Language (SQL) queries, especially in the context of VHA's Clinical Data Warehouse (CDW). This role requires a strategic thinker with the ability to manage software development teams and navigate the complexities of major database technologies.

Please note, this position is contingent upon award (expected July/August 2024).

Primary Responsibilities:

  • Database Design and Support: Lead the design, implementation, and maintenance of complex databases, ensuring high levels of data quality and accessibility for business intelligence, reporting, and decision-making processes.
  • Enterprise Data Reporting: Develop and oversee enterprise data reporting strategies, utilizing advanced SQL querying techniques to extract, analyze, and report data critical to the determination of entitlement to VBA benefits under Title 38 of the Code of Federal Regulations.
  • System Integration and Data Migration: Manage the integration of VA systems including SDP, VBMS, VHA's CDW, VistA, CAPRI, and VBA's Corporate Database with modern EHR systems like Cerner, ensuring seamless data migration and interoperability.
  • Team Leadership: Lead and manage software development teams, fostering a collaborative environment and ensuring the successful delivery of database projects on time and within budget.
  • Data Security and Compliance: Ensure the management and control of sensitive healthcare data, adhering to all relevant laws and regulations regarding PHI and PII, and implementing best practices in data security.
  • Technology Proficiency: Stay current with major database technologies including Oracle, SQL Server, Postgres, and MongoDB, applying best practices in database design and maintenance.
  • SDLC and Best Practices: Apply a deep understanding of the Software Development Life Cycle (SDLC) to all database projects, ensuring best practices in database architecture, design, and implementation.

Minimum Requirements:

  • Master's degree or higher in Computer Science or equivalent discipline.
  • 8+ years of experience in database design and support, with a focus on VA systems.
  • 5+ years of experience in enterprise data reporting and writing advanced SQL queries.
  • Proficient understanding of the VHA's CDW and the ability to chain adjacent hospital admissions for accurate determination of hospitalization duration relevant to VBA benefits.
  • 1+ years of experience with Cerner EHR and VA health data migrations efforts.
  • Familiarity with major EHR systems (i.e., Epic, Cerner) and data exchange formats such as FHIR, Blue Button, and CCDA.
  • Extensive experience in managing software development teams and proficiency with major database technologies including Oracle, SQL Server, Postgres, and MongoDB.
  • Strong knowledge and experience in managing and controlling sensitive healthcare data (PHI, PII, etc.).
  • Well-versed in SDLC and project management methodologies.
  • Exceptional analytical and problem-solving skills with the ability to manage complex data integration challenges.
  • Strong leadership qualities with experience in mentoring and developing technical teams.
  • Excellent communication skills, capable of engaging with technical and non-technical stakeholders alike.
  • A proactive approach to staying informed on the latest technologies and best practices in database design and data management.

Preferred Qualifications:

  • VA or VBA experience

Benefits (including but not limited to):

  • Health, dental, and vision plans
  • Optional FSA
  • Safe Harbor 401(k) with employer contributions 100% vested from day 1
  • Paid parental leave
  • Paid time off and 11 paid holidays
  • No cost group term life/AD&D plan, and optional supplemental coverage
  • Pet insurance
  • Monthly phone and internet stipend
  • Tuition and training reimbursement

Regarding remote positions, Trilogy Federal is able to offer virtual employment in the following states: Colorado, Connecticut, D.C., Florida, Georgia, Illinois, Maryland, New York, South Carolina, Texas, and Virginia.

Trilogy Federal is an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.



  • Arlington, Virginia, United States Tetra Tech Full time

    Job SummaryWe are seeking a highly skilled Sr. Oracle Database Engineer to lead our team in administering Oracle 19c databases and delivering Continuous Integration/Continuous Delivery (CI/CD) capabilities in support of the AFRL mission.Key ResponsibilitiesLead a team of Oracle database administrators and engineers in administering Oracle 19c...

  • Database Developer

    2 days ago


    Arlington, Virginia, United States Absolute Business Solutions Corp (ABSC) Full time

    About the RoleWe are seeking a highly skilled Database Specialist to join our team at Absolute Business Solutions Corp (ABSC). As a key member of our team, you will play a critical role in supporting the Research and Technology Protection (RTP) and Cyber Intrusion Damage Assessment (CIDA) program.Key ResponsibilitiesDesign, develop, and administer customized...

  • Database Specialist

    2 days ago


    Arlington, Virginia, United States Absolute Business Solutions Corp (ABSC) Full time

    About the RoleWe are seeking a highly skilled Database Specialist to join our team at Absolute Business Solutions Corp (ABSC). As a key member of our team, you will play a critical role in supporting the Research and Technology Protection (RTP) and Cyber Intrusion Damage Assessment (CIDA) program.Key ResponsibilitiesDesign, develop, and administer customized...

  • interior designer

    4 weeks ago


    Arlington, Virginia, United States USAJobs Full time

    DutiesSUMMARY CONTINUED:GS-13The primary purpose of this position is to serve as a professional Operations Interior Design Project Officer and is responsible for the performance of work related to the design and construction of interior environments and space utilization to promote employee productivity, health, and welfare and /or the health and welfare of...


  • Arlington, Virginia, United States Amazon Full time

    AWS Infrastructure and Networking Services owns the design, planning, delivery, and operation of all AWS global infrastructure including Reliability Services. In other words, we're the people who keep the cloud running. We support all AWS data centers and all of the servers, storage, networking, power, and cooling equipment that ensure our customers have...


  • Arlington, Virginia, United States Amazon Full time

    As a senior software engineer in AWS Commerce Platform, you will work on the hardest engineering problems in distributed systems at a massive scale and on multiple dimensions. You will exercise your intellectual curiosity, work with motivated teams of sharp individuals, partner with other senior and principal engineers, and provide guidance in defining your...


  • Arlington, Virginia, United States Airlines Reporting Corporation Full time

    About Airlines Reporting CorporationAirlines Reporting Corporation (ARC) is a leading travel intelligence company that accelerates the growth of global air travel by delivering forward-looking travel data, flexible distribution services, and innovative industry solutions.Job OverviewWe are seeking a highly skilled Data Platform Architect to join our team and...


  • Arlington, Virginia, United States Amazon Full time

    Our team is building new Automotive discovery and shopping products that connect customers with their new vehicle of choice We're developing new customer experiences and seller tools to support the entire vehicle discovery journey. We are seeking a Sr Voice of Customer Manager to be responsible for building and scaling a Voice of Customer program focused on...


  • Arlington, Virginia, United States CAE Full time

    About This Role Who We Are:CAE Vision: Our vision is to be the worldwide partner of choice in defense and security, civil aviation, and healthcare by revolutionizing our customers' training and critical operations with digitally immersive solutions to elevate safety, efficiency and readiness.CAE Defense & Security Mission: CAE's Defense and Security business...

  • SQL Developer

    2 days ago


    Arlington, Virginia, United States D.R. Horton Full time

    About the RoleD.R. Horton is seeking a skilled SQL Developer to join our team. As a SQL Developer, you will be responsible for designing, developing, and maintaining databases and data systems to support business operations.Key ResponsibilitiesDesign and develop databases and data systems to meet business requirementsDevelop and implement data conversion...


  • Arlington, Virginia, United States Black & Veatch Family of Companies Full time

    Together, we own our company, our future, and our shared success. As an employee-owned company, our people are Black & Veatch. We put them at the center of everything we do and empower them to grow, explore new possibilities and use their diverse talents and perspectives to solve humanity's biggest challenges in an ever-evolving world. With over 100 years of...

  • Data Architect

    7 days ago


    Arlington, Virginia, United States ManTech Full time

    About the RoleWe are seeking a highly skilled and experienced Data Architect to join our team at ManTech. As a Data Architect, you will play a critical role in designing and supervising a data infrastructure, data flows, and data management principles.Key ResponsibilitiesDesign and Supervise Data Infrastructure: Develop and implement data architecture...


  • Arlington, Virginia, United States InsideHigherEd Full time

    Job SummaryWe are seeking a highly skilled Senior IT Systems Configuration and Programming Analyst to join our team at InsideHigherEd. As a key member of our IT department, you will be responsible for providing full life-cycle management of quality technical solutions and software applications that meet business and organizational standards, constraints, and...


  • Arlington, Virginia, United States Macalogic Full time

    Company Overview:Macalogic is a company with broad competencies focused on bringing practical technology solutions to complex problems. We are a Woman-Owned SBA-certified Small Business and an Economically Disadvantaged Woman-Owned Small Business (EDWOSB). We provide business consulting services to government clients in four primary areas: software...


  • Arlington, Virginia, United States APTNEXUS Full time

    Company OverviewEstablished in 2012, APTNEXUS stands as a leading provider of IT Services, specializing in Cybersecurity Governance, Risk, and Compliance solutions tailored for both information and operational technologies. Our commitment to IT, coupled with our expertise in cybersecurity compliance, ensures that our offerings are designed to seamlessly...


  • Arlington, Virginia, United States Chenega MIOS SBU Full time

    About the RoleWe are seeking a highly skilled and experienced Senior Intelligence Project Lead to join our team at Chenega MIOS SBU. As a key member of our organization, you will be responsible for leading the development and execution of the J2 Senior Readiness Seminar (SRS) project.Key ResponsibilitiesProject Management: Lead the project team to develop...

  • Sr. Program Manager

    4 weeks ago


    Arlington, Virginia, United States Amazon Full time

    Amazon has an immediate opening for a Senior Program Manager to join our Accounting Technology Group. This leader will work closely with the global lease accounting and lease systems teams. In this role, the candidate will be part of a team that collaborates with business, finance, and technical teams to deliver world-class solutions that are highly...

  • Data Architect

    7 days ago


    Arlington, Virginia, United States ManTech Full time

    Secure Our Nation, Ignite Your FutureBecome an integral part of a diverse team while working at an Industry Leading Organization, where our employees come first. At ManTech, you'll help protect our national security while working on innovative projects that offer opportunities for advancement.ManTech is seeking a motivated, career and customer-oriented Data...

  • Data Analyst

    2 months ago


    Arlington, Virginia, United States Copper River Family of Companies Full time

    COHO Consulting Group is seeking a Data Analyst for process and data analysis support for a federal customer process improvement contract. They will be supporting an operational efficiency though process and data analysis, developing improvement recommendations, metric development and monitoring, dashboard, and data visualization as well as workflow...


  • Arlington, Virginia, United States SAIC Full time

    Software Development ExpertSAIC is seeking a skilled Software Development Expert to join our team. As a key member of our development team, you will work closely with stakeholders to design, develop, and maintain core application software.Key Responsibilities:Design and Development: Create user interfaces for web applications using HTML, CSS, and Angular...