Senior Database Administrator IMS Logical

DUTIES AND RESPONSIBILITIES
Consistently provides proven, formal mentorshipHigh complexity assignments ownerModerate complexity assignments owner (1 or >)Low complexity assignments provide oversight/reviewRegularly lead self and others and/or established as Product SME and/or established as specialistUnderstands how whole picture aligns to overall Ensono strategyInstallation and configuration of database software and related productsPlans and implements Database backup and recoveryImplementing robust change control and configuration management policiesCapacity planning & system-level architectureOS/Storage/DB configuration and optimizationDatabase security checks and audits, including compliance-related reporting & controlsGeneral database health checksDatabase monitoringWorking with DBMS vendor support (Oracle support, Microsoft support, etc.)Defining and maintaining quantitative SLAs and helping enhance current service levelsPhysical data model/architecture, DDL generation and maintenanceDB server migrations and decommissioningDatabase creation and configurationApplying patchesUpgrading the databasesMaintenance (proactive, reactive and automated); both scheduled and unscheduledDatabase refreshesImprove processes and proceduresLog-file reviewComplex trouble-shooting and repairsReporting on state of databasesDatabase tuning (proactive and reactive)Maintaining specialized environments such as log shipping, replication, cluster-based instances, etc.SOP (Std. Operating Procedure) definition & automationDBMS and related tools license managementDocumentation related to all Systems DBA areasManagement of database-related tools (monitoring systems, tool repositories, etc.)Automated measurement of quantitative SLAs & any deviations thereofDevelopment & utilization of detailed triage processesDetailed workload analysisInfrastructure advise and planningDisaster recovery/failover servicesWorking with DevelopersEnsuring the availability of the databaseManaging database users and security/access controlContributes significant, new and innovative ideas to the DBA knowledge baseArchitect complex database solutionsOn-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 years experience; 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

Travel %