Database Developer

Job description

Database Developer

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 seeking a Database Developer 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.

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.

**Responsibilities:**

+ Create data models based on high level business requirements adhering to project, portfolio, enterprise, and industry standards and best practices in a cloud environment.
+ Design, develop, and implement version-controlled database schemas, tables, views, stored procedures, and triggers.
+ Optimize database queries, stored procedures, and functions for maximum performance and efficiency.
+ Develop and maintain data migration and transformation scripts.
+ Monitor and troubleshoot database performance issues.
+ Actively participate in Agile Scrum sprint planning, artifact creation, sprint testing, regression testing, demonstrations, retrospectives and solution releases
+ Deliver deployable software in short sprints.

**Qualifications:**

_Required:_

+ College degree (B.S. or greater) in Computer Science, Software Engineering, Information Management Systems or a related discipline (Will consider experience in lieu of education).
+ 7+ years of experience working with relational databases, including designing data models, implementing version-controlled schema changes, and optimizing database systems.
+ Solid understanding of concepts such as data types, indexing, performance tuning, query plans.
+ Demonstrated skill to take high level requirements and work with Product Architects to create a data model to store transactional data.
+ Proven expertise in relational databases such as PostgreSQL, SQL Server, MySQL, or Oracle.
+ 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.
+ Understanding of NoSQL databases such DynamoDB, MongoDB, Cassandra, or Couchbase.
+ 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.
+ 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.
+ 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 convictions
+ 1-year check for illegal drug use
+ 1-year check for misconduct such as theft or fraud

_Desired:_

+ Experience with NoSQL databases such as DynamoDB, DocumentDB, or Mongo.
+ Experience with geospatial data management.
+ Experience with Apache Kafka for messaging and data streaming.
+ Experience with data governance platforms such as Collibra or Open Metadata.
+ Experience in Continuous integration, Continuous Deployment (CI/CD) and DevOps processes and tools
+ Experience implementing or migrating to Cloud environments like Amazon Web Services (AWS), Google Cloud, or Microsoft Azure.

-
**________________________________________________________________________________________**

**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.

Learn more about CACI here.

(https://careers.caci.com/global/en/life-at-caci)

**________________________________________________________________________________________**

**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.

Learn more here (https://careers.caci.com/global/en/employee-benefits) .

Since this position can be worked in more than one location, the range shown is the national average for the position.

The proposed salary range for this position is:

$98,500-$206,800

_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._

Required Skill Profession

Other General