PostgreSQL Database Administrator

About the role

Leidos’ National Security Sector is seeking a hands-on PostgreSQL Database Administrator to support the Passenger Systems Program Directorate (PSPD) within U.S. Customs and Border Protection (CBP). PSPD executes DHS and CBP missions by screening and processing travelers at U.S. ports of entry. You will collaborate on architecting, designing, building, delivering, and enhancing highly available, scalable, real-time systems, exercising judgment to recommend optimal designs under customer objectives, timelines, and resource constraints. You will participate in and/or lead major project deliverables across the full software development life cycle, including scope and work estimation, architecture and design, coding, and unit and integration testing.

Location requirement: This position requires the candidate to be in Ashburn, VA, 2 times per week.

Responsibilities

• Perform technical planning, system integration, verification and validation, cost and risk analysis.
• Design and implement database schemas and structures aligned to project requirements.
• Develop and maintain documentation for database environments, including data standards and procedures.
• Plan storage requirements and database growth, scaling infrastructure as needed.
• Collaborate with developers to optimize queries, stored procedures, and database design for applications.
• Operate with a high degree of autonomy; self-starter with strong leadership and minimal supervision.

Minimum Qualifications

• Bachelor’s degree and 8+ years of prior relevant DBA experience, or Master’s degree with 6+ years of prior relevant DBA experience, or 4 years of experience in lieu of degree.
• 4+ years tuning Aurora PostgreSQL database performance and PL/pgSQL scripts to optimize performance.
• 4+ years as an AWS Aurora PostgreSQL DBA in a 24x7 environment managing multiple databases totaling over 70TB.
• 4+ years as an Oracle DBA in a 24x7 environment supporting databases totaling over 200TB.
• Proficiency in tuning Oracle databases and troubleshooting performance issues.
• Ability to support on-call schedule and incident resolution.
• Proficiency with Microsoft Office products (Word, Excel, Visio, PowerPoint).
• Excellent written and verbal communication skills.
• U.S. citizenship required.
• Must be able to obtain and maintain a CBP background investigation prior to start.

Preferred Qualifications

• Experience migrating Oracle to Aurora PostgreSQL for databases over 70TB.
• Experience using generative AI to tune SQL statements.
• Experience with CBP Java applications.
• Experience with other AWS data-related services.
• Familiarity with Struts, Hibernate, Java, JSF, Swing, JavaScript, Bootstrap, Angular.
• Experience with CI/CD, SecDevOps, and Git source code repositories (GitLab, GitHub).

Pay

The Leidos pay range for this job level is $107,900.00 – $195,050.00. Actual compensation will be determined based on job responsibilities, education, experience, knowledge, skills, abilities, internal equity, market data, applicable bargaining agreements, and other law.