Database Administrator

Ensono · via Himalayas ·

TypeFull-time job
LocationUnited States
Posted2 hours ago
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, IllinoisAdditional 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
database-administrator database-engineer it-systems-and-database-administrator database-reliability-engineer
Apply on Himalayas →

Job sourced from Himalayas. Applications happen directly on the original platform — we never collect your data.