Database Administrator (PostgreSQL)

Xenith Solutions•Ashburn, VA

About The Position

Xenith Solutions is seeking a PostgreSQL DBA with strong ETL and AWS Experience to join their BEAGLE (Border Enforcement Applications for Government Leading-Edge Information Technology) Agile Solution Factory (ASF) Team, supporting Customs and Border Protection (CBP) client in Northern Virginia. As a member of the BEAGLE ASF Team, the individual will support CBP agents and officers in safeguarding the American people and enhancing national security. ASF programs foster innovation, seeking individuals who can bring creative ideas to solve complex technical and procedural problems. The role requires adaptability and constructive collaboration within a technically diverse and geographically separated team. Candidates should have PostgreSQL DBA experience, understand ETL concepts, and have supported RDS in an AWS environment.

Requirements

Must be a U.S. Citizen with the ability to pass CBP background investigation, criteria include but are not limited to: 3-year check for felony convictions, 1-year check for illegal drug use, 1-year check for misconduct such as theft or fraud
College degree (B.S.) in Computer Science, Software Engineering, Information Management Systems or a related discipline. Equivalent professional experience will be considered in lieu of degree
7-10 years of technical experience
A minimum of 5 years of experience as Database Administrator and Developer in PostgreSQL and Oracle environment
A minimum of 2 years of AWS DMS service experience
Must be familiar with RDS upgrades
Must have worked on AWS performance insight
Strong analytical and problem-solving skills to provide expertise to support application team
Strong written communication skills to document implemented solutions or workarounds
Good understanding of physical and logical data modelling
Capable of working in a team environment and collaborating with other teams like platform support, developers, production support etc.
Experience utilizing performance monitoring tools to work with application developers to identify and correct inefficient database operations
AWS RDS experience especially Aurora
Experience working with AWS services such as S3 AND Lambda
Strong programming background for writing triggers, functions and procedures
Must be available for Production on-call support

Nice To Haves

Database Migration experience strongly preferred, especially Oracle to PostgreSQL

Responsibilities

Build ERD, physical and logical data models
Follow and establish DB standards
Understand PostgreSQL architecture
Upgrade PostgreSQL Databases
Support the Functional Business, Application Development, and Security Technical Teams to provide O&M and Release Management support for landscape components
Integrate and support cloud RDS Databases providing high availability backup
Participate in the design activities consistent with enterprise standards and Agency priorities for continuous improvement (e.g.: Robotics Process Automation, Automated Testing, etc.) to deliver value-added solutions
Participate proof of concept in new technologies
Design, develop and implement approaches for historical data retention and archival storage backup and recovery solutions
Work in a collaborative team environment with other operational (e.g. OS, DBA, network, security, etc.) team members to troubleshoot and optimize performance
Write triggers and functions to support ETL
Migrate data across heterogenous Databases
Work on AWS services specifically AWS DMS, RDS, Lambda, S3
Work on performance insight AWS service
Work with Informatica ETL tool