Oracle Database Administrator III

IntePros; Boston (MA); Hybrid; USD 120,000 - 160,000; Full time

Job summary

IntePros is seeking an experienced Oracle Database Administrator focused on performance tuning and automation in a hybrid Boston setting. The role involves large-scale Oracle environments, Exadata migrations, and cloud readiness.

Responsibilities cover tuning, scripting, patching, backups, RAC support, and data replication with GoldenGate. Strong Linux, PL/SQL, and collaboration skills are essential for success.

Qualifications

• 5+ years of Oracle Database Administration experience.
• Strong experience with Oracle 19c databases.
• Advanced SQL and PL/SQL skills.
• Proven SQL performance tuning and optimization experience.
• Strong Linux administration experience.
• Scripting for automation (KSH/Shell).
• Excellent troubleshooting and collaboration skills.

Responsibilities

• Administer Oracle databases running 19c; monitor health and performance.
• Perform SQL tuning, execution plan analysis, and trace analysis.
• Develop automation with KSH/Shell, PL/SQL, and SQL.
• Handle patching, upgrades, cloning, backups, recoveries, and migrations.
• Support RAC environments and migrations to Exadata.
• Configure and support Oracle GoldenGate for data replication.
• Collaborate with dev, infra, and engineering teams.

Skills

Oracle DBA

SQL

PL/SQL

Performance tuning

Linux

Scripting

Troubleshooting

Communication

Tools

Oracle RAC

Oracle Exadata

Oracle GoldenGate

Oracle Enterprise Manager

Job description

Oracle Database Administrator (Performance Tuning)

Location: Boston, MA (Hybrid – 3 days onsite per week)

We're seeking an experienced Oracle Database Administrator with a strong focus on database performance tuning, scripting, and automation to support mission-critical enterprise database environments. This is an opportunity to work with large-scale Oracle platforms while helping drive modernization initiatives, including migration to Oracle Exadata and cloud-based infrastructure.

If you're passionate about optimizing database performance, automating manual processes, and solving complex technical challenges, we'd love to hear from you.

What You'll Do

• Administer and support Oracle database environments running Oracle 19c
• Diagnose and resolve database performance issues through SQL tuning, execution plan analysis, trace file analysis, indexing strategies, and query optimization
• Develop automation solutions using Korn Shell (KSH), Shell scripting, PL/SQL, and SQL to streamline database operations
• Perform database maintenance activities including patching, upgrades, cloning, backup, recovery, and migrations
• Support Oracle RAC environments and participate in ongoing migration efforts to Oracle Exadata
• Configure and support Oracle GoldenGate for data replication
• Monitor database health, availability, and performance while responding to production incidents and operational requests
• Collaborate with application, infrastructure, and engineering teams to improve reliability and operational efficiency
• Support both on-premises and cloud-hosted Oracle database environments

Required Qualifications

• 5+ years of Oracle Database Administration experience
• Strong experience administering Oracle 19c databases
• Advanced SQL and PL/SQL skills
• Proven experience with SQL performance tuning, execution plans, SQL trace analysis, and database optimization
• Strong Linux administration experience
• Hands-on scripting experience using Korn Shell (KSH) or Shell scripting for automation
• Excellent troubleshooting and root cause analysis skills
• Strong communication and collaboration skills

Preferred Qualifications

• Oracle RAC administration
• Oracle Exadata experience
• Oracle GoldenGate
• Oracle Enterprise Manager
• Python scripting
• Experience supporting Oracle databases in cloud environments (OCI, AWS, or Azure)
• Experience with ServiceNow or similar ITSM platforms
• Knowledge of Oracle ZFS and Oracle Zero Data Loss Recovery Appliance (ZDLRA)

Why Join Us?

You'll be joining a highly collaborative database operations team responsible for supporting large-scale enterprise Oracle environments. This role offers the opportunity to work with cutting-edge Oracle technologies, contribute to cloud modernization initiatives, and lead automation and performance optimization efforts that directly impact critical business platforms.

Schedule: Hybrid (3 days onsite weekly)

Support Rotation: Participation in an on-call rotation for production support and occasional after-hours maintenance activities is required.