AssetWorks Inc logo
AssetWorks Inc

We provide innovative and practical solutions to help our customers, and the people they serve, thrive.

Senior Oracle Database Administrator

Database AdministratorDatabase AdministratorFull TimeRemoteSeniorTeam 5,001-10,000H1B SponsorCompany SiteLinkedIn

Location

Pennsylvania

Posted

10 days ago

Salary

0

Seniority

Senior

Job Description

Senior Oracle Database Administrator

AssetWorks Inc

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

Job 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

Related Categories

Related Job Pages

More Database Administrator Jobs

Role Description At Fearless, we are seeking a Senior Database Administrator as part of our Senior Consultant, Engineering and Technical Services career path to provide technical leadership for enterprise database systems supporting federal law enforcement and investigative operations. This role serves as the database architect for production, development, testing, and disaster recovery environments while supporting critical data migration activities. You will manage the administration, security, optimization, and lifecycle of Microsoft SQL Server databases that enable mission-critical investigative systems serving the federal government. This role is fully remote. This Senior Consultant collaborates with cross-functional teams to align the technical vision, implementation, and quality of software systems across development, reliability, testing, and operations. This role will possess the skills to bridge business objectives with technical execution in software development, infrastructure, security, and testing at an advanced application level of proficiency. The Sr. Consultant role will work on projects that allow them to ensure scalable, secure, and reliable solutions while mentoring engineers, fostering collaboration, and aligning stakeholders with product and project goals. Responsibilities - Administer enterprise Microsoft SQL Server environments, ensuring database availability, integrity, and performance across production and non-production systems. - Design database structures and schemas that support mission-critical applications and investigative workflows. - Develop and maintain backup, recovery, and disaster recovery procedures to ensure data resilience and business continuity. - Optimize database performance through indexing strategies, query tuning, and resource monitoring. - Lead database security administration, implementing access controls, auditing mechanisms, and compliance with federal data protection standards. - Support ETL processes and coordinate data migration activities, including legacy data integration into modernized case management platforms. - Develop stored procedures, views, and database utilities that streamline data access and reporting workflows. - Coordinate database changes and deployments during production releases, ensuring minimal disruption to investigative operations. Impact - Fosters collaboration with cross-functional teams by taking the initiative and driving conversations. - Coaches, mentors, and develops peers that elevate team capability and technical expertise using clear and persuasive communication of engineering solutions to both technical and non-technical audiences. - Earns the trust of customers and teammates by delivering world-class services. - Drives accountability and delivery by ensuring project objectives are met on time and aligned with client priorities and Fearless standards of excellence. - Anticipates risks and implements proactive solutions to keep initiatives on track. - Takes ownership of risk management by monitoring deliverables across the team, identifying issues early, and coaching teammates on mitigation strategies while keeping leadership informed. - Shapes client engagement and intelligence-gathering efforts by actively cultivating relationships with stakeholders, synthesizing insights across the client organization and partner ecosystem, and providing Fearless leaders with actionable recommendations that inform strategy and strengthen delivery outcomes. Qualifications - Minimum of 7 years of experience administering Microsoft SQL Server in enterprise environments. - Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field, or equivalent work experience. - Ability to obtain and maintain Public Trust clearance. - Proven experience with SQL Server Management Studio, T-SQL, and database architecture design. - Demonstrated expertise in performance tuning, backup and recovery, and database security practices. - Experience supporting ETL processes, data migration projects, and disaster recovery planning. - Proficiency with Business Intelligence reporting tools, including Crystal Reports and Business Objects. Preferred Qualifications - Current or recent Public Trust BI clearance within the last 3 years. - Experience supporting IRS Criminal Investigations or similar federal law enforcement systems. - Familiarity with IRS Internal Revenue Manuals (IRMs) and OneSDLC processes. Skills and Competencies - Analytical Thinking: The ability to observe and interpret information, break down complex problems into parts, identify patterns/relationships and draw logical conclusions to develop effective solutions. - Synthetic Thinking: The ability to combine different ideas, information, or concepts to create a new, complex understanding or solution by integrating disparate elements into a new, meaningful whole. - Adaptability: Comfort with change, flexibility in the face of shifting demands and resilience to setbacks. - Ownership & Accountability: Committed to taking responsibility for outcomes, ensuring that all commitments are met with a focus on enhancing service delivery. - Consultative Advising: Identifies and articulates client challenges, scopes projects and aligns recommendations to business goals and client expectations. - Communicating with Influence: Capable of crafting and delivering clear, persuasive messages that integrate data insights and structured narratives, tailored to the strategic needs of diverse audiences to drive effective decision-making. - Managing Priorities & Client Alignment: Skillfully negotiates and manages conflicting priorities to strategically align decisions, enhancing service delivery and client satisfaction. Physical Requirements - Ability to sit for extended periods while working on a computer or during meetings. - Must be able to travel occasionally to client sites or company meetings, which may involve driving or flying. - Ability to communicate effectively via phone, email, and in-person, requiring clear speech, listening, and written communication skills. - Ability to move within an office environment, including reaching for files, using office equipment, and occasional light lifting (up to 10 pounds). Benefits - Flexible, life-friendly schedules. - 100% coverage for our medical HSA plan + HSA contributions. - Dental & vision covered 100% for you and your dependents. - Competitive premiums for HMO/PPO and dependent coverage. - 401(k) with 4% match & immediate vesting. - Paid Parental Leave and 12 weeks paid FMLA. - Generous PTO, 11 Federal Holidays, a Birthday Holiday, and Sick Leave. - Up to 15 days for Jury Duty and Bereavement Leave. - Education, wellness, and tech allowances. - Referral bonus: $6K–$12K for each successful referral. - Pet insurance & discount plans. - Employee Assistance Program (EAP). - Legal support, life insurance, disability coverage. - Performance-Based Bonuses.

United States
$120.6K - $196.0K / year
Full TimeRemoteTeam 10,001+H1B Sponsor

Role Description Buscamos un administrador de bases de datos Oracle con perfil júnior para integrarse al equipo de Resolution Groups – Base de datos. El profesional dará soporte operativo a los perfiles más experimentados en la administración de instancias Oracle Database Cloud Service en OCI, participando en actividades de monitoreo, ejecución de tareas operativas y resolución de incidentes de menor complejidad. Es una excelente oportunidad para desarrollar experiencia en Oracle Cloud Infrastructure dentro de un proyecto de gran escala para el sector financiero colombiano. Responsabilidades principales - Ejecutar tareas operativas diarias: verificaciones de salud, limpieza de archivos de registro y traza, y verificación de respaldos. - Monitorear instancias Oracle Database en OCI mediante herramientas de observabilidad (Nagios, OEM, GenWizard). - Apoyar la resolución de incidentes P3/P4 bajo la supervisión de perfiles sénior. - Aplicar cambios de configuración aprobados en instancias de base de datos. - Gestionar de manera básica los espacios de tabla y el espacio en disco. - Reiniciar instancias según los procedimientos documentados. - Registrar y documentar las actividades operativas en la plataforma ServiceNow Aurora. - Participar en las actividades de transferencia de conocimiento (KT) durante la fase de movilización. - Apoyar la ejecución de parches de seguridad en ambientes no productivos. - Generar reportes del estado de la plataforma para el equipo de gobernanza. Qualifications - 1 a 2 años de experiencia como administrador de Oracle o en roles de soporte de bases de datos. - Conocimiento de Oracle Database 12c o superior (instancia, tablespace, redo logs). - Conocimiento básico de RMAN para verificación de respaldos. - Manejo de SQL y PL/SQL para consultas de diagnóstico. - Familiaridad introductoria con Oracle Cloud Infrastructure (OCI), o interés en obtener certificación. - Experiencia con herramientas de gestión de tickets (ServiceNow, Jira o similares). - Inglés técnico básico para lectura de documentación. Requirements - Actitud proactiva de aprendizaje y desarrollo técnico continuo. - Atención al detalle y disciplina en la ejecución de procedimientos operativos. - Buena comunicación y disposición para el trabajo en equipo con perfiles sénior. - Disponibilidad para participar en esquemas de guardia on-call rotativa junto a perfiles sénior. Company Description Accenture es una compañía global líder en servicios profesionales, con una amplia oferta en estrategia y consultoría, tecnología, operaciones y capacidades digitales. Acompañamos a nuestros clientes en su evolución para alcanzar su máximo rendimiento mediante soluciones innovadoras y de alto impacto.

Colombia
Microchip Technology Inc. logo

Principal Database Administrator

Microchip Technology Inc.

Microchip Technology Inc. is a leading semiconductor supplier of smart, connected and secure embedded control solutions.

Full TimeRemoteTeam 10,001+Since 1989H1B No Sponsor

Role Description The Principal Database Administrator – Oracle is responsible for the architecture, reliability, performance, security, and lifecycle management of enterprise Oracle database platforms. This role serves as the senior technical authority for Oracle database operations, high availability, disaster recovery, patching, upgrades, automation, standards, and production support. The Principal DBA will lead complex database initiatives, guide other DBAs, establish best practices, and work closely with infrastructure, application, security, and data platform teams to ensure Oracle environments are stable, scalable, secure, and aligned with business requirements. Responsibilities - Administer and support Oracle databases across production, DR, test, and development environments. - Install, configure, patch, upgrade, clone, refresh, and maintain Oracle database environments. - Manage Oracle 11g, 12c, 19c, and newer versions, including single-instance and CDB/PDB environments. - Support Oracle Data Guard, including standby databases, redo transport, apply lag, switchover, failover, and recovery. - Develop and maintain backup and recovery strategies using RMAN and related enterprise backup tools. - Monitor and tune database performance using AWR, ASH, SQL Monitor, execution plans, wait events, and Oracle dynamic performance views. - Troubleshoot production issues related to availability, performance, storage, backup failures, locking, replication, and connectivity. - Manage database security, users, roles, privileges, auditing, encryption, and compliance-related controls. - Create and maintain automation scripts for routine DBA tasks, health checks, monitoring, refreshes, and maintenance. - Define and enforce database standards, operational procedures, documentation, and runbooks. - Lead database projects including migrations, upgrades, DR testing, monitoring improvements, and platform modernization. - Provide technical leadership, mentoring, and escalation support to other DBAs and technical teams. - Participate in change management, incident response, root cause analysis, and on-call support. Qualifications - 10+ years of hands-on Oracle Database Administration experience in enterprise production environments. - Strong experience with Oracle 11g, 12c, and 19c. - Strong knowledge of Oracle architecture, backup/recovery, performance tuning, security, and operational best practices. - Hands-on experience with RMAN backup and recovery. - Hands-on experience with Oracle Data Guard administration and troubleshooting. - Strong SQL and PL/SQL troubleshooting skills. - Experience with Oracle patching, upgrades, OPatch, datapatch, and release/update planning. - Experience tuning Oracle databases using AWR, ASH, ADDM, SQL Monitor, execution plans, and wait events. - Experience supporting large, business-critical databases with formal change control and incident management. - Strong Linux/Unix skills, including shell scripting and system-level troubleshooting. - Ability to write clear technical documentation, runbooks, standards, and root cause analysis reports. - Strong communication skills and ability to work with application, infrastructure, security, and business teams. Preferred Qualifications - Oracle certification or equivalent demonstrated expertise. - Experience with Oracle ASM and Grid Infrastructure. - Experience with Oracle RAC, SEHA, or other high availability architectures. - Experience with Oracle Multitenant, including CDB/PDB administration. - Experience with Oracle Enterprise Edition features such as Diagnostics Pack, Tuning Pack, Partitioning, Advanced Security, or Advanced Compression. - Experience with VMware, enterprise storage, or clustered infrastructure. - Experience with database replication or CDC tools such as Qlik Replicate, GoldenGate, Debezium, or similar platforms. - Experience with monitoring tools such as OEM, Prometheus, Grafana, Splunk, Datadog, or similar tools. - Experience with automation and CI/CD tools such as Ansible, Git, Azure DevOps, Jenkins, or Terraform. - Experience with PostgreSQL, SQL Server, MySQL, or other database platforms is a plus. - Familiarity with Oracle licensing considerations and database platform modernization. Travel Time - 0% - 25% To all recruitment agencies Microchip Technology Inc. does not accept unsolicited agency resumes. Please do not forward resumes to our recruiting team or other Microchip employees. Microchip is not responsible for any fees related to unsolicited resumes.

Malaysia
Sabel Systems Technology Solutions, LLC logo

PLM Database Administrator

Sabel Systems Technology Solutions, LLC

Providing digital solutions for software, requirements, systems design, integration, and testing - digital engineering.

Full TimeRemoteTeam 201-500Since 2001H1B No Sponsor

• Lead the implementation, configuration, and ongoing administration of PTC Windchill PDMLink and associated modules • Help bridge the gap between database health and systems infrastructure, specifically around the PTC Windchill application suite • Install, configure, maintain, and upgrade Windchill environments to ensure optimal performance and reliability • Monitor server health and performance utilizing SQL Server Management Studio (SSMS) and SQL Server Agent to ensure high availability for Windchill services. • Build, test, and deploy PLM solutions using industry best practices • Support data migrations, legacy system transitions, and system transformation initiatives • Perform DISA STIG (Security Technical Implementation Guides) activities for SQL Server instances • Maintain user permissions, encryption, and conduct regular audits to maintain compliance • Design and implement automated SQL Server backup strategies and lead regular testing of disaster recovery protocols • Optimize server-level settings, manage indexing, and analyze execution plans to resolve database bottlenecks. • Support systems administration for PTC Windchill, ensuring the application layer and the SQL database are perfectly synchronized. • Support working groups, technical meetings, and customer engagement activities • Document system configurations, processes, and procedures to support long-term sustainment • Train and mentor users to improve adoption and effective utilization of Windchill • Collaborate with cross-functional teams to support system integration and future capability enhancements

Ohio
Job Closed