The Database Administrator creates, maintains, designs, monitors and troubleshoots Ensono or client databases. They use specific relational database management systems, develop and implement database recovery mechanisms and procedures. And coordinate security measures to safeguard database integrity.
DUTIES AND RESPONSIBILITIES Consistently provides proven, formal mentorship High complexity assignments – owner Moderate complexity assignments – owner (1 or >) Low complexity assignments – provide oversight/review Regularly lead self and others and/or established as Product SME and/or established as specialist Understands how whole picture aligns to overall Ensono strategy Installation and configuration of database software and related products Plans and implements Database backup and recovery Implementing robust change control and configuration management policies Capacity planning & system-level architecture OS/Storage/DB configuration and optimization Database security checks and audits, including compliance-related reporting & controls General database health checks Database monitoring Working with DBMS vendor support (Oracle support, Microsoft support, etc.) Defining and maintaining quantitative SLAs and helping enhance current service levels Physical data model/architecture, DDL generation and maintenance DB server migrations and decommissioning Database creation and configuration Applying patches Upgrading the databases Maintenance (proactive, reactive and automated); both scheduled and unscheduled Database refreshes Improve processes and procedures Log-file review Complex trouble-shooting and repairs Reporting on state of databases Database tuning (proactive and reactive) Maintaining specialized environments such as log shipping, replication, cluster-based instances, etc. SOP (Std. Operating Procedure) definition & automation DBMS and related tools license management Documentation related to all Systems DBA areas Management of database-related tools (monitoring systems, tool repositories, etc.) Automated measurement of quantitative SLAs & any deviations thereof Development & utilization of detailed triage processes Detailed workload analysis Infrastructure advise and planning Disaster recovery/failover services Working with Developers Ensuring the availability of the database Managing database users and security/access control Contributes significant, new and innovative ideas to the DBA knowledge base Architect complex database solutions On-call
SUPERVISORY RESPONSIBILITIES This position does not have direct reports but may mentor less experienced associates in the role. RECRUITING INFORMATION Specific hiring needs may vary by location, industry, client, internal department and other business related factors. The qualifications section lists examples that may be used as guidance when populating required and preferred skills sections of recruiting requisitions / job postings. QUALIFICATIONS Required Typically requires a minimum of 7 years of related experience with a Bachelor's degree; or 6 years and a Master's degree; or a PhD with 3 yearsexperience; or equivalent work experience Analytical Organizational Complex Problem Solving Documentation Ability to Multi-task Strong Relational Database SQL UNIX Windows Strong Database Administration and Performance Tuning Project Management Skills Coaching Skills Leadership Ability to work independently Logical /Physical Database Design Preferred Detailed knowledge of Ensono products. Bachelor's degree and a minimum of 7 years of related experience; or equivalent work experience