Minimum Clearance Required to Start: TS/SCI with Polygraph
Employee Type: Regular
Percentage of Travel Required: None
Type of Travel: None
We are seeking an experienced and motivated PostgreSQL Database Administrator / Database Performance Engineer to join our Federal IT Operations team. You will support and optimize a large-scale ServiceNow platform environment that is mission-critical to national security operations. The role focuses on PostgreSQL database performance, SQL optimization, data architecture, scalability, integrations, and troubleshooting of data-intensive workloads across the ServiceNow ecosystem.
The ideal candidate has a strong background in enterprise relational databases and SQL, with deep, hands-on PostgreSQL experience. They have supported high-volume SaaS or application platforms. Familiarity with ServiceNow architecture and data models is preferred, as is experience with ServiceNow RaptorDB Professional. The role requires technical expertise, problem-solving ability, adaptability, and collaboration with cross-functional teams in a secure, fast-paced environment.
Provide database and SQL expertise in support of enterprise ServiceNow environments, applications, integrations, and reporting workloads.
Analyze and troubleshoot database performance issues, including inefficient queries, large-table operations, indexing, transaction performance, and high-volume data access patterns.
Identify performance bottlenecks and recommend improvements to queries, table structures, data models, archival strategies, and application design.
Review SQL and data-access patterns associated with integrations, reporting, analytics, ETL/data pipelines, APIs, and custom applications.
Monitor database and application performance, availability, and capacity metrics, and proactively identify trends and potential issues.
Support capacity planning and performance analysis for large and rapidly growing ServiceNow datasets.
Assist with data retention, archival, purge, and lifecycle-management strategies.
Manage database backup, recovery, and storage solutions.
Support database hardening, patching, and compliance with DoD/Federal security standards (STIGs, DISA, NIST).
Develop and maintain scripts and automation (e.g., PL/pgSQL, PowerShell, Python, Bash) for database provisioning, configuration management, and routine maintenance.
Support and manage databases hosted on AWS EC2, including instance sizing, storage (EBS) performance, snapshots and backups, and network connectivity.
Show the full description
ServiceNow Platform Support
Advise development teams on database design, query optimization, normalization/denormalization, indexing, and efficient data-access practices.
Support ServiceNow upgrades, migrations, major platform changes, and database modernization initiatives.
Work with ServiceNow and internal engineering teams on RaptorDB-related performance, migration, analytics, and architecture considerations.
Support incident, problem, and root-cause analysis for performance and data-related production issues.
General Duties
Partner with ServiceNow platform architects, developers, administrators, network, security, infrastructure, and application teams to improve platform performance, scalability, and reliability.
Work within an Agile/Scrum team, participating in sprint planning, stand-ups, and retrospectives, and delivering database work in alignment with sprint priorities.
Develop and maintain technical documentation, operational procedures, performance baselines, and database best practices.
Participate in the on-call support rotation and provide occasional off-hours support as needed.
Respond to critical system alerts and incidents in a timely manner.
What they ask for vs. your profile
Must have
ServiceNow
SQL
AWS
ETL
Postgres
Troubleshooting
Agile
Python
Adaptability
Attention to detail
Support accreditation and certification activities in alignment with RMF (Risk Management Framework).
Required Qualifications
Active TS/SCI with Polygraph.
Bachelor's degree in Computer Science, Information Systems, or a related discipline (or equivalent work experience).
Experience in federal government or DoD environments.
Familiarity with cloud platforms (AWS, Azure, or GovCloud) and containerization technologies (Docker, Kubernetes).
AWS Certified Solutions Architect – Associate, or relevant database certifications.
Current IAT Level II certification (Security+ or equivalent).
ServiceNow Certified System Administrator (CSA) completed within 60 days of start date.
5+ years of experience in database administration, database engineering, or SQL performance engineering, with at least 3 years focused on PostgreSQL administration and performance tuning.
Excellent communication and interpersonal skills. • Strong attention to detail, with a commitment to accuracy in database changes, configurations, and deliverables.
Ability to write clear, accurate, and usable documentation (e.g., runbooks, procedures, performance baselines) that others can follow and maintain.
Ability to collaborate effectively with platform engineers, developers, architects, infrastructure teams, and business stakeholders.
Strong willingness to learn new technologies and adapt to evolving requirements.
Ability to work effectively in a secure, team-oriented, mission-driven environment.
Self-motivated, with the ability to manage multiple priorities.
Ability to translate database-level findings into actionable recommendations for ServiceNow developers and architects.
Proactive about performance, scalability, data quality, and operational reliability.
Desired Qualifications
ServiceNow platform architecture, data model, tables, and relationships, including large-table considerations.
Experience with ServiceNow RaptorDB Professional, including: o Understanding of its architecture, performance characteristics, and migration considerations. SQL-based data access, analytical workloads, column-store technologies, or large-scale operational analytics.
ServiceNow Performance Analytics, Workflow Data Fabric, or related data and analytics capabilities.
ServiceNow query and transaction performance, including how GlideRecord and application data-access patterns affect the database.
ServiceNow integration and data-load mechanisms (REST/SOAP integrations, Import Sets, and Transform Maps) and their impact on database load.
ServiceNow at enterprise scale, including environments with very large datasets, high transaction volumes, or significant reporting and analytics requirements.
Performance troubleshooting and optimization in a ServiceNow environment. Advanced SQL skills, with demonstrated experience analyzing and optimizing complex queries.
Strong understanding of relational database concepts, including
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.
The proposed salary range for this position is
$103,800 - $218,100
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.
