The company is hiring a PostgreSQL database administrator who also does performance engineering. The role sits in the Federal IT Operations team and supports a large ServiceNow platform that serves national security work.
The work covers PostgreSQL performance, SQL tuning, data architecture, scalability, integrations, and fixing problems in data-heavy workloads across the ServiceNow ecosystem.
The ideal person knows enterprise relational databases and SQL well, has hands-on PostgreSQL experience, and has supported high-volume SaaS or application platforms. Familiarity with ServiceNow architecture and data models is preferred, and so is experience with ServiceNow RaptorDB Professional.
The team works in a secure setting and values problem solving, adaptability, and collaboration with cross-functional groups.
Responsibilities
Troubleshoot slow queries, heavy table operations, indexing problems, transaction speed, and high-volume data access.
Find bottlenecks and recommend fixes to queries, table structures, data models, archiving, and application design.
Review SQL and data access coming from integrations, reporting, analytics, ETL pipelines, APIs, and custom applications.
Track database and application performance, availability, and capacity, and flag trends and risks early.
Help plan capacity and analyze performance for large, fast-growing ServiceNow datasets.
Help define data retention, archival, purge, and lifecycle strategies.
Run database backup, recovery, and storage.
Help harden and patch databases and keep them compliant with DoD and federal standards (STIGs, DISA, NIST).
Write and maintain scripts for provisioning, configuration, and routine maintenance using PL/pgSQL, PowerShell, Python, or Bash.
Manage databases on AWS EC2, covering instance sizing, EBS storage performance, snapshots and backups, and network connectivity.
Advise developers on schema design, query tuning, normalization and denormalization, indexing, and efficient data access.
Support ServiceNow upgrades, migrations, major platform changes, and database modernization.
Work with ServiceNow and internal engineers on RaptorDB performance, migration, analytics, and architecture.
Support root-cause analysis and handling of performance and data incidents and problems in production.
Work with platform architects, developers, administrators, and network, security, infrastructure, and application teams to improve performance, scale, and reliability.
Join Agile/Scrum sprint planning, stand-ups, and retrospectives, and deliver database work in line with sprint priorities.
Write and maintain technical documentation, runbooks, performance baselines, and database best practices.
Join the on-call rotation and cover occasional off-hours support.
Respond promptly to critical alerts and incidents.
Support accreditation and certification work under the Risk Management Framework (RMF).
Requirements
Required: Hold an active TS/SCI clearance with a Polygraph.
Required: Hold a bachelor's degree in computer science, information systems, or a related field, or have equivalent work experience.
Required: Have experience in federal government or DoD environments.
Required: Be familiar with cloud platforms (AWS, Azure, or GovCloud) and containers (Docker, Kubernetes).
Required: Hold AWS Certified Solutions Architect, Associate or a relevant database certification.
Required: Hold a current IAT Level II certification (Security+ or equivalent).
Required: Earn ServiceNow Certified System Administrator (CSA) status no later than 60 days after you start.
Required: Have 5+ years in database administration, database engineering, or SQL performance engineering, including at least 3 years on PostgreSQL administration and tuning.
Required: Communicate clearly and well with people at every level.
Required: Be meticulous, with accurate database changes, configurations, and deliverables.
Required: Write runbooks, procedures, and performance baselines that others can follow and maintain.
Required: Work well with engineers, developers, architects, infrastructure teams, and business stakeholders.
Required: Be eager to learn new technology and adjust as requirements change.
Required: Work securely and as a team in a mission-driven environment.
Required: Be self-directed and able to juggle several priorities.
Required: Turn database findings into actions that ServiceNow developers and architects can use.
Required: Anticipate issues with performance, scalability, data quality, and reliability.
Desired: Knowledge of ServiceNow platform architecture, data model, tables, and relationships, including large-table issues.
Desired: Experience with ServiceNow RaptorDB Professional, including its architecture, performance behavior, and migration considerations.
Desired: Experience with SQL-based analytics, column-store technologies, or large-scale operational analytics.
Desired: Familiarity with ServiceNow Performance Analytics, Workflow Data Fabric, or related data and analytics tools.
Desired: Understanding of how GlideRecord and application data access affect the database.
Desired: Understanding of how REST/SOAP integrations, Import Sets, and Transform Maps load the database.
Desired: Experience with ServiceNow at enterprise scale, including very large datasets, high transaction volumes, or heavy reporting.
Desired: Experience tuning ServiceNow performance and optimizing complex SQL queries.
Desired: Solid grasp of relational concepts, including query execution, indexing, data modeling, transactions and locking, performance tuning, large-table management, and retention and archival.
Desired: Strong troubleshooting across application, database, integration, and infrastructure layers.
Desired: Experience analyzing performance with database, application, and platform telemetry.
Desired: Experience running databases on AWS EC2, Amazon RDS, or comparable cloud infrastructure.
Desired: Understanding of REST APIs, integrations, ETL pipelines, and enterprise data movement.
Desired: Working knowledge of database hardening, patch management, and security compliance such as STIGs.
Desired: Experience scripting and automating routine database tasks.
Conditions
This is a full-time, regular position with no travel required.
The minimum clearance required to start is TS/SCI with a Polygraph.
You will join the on-call rotation and provide occasional off-hours support as needed.
The proposed salary range is $103,800 - $218,100.
Final pay depends on factors such as location, federal contract labor categories and wage rates, prior experience, skills, education, and certifications.
Benefits
Competitive compensation, benefits, and learning and development opportunities.
Comprehensive benefits including healthcare, wellness, financial, retirement, family support, continuing education, and time off.
A flexible time-off benefit that lets you take the time you need.
Access to robust learning resources to support your career goals.