Dieses Stellenangebot ist nicht mehr verfügbar
Über
Job Category: Information Technology
Time Type: Full time
Minimum Clearance Required to Start: None
Employee Type: Regular
Percentage of Travel Required: Up to 10%
Type of Travel: Local
The Opportunity:
CACI is currently seeking a PostgreSQL DBA with strong ETL and AWS Experience to join our BEAGLE (Border Enforcement Applications for Government Leading-Edge Information Technology) Agile Solution Factory (ASF) Team supporting Customs and Border Protection (CBP) client located in Northern Virginia! Join this passionate team of industry-leading individuals utilizing ASF best for the Department of Homeland Security (DHS).
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.
_________________________________________________________________________
What You Can Expect:
A culture of integrity.
At CACI, we place character and innovation at the center of everything we do. As a valued team member, you'll be part of a high-performing group dedicated to our customer's missions and driven by a higher purpose - to ensure the safety of our nation.
An environment of trust.
CACI values the unique contributions that every employee brings to our company and our customers - every day. You'll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.
A focus on continuous growth.
Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground - in your career and in our legacy.
Your potential is limitless.
So is ours.
_________________________________________________________________________
Pay Range
: There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.
The proposed salary range for this position is:
$103,800 - $218,100
CACI is
an Equal Opportunity Employer.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any
other protected characteristic.
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot wurde von einem unserer Partner veröffentlicht. Sie können das Originalangebot einsehen hier.