SQL Database Administrator Database Performance Engineer – ServiceNow Platform

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.

Responsibilities:
Database Administration & Performance Engineering:
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.

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.
Support accreditation and certification activities in alignment with RMF (Risk Management Framework).

Required Qualifications:

Active TS/SCI with Polygraph.

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

o Query execution and optimization.

o Indexing strategies.

o Data modeling.

o Transactions and locking.

o Database performance tuning.

o Large-table and high-volume data management.

o Data retention and archival.

Experience supporting highly available high-volume enterprise application environments.

Strong troubleshooting skills across application database integration and infrastructure layers.

Experience analyzing performance problems using database application and platform telemetry.

Experience administering databases on AWS EC2 Amazon RDS or comparable cloud-hosted infrastructure.

Understanding of REST APIs integrations ETL/data pipelines and enterprise data movement patterns.

Working knowledge of database hardening patch management and security compliance (e.g. STIGs).

Experience scripting and automating routine database tasks (e.g. PL/pgSQL PowerShell Python Bash).

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 youll be part of a high-performing group dedicated to our customers 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. Youll 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 nations 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: