Oracle Database Administrator III

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

Job summary

IntePros is seeking an experienced Oracle Database Administrator with a strong focus on performance tuning to support enterprise environments in Boston. You will optimize SQL, manage 19c databases, and contribute to migrations toward Exadata and cloud infrastructure.

This role emphasizes automation and scripting, with hands-on work in KSH, Shell, PL/SQL, and SQL. You will maintain RAC and data replication setups, monitor health and incidents, and collaborate across teams to improve reliability

Qualifications

• 5+ years of Oracle Database Administration experience.
• Strong experience with Oracle 19c databases and Linux.
• Advanced SQL and PL/SQL with performance tuning.
• Automation using shell scripting and PL/SQL.
• Experience with RAC, Exadata, GoldenGate, and Enterprise Manager.

Responsibilities

• Administer Oracle databases and support environments running Oracle 19c.
• Diagnose and resolve performance issues via SQL tuning and trace analysis.
• Develop automation using KSH, Shell, PL/SQL, and SQL.
• Perform patching, upgrades, cloning, backup, recovery, and migrations.
• Support RAC environments and migration efforts to Exadata.
• Configure and support GoldenGate for data replication.
• Monitor health, availability, and incidents; collaborate cross-functionally.

Skills

SQL performance tuning

Shell scripting

Automation

Troubleshooting

Communication

Tools

Oracle 19c

Oracle RAC

Oracle Exadata

Oracle GoldenGate

Oracle Enterprise Manager

PL/SQL

Cloud platforms (OCI/AWS/Azure)

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.