Database Administrator - Onsite, OH
Listed on 2025-12-27
-
IT/Tech
Database Administrator, Data Engineer
This role is for a Database Administrator in Columbus, OH, with a contract length until 12/30/2025, offering a competitive pay rate. Key skills include SQL Server expertise, Java development, RESTful APIs, and database performance tuning. Experience with IBM DB2 is desired.
United States
-
Unknown
-
December 25, 2025
-
On-site
-
-
Columbus, OH 43215
#Java #Data Storage #Database Design #Data Modeling #Data Dictionary #Deployment # Server #Hibernate #SQL (Structured Query Language) #Database Migration #Automation #Database Management #SQL Queries #Database Upgrade #DBA (Database Administrator) #Scripting #Angular #Data Analysis #JDBC (Java Database Connectivity) #Replication #Web Services #Migration #API (Application Programming Interface) #Database Schema #Monitoring #Schema Design #Data Access #Storage #JPA (Java Persistence API) #Microservices #Security #JUnit #Statistics #Databases #Logical Data Model #Database Performance #Code Reviews
Database Administrator - Onsite, OH13 hours agocolumbus,ohio Submission Due Date: 12/30/2025
Client - State of Ohio Interviews will be onsite.
Work onsite: OIC location (William Green Building 8th floor, 30 West Spring Street, Columbus, Ohio).This position will support the Division of Information Technology at the Ohio Industrial Commission.
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 in script for 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.
Freelance data hiring powered by an engaged, trusted community — not a CV database.
85 Great Portland Street, London, England, W1W 7LT
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).