Database Administrator with Databricks and Oracle

Database Administrator With Databricks And Oracle

CACI is currently looking for a Databricks DBA with agile methodology 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 supporting the best practices in Agile Software Development 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 with or have a strong interest in agile software development practices and delivering deployable software in short sprints.

Responsibilities

Maintain Oracle RDS databases, ensuring optimal performance, availability, and security

Manage Databricks workspaces and clusters on AWS, including configuration, optimization, and troubleshooting for data engineering and machine learning workloads.

Develop and implement robust backup, recovery, and disaster recovery strategies for both Oracle RDS and Databricks environments.

Monitor database and platform performance, identify bottlenecks, and implement tuning strategies to enhance efficiency and responsiveness.

Collaborate with development teams to optimize SQL queries, data models, and Databricks notebooks for improved application and data pipeline performance.

Implement and enforce security best practices for data at rest and in transit within Oracle RDS and Databricks on AWS.

Automate routine administrative tasks and build efficient operational processes for database and platform management.

Provide expert-level support for database-related issues, including performance tuning, troubleshooting, and incident resolution.

Stay current with AWS, Oracle, and Databricks technologies, recommending and implementing new features and best practices.

Modernize the data warehouse environment by migrating the platform to Databricks

Actively participate in Agile Scrum sprint planning, artifact creation, sprint testing, regression testing, demonstrations, retrospectives and solution releases.

Support the Functional Business, Application Development, and Security Technical Teams to provide O&M and Release Management support for landscape components.

Work in a collaborative team environment with other operational (OS, DBA, network, security, etc.) team members to troubleshoot and optimize performance.

Strong written communication skills to document implemented solutions or workarounds.

Qualifications

Required:

Must be a U.S. Citizen with the ability to pass CBP background investigation, criteria includes but is not limited to:

o 3 year check for felony convictions

o 1 year check for illegal drug use

o 1 year check for misconduct such as theft or fraud

7+ years of professional experience working on complex data challenges in the areas of data architecture and engineering

Proven experience as an Oracle DBA, with specific expertise in managing Oracle databases on Amazon RDS.

Solid experience with Databricks administration and optimization on AWS, including cluster management, notebook execution, and data access.

Expertise in database performance tuning, including SQL optimization, index management, and resource allocation.

Proficiency in scripting languages (e.g., Python, Shell) for automation and operational tasks.

5+ years of experience as an Oracle Database Administrator in a Linux environment

Databricks experience

Strong software development background using Agile or DevOps methods and deep familiarity with cloud-native technologies.

College degree (B.S.) in Mathematics, Statistics, Computer Science, Software Engineering, or a related discipline. (Industry and/or Academic experience is acceptable in lieu of degree.)

Available to work hybrid schedule in Ashburn, VA

Desired:

5-10 years of DHS, DoD, or IC experience working in complex data environments, including the architecture and optimization of data schemas, terabyte-scale ETL, etc.

5-10 years of experience applying a range of analytical techniques including statistical, geospatial, link, temporal, and predictive analysis, for DHS, DoD, or IC agencies.

AWS Certified Database Specialty or Databricks certifications.

3-5 years of experience building and implementing artificial intelligence, neural networks, deep learning, or machine learning capabilities in software applications in a national security or academic environment.

Exposure to Continuous integration, Continuous Deployment (CI/CD) and DevOps processes and tools

Exposure to implementing or migrating to Cloud environments like Amazon Web Services (AWS) or Microsoft Azure.

Previous experience as an Enterprise-level Data Architect, Data Engineer, Data Scientist, or Data Analyst.

Ability to apply advanced principles, theories, and concepts, and contribute to the development of innovative principles and ideas.