Senior Database Engineer (Hybrid)

Allocore; Mechanicsburg (Cumberland County); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Competitive salary and performance‑dr基

Comprehensive health plans

Hybrid work options

Unlimited PTO

Job summary

Allocore, a mission-driven technology company in Mechanicsburg, is seeking a Senior Database Engineer to design, optimize, and support enterprise databases across AWS services, ensuring reliability and security for high-volume workloads. You will collaborate with application, cloud, and security teams to drive modernization initiatives and automation.

The role requires hands-on expertise with Aurora PostgreSQL, DocumentDB, Redshift, and other AWS databases, plus strong SQL skills and

Qualifications

• U.S. citizenship required with ability to obtain Public Trust clearance.
• Local to Mechanicsburg HQ; in-office 3 days a week preferred.
• Bachelor’s degree in computer science, information systems, business, accounting, finance, or equivalent experience.
• Extensive experience managing databases including Aurora PostgreSQL, Oracle, DocumentDB, MSSQL, and Redshift.
• Expertise in performance troubleshooting, query optimization, and performance enhancement.
• Strong knowledge of cloud platforms, specifically AWS.
• AWS Solution Architect (Associate/Professional) and/or AWS Certified Data Engineer certifications required.
• Familiarity with Datadog, Sentry, and CloudWatch monitoring tools.
• Proven ability to lead, mentor, and develop high-performing technical teams.
• Strong project management skills with cross-functional collaboration.
• Exceptional problem-solving, decision-making, and communication skills.
• Minimum 5 years of experience in database and data engineering.
• Hands-on experience managing large-scale database environments and data pipelines.
• Software development experience with GitHub or similar SCM and peer review processes.

Responsibilities

• Design, implement, administer, and support database platforms including Aurora PostgreSQL, DocumentDB, Redshift, Databricks, ElastiCache, Oracle, and MSSQL.
• Analyze and tune complex SQL queries, stored procedures, workloads, and access patterns.
• Collaborate with Cloud, DevOps, and Security teams to ensure security, availability, and compliance.
• Review migration plans; assist with migrations across database platforms.
• Monitor performance; optimize for cost and scalability using AWS services.
• Support data pipelines, ETL, and analytics workloads; troubleshoot data quality issues.
• Develop automation for database administration, monitoring, and release validation.
• Lead and mentor teams; contribute to capacity planning and disaster recovery.

Skills

Aurora PostgreSQL

Oracle

DocumentDB

MSSQL

Redshift

Performance troubleshooting

Query optimization

AWS knowledge

GitHub collaboration

Education

Bachelor’s degree in Computer Science or related field

Tools

Datadog

Sentry

CloudWatch

GitHub

Job description

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.

• Review and optimize data pipelines, batch processing jobs, file movement workflows, and transformation logic.

• Collaborate with data engineering and reporting teams to improve data reliability, processing performance, and data availability.

• Assist with troubleshooting data quality, data latency, load failures, and pipeline performance issues.

• Support data warehouse concepts, lakehouse patterns, ETL workflow management, and analytical workload optimization.

• Review database migration plans, scripts, schema changes, data movement strategies, and rollback procedures.

• Support migrations across database platforms, including legacy-to-cloud and cloud-to-cloud database transitions.

• Validate migration readiness, performance impact, security controls, and post-migration stability.

• Partner with application release teams to review database changes, deployment sequencing, and production implementation plans.

• Support AWS DMS, custom scripts, ETL tools, and automation frameworks used for database migration and synchronization.

• Develop and maintain automation for database administration, monitoring, deployment, reporting, and operational support.

• Create scripts, tools, and repeatable processes to reduce manual effort and improve reliability.

• Support automation use cases involving database health checks, maintenance tasks, alerting, performance analysis, and release validation.

• Identify opportunities to standardize database processes, improve documentation, and enhance operational controls.

• Contribute to continuous improvement initiatives across database engineering and platform operations.

• Monitor database and application performance using tools such as Datadog, Sentry, CloudWatch, and other observability platforms.

• Respond to production incidents involving database performance, API issues, connectivity, data processing failures, and service degradation.

• Perform root cause analysis and document findings, remediation steps, and preventive actions.

• Establish and maintain proactive monitoring, alerting, dashboards, and operational runbooks.

• Collaborate with application, infrastructure, and support teams to resolve incidents in a timely and reliable manner.

• Support AI and automation use cases related to database engineering, troubleshooting, query analysis, documentation, and operational efficiency.

• Evaluate opportunities to use AI-assisted tools for performance diagnostics, code review, migration analysis, monitoring insights, and knowledge management.

• Partner with technical teams to safely apply AI capabilities while following security, compliance, and confidentiality requirements.

• Help identify repeatable use cases where AI can improve database operations, productivity, and decision‑making.

Qualifications

• U.S. citizenship is required. Must be eligible to obtain and maintain a Public Trust clearance.

• Local to Mechanicsburg HQ and in the office 3 days a week is strongly preferred

• Bachelor’s degree in computer science, information systems, business, accounting, finance, or equivalent experience

• Extensive experience managing databases, including Aurora PostgreSQL, Oracle, DocumentDB, MSSQL, and Redshift.

• Expertise in performance troubleshooting, query optimization, and performance enhancement.

• Strong knowledge of cloud platforms, specifically AWS, and associated database services.

• AWS Solution Architect (Associate or Professional) and/or AWS Certified Data Engineer–certifications are mandatory.

• Familiarity with monitoring and analytics tools like Datadog and Sentry.

• Proven ability to lead, mentor, and develop high‑performing technical teams.

• Strong project management skills with a track record of cross‑functional collaboration.

• Exceptional problem‑solving, decision‑making, and communication skills.

• Minimum 5 years of experience in database and data engineering.

• Hands‑on experience in managing large‑scale database environments and data pipelines.

• Software development experience in team collaboration via GitHub or similar source code management and peer review processes.

Why Allocore

• Work on high-impact systems that support critical government programs

• Be part of a growing company where you can shape both product and engineering culture

• Collaborative, mission‑driven team with startup energy

• Opportunity to build and scale a platform from the ground up

Benefits

• Competitive salary and performance‑based bonuses

• Comprehensive health plans to choose from. FREEdental &FREE visionplans

• Flexible work hours and hybrid work options

• Unlimited PTO and company holidays

• Collaborative and inclusive work environment with a diverse team

Allocore is an equal‑opportunity employer and is committed to providing a workplace free from harassment and discrimination. We celebrate our employees' unique differences because that drives curiosity, innovation, and the success of our business. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, gender identity or expression, age, marital status, veteran status, disability status, pregnancy, parental status, genetic information, political affiliation, or any other status protected by the laws or regulations in the locations where we operate. Accommodations are available for applicants with disabilities.

Texting Privacy Policy and Information:

• Message type: Informational; you will receive text messages regarding your application and potentially regarding interview scheduling.

• No mobile information will be shared with third parties/affiliates for marketing/promotional purposes.

• Message frequency will vary depending on the application process.

• Msg & data rates may apply.

• OPT out at any time by texting "Stop".