Techstra Solutions · 21 hours ago
Senior Database Engineer (Oracle & MongoDB)
Pittsburgh, PA
Full-time
Onsite
Senior Level, Lead/Staff
10+ years expTechstra Solutions helps leading organizations unlock the value of Digital and Talent Transformation. They are seeking a Senior Database Engineer to lead performance tuning efforts for Oracle and MongoDB in high-throughput transactional systems and improve data access patterns in collaboration with application development teams.
Cloud ComputingConsultingDevOpsManagement Consulting
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
Qualification
Required
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
Expert-level knowledge of 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
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
Hands-on experience with MongoDB Atlas performance tools or equivalent diagnostics
Company
Techstra Solutions
Techstra Solutions is a consulting firm for digital and talent transformation.
51-200 employees
H1B Sponsorship
Techstra Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (8)
2023 (2)
2021 (2)
2020 (1)
Funding
Current Stage
Growth StageLeadership Team
Larry Honig
Chief Digital Officer
Recent News
Business Journals
2022-04-01
Company data provided by crunchbase