Oracle Database Administrator

American Greetings - Westlake, OH

Full-time

Westlake, OH

Publishing Industries

About the position

The Database Administrator position is a hybrid role responsible for providing comprehensive database management and administration support for all Oracle databases. This includes tier 1, 2, and 3 support, along with an on-call rotation for critical issues. The role requires familiarity with Oracle database architecture, performance tuning, and backup & recovery concepts, while also emphasizing strong analytical and communication skills.

Responsibilities

• Responsible for Oracle database backups, design, development, testing, and performance tuning.
• Conducts after-action analyses when issues arise and plans to prevent future occurrences.
• Debugs database performance problems and documents results and findings.
• Acts as a team-wide subject matter expert.
• Identifies impacts of proposed changes to the database.
• Creates estimates for tasks and completes them within expected timeframes.
• Delivers results without requiring rework from other engineers.
• Learns new technologies and applies knowledge to achieve goals.
• Maintains underlying storage and database interaction.
• Audits databases for access and security.
• Maintains database access control and privileges.
• Performs capacity planning for space and performance.
• Plans for disaster recovery scenarios.
• Migrates data among databases and to external sources.
• Expert in SQL and database-specific variants.
• Understands replication and high availability concepts.
• Enforces database integrity through triggers and constraints.
• Writes basic stored procedures, functions, and triggers.
• Maintains patch schedule for security and maintenance releases.
• Champions process, documentation, and operational improvements.
• Provides 24 x 7 support for planned and unplanned activities.
• Understands basic Linux commands and operations.
• Understands basic networking tasks.

Requirements

• 5+ years in a large, enterprise client-server environment.
• 5+ years Oracle DBA experience.
• Effective communication skills and ability to interact professionally with diverse clients and staff.
• Demonstrated time management and organizational skills.
• Ability to work productively in teams.
• Desire to learn new technical skills quickly.
• Strong troubleshooting skills and ability to resolve technical problems independently.
• Familiarity with backups, Disaster Recovery (DR), and restoration systems.

Nice-to-haves

• Knowledge of Oracle Enterprise Manager, RMAN, ASM, Erwin, DBArtisan, SolarWinds Database Performance Analyzer, Veritas Cluster Server, Pure Storage, NetApp.
• Knowledge of Linux shell scripting.
• Knowledge of Python and Perl.