CACI is seeking a Database Administrator to support the Border Enforcement Applications for Government Leading-Edge Information Technology (BEAGLE) contract, aiming to build a modern, cloud-native application for the Department of Homeland Security (DHS) to enhance national security and protect the lives of agents, officers, and those entering the country.
Requirements
- Professional Experience: at least seven (7) years related technical experience, with 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.
- 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.
Responsibilities
- 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 applications.
- Actively participate in Agile Scrum sprint planning, artifact creation, sprint testing, regression testing, demonstrations, retrospectives and solution releases.
- Analyze project-related problems and create innovative solutions involving technology, analytic methodologies, and advanced solution components.
- Deliver deployable software in short sprints.
- Ability to take high level requirements and work with Product Architects to create a data model to store transactional data.
- 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.
Other
- 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.
- Must be available to work a hybrid schedule with an on-site requirement in Ashburn, VA.
