Database Engineer (Senior)

Role Overview

The Senior Database Engineer with deep expertise in Oracle and MongoDB is meant to lead performance tuning, rapid analysis, and remediation of inefficient database components. This role is hands-on and problem-driven, requiring the ability to quickly diagnose issues, rewrite or refactor problematic queries and data access patterns, and improve performance in transaction-heavy systems. This position is focused on OLTP and transactional workloads, not large-scale analytical or data lake environments.

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

Required Qualifications/Skills

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

Solving complex database issues

Performance tuning both Oracle and Mongo

Ability to quickly diagnose problems.

Partnering and mentoring other database administrators

Strong data movement background.

Preferred Qualifications

Experience in banking, financial services, or payment processing environments.

Familiar with transaction-heavy systems such as core banking, payments, account processing, or ledger-style data models.

Experience optimizing systems where latency, consistency, and reliability are more critical than large-scale data analytics.

Exposure to regulatory or audit-driven environments.

Experience with Oracle AWR/ASH, OEM, MongoDB Atlas performance tools, or similar diagnostics.

Locations: Pittsburgh, PA

About Techstra Solutions

Techstra Solutions is a certified woman-owned (WBENC) management consulting firm specializing in strategy, technology, and implementation services for large organizations undergoing digital and talent transformation. Our experienced team partners with clients to co-create innovative solutions in applications, data, AI, and automation that accelerate measurable, sustainable change. From advisory consulting through technical execution, we are dedicated to driving world-class business solutions that fit your strategic requirements and deliver results. For more information: