Database Administrator

Responsibilities

• Fully functional and self‑directed
• Provides formal mentorship
• High complexity assignments – owner
• Moderate complexity assignments – owner (1 or higher)
• Low complexity assignments – provide oversight/review
• Regularly lead self and others and/or established as Product SME and/or 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
• Implements 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 troubleshooting 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 Liquibase
• Manage DR replication using Zerto
• Perform data privacy masking and obfuscation using Compuware Topaz
• Manage I/O using V‑Velocity (DymaxIO)
• Perform SOX audit SOP 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 advice 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.

• 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 and problem‑solving skills.
• Strong documentation ability.
• Multi‑tasking capability.
• Relational Database SQL experience.
• UNIX and Windows experience.
• Database Administration experience.
• Project Management experience.
• Ability to work independently.
• Logical/Physical Database Design knowledge.
• Advanced, proven knowledge of Ensono products.
• Primary location:
  Home‑based
  - Downers Grove, IL
  - Finley, Illinois.

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.