Junior/Mid-level Database Developer/Architect
CACI International - Norco, California, United States, 91760
Work at CACI International
Overview
- View job
Overview
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.
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:
$99,300 - 208,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.