Oracle Database Administrator

American Greetings - Westlake, OH

Full-time

Hybrid - 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 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 and recovery concepts, as well as strong analytical and communication skills. The position reports directly to the Team Lead of Web Operations.

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.
• Understands database design and modeling.
• 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.