SQL DBA

One of our clients is looking for the position of  Database Administrator based on following skills:

Work onsite: Columbus, Ohio

Interviews will be onsite.

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.

The successful candidate may have to undergo a drug test and background check.

Sincerely,

Tamana Nair

Digitek Software, Inc.

650 Radio Drive, Lewis

Center, OH 43035 Tel No ext. 3105/ Fax

Email