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 American Greetings

Job Tags

Similar Jobs