Senior Database Engineer (Oracle & MongoDB)
Employment Type: Full-time
Locations: Pittsburgh, PA
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
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
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
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.
Top Skills
What We Do
Techstra Solutions is a certified woman-owned consulting firm that provides strategy, technology and implementation support to large organizations undergoing digital and talent transformation. The rapid pace of technology innovation required to remain competitive, juxtaposed with the slow rate of change in many organizations, causes most to struggle.
To be successful companies must drive new ways of working including the use of technology/analytics and new skillsets (hard/soft) deep into their culture so that they are able to rapidly and continuously react to change. They must also apply new approaches that empower their employees, ensuring its sustainability.
At Techstra Solutions we focus on four key areas, otherwise known as the 4 A’s: Automation (Robotic Process Automation (RPA)/Intelligent Automation), Analytics (Reporting/Analytics/AI/ML), Application Modernization (Cloud, Mobility, etc), and Agile-based solutions (DevOps).
