Senior Database Administrator

Senior Database AdministratorRemote - United StatesJR011146nThe 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.nDUTIES AND RESPONSIBILITIESnConsistently provides proven, formal mentorshipnHigh complexity assignments – ownernModerate complexity assignments – owner (1 or >)nLow complexity assignments – provide oversight/reviewnRegularly lead self and others and/or established as Product SME and/or established as specialistnUnderstands how whole picture aligns to overall Ensono strategynInstallation and configuration of database software and related productsnPlans and implements Database backup and recoverynImplementing robust change control and configuration management policiesnCapacity planning & system-level architecturenOS/Storage/DB configuration and optimizationnDatabase security checks and audits, including compliance-related reporting & controlsnGeneral database health checksnDatabase monitoringnWorking with DBMS vendor support (Oracle support, Microsoft support, etc.)nDefining and maintaining quantitative SLAs and helping enhance current service levelsnPhysical data model/architecture, DDL generation and maintenancenDB server migrations and decommissioningnDatabase creation and configurationnApplying patchesnUpgrading the databasesnMaintenance (proactive, reactive and automated); both scheduled and unschedulednDatabase refreshesnImprove processes and proceduresnLog-file reviewnComplex trouble-shooting and repairsnReporting on state of databasesnDatabase tuning (proactive and reactive)nMaintaining specialized environments such as log shipping, replication, cluster-based instances, etc.nSOP (Std. Operating Procedure) definition & automationnDBMS and related tools license managementnDocumentation related to all Systems DBA areasnManagement of database-related tools (monitoring systems, tool repositories, etc.)nAutomated measurement of quantitative SLAs & any deviations thereofnDevelopment & utilization of detailed triage processesnDetailed workload analysisnInfrastructure advise and planningnDisaster recovery/failover servicesnWorking with DevelopersnEnsuring the availability of the databasenManaging database users and security/access controlnContributes significant, new and innovative ideas to the DBA knowledge basenArchitect complex database solutionsnOn-callnSUPERVISORY RESPONSIBILITIESnThis position does not have direct reports but may mentor less experienced associates in the role.nRECRUITING INFORMATIONnSpecific 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.nQUALIFICATIONSnRequirednnnTypically 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 experiencen nnAnalyticaln nnOrganizationaln nnComplex Problem Solvingn nnDocumentationn nnAbility to Multi-taskn nnStrong Relational Databasen nnSQLn nnUNIXn nnWindowsn nnStrong Database Administration and Performance Tuningn nnProject Management Skillsn nnCoaching Skillsn nnLeadershipn nnAbility to work independentlyn nnLogical /Physical Database Designn n nPreferrednnnDetailed knowledge of Ensono products.n nnBachelor’s degree and a minimum of 7 years of related experience; or equivalent work experiencen n nTravel %n< 5%nJR011146