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.- 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
- 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.
Locations: Pittsburgh, PA
Work Model: On-Site 5 Days Per Week
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.
Equal Employment Opportunity Statement
Techstra Solutions is an equal opportunity employer. The Company makes its decisions on merit, and its policy of equal opportunity prohibits discrimination in all phases of the employment process, including, but not limited to, recruitment, hiring, promotion, selection, transfer, demotion, layoff, termination, compensation, benefits, and other terms and conditions of employment. The policy of equal opportunity applies without regard to race, color, creed, religion, gender,, sexual orientation, gender identification, pregnancy, marital status, national origin, ancestry, age, disability that can reasonably be accommodated without undue hardship, military status, veteran status, genetic predisposition or carrier status, alienage or citizenship, domestic partnership status, arrest or conviction record, status as a victim of domestic violence, or any other protected categories under federal, state, or local law. The Company also prohibits discrimination or harassment based upon the perception that a person has, or is associated with a person who has, any of these characteristics.