Database Engineer (Senior)

Techstra Solutions • Pittsburgh, PA

19h • Onsite

About The Position

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.

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
• 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.

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