Database Administrator

MCJC•Dayton, OH

About The Position

The Database Administrator provides senior-level technical support and oversight for the Court’s enterprise data systems, ensuring the availability, integrity, security, and performance of mission-critical databases. The position bridges database administration, reporting enablement, and system continuity, supporting court operations and Data Services initiatives. The employee collaborates with IT staff, Data Services, vendors, and court departments to reduce operational risk and ensure reliable access to information supporting services to youth and families. This is a full-time, exempt position in the IT Department, reporting to the Data Manager, with a 40-hour work week. The position is at-will and serves at the pleasure of the Administrative Judge. The role administers and supports Oracle and SQL Server environments; manages database security, access controls, auditing, backups, recovery, and disaster recovery; and supports production, test, and reporting environments. It monitors database performance, storage growth, indexing, and query efficiency, and supports Data Services reporting and analytics through complex SQL data extraction, Tableau analysis, and Telerik self-service report requests. The Database Administrator also coordinates database changes with vendors and internal stakeholders, documents database systems and procedures, and contributes to modernization initiatives including an Oracle-to-SQL Server migration and JCS.NET evolution. The position has no supervisory responsibilities. It involves access to confidential juvenile justice data, court records, and sensitive system information. The work is performed under good office conditions, with limited exposure to juveniles. Occasional after-hours or emergency response may be required to support system availability. The employee frequently sits for extended periods and uses a computer, and occasionally stands and walks within the work area. The role requires verbal communication and close visual attention when reviewing data and computer screens.

Requirements

Strong SQL skills.
Knowledge of relational database management systems, database security and backup practices, reporting and analytics systems, and data integrity and governance principles.
Ability to analyze and resolve complex technical issues; maintain confidentiality of sensitive information; communicate effectively with technical and non-technical staff; document systems and procedures; and work independently and collaboratively in a mission-critical environment.
Skills in SQL development, database administration, performance tuning, troubleshooting, technical documentation, database operation, database migration, database security, database backup and recovery, and reporting software.
Ability to pass a criminal background check.
Valid Ohio Driver’s License and insurance.
Ability to document identity and employment eligibility within three days of original appointment, as required by the Immigration Reform and Control Act.

Nice To Haves

Bachelor’s degree in computer science, information systems, data science, or a related technical field.
Three to five years’ experience supporting enterprise database systems or data services environments; additional experience may be substituted for education at the Court’s discretion.
Knowledge of court or government data environments and HIPAA, CJIS, PII, and PCI-DSS compliant standards.
Oracle-to-SQL Server migration experience.
Knowledge of Oracle and SQL Server SQL syntax.
Oracle Database Administration Certification.
Microsoft Certified: Azure Database Administrator Associate (Exam DP-300).

Responsibilities

Administer and support enterprise database systems, including Oracle and SQL Server environments, to ensure availability, performance, and data integrity.
Manage database security, access controls, auditing, and compliance with court and county standards.
Oversee database backup, recovery, and disaster recovery processes, including validation and restore testing using native database tools.
Support production, test, and reporting environments.
Monitor performance, storage growth, indexing, and query efficiency.
Support Data Services reporting and analytics through complex SQL data extraction, Tableau analysis, and self-service report requests using Telerik.
Collaborate with IT leadership, Data Services, vendors, and court departments to support daily operations and modernization initiatives, including the Oracle-to-SQL Server migration and JCS.NET evolution.
Coordinate with application vendors and internal stakeholders to review database changes, patches, and scripts for alignment with court standards and operational needs.
Document database architecture, procedures, and critical systems to prevent single-point-of-failure dependencies.
Implement safeguards to prevent data loss, corruption, and duplication.
Assist in defining data standards, validation rules, and audit checks.
Support data lineage and logic documentation for critical metrics.
Offer essential training to help enforce good data practices system-wide.