Junior/Mid-level Database Developer/Architect

Junior/Mid-level Database Developer/Architect

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: Secret

Employee Type: Regular

Percentage of Travel Required: Up to 10%

Type of Travel: Continental US

* * *

The Opportunity:

CACI is seeking a motivated and detail-oriented Database Developer with foundational experience in database development and a strong desire to grow into architectural responsibilities. The ideal candidate should have exposure to both OLTP systems and be eager to work on modernizing legacy databases.

Responsibilities:

Database Development and Maintenance

• Design, develop, and maintain robust and efficient database solutions for OLTP systems.

• Ensure databases are optimized for performance, scalability, and reliability.

• Implement and manage database objects such as tables, indexes, views, stored procedures, and functions.

Legacy Database Modernization

• Assess and identify opportunities for modernizing legacy databases.

• Plan and execute database upgrades and migrations to newer technologies or platforms.

• Collaborate with senior developers to ensure smooth transition and minimal downtime during migrations.

Data Warehousing and ETL Processes

• Develop and maintain ETL (Extract, Transform, Load) processes to integrate data from various sources into the data warehouse.

• Ensure data integrity and accuracy throughout the ETL process.

• Optimize data warehousing solutions for query performance and efficiency.

Database Security and User Management

• Implement and manage database security protocols, including user authentication and authorization.

• Regularly review and update user permissions to ensure compliance with security policies.

• Monitor database activity for any security breaches or anomalies.

Collaboration and Communication

• Work closely with senior developers and cross-functional teams to understand business requirements and translate them into technical solutions.

• Provide clear and concise documentation of database designs, processes, and changes.

• Communicate effectively with stakeholders to ensure database solutions align with business objectives.

Qualifications:

Required: 

•    2 to 5 years of experience in database development.
•    Basic understanding of OLTP (Online Transaction Processing) systems.
•    Exposure to Data Warehousing concepts and ETL processes.
•    Familiarity with Database Replication and User Management.
•    Solid grasp of SQL and database programming (queries, stored procedures, functions).
•    Understanding of database transaction management, including ACID principles.
•    Willingness to learn and contribute to legacy database upgrades and migrations.
•    Good problem-solving skills and attention to detail.
•    Ability to work collaboratively with senior developers and cross-functional teams.
•    Must be available to work full-time on-site in Norco, CA; remote work is not permitted.

Desired:

• Experience with one or more database platforms (e.g., SQL Server, Oracle, PostgreSQL, MySQL).

• Exposure to cloud-based database environments (e.g., AWS RDS, Azure SQL).

• Strong communication skills and a proactive attitude toward learning.

• US Navy Knowledge of Combat Systems (ET, FC, OS, IT, etc.).

• Active SECRET Clearance.

-

________________________________________________________________________________________

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