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

　　Fully functional and self-directed

　　Provides 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

　　Sees the whole picture and adjusts work accordingly

　　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 with supervision

　　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 with supervision

　　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

　　Log-file review

　　Medium-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 with supervision

　　Infrastructure advise and planning

　　Disaster recovery/failover services

　　Working with Developers

　　Ensuring the availability of the database

　　Managing database users and security/access control

　　Architect 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 4 years of related experience with a Bachelor's degree; or 3 years and a Master's degree; or a PhD without experience; or equivalent work experience

　　Analytical

　　Organizational

　　Strong Problem Solving

　　Documentation

　　Ability to Multi-task

　　Relational Database

　　SQL

　　UNIX

　　Windows

　　Database Administration

　　Project Management

　　Ability to work independently

　　Logical/Physical Database Design

　　Preferred

　　Advanced, proven knowledge of Ensono products

　　Bachelor's degree and a minimum of 4 years of related experience; or equivalent work experience

　　Travel %

　　< 5%

　　JR009789