Database Administrator (PostgreSQL)Job Category: Information TechnologyTime Type: Full timeMinimum Clearance Required to Start: NoneEmployee Type: RegularPercentage of Travel Required: Up to 10%Type of Travel: LocalCACI is seeking a Database Administrator to join our team and support the Border Enforcement Applications for Government Leading-Edge Information Technology (IT) (BEAGLE) contract. You will have the opportunity to apply your knowledge, skills and experience to building a truly modern application that is new development and cloud native.

You will work in a SecDevOps environment that includes continuous integration/continuous deployment and test automation in a consistent agile software development framework. If you thrive in a culture of innovation and bring creative ideas to solve complex technical and procedural problems at the at the team and portfolio levels, then this opportunity is for you!Join this passionate team of industry-leading individuals supporting best practices in agile software development for the Department of Homeland Security (DHS). You will support the men and women charged with safeguarding the American people and enhancing the nation's safety and security.

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.Duties include but are not limited to: Help shape the future of how some of the nation's most complex and challenging data are used to enhance national security and protect the lives of Agents, Officers, and those entering the country.

Provide high-level architectural guidance, technical innovation, and analytical expertise to teams across CBP.Champion all aspects of data architecture, analytic methodology, and visualization functions including engineering standards, governance processes, and providing vision and context to explore and effectively utilize emerging technologies.Work with database developers and administrators across multiple product teams.

Serve as a data and technology expert across a broad and diverse set of mission critical applicationsActively participate in Agile Scrum sprint planning, artifact creation, sprint testing, regression testing, demonstrations, retrospectives and solution releasesAnalyze project-related problems and create innovative solutions involving technology, analytic methodologies, and advanced solution components.Deliver deployable software in short sprints.The ability to be adaptable and work constructively with a technically diverse and geographically separated team is crucial.

Required Qualifications: 5-10+ years of experience working with PostgreSQL databases, including designing, implementing, and optimizing database systems.Experience with data modeling, tuning, scaling, security, backup, recovery, and integrity of RDBMS, specifically PostgreSQL in AWS.Solid understanding of concepts such as data types, indexing, performance tuning, query plans.

Ability to take high level requirements and work with Product Architects to create a data model to store transactional data.Understanding of Oracle, Microsoft SQL Server, or MySQL, as well as understanding of NoSQL databases like DynamoDB, MongoDB, Cassandra, or Couchbase.Strong SQL skills for querying, analyzing, and managing data, as well as creating and maintaining stored procedures, triggers, and views.

Experience with CDC (change data capture) concepts and usage.Knowledge of security best practices, including encryption, authentication, and access control, to ensure that sensitive data is protected and compliant with government regulations.Experience with cloud-based database services such as Amazon Web Services (AWS) RDS, Google Cloud SQL, or Microsoft Azure SQL Database.

Experience with data integration tools and techniques, including ETL (Extract, Transform, Load) processes, and queue-based messaging systems to ensure seamless data flow between systems.Familiarity with microservices based architecture and its impact to data storage.Skills in analyzing and optimizing database performance, including indexing, partitioning, and query optimization.

Ability to work effectively with cross-functional teams, including developers, data analysts, and business stakeholders, to gather requirements and communicate complex database concepts.Experience helping customers and mission users conceptualize and prioritize their data analysis and visualization needs.Typically has a University Degree (BA/BS) or equivalent experience and minimum 7 years of related work experience.Must be a U.S.

Citizen with the ability to pass CBP background investigation, criteria include, but not limited to:3-year check for felony convictions1-year check for illegal drug use1-year check for misconduct such as theft or fraudDesired Qualifications:Experience with NoSQL databases such as DynamoDB, DocumentDB, or Mongo a plus.Experience with geospatial data management a plus.Experience with Apache Kafka for messaging and data streaming a plus.

Experience with data governance platforms such as Collibra a plus.Experience in Continuous integration, Continuous Deployment (CI/CD) and DevOps processes and toolsExperience implementing or migrating to Cloud environments like Amazon Web Services (AWS), Google Cloud, or Microsoft AzureWhat We Can Offer You:- We've been named a Best Place to Work by the Washington Post.- Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives.

- We offer competitive benefits and learning and development opportunities.- We are mission-oriented and ever vigilant in aligning our solutions with the nation's highest priorities.- For over 60 years, the principles of CACI's unique, character-based culture have been the driving force behind our success.

Company Overview: At CACI, you will have the opportunity to make an immediate impact by providing information solutions and services in support of national security missions and government transformation for Intelligence, Defense, and Federal Civilian customers. CACI is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other protected characteristic.

Pay Range: The proposed salary range for this position is $95,500-$210,100. 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, geographic location, 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. Employment benefits include health and wellness programs, income protection, paid leave and, life insurance, retirement and savings.

Job SummaryJob number: 282688Date posted : 2023-06-23Profession: ITEmployment type: Full time.