PostgreSQL Database Administrator

Leidos • Ashburn, VA

7d • Hybrid

About The Position

Leidos’ National Security Sector is seeking a PostgreSQL Database Administrator to support the Passenger Systems Program Directorate (PSPD) within Customs and Border Protection (CBP). PSPD supports critical Department of Homeland Security and CBP missions, including screening and processing travelers at U.S. ports of entry. This hands-on role collaborates on the architecture, design, build, delivery, and enhancement of highly available, scalable, real-time systems. The administrator exercises judgment in recommending designs that balance customer business objectives, timelines, and resource constraints, and participates in or directs project deliverables throughout the software development life cycle, from estimation and architecture through coding and testing. The position requires working in Ashburn, Virginia, two times per week.

Requirements

• Bachelor’s degree and 10+ years of prior relevant DBA experience, or a master’s degree and 6+ years of prior relevant DBA experience; alternatively, four years of experience may be substituted for a degree.
• At least 4 years of experience tuning Aurora PostgreSQL database performance and PL/pgSQL scripts.
• At least 4 years as an AWS Aurora PostgreSQL DBA in a 24x7 environment managing multiple databases totaling over 70 TB.
• At least 4 years as an Oracle DBA in a 24x7 environment supporting databases over 200 TB.
• Proficiency tuning Oracle databases and troubleshooting performance issues.
• Ability to support an on-call schedule and resolve incidents.
• Proficiency with Microsoft Office products, including Word, Excel, Visio, and PowerPoint.
• Excellent written and verbal communication skills.
• U.S. citizenship.
• Ability to obtain and maintain a CBP Background Investigation prior to starting.
• Self-starter with strong leadership skills and the ability to work independently with little supervision.

Nice To Haves

• Experience migrating more than 70 TB from Oracle to Aurora PostgreSQL.
• Experience using generative AI to tune SQL statements.
• Experience with CBP Java.
• Experience with other AWS data-related services.
• Experience with one or more of the following: Struts, Hibernate, Java, JSF, Swing, JavaScript, Bootstrap, or Angular.
• Experience with CI/CD, SecDevOps, and Git source code repositories such as GitLab or GitHub.

Responsibilities

• Perform technical planning, system integration, verification and validation, cost and risk analyses, and analyses of supportability and effectiveness.
• Design and implement database schemas and structures according to project requirements.
• Develop and maintain database environment documentation, including data standards and procedures.
• Plan storage requirements and database growth, and scale infrastructure as needed.
• Collaborate with developers to optimize application queries, stored procedures, and database design.
• Participate in or direct project deliverables through the software development life cycle, including scope and work estimation, architecture and design, coding, and unit and integration testing.
• Support an on-call schedule and resolve incidents.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior