American Greetings
Database Administrator
American Greetings, Westlake, Ohio, United States, 44145
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
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