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