Database Administrator – Datacom

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.

Job Role

• Fully functional and self-directed
• Provides 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
• Sees the whole picture and adjusts work accordingly
• 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 with supervision
• 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 with supervision
• 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
• Log-file review
• Medium-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 systems, tool repositories, etc.)
• Automated measurement of quantitative SLAs & any deviations thereof
• Development & utilization of detailed triage processes
• Detailed workload analysis with supervision
• Infrastructure advise and planning
• Disaster recovery/failover services
• Working with Developers
• Ensuring the availability of the database
• Managing database users and security/access control
• Architect database solutions
• On-call

  Experience level

  Typically requires a minimum of 10 years of related experience with a Bachelor’s degree; or 3 years and a Master’s degree; or a PhD without experience; or equivalent work experience
  Analytical