Senior PostgreSQL DBA | AWS Aurora | Real-Time Systems

Quest Oracle Community; Ashburn, Northern (VA, KY); Hybrid; USD 108,000 - 195,000; Full time

Job summary

Leidos is seeking a PostgreSQL Database Administrator to support the Passenger Systems Program Directorate within CBP. The role is hands-on, architecting, building, delivering, and enhancing highly available, scalable, real-time systems, in a 24x7 environment, with focus on performance tuning and cloud integration.

The position requires US citizenship, ability to obtain CBP background clearance, and willingness to commute to Ashburn, VA two days a week.

Qualifications

• BS/BA degree with 8+ years DBA experience or Masters with 6+ years 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 AWS Aurora PostgreSQL DBA in a 24x7 environment managing multiple databases of over 70TB
• 4+ years Oracle DBA in a 24x7 environment supporting databases of over 200TB
• Proficiency in tuning Oracle Databases and troubleshooting performance issues
• Able to support on-call schedule and incident resolution
• Proficiency with Microsoft Office Products (Word, Excel, Visio, & PowerPoint)
• U.S. Citizen.
• Must be able to maintain and obtain a CBP Background Investigation prior to start

Responsibilities

• Performs technical planning, system integration, verification and validation, cost and risk, and support ability and effectiveness analyzes.
• Designs and implements database schemas and structures according to project requirements.
• Develops and maintains documentation for database environments, including data standards and procedures.
• Plans for storage requirements and database growth, and scale infrastructure as needed.
• Collaborates with developers to optimize queries, stored procedures, and database design for applications.
• Must be a self-starter, strong leader, and the ability to work independently with little supervision.

Skills

PostgreSQL Administration

AWS Aurora PostgreSQL

PL/pgSQL

24x7 on-call support

Communication skills

US Citizenship

CBP background clearance

Leadership / self-starter

Education

BS/BA in IT or related field

Masters in related field

4 years experience in lieu of degree

Tools

Oracle DBA

Oracle tuning

SQL tuning

AWS data services

CI/CD / Git (GitLab/GitHub)

Java

Struts / Hibernate / JSF / JS / Bootstrap / Angular

Job description

Leidos is seeking a PostgreSQL Database Administrator to support the Passenger Systems Program Directorate within CBP. The role is hands-on, architecting, building, delivering, and enhancing highly available, scalable, real-time systems, in a 24x7 environment, with focus on performance tuning and cloud integration.

The position requires US citizenship, ability to obtain CBP background clearance, and willingness to commute to Ashburn, VA two days a week.