Why this role stands out
This hybrid role offers a fantastic opportunity to shape the relational data platform for a leading technology organization, directly impacting mission-critical services and driving innovation. You'll thrive here if you're a skilled AWS/Postgres expert eager to optimize performance, ensure data integrity, and collaborate with dynamic engineering teams. Apply now to elevate your database engineering career in a supportive and forward-thinking environment.
Quick overview
Job description
Company Overview
At The Intersect Group, we partner with industry-leading technology organizations A technology-driven organization operating large-scale, highly available SaaS platforms in a regulated environment. Our client develops large-scale, cloud-based software platforms supporting mission-critical operations, transaction processing, and customer-facing services for enterprise and public-sector organizations. Driven by a commitment to operational excellence, innovation, and customer success, they foster a collaborative engineering environment focused on data integrity, operational reliability, and continuous innovation.
Role Summary
We are seeking an experienced Senior Database Engineer to own the design, performance, and operational integrity of the relational data platform powering our client’s core transactional products. In this hands-on individual contributor role, you will lead schema architecture, migration safety, query optimization, and data durability across a high-volume, multi-tenant AWS environment.
You will collaborate closely with software, DevOps, and platform engineering teams to support hundreds of microservices processing shared operational data. Your impact will be defined by maximizing query performance, ensuring zero-downtime schema migrations, maintaining strict recovery objectives, and modernizing legacy data access patterns to enable seamless scale.
Key Responsibilities
Key point: Experience in Postgres Only or mostly Postgres environments and AWS experience no substitutions(GCP/Azure/OCI not considered)
- Architect and manage relational schemas, entity modeling, index strategies, and version-controlled reference data across all environments.
- Design and execute zero-downtime, backward-compatible database migrations (expand/contract, dual-write) using automated CI/CD pipelines.
- Profile, tune, and optimize high-volume OLTP workloads on AWS Aurora PostgreSQL and RDS through execution plan analysis, partitioning, and connection management.
- Diagnose complex latency, deadlock, and transaction boundary issues while setting strict performance budgets and query regression standards.
- Modernize data access architectures by transitioning legacy data layers toward typed, reusable domain microservices.
- Implement robust backup, point-in-time recovery, and failover strategies to guarantee contractual RPO and RTO standards through regular restore exercises.
- Enforce database security, managed identity, least-privilege access, encryption, and data masking for sensitive regulated information.
- Establish comprehensive database observability using APM tools and define critical Service Level Indicators (SLIs) for the data tier.
- 6+ years of production experience in database engineering or platform administration, with 3+ years specifically focused on PostgreSQL at scale.
- Deep technical expertise in PostgreSQL internals, query plan analysis, autovacuum management, partitioning, and concurrency/locking mechanics.
- Hands-on production experience managing cloud database platforms (AWS Aurora PostgreSQL or RDS) and infrastructure as code tools (Terraform or CloudFormation).
- Proven track record using schema migration tools (Flyway, Liquibase, Alembic, or Sqitch) integrated into automated CI/CD pipelines.
- Proficiency in advanced SQL and at least one scripting or automation language (Python, TypeScript, Go, or Bash).
- Strong working knowledge of data protection practices, encryption, and compliance frameworks (PCI-DSS, SOC 2, or SOX).
- Outstanding written and verbal communication skills, with a proven ability to mentor peers and articulate complex data-tier trade-offs to cross-functional stakeholders.
If you are ready to take ownership of a high-impact, mission-critical data platform, we want to hear from you! Please submit your updated resume and preferred contact details to apply promptly.
Similar jobs
- AF
Assistant Information System Security Manager (SME) with Security ClearanceNew
A2 Federal Inc. · Augusta, GA · Hybrid 🇺🇸
TechnologySalary not listed10 hours ago - AF
GIS/Tools Administrator - Sr. Level with Security ClearanceNew
A2 Federal Inc. · Augusta, GA · Hybrid 🇺🇸
Data AnalysisTechnologySalary not listed10 hours ago - DO

IT Specialist (Information Security and Systems Analysis (INFOSE with Security ClearanceNew
Department of the Army · Alexandria, VA · Remote 🇺🇸
Technology$121.8k - $158.3k/yr10 hours ago - AF
IT Sys Solutions Architect - Sr. Level with Security ClearanceNew
A2 Federal Inc. · Aberdeen, MD · Hybrid 🇺🇸
LinuxTechnologySalary not listed10 hours ago - SN

Test Engineer III with Security ClearanceNew
Sierra Nevada Corporation · Dayton, OH · Hybrid 🇺🇸
System DesignTechnologySalary not listed10 hours ago - SN

Sr Systems Security Engineer with Security ClearanceNew
Sierra Nevada Corporation · Lone Tree, CO · Hybrid 🇺🇸
Active DirectoryPKILinux+1TechnologySalary not listed10 hours ago - TA

Component Test Engineer (II-Senior) with Security ClearanceNew
True Anomaly. Inc. · Long Beach, CA · Hybrid 🇺🇸
PythonMATLABEmbedded SystemsTechnology$100k - $120k/yr10 hours ago - SN

Systems Engineer II with Security ClearanceNew
Sierra Nevada Corporation · Lone Tree, CO · Hybrid 🇺🇸
MATLABAgileTechnology$94.3k - $129.7k/yr10 hours ago - AF
Developer, Visualization and Data Analysis - Sr. Level with Security ClearanceNew
A2 Federal Inc. · Augusta, GA · Hybrid 🇺🇸
DockerJavaPython+2TechnologySalary not listed10 hours ago - GE

Senior Full Stack Developer (GenAI) - RemoteNew
Genesis10 · Cleveland, OH · Remote 🇺🇸
FastAPIFlaskNext.js+23Technology$52 - $62/hr10 hours ago - IN
Java/Python Cucumber Automation Test Engineer - Intermediate Wilmington, DENew
Innova · Wilmington, DE · Hybrid 🇺🇸
AgileTechnologySalary not listed10 hours ago - BB

IT Training Program Analyst (ELTP) ? MainframeNew
BlueCross BlueShield Of South Carolina · Columbia, SC · On-site 🇺🇸
Microsoft OfficeCOBOLTechnologySalary not listed10 hours ago
