Overview
On Site
Depends on Experience
Contract - Independent
Contract - 12 Month(s)
Skills
Communication
API
AngularJS
Backup
Caching
Code Review
Collaboration
Data Dictionary
Data Flow
Data Modeling
Data Storage
Data Warehouse
Continuous Delivery
Continuous Integration
DAO
DDL
DML
Data Analysis
Logical Data Model
Microservices
Microsoft SQL Server
Microsoft Windows
Grafana
Hibernate
IBM DB2
JPA
JUnit
Java
Management
Database
Database Administration
Database Design
Entity Relationship Model
Professional Development
Recovery
Replication
Scripting
Software Development
Performance Engineering
Performance Tuning
Process Improvement
RESTful
JDBC
Migration
Modeling
New Relic
Stored Procedures
Systems Analysis/design
NoSQL
Object-relational Mapping
SQL
Spring Framework
Statistics
Supervision
Team Leadership
Testing
Unit Testing
Web Services
Job Details
Position Description:
OIC-Database Administrator 4(DBA4)
Interviews will be onsite.This position will support the Division of Information Technology at the Ohio Industrial Commission.
Database Administrator 4
Work onsite: OIC location (William Green Building 8th floor, 30 West Spring Street, Columbus, Ohio).
The ideal candidate will have the skills specified below:
Highly skilled at database design, installations, and conversions, specifically with SQL Server databases.
Document data flows, API specifications, and database operational procedures.
Implement best practices for efficient data access, transactions, and database interaction within a Java (Back End) and Angular (Front End) environment.
Skilled data dictionary analysis and design, and data model analysis and design.
Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design, and data storage management.
Engage in ongoing process improvement.
Skilled data dictionary analysis and design, and data model analysis and design.
Experience and knowledge in supporting the application system development life cycle.
Responsible for data dictionary backup and recovery.
Responsible for the definition of standards of data dictionaries.
Perform performance tuning.
Monitor database performance and space requirements.
Schedule and monitor end-of-day data warehousing jobs.
Evaluate and perform database upgrades.
Ability to work in a team environment.
Strong communication skills, both written and spoken.
Logical data modeling techniques.
Knowledgeable in data analysis and database management techniques.
Execution of all responsibilities with little direct supervision of the Team Lead.
Author scripts to perform backup, restore, and monitoring tasks.
Identify and track issues, risks, and action items.
Experience in Java solution development in the Windows environment.
Experience with Java Persistence API (JPA), SQL, RESTful web services, and JUnit.
Experience designing, developing, and consuming RESTful APIs for seamless integration.
Strong experience with SQL Server Database.
Experience with IBM DB2 database will be desired
Day-to-Day responsibilities include, but are not limited to:
Performance Engineering: Actively analyze, tune, and optimize the slow SQL queries and stored procedures impacting application performance.
Java Development: Design, implement, and unit-test high-performance data access layers (JPA/DAO/JDBC) and data-centric microservices using Java.
Code Review: Perform rigorous code reviews focusing on ORM usage (JPA/Hibernate), transaction management, and efficient data retrieval to prevent common database anti-patterns (like N+1 queries).
Support Ongoing Projects: Monitor, diagnose, and quickly resolve critical issues related to database locking, deadlocks, and high resource utilization.
Schema Design: Collaborate with application developers to design and document optimal physical and logical database schemas (DDL) for new features.
Monitoring & Health: Review daily database health reports, manage routine maintenance (e.g., statistics updates), and ensure replication health.
Automation: Develop and maintain custom tooling or scripts (often in Java or scripting languages) to automate repetitive DBA tasks and enhance operational monitoring.
Deployment & CI/CD: Ensure that database migrations and application changes are safely deployed through CI/CD pipelines following governance and testing standards.
Skills Table:
Skill Required / Desired Amount of Experience
Where does your candidate currently reside?
Experience administering and tuning high-traffic production databases (e.g., SQL Server)
Required 10 Years
Expert-level knowledge of SQL, DDL, DML, and advanced tuning techniques (indexing, partitioning, materialized views, execution plan analysis
Required 10 Years
Experience with database monitoring tools (e.g., Prometheus, Grafana, OEM, New Relic) and building custom alerting thresholds
Required 10 Years
Proficiency in relational data modeling (3rd Normal Form) and NoSQL modeling concepts
Required 10 Years
Hands-on, professional development experience with Java 11+ (or higher) in the Windows environment.
Required 5 Years
Experience with Java Persistence API (JPA), SQL, RESTful web services and JUnit
Required 5 Years
Experience designing and implementing RESTful APIs for data delivery
Required 5 Years
In-depth understanding of Object-Relational Mapping (ORM) and its performance implications, including cache management, lazy vs. eager
Required 5 Years
Experience working IBM DB2 database
Highly desired
Where does your candidate currently reside?
Selected candidate will be required to have a BCI Fingerprint check performed. Does your candidate agree?
Resource will be required to work onsite: OIC location (William Green Building 8th floor, 30 West Spring Street, Columbus, Ohio). Do you agree with this requirement?
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.