Senior 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 highly experienced Senior Database Developer/Architect with a strong background in database architecture. The ideal candidate will have deep expertise in designing, developing, and managing complex database systems, and should be comfortable working across both OLTP and OLAP environments.

QUALIFICATIONS:

Required:

• 10+ years of hands-on experience in database development and architecture
• Strong understanding of OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) systems.
• Proven experience with Data Warehousing concepts and implementation.
• Expertise in ETL (Extract, Transform, Load) processes and tools.
• Solid knowledge of Database Replication strategies and technologies.
• Experience with User Management and database security best practices.
• Advanced proficiency in SQL and database development (procedures, functions, performance tuning, etc.).
• Strong understanding of database transaction management, including ACID properties, isolation levels, and concurrency control.
• Ability to design scalable and maintainable database solutions.
• Strong problem-solving skills and attention to detail.
• Experience in upgrading and migrating legacy databases to modern platforms, including schema redesign, data transformation, and performance optimization.
• Must be available to work full-time on-site in Norco, CA; remote work is not permitted.

Desired:

• Experience with enterprise-level database platforms (e.g., SQL Server, Oracle, PostgreSQL, etc.).
• Familiarity with cloud-based database solutions (e.g., AWS RDS, Azure SQL).
• Excellent communication and documentation skills.
• US Navy Knowledge of Combat Systems (ET, FC, OS, IT, etc.).

• Active SECRET Clearance.