PostgreSQL Database Engineer (Mid-Level)

Posted Yesterday
Be an Early Applicant
Hiring Remotely in State Road, IL, USA
In-Office or Remote
90K-190K Annually
Mid level
Information Technology • Consulting • Defense
The Role
Design, develop, and optimize PostgreSQL stored procedures, triggers, schemas, and queries. Perform performance tuning, indexing, partitioning, and execution plan analysis. Support Oracle-to-PostgreSQL migrations, dependency analysis, and integration troubleshooting. Ensure GovCloud security controls (IAM, encryption, auditing) and collaborate with development teams in design/code reviews and DevSecOps pipelines.
Summary Generated by Built In
Job Title: PostgreSQL Database Engineer (Mid-Level)

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: Local

* * *

The Opportunity:
CACI is seeking a skilled Mid-Level PostgreSQL Database Engineer to support modernization efforts in a customer environment. This role focuses on database development, schema optimization, and performance tuning on a cloud-based PostgreSQL environment. The ideal candidate has hands-on experience with stored procedures, triggers, query optimization, and data integrity controls.

Responsibilities:

  • Develop and optimize stored procedures, functions, triggers, packages, and views in PostgreSQL.

  • Analyze and tune SQL queries for performance and scalability.

  • Support schema design, normalization, refactoring, and dependency analysis.

  • Collaborate on database integration across legacy and modernized systems.

  • Assist in migration efforts involving Oracle and PostgreSQL.

  • Identify performance bottlenecks and implement solutions involving indexing, partitioning, and execution plan analysis.

  • Apply best practices for data integrity, concurrency, and transaction management.

  • Support development teams by providing database expertise for API and application interactions.

  • Participate in design reviews, code reviews, and data modeling workshops.

  • Ensure compliance with GovCloud security controls including IAM, encryption, and auditing.

Qualifications:
Required: 

  • Bachelor’s degree in Computer Science, Engineering, or related technical discipline.

  • 3–5 years of hands-on experience as a database engineer or database developer.

  • Ability to obtain and maintain a DoD Secret clearance is required.

  • Strong experience developing stored procedures, triggers, and SQL logic for PostgreSQL.

  • Strong experience reviewing PL/SQL code and reverse engineering Oracle schemas.

  • Proven expertise with performance tuning, indexing strategies, query plans, and workload analysis.

  • Experience analyzing schema dependencies, constraints, and database objects.

  • Familiarity with database migration concepts and tools.

  • Ability to troubleshoot database issues in distributed integration environments

Desired:

  • Experience modernizing data systems for DoW customers.

  • Experience migrating databases to PostgreSQL using migration automation tools.

  • Experience working in Agile/SAFe environments with DevSecOps pipelines.

Working Conditions

  • Hybrid work with support at CACI facilities, customer sites, or remote depending on project needs.

  • May require infrequent travel for technical workshops, customer engagement, or integration events.

-

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.

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.

Since this position can be worked in more than one location, the range shown is the national average for the position.

The proposed salary range for this position is:

$90,300-$189,600

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.

Skills Required

  • Bachelor's degree in Computer Science, Engineering, or related technical discipline.
  • 3-5 years of hands-on experience as a database engineer or database developer.
  • Ability to obtain and maintain a DoD Secret clearance.
  • Strong experience developing stored procedures, triggers, and SQL logic for PostgreSQL.
  • Strong experience reviewing PL/SQL code and reverse engineering Oracle schemas.
  • Proven expertise with performance tuning, indexing strategies, query plans, and workload analysis.
  • Experience analyzing schema dependencies, constraints, and database objects.
  • Familiarity with database migration concepts and tools.
  • Ability to troubleshoot database issues in distributed integration environments.
  • Experience modernizing data systems for DoW customers.
  • Experience migrating databases to PostgreSQL using migration automation tools.
  • Experience working in Agile/SAFe environments with DevSecOps pipelines.

CACI International Inc Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about CACI International Inc and has not been reviewed or approved by CACI International Inc.

  • Healthcare Strength Pay is supported by a broad set of health-plan options across multiple national carriers, with telemedicine and tax-advantaged accounts included. Dental and vision choices are also described as multi-option, which strengthens overall coverage breadth.
  • Leave & Time Off Breadth Flexible Time Off is available for many salaried-exempt roles, while hourly roles accrue PTO, creating multiple time-off pathways by employment class. Paid disability coverage, fixed holidays, and paid leave programs (including parental leave and other leave types) further round out time-off and leave coverage.
  • Retirement Support Retirement support includes a 401(k) match structure described as 50% up to 8% of pay (effective 4%) and an Employee Stock Purchase Plan with a discount. Tuition reimbursement and certification support also add to the overall rewards package that complements core retirement benefits.

CACI International Inc Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Reston, VA
17,673 Employees
Year Founded: 1962

What We Do

CACI’s approximately 23,000 talented employees are vigilant in providing the unique expertise and distinctive technology that address our customers’ greatest enterprise and mission challenges. Our culture of good character, innovation, and excellence drives our success and earns us recognition as a Fortune World's Most Admired Company. As a member of the Fortune 1000 Largest Companies, the Russell 1000 Index, and the S&P MidCap 400 Index, we consistently deliver strong shareholder value. Visit us at www.caci.com.

Similar Jobs

TextUs Logo TextUs

Business Operations Analyst

Enterprise Web • HR Tech • Information Technology • Software
Easy Apply
Remote
USA
53 Employees
70K-85K Annually

Pfizer Logo Pfizer

Senior Director, Internal Medicine Portfolio Strategy Lead

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
In-Office or Remote
10 Locations
121990 Employees
215K-358K Annually

Pfizer Logo Pfizer

Director, Portfolio Strategy Inflammation & Immunology

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
In-Office or Remote
10 Locations
121990 Employees
177K-294K Annually

Capital One Logo Capital One

Business Development Manager

Fintech • Machine Learning • Payments • Software • Financial Services
Remote or Hybrid
2 Locations
55000 Employees
162K-184K Annually

Similar Companies Hiring

Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Outpost Space Thumbnail
Aerospace • Defense
US
24 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account