Database Administrator

Company: Ensono
Worker Type:
EmployeeThe 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.
Originally posted on Himalayas