PostgreSQL Database Administrator
About The Position
The National Security Sector within Leidos 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. The role requires working in Ashburn, Virginia, two times per week. In this hands-on position, you will collaborate to architect, design, build, deliver, and enhance highly available, scalable, real-time systems. You will use judgment to recommend designs based on customer business objectives, timelines, and resource constraints. You will participate in and/or direct major project deliverables across the software development life cycle, including scope and work estimation, architecture and design, coding, and unit and integration testing.
Requirements
- Bachelor's degree and 10 or more years of relevant DBA experience, or a master's degree and 6 or more years of relevant DBA experience, or 4 years of experience in lieu of a degree.
- At least 4 years of experience tuning Aurora PostgreSQL database performance and PL/pgSQL scripts to optimize performance.
- At least 4 years of experience as an AWS Aurora PostgreSQL DBA in a 24x7 environment managing multiple databases totaling more than 70 TB.
- At least 4 years of experience as an Oracle DBA in a 24x7 environment supporting databases totaling more than 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 before starting.
- Self-starter with strong leadership ability and capacity 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.
- Experience with other AWS data-related services.
- Experience with 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, and supportability and effectiveness analyses.
- Design and implement database schemas and structures according to project requirements.
- Develop and maintain documentation for database environments, including data standards and procedures.
- Plan storage requirements and database growth, and scale infrastructure as needed.
- Collaborate with developers to optimize queries, stored procedures, and database design for applications.
- Support an on-call schedule and resolve incidents.
- Participate in and/or direct major project deliverables throughout the software development life cycle, including scope and work estimation, architecture and design, coding, and unit and integration testing.
- Work independently with little supervision.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
