Urgent requirement for the position of Database Administrator 4 (SQL Server) at Columbus, OH.
Vinay CloudShift
Position: OIC-Database Administrator 4(DBA4)
Location: Columbus, OH
Client: State of Ohio
Agency: OIC
Interview Type: Interviews will be onsite
Position ID: 788750
Database Administrator 4
Work onsite: OIC location (William Green Building 8th floor, 30 West Spring Street, Columbus, Ohio).
Interviews will be onsite.
Job Description:
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 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.
|
Skill |
Required / Desired |
Your Amount of Experience in years/month |
|
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 5 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 |
|
_______________________________________
Vinay Kumar| Cloud Shift Technologies
Email: vi...@cloudshifttech.com
