Database Administrator

Worker Type:

Employee

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.

DUTIES AND RESPONSIBILITIES

• 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
• 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.
• Configure and address issues related to Encryption & CDC
• Database refreshes with or without Encryption.
• Manage Version control and track changes using Liquidbase
• Manage DR Replication using Zerto.
• Perform Data Privacy masking and obfuscation using Compuware Topaz
• Manage I/O using V-Locity (DymaxIO)
• Perform SOX Audit
• 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

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 4 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
• Organizational
• Strong Problem Solving
• Documentation
• Ability to Multi-task
• Relational Database
• SQL
• UNIX
• Windows
• Database Administration
• Project Management
• Ability to work independently
• Logical/Physical Database Design

Preferred

• Advanced, proven knowledge of Ensono products
• Bachelor's degree and a minimum of 4 years of related experience; or equivalent work experience

Primary Location City/State:

Homebased - Downers Grove, IL - Finley, Illinois

Additional Locations (if applicable):

Ensono is an Equal Employment Opportunity Employer. Ensono provides equal employment opportunities to all qualified applicants without regard to race, color, religion, national origin, ancestry, citizenship status, sex, marital status, pregnancy, age, disability, genetic information, sexual orientation, gender identity or expression, veteran status, military status, or any other status protected by applicable law.

About Us

Ensono helps IT leaders be the catalyst for change by harnessing the power of hybrid IT to transform their businesses. We drive digital transformation by enabling increased agility and scalability through the modernization to public cloud. Our broad services portfolio from mainframe to cloud, powered by an intelligent governance platform, is designed to help our clients operate for today and optimize for tomorrow. We are award-winning certified experts in AWS and Azure and recognized as Microsoft Datacenter Transformation Partner of the Year. Ensono has over 2,000 associates around the world and is headquartered in greater Chicago.

Visit us at www.ensono.com. In June 2018, Ensono acquired the hosted data center business of Wipro.

Our company and community is one that focuses on philosophy of we win together. Our job opportunities will stretch your limits and expose you to cutting edge technologies whether you’re an engineer, developer, products guru, systems and security expert, sales and consulting executive, or an intern looking to gain real experience with a company that will make your résumé — and you — stand out.

If you are interested in applying for employment with Ensono and need special assistance or an accommodation to apply for a posted position, contact our recruiting department at 1-800-729-1501. We highly recommend for you to create an account to monitor your resume submissions. Click on the Sign In link above to create an account or sign up at the end of your application. Thank you!