Oracle DBA

• Resolve SQL plan instability using SPM baselines and SQL Profiles
• Design indexing strategies based on real application usage patterns
• Tune connection pools, RAC-specific configuration, and parallel execution
• Diagnose and remediate locking, contention, and wait event issues

• Manage Oracle accounts, roles, profiles, and least-privilege service accounts
• Enforce session controls, password policies, and audit configuration
• Partner with developers on stored procedure design and code review
• Build out DBA documentation, runbooks, and operational standards

• Work with application, dev, and infrastructure teams
• Coordinate with the external infrastructure vendor on migration work
• Weigh in on architecture decisions and project planning

• 5+ years of hands-on Oracle DBA experience in production environments
• Proven, hands-on production experience with Oracle RAC (specifically a 2-node cluster) and Data Guard - this is a core requirement, not a nice-to-have
• Strong Oracle 19c (or comparable recent version) administration expertise
• Strong SQL and PL/SQL skills - able to read and write production code, not just execute scripts
• Experience with Oracle Enterprise Manager, AWR, ASH, ADDM, and execution plan analysis
• Demonstrated ability to work independently and self-manage - this role has minimal day-to-day oversight, so a self-starter mindset is essential
• Comfortable operating with broad technical ownership on a small, lean team

• Oracle patching and version upgrade planning/execution
• Index lifecycle management, partitioning, and large table reorganization
• SQL Plan Management (SPM) and SQL Profiles
• Connection pool administration (DRCP or shared server)
• Lower environment refresh design/automation
• Oracle APEX and/or ORDS administration
• Experience with infrastructure or storage migrations
• Strong documentation and runbook-writing habits

• OCP certification or equivalent
• Background in financial services or transaction-processing environments

You're a technician at heart - happiest diagnosing, fixing, or building rather than sitting in meetings talking about it. You're methodical, you document as you go, and you don't call something fixed until you understand why it broke. You're comfortable being the go-to expert with minimal hand-holding, and you've walked into environments with a backlog before and seen it as an opportunity, not a burden.

Interested candidates can apply here or email doug.halve@techpartnersllc.com