SQL Server Database Administrator

This position will support the Division of Information Technology at the Ohio Industrial Commission.

• 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.
• 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.

• Performance Engineering:
  Actively analyze, tune, and optimize the slow SQL queries and stored procedures impacting application 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.

• Work onsite: OIC location (William Green Building 8th floor, 30 West Spring Street, Columbus, Ohio).
• Interviews will be onsite.