Database Administrator
 American Greetings Corporation | |
 United States, Ohio, Westlake | |
 Nov 13, 2024 | |
|
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 | |