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. **Responsibilities:** **Design and Develop Complex Database Systems:** + Create and implement robust database architectures for both OLTP and OLAP environments. + Ensure databases are scalable, maintainable, and aligned with business requirements. **Manage Data Warehousing and ETL Processes:** + Oversee the design and implementation of data warehousing solutions. + Develop and maintain ETL processes to ensure accurate and efficient data transformation and loading. **Implement Database Replication Strategies:** + Design and deploy database replication strategies to ensure data consistency and availability across multiple systems. + Monitor replication performance and troubleshoot any issues that arise. **Ensure Database Security and User Management:** + Establish and enforce database security protocols and best practices. + Manage user access and permissions to maintain the integrity and confidentiality of data. **Upgrade and Migrate Legacy Databases:** + Lead the process of upgrading and migrating legacy databases to modern platforms. + Perform schema redesign, data transformation, and performance optimization to ensure seamless transition and improved performance. **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. - **________________________________________________________________________________________** **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) . The proposed salary range for this position is: $90,300 - 189,600 USD _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._