AssetWorks LLC Logo

AssetWorks LLC

Senior Oracle Database Administrator

Posted 2 Days Ago
Be an Early Applicant
Remote
Hiring Remotely in Pennsylvania, USA
Senior level
Remote
Hiring Remotely in Pennsylvania, USA
Senior level
Manage and optimize Oracle databases on Exadata and RHEL/OEL Standard Edition platforms. Responsibilities include RAC/Data Guard/ASM management, performance tuning (AWR/ADDM/ASH), patching, RMAN backup/recovery, automation scripting (Bash/PL/SQL), incident response, runbook maintenance, on-call support, and mentoring junior DBAs.
The summary above was generated by AI

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 home patches, GI patches, Exadata Bundle Patches (ExaBP), and cell patches.
  • Coordinate patching activities through the Change Advisory Board (CAB) process, ensuring minimal customer downtime.
  • Test patches in lower environments prior to production rollout and maintain detailed patching runbooks.
  • Track Oracle patch schedules, Critical Patch Updates (CPUs), and security advisories.

Scripting & Automation

  • Develop and maintain Shell (Bash), Python, and PL/SQL scripts to automate routine DBA tasks including health checks, space monitoring, alert log parsing, and report generation.
  • Build and enhance automation for patching workflows, backup verification, and performance data collection.
  • Integrate DBA automation scripts with CI/CD pipelines (Azure DevOps, GitHub Actions) where applicable.
  • Contribute to Infrastructure as Code (IaC) initiatives related to database provisioning and configuration management.

Backup, Recovery & Business Continuity

  • Design, implement, and maintain Oracle RMAN backup strategies for Exadata and SE environments, including full, incremental, and archived log backup policies.
  • Perform and validate periodic recovery tests to confirm backup integrity and meet RTO/RPO objectives.
  • Manage Data Pump (expdp/impdp) exports for logical backups, environment refreshes, and data migration.
  • Maintain backup and recovery runbooks, escalation procedures, and incident documentation.
  • Respond to and lead database recovery efforts during incidents, ensuring minimal data loss and rapid restoration.

Collaboration & Documentation

  • Partner with application teams, infrastructure engineers, and customer success managers to resolve database-related issues.
  • Contribute to internal knowledge base and Confluence documentation for SOPs, runbooks, and architecture references.
  • Participate in on-call rotation to support production databases during off-hours incidents.
  • Mentor junior DBA team members and provide technical guidance on best practices.

REQUIRED QUALIFICATIONS

  • 7+ years of Oracle DBA experience in an enterprise hosting or managed services environment.
  • Hands-on experience administering Oracle Exadata (ExaCC, X8 or later, quarter/half/full rack configurations).
  • Proven experience managing Oracle Standard Edition (SE2) databases on RHEL/OEL Linux platforms.
  • Strong proficiency in Oracle performance tuning using AWR, ADDM, ASH, SQL Tuning Advisor, and execution plan analysis.
  • Experience with Oracle RMAN backup strategies, including cross-platform recovery and Exadata-specific configurations.
  • Demonstrated experience with Oracle patching on both SE and Exadata platforms (PSU, RU, ExaBP, GI patches).
  • Proficiency in scripting languages: Bash/Shell scripting and PL/SQL; Python is an asset.
  • Experience with Oracle RAC, ASM, and Data Guard in high-availability configurations.
  • Solid understanding of Linux OS administration (RHEL/OEL) as it relates to Oracle database hosting.
  • Excellent written and verbal communication skills; ability to produce clear technical documentation and customer-facing performance reports.

PREFERRED QUALIFICATIONS

  • Oracle Certified Professional (OCP) 19c or later.
  • Experience with Oracle 19c (including quarterly patch releases) and familiarity with Oracle 21c/23ai features.
  • Exposure to Exadata-specific tooling: ExaCLI, OEDA, CellCLI, and Exadata Health Monitor.
  • Familiarity with Azure cloud infrastructure and Oracle DB on Azure or OCI (Oracle Cloud Infrastructure).
  • Experience with monitoring and alerting tools such as Oracle Enterprise Manager (OEM), Grafana, or Datadog.

Benefits:

  • Generous Paid Time Off
  • 11 Paid Holidays
  • Medical, Dental, Vision, Life insurance benefits with various choices and generous employer contribution
  • 401k with employer match which immediately vests
  • Annual Company Bonus
  • Career growth and mentoring opportunities as a smaller business unit within the Volaris Group
  • Tuition Reimbursement Program
  • Employee rewards and recognition programs
  • Optional Employee Stock Purchase Program with company match
  • Pet insurance
  • Employee Discount Platform discounted entertainment tickets to movies, sporting events, hotels, live performances, etc.
  • Referral bonuses
  • Employee engagement events
  • Flexible remote work arrangements

Worker Type:

Regular

Number of Openings Available:

1

Similar Jobs

17 Hours Ago
Remote
United States
Senior level
Senior level
Software
Lead administration, maintenance, performance tuning, and security of enterprise Oracle databases across on-premises and cloud. Implement HA/DR (Data Guard, RMAN, GoldenGate), optimize SQL/PLSQL, perform patching, upgrades, migrations, capacity planning, and monitor dev/test/prod environments to ensure availability and integrity for mission-critical federal systems.
Top Skills: CloudExport/Import UtilitiesGoldengateJob Scheduling And MonitoringLinuxMultitenant ArchitectureMySQLOracleOracle 19COracle ClientOracle Data GuardPl/SqlRmanSQLUnixWindows
45 Minutes Ago
Remote or Hybrid
USA
167K-220K Annually
Expert/Leader
167K-220K Annually
Expert/Leader
Edtech • Information Technology • Software
Lead company-wide data governance and standards, enforce data contracts and schema/version control, manage PII/RBAC and master data, establish data-quality metrics and monitoring, grow and run the governance team, remain hands-on with data profiling and SQL, and use AI to accelerate governance work and modeling.
Top Skills: Ai ToolsDbtSalesforceSnowflakeSQLWorkdayZuora
45 Minutes Ago
Remote or Hybrid
USA
167K-220K Annually
Expert/Leader
167K-220K Annually
Expert/Leader
Edtech • Information Technology • Software
Lead architecture, build, and operate customer-facing analytics platform: design ELT and metric governance, implement low-latency serving (OLAP), ensure reliability/performance, mentor engineers, partner with product, and use AI coding tools to accelerate development.
Top Skills: Ai Coding ToolsApache AirflowCdcCi/CdClickhouseDbtEltGitKafkaOlapRedisSnowflakeSQL

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account