Senior Database Engineer (Oracle & MongoDB)

Job Title

Senior Database Engineer (Oracle & MongoDB)

Employment Type: Full-time

Locations: Pittsburgh, PA

Key Responsibilities

Lead advanced performance tuning efforts for Oracle and MongoDB in high-throughput transactional (OLTP) systems

Rapidly analyze poorly performing database components to identify root causes across schema design, queries, and application interactions

Rewrite and optimize inefficient SQL, PL/SQL, and MongoDB queries/aggregations supporting real-time transaction processing

Review and influence data models and schema design with a focus on transactional integrity, consistency, and performance

Partner closely with application development teams to improve data access patterns, reduce latency, and eliminate performance anti-patterns

Proactively identify performance risks related to transaction volume, concurrency, and system growth

Provide fast, analytical, and decisive support for production performance issues, including transaction slowdowns and degradation

Document performance tuning decisions, improvements, and database best practices

MUST HAVE QUALIFICATIONS (Non-Negotiable)

10+ years of hands-on database engineering experience with deep expertise in Oracle and significant experience with MongoDB

Expert-level knowledge of:

Oracle SQL performance tuning, execution plans, indexing, partitioning, optimizer behavior, and transaction management

MongoDB performance tuning for transactional workloads, including indexing strategies and query analysis

Proven ability to rapidly diagnose and remediate performance issues in complex, high-volume transactional systems

Demonstrated experience rewriting and refactoring inefficient database logic in both legacy and modern systems

Strong understanding of concurrency, locking, and transactional consistency

Experience supporting mission-critical production systems

Preferred Qualifications

Experience in banking, financial services, payments, or transaction-heavy environments

Familiarity with core banking, payments, account processing, or ledger-style data models

Experience optimizing systems where latency, consistency, and reliability are prioritized over large-scale analytics

Exposure to regulatory or audit-driven environments

Hands-on experience with:

Oracle AWR / ASH / OEM

MongoDB Atlas performance tools or equivalent diagnostics

About Techstra Solutions

Techstra Solutions helps leading organizations unlock the value of Digital and Talent Transformation. We combine business strategy, technology, and talent to guide clients through complex transformation journeys—from strategy through execution.

We deliver our expertise through consulting, innovative staffing solutions, and software development, always focused on measurable outcomes and long-term impact.