Database Administrator (PostgreSQL)
As a member of the BEAGLE ASF Team, you will support the men and women charged with safeguarding the American people and enhancing the Nation’s safety, security, and prosperity. CBP agents and officers are on the front lines every day, protecting our national security by combining customs, immigration, border security, and agricultural protection into one coordinated and supportive activity.
ASF programs thrive in a culture of innovation and are constantly seeking individuals who can bring creative ideas to solve complex problems, both technical and procedural at the team and portfolio levels. The ability to be adaptable and to work constructively with a technically diverse and geographically separated team is crucial. You should have worked in PostgreSQL DBA experience, ETL tool to understand concepts and supported RDS in AWS environment.
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
Qualifications:
- 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
- Database Migration experience strongly preferred, especially Oracle to PostgreSQL
- 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.
Xenith Solutions LLC is a Service-Disabled Veteran-Owned Small Business founded in 2019. We provide comprehensive, timely and relevant Solutions and Business Consulting support to our customers as a key partner. Our leadership brings over a century of combined experience in Defense and Civilian markets. Our employees possess experience in all aspects of solution development from requirements creation, development, test and evaluation, fielding, and sustainment. At the core of our offerings, we provide strategy and technology solutions, giving our customers valuable insights and thought leadership on the best application of information technology to drive business objectives.
Xenith focuses on solving complex business challenges facing our customers. Our “Success Through Achievement” work ethic means our customer receive quality solutions through our commitment. We pride ourselves on tackling some of the most difficult operational requirements our customers have – ensuring an appropriate match between the mission requirements, financials, schedule, and security.
EEO
Xenith Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws.
EEO IS THE LAW
If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact Xenith Solutions.
E-Verify
As a Federal Contractor, Xenith Solutions is required to participate in the E-Verify Program to confirm eligibility to work in the United States.
Affirmative Action Plan
As a federal government contractor and based on Executive Orders and applicable laws and regulations, Xenith Solutions develops and maintains annual written Affirmative Action Plans and endeavors to hire and advance qualified minorities, females, individuals with disabilities, and protected veterans.