SQL Database Administrator

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. The Database Administrator position is responsible for providing tier 1, 2 and 3 database management and administration support for all database. They are expected to be familiar with database architecture, logical and physical design, automation, documentation, installs, Linux, shell scripting, backup & recovery concepts, and database performance and. 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 database backups, design, development, testing, and performance tuning. Conducts after-action analyses when things go bad 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 This company is an equal opportunity employer and makes employment decisions without regard to race, gender, disability or protected veteran status. We desire to place a priority on referrals of protected veterans. EOE M/F/disability/vet VEVRAA Federal Contractor