Apply on Employer Site

CACI International Inc · 5 months ago

Junior/Mid-level Database Developer/Architect

US CA Norco

Full-time

Onsite

Entry, Mid Level

$99K/yr - $209K/yr

2+ years exp

CACI International Inc 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 role involves designing and maintaining efficient database solutions, modernizing legacy databases, and developing ETL processes to integrate data into a data warehouse.

Information TechnologyService IndustrySoftware

Comp. & Benefits

No H1B

Security Clearance Required

Responsibilities

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

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

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

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

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

Qualification

Database DevelopmentSQLOLTP SystemsETL ProcessesData WarehousingDatabase SecurityWillingness to LearnProblem-solvingCollaborationCommunicationAttention to Detail

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

Preferred

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

Benefits

Healthcare

Wellness

Financial

Retirement

Family support

Continuing education

Time off benefits

Company

CACI International Inc

Glassdoor4.0

At CACI International Inc (NYSE: CACI), our 25,000 talented and dynamic employees are ever vigilant in delivering distinctive expertise and technology to meet our customers’ greatest challenges in national security.

Founded in 1962

Arlington, Virginia, USA

10001+ employees