Confirmed on the employer's own hiring board on Nov 16, 2026. First seen by Alion on Nov 16, 2026.
Job Summary
The L2 Oracle Database Administrator is responsible for the administration, monitoring, maintenance, and support of Oracle database environments. The role involves handling routine database operations, troubleshooting database issues, ensuring database performance, backup and recovery management, and supporting business-critical applications running on Oracle databases.
Key Responsibilities
Monitor and maintain Oracle database environments to ensure high availability and performance. Perform Level 2 support activities including incident, problem, and change management. Troubleshoot database-related issues and work toward timely resolution within SLA. Execute database backup, recovery, and restore operations using RMAN. Monitor database health, storage utilization, tablespaces, and performance metrics. Perform database patching, upgrades, and security updates. Manage Oracle users, roles, profiles, and privileges. Support database refresh, cloning, migration, and replication activities. Analyze and optimize SQL queries and database performance bottlenecks. Perform routine maintenance tasks such as gathering statistics, index maintenance, and log management. Support High Availability (HA) and Disaster Recovery (DR) solutions. Coordinate with application teams, infrastructure teams, and vendors for issue resolution. Prepare and maintain technical documentation, SOPs, and knowledge articles. Participate in on-call support and rotational shifts.
Skill Requirements
Oracle Database Administration Oracle Database 12c, 19c, 21c Oracle Enterprise Manager (OEM) Oracle RAC (Real Application Clusters) Oracle ASM (Automatic Storage Management) Oracle Data Guard Oracle Multitenant Architecture Backup & Recovery RMAN (Recovery Manager) Export/Import (Data Pump) Flashback Technologies Performance Tuning AWR Reports ADDM ASH Reports SQL Tuning Query Optimization Wait Event Analysis Database Security User and Role Management Privilege Administration Database Auditing Security Patching Operating Systems Linux (RHEL, Oracle Linux, CentOS) Unix (Preferred) Windows Server Scripting SQL PL/SQL Shell Scripting Python (Preferred) Monitoring Tools Oracle Enterprise Manager (OEM) ServiceNow Nagios SolarWinds (Preferred)
Other Requirements
NA

