AssetWorks

Senior Oracle Database Administrator

PA, USPosted 10 days ago

Job Description

Job Summary

We are seeking an experienced Senior Oracle Database Administrator to join our Hosting Operations team. In this role, you will be responsible for managing, monitoring, tuning, and maintaining Oracle database environments across Exadata infrastructure and Linux-based Standard Edition (SE) platforms. You will serve as a subject matter expert for database performance, patching, backup/recovery, and automation scripting, playing a critical role in ensuring the reliability and performance of hosted customer environments across a diverse enterprise client base.Job Description:

KEY RESPONSIBILITIES

Database Administration & Platform Management

  • Administer and manage Oracle databases on Exadata infrastructure (ExaCC / on-premise) and Linux-hosted Standard Edition environments.
  • Monitor database health, availability, and capacity across multiple hosted customer environments.
  • Manage Oracle RAC (Real Application Clusters) and Data Guard configurations on Exadata.
  • Coordinate planned maintenance, failover testing, and disaster recovery activities.
  • Manage ASM (Automatic Storage Management) diskgroups and storage configurations on Exadata.

Performance Tuning & Optimization

  • Conduct proactive and reactive performance analysis using AWR, ADDM, ASH, and Statspack reports.
  • Identify and resolve database bottlenecks related to SQL execution plans, memory allocation (SGA/PGA), I/O, and locking contention.
  • Tune SQL statements, indexes, and schema objects to improve application response times.
  • Provide written performance improvement recommendations and root cause analysis to stakeholders and customers.
  • Monitor and tune Exadata-specific features: Smart Scan offloading, Flash Cache, Hybrid Columnar Compression (HCC), and IORM.

Oracle Patching & Lifecycle Management

  • Plan and execute Oracle quarterly PSU/RU patching for Standard Edition databases on Linux.
  • Manage full-stack patching on Exadata platform, including DB hom...

Apply for this role

Keep looking

Similar Remote IT And Developer Jobs