Jobs and Careers

Senior Database Engineer

Mechanicsburg, United Statesfull_timeVerifiedPosted 3 Jun 2026

About the role

Allocore powers the leading government loans, grants, and fraud prevention programs with a unified cloud-based platform built for efficiency and security. Our advanced solutions power the largest and most complex government loan and grant programs, streamlining workflows and integrating proven technologies to handle high-volume financial processes with speed and precision. Every day, we’re enabling government agencies to deliver critical financial resources to those who need them most—quickly and efficiently. At Allocore, our culture is built on three core values—Urgency, Collaboration, and Commitment—which shape how we work, innovate, and support one another. Joining Allocore means being part of a mission-driven team that values innovation, collaboration, and a commitment to excellence. If you thrive in high-pressure environments where urgency meets creativity and where every challenge is an opportunity to create impact, then continue reading....

We are seeking a Senior Database Engineer is responsible for designing, managing, optimizing, and supporting enterprise database platforms and data services across Allocore’s technology ecosystem. This role focuses on Aurora PostgreSQL, DocumentDB, Redshift, Databricks, ElastiCache, API troubleshooting, Query tuning, Database migrations, Automation, and New database feature implementation.

The Senior Database Engineer will work closely with application, cloud, data engineering, DevOps, and release teams to ensure database platforms are reliable, scalable, secure, and optimized for business-critical workloads. This role requires strong hands-on technical expertise, problem-solving ability, an ownership mindset, and the ability to support both operational needs and strategic modernization initiatives.

Key Responsibilities

Design, implement, administer, and support database platforms including Aurora PostgreSQL, Amazon DocumentDB, Amazon Redshift, Databricks, ElastiCache, Oracle, and MSSQL where applicable.

Knowledge of Internals of Aurora PostgreSQL and other AWS databases.

Ensure database environments are highly available, secure, scalable, and aligned with application and business requirements.

Perform database upgrades, patching, configuration management, backup validation, disaster recovery planning, and operational readiness reviews.

Support implementation of new database features, platform enhancements, and cloud-native database capabilities.

Review database architecture, schemas, indexes, stored procedures, functions, and configurations for performance, reliability, and maintainability.

Analyze and tune complex SQL queries, stored procedures, database workloads, and application access patterns.

Identify performance bottlenecks across databases, APIs, caching layers, and data pipelines.

Optimize Aurora PostgreSQL, Redshift, DocumentDB, Databricks, and ElastiCache workloads for cost, performance, and scalability.

Review execution plans, indexing strategies, table design, partitioning, vacuum/analyze processes, statistics, and query patterns.

Partner with application teams to troubleshoot API latency, timeout issues, connection pool behavior, and database-related performance incidents.

Work with AWS cloud services including Aurora PostgreSQL, DocumentDB, Redshift, ElastiCache, S3, IAM, CloudWatch, DMS, Lambda, and related platform components.

Support cloud database provisioning, monitoring, access management, environment configuration, and operational automation.

Collaborate with Cloud, DevOps, and Security teams to ensure database platforms follow IT security, availability, compliance, and operational standards.

Assist with capacity planning, scaling strategies, failover testing, disaster recovery exercises, and production readiness reviews.

Evaluate and recommend improvements for cloud database architecture and operational efficiency. Support data engineering workloads involving Redshift, Databricks, ETL pipelines, data movement, and analytics platforms.