Database Engineer (RDS PostgreSQL & OpenSearch)
Database Engineer (RDS PostgreSQL & OpenSearch) Belong. Connect. Grow. with KBR! Around here, we define the future.
We share one goal: to improve the world responsibly as a company of innovators, thinkers, creators, explorers, volunteers, and dreamers. Note: This position is contingent upon contract award, customer approval, and funding availability. Clearance: Ability to obtain and maintain a government background check
Citizenship Requirement: Applicants must be U.S. Citizens or Permanent Residents Preferred location is Sioux Falls, SD Will consider Remote About the Role We are seeking a highly skilled Database Engineer with deep expertise in Amazon RDS for PostgreSQL and Amazon OpenSearch Service . The ideal candidate will be capable of architecting scalable data solutions, optimizing performance, and troubleshooting complex production issues across relational and search engine workloads. This role supports mission critical systems and requires a strong background in AWS cloud services, database internals, and distributed data architectures. Key Responsibilities Architecture & Design
- Design and implement scalable, highly available database architectures using Amazon RDS (Postgres) and OpenSearch .
- Create schema designs, index strategies, and data models optimized for query performance and storage efficiency.
- Evaluate and recommend tools, patterns, and best practices for data pipelines, ingestion, search indexing, and replication.
- Develop secure, resilient architectures aligned with cloud-native and DevSecOps principles.
- Conduct in-depth performance tuning including:
- SQL query optimization
- Indexing strategy improvements
- Vacuum/analyze planning
- Connection pooling and load balancing adjustments
- Optimize OpenSearch clusters for indexing throughput, shard/replica strategy, query performance, and log analytics workloads.
- Monitor performance using CloudWatch, Performance Insights, OpenSearch Dashboards, and custom telemetry.
- Lead troubleshooting of database and cluster issues including failovers, replication lag, slow queries, cluster imbalance, and node-level failures.
- Perform root cause analysis and implement long term corrective actions.
- Maintain backup, restore, and disaster recovery strategies for both Postgres and OpenSearch.
- Support automation of administrative tasks using InfrastructureasCode (Terraform, CloudFormation) and scripting tools.
- Implement and maintain IAM policies, encryption at rest/in transit, security groups, and audit logging.
- Ensure database and cluster configurations meet organizational security standards and regulatory requirements.
- Define Recovery options (RPO/RTO) and setup appropriate backup strategy.
- Create plans for backup service management including schedules and disaster recovery options.
- Implement procedures to restore operations for point-in-time-recovery (PITR) and disaster recovery.
- Work closely with application teams, cloud architects, DevOps engineers, and data stakeholders to support existing systems and plan new capabilities.
- Provide guidance on database best practices and mentor junior engineers.
- 5+ years of hands-on experience with PostgreSQL , including advanced SQL, performance tuning, query planning, and replication.
- 3+ years of experience with Amazon RDS (Postgres) in production environments.
- 2+ years of experience managing and tuning Amazon OpenSearch clusters.
- Strong understanding of AWS services including EC2, IAM, VPC networking, S3, CloudWatch, Lambda, and KMS.
- Experience with Terraform, CloudFormation , or other IaC tools.
- Proficiency with scripting languages (Python, Bash) for automation and diagnostics.
- Solid understanding of distributed systems, search indexing, and data lifecycle management.
- Experience supporting mission critical or high throughput environments.
- Knowledge of log analytics pipelines (e.g., FluentBit, Logstash, Firehose).
- Familiarity with containerized environments (Docker, Kubernetes) and CI/CD pipelines.
- Certifications: AWS Solutions Architect, AWS Database Specialty, or similar.
Recommended Jobs
Mover - Junk Remover
Excellent earning potential including hourly pay plus tips and performance based bonuses. To be one of the H.U.N.K.S., you must be: Honest, Uniformed, Nice, Knowledgeable, and Service-oriented. Come…
Quality Clerk
Quality Clerk Location Arlington, TX | Onsite Compensation & Schedule • $16.00 per hour • 40 hours per week, 8-hour shifts • Monday–Friday; typical schedule 7:00am–3:30pm (30-minute lunc…
Heavy Equipment Service Technician
ASCO Equipment has career opportunities for Heavy Equipment Service Technicians in Wichita Falls, Texas. Shop and Field positions available. Experience with Diesel Engines, Hydraulics or Advanced E…
Entry Level Service Technician - Level I & II
At the Hiley Automotive Group, we know to be best-in-class in the industry and to succeed that we need the best people. That's why we are committed to hiring top talent who can help us to curate excep…
After School Instructor
Summary Under the direct supervision of the Apogee STEM Discovery Learning Academy Director, the After School Teacher/Caregiver shall be responsible for planning, scheduling and implementing a…
Driver Non CDL - 1st shift
Logistics at full potential. At GXO, we’re constantly looking for talented individuals at all levels who can deliver the caliber of service our company requires. You know that a positive work …
High Ticket Sales Consultant (Remote)
About Us We are a global personal development company offering premium digital programs and world-class live events. Our work is centered on mindset, empowerment, leadership, and lifestyle trans…
Equipment Operator w/CDL
Are you a skilled equipment operator looking for an opportunity to work with a company that values safety, precision, and teamwork? Talon/LPE is searching for dedicated Equipment Operators to hel…
MLOps Engineer
About Grassroots Carbon Grassroots Carbon is the leading grasslands restoration and soil carbon storage company that partners with landowners to implement and scale regenerative land management pr…
Server
At Studio Movie Grill , we’re all about movies and dedicated to making a real impact in the communities we serve. We’ve led the way in in-theater dining, transforming the movie-going experience. As …