Postgres Database Administrator

Description

Leidos has a need for a PostGres database Administrator to support the Custom Border Patrol TVPS program that handles all the travelers coming into the country via Airports, Seaports, Pedestrian, and Vehicle lanes. The candidate is responsible for performing tasks relating to Database Management System (DBMS) applications, including definition, design, structure, documentation, upgrades, long-range requirements, operational guidelines, and protection. Duties include database modeling and design, relational database architecture, metadata and repository creation. Uses data mapping, data mining and data transformational analysis tools to design and develop databases.

Support duties may include:

• Entering and reviewing data within the database, ensuring user data integrity, maintaining database support tools, database tables and dictionaries, recovery and back-up procedures, and making recommendations regarding enhancements and/or improvements
• Responsible for entire projects or processes within a technical area
• Typically responsible for coaching and reviewing the work of lower level technical staff
• Develops technical solutions that require collaboration with internal experts, deep analyses and understanding of impact on end-product/solution
• Develops solutions to technical problems and issues that are unclear and require deep technical knowledge
• Communicates with internal and client project team members
• Works to influence team members regarding solution design, process and/or approaches.

• Over 10 years of experience with Postgres 16.4 database with an understanding of upgrading, partitioning and archiving current database.
• U.S. Citizen
• Must be able to maintain and obtain a CBP Background Investigation prior to start
• Understands how to write queries into the database to gather information and metrics.
• Experience in Troubleshooting problems
• Good Customer interaction and communication
• Good communication skills including documentation and ticket resolution
• On rare occasions, be willing to support the contract in evening, weekend, and holidays is ever needed
• Willing to travel to the DC area twice a week (on-site visits to Ashburn)
• Can work with a team or independently
• Experience in Windows, Software Center, and looking into logs to determine cause of issues.

• Develop test data that can be insert into testing database within Dev end Test regions
• Develop scripts for the database for information, metrics, test results, etc...
• Work with a team of DBAs to share best practices across the program
• DHS BI clearance