About this role
About Us (Ensono)
Ensono is an expert technology adviser and managed service provider. As a relentless ally, we accelerate clients' digital transformation to achieve business outcomes that stand to last. Our dedicated team helps organizations optimize today's systems across any hybrid environment with services such as consulting, mainframe and application modernization, public cloud migration and cloud-native development. With certified experts in AWS, Azure and Google Cloud and recognized as Microsoft Datacenter Transformation Partner of the Year, Ensono has over 3500+ associates globally and is headquartered in greater Chicago.
We care about your success, offering comprehensive strategic and managed services for mission-critical applications. Our Advisory and Consulting services can help upfront with an application strategy or find the right places for your applications - whether it's public, multi or hybrid cloud, or mainframe. And because we span across all mission-critical platforms, we can meet you wherever you are in your digital transformation journey, with 24/7 support when you need it. We are your relentless ally, flexing with you when challenges emerge so you don't feel stuck in place. With cross-platform certifications and decades of experience, our technology experts have become an extension of your team so you're continuously innovating - doing more with less while remaining secure. And that's just the beginning.
About Role
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.
Roles 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 Qualifications:
Typically requires a minimum of 5 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 experienceAnalyticalOrganizationalComplex Problem SolvingDocumentationAbility to Multi-taskStrong Relational DatabaseSQLUNIXWindowsStrong Database Administration and Performance TuningCoaching SkillsLeadershipAbility to work independentlyLogical /Physical Database DesignPreferredBachelor's degree and a minimum of 5 years of related experience; or equivalent work experience JR010518