Senior Database Engineer (Oracle & MongoDB)

Techstra Solutions • Pittsburgh, PA

5d

About The Position

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 .

Requirements

• 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

Nice To Haves

• 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

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed