Senior Oracle Database Administrator

🔥 0 minutes ago

🔔 Pennsylvania – Remote

🔔 Pennsylvania – Remote

⏰ Full Time

🟠 Senior

📀 Database Administrator

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

AssetWorks Inc

WebsiteLinkedInAll Job Openings

5001 - 10000 employees

☁️ SaaS

🏢 Enterprise

🚗 Transport

SaaS • Enterprise • Transport

AssetWorks Inc. is a leading provider of integrated software solutions designed to help organizations make data-driven decisions. With a focus on fleet and fuel management, enterprise asset management, facilities management for education, risk management, and government property management, AssetWorks offers a comprehensive suite of solutions that enhance efficiency and reduce costs. The company's products are tailored to streamline operations and improve data transparency for public and private sector entities. With over 40 years of experience and more than 1,000 customers, AssetWorks is committed to delivering high-quality, scalable solutions that improve accountability and operational efficiency across various industries.

📋 Description

• 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. • 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. • 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. • 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. • 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. • 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.

🎯 Requirements

• 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.

🏖️ 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