Location: Houston,TX, USA
Senior Database AdministratorRemote - United StatesJR011146The 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 RESPONSIBILITIESConsistently 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-callSUPERVISORY RESPONSIBILITIESThis position does not have direct reports but may mentor less experienced associates in the role.RECRUITING INFORMATIONSpecific 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.QUALIFICATIONSRequiredTypically 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 experienceAnalyticalOrganizationalComplex Problem SolvingDocumentationAbility to Multi-taskStrong Relational DatabaseSQLUNIXWindowsStrong Database Administration and Performance TuningProject Management SkillsCoaching SkillsLeadershipAbility to work independentlyLogical /Physical Database DesignPreferredDetailed knowledge of Ensono products.Bachelor's degree and a minimum of 7 years of related experience; or equivalent work experienceTravel %< 5%JR011146