Oracle Database Administrator - American Greetings

Westlake, OH

Job Description

As this is a hybrid role, working out of our Creative Studios in Westlake, Ohio, we will focus on candidates currently residing in north east Ohio.

GENERAL SUMMARY:
The Database Administrator position is responsible for providing tier 1, 2 and 3 database management and administration support for all Oracle databases including an on-call rotation for critical issues. They are expected to be familiar with Oracle database architecture, logical and physical design, automation, documentation, installs, Linux, shell scripting, backup & recovery concepts, and database performance. The Database Administrator must have good analytical, verbal, and written skills. This individual will report directly to the Team Lead of Web Operations.

ESSENTIAL DUTIES & RESPONSIBILITIES:

• Responsible for Oracle database backups, design, development, testing, and performance tuning.
• Conducts after-action analyses when things go wrong and plans to prevent the same problem in the future.
• Debugs database performance problems, competent with profiling tools and documents the results and findings
• Team-wide subject matter expert
• Identifies subtle or obscure impacts of proposed changes
• Creates estimates for tasks
• Finishes tasks within the expected time.
• Delivers results without rework from other engineers
• Learns new things and applies that knowledge to achieve goals
• Understands and maintains underlying storage (SAN,NAS,NFS, etc.) and database interaction (eg, ORACLE ASM)
• Audits databases for access and security (via built-in software abilities or external tools)
• Maintains database access control and privileges
• Performs capacity planning (space and performance)
• Advanced understanding of specific schema/meta data architecture as it relates to the various business units
• Plans for disaster recovery (advanced backup/recovery scenarios)
• Migrates data among databases and to external sources
• Expert in SQL (general) and 2+ database specific variants
• Understands the concepts of replication and HA (knows specifics of implementing it in at least 1 vendor specific platform)
• Able to enforce database integrity (triggers, RI, constraints)
• Write basic stored procedures/functions/triggers
• Understands patching requirements (security and maintenance releases) and maintains patch schedule
• Understands basics of database design and modeling (physical and logical) (should be able to create and maintain a schema/database for at least 1 vendor specific platform)
• Champion process, documentation and operational improvements and best practices
• Provide 24 x 7 support for both planned and unplanned activities to minimize disruption to the business
• Understands basic Linux commands and operations
• Understanding basic networking tasks
• Being able to architecturally see the big picture as to how the database and other technologies come together

Experience Required:

Required Length & Type of Experience:
• 5+ years in a large, enterprise client-server environment
• 5+ years Oracle DBA experience
• Effective communication skills and the ability to interact professionally with a diverse group of clients and staff
• Demonstrate time management and organizational skills
• Demonstrate ability to work productively in teams
• Ability and desire to learn new technical skills quickly
• Strong troubleshooting skills, and the ability to resolve technical problems on your own
• Familiarity with backups, Disaster Recovery (DR) and restoration systems

Knowledge, Skills & Abilities:
• 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 are a plus
• Excellent interpersonal skills, able to work effectively with technical and business partners
• Strong written, verbal and presentation abilities
• Flexible, positive and team-oriented attitude
• Able to handle dynamic and high-pressure environment with focus on success and productivity
• Demonstrate excellent analytical abilities and critical thinking
• Basic knowledge of information security areas
• As new technologies emerge, the Senior Database Administrator is expected to learn these technologies very quickly and resolve any problems involved in integrating new technologies with corporate systems/infrastructure

PHYSICAL DEMANDS:
• Must be able to install, move and uninstall server hardware, not exceeding 50 pounds
• In emergency situations, must be able to work extended hours, potentially up to 18 hours at a time