Location & Work Arrangement
- City, State : Columbus, Ohio
- Work Arrangement : Onsite (Required to work onsite at the William Green Building).
- Contract : This is a Contract position.
- Mode of Interview : In Person .
Key Responsibilities and Technical Expertise
The ideal candidate will bridge the gap between application development and core database administration, with significant experience in performance engineering.
1. Database Administration & Performance Engineering (10 Years Required)
Performance Tuning : Actively analyze, tune, and optimize slow SQL queries and stored procedures impacting application performance.Expert-level knowledge of SQL, DDL, DML , and advanced tuning techniques (indexing, partitioning, execution plan analysis).
Operations : Responsible for database backup and recovery procedures , access security, database integrity, physical data storage design, and data storage management.Monitoring : Monitor database performance and space requirements. Experience with database monitoring tools (e.g., Prometheus, Grafana, OEM) and building custom alerting thresholds.Design & Upgrades : Highly skilled at database design, installations, and conversions (specifically SQL Server ). Evaluate and perform database upgrades.Data Modeling : Proficiency in relational data modeling (3rd Normal Form) and NoSQL modeling concepts. Skilled data dictionary analysis and design.2. Java Development & Application Integration (5 Years Required)
Data Access Layer : Design, implement, and unit-test high-performance data access layers (JPA / DAO / JDBC) and data-centric microservices using Java (11 or higher) in the Windows environment.API Development : Experience designing, developing, and consuming RESTful APIs for seamless integration and efficient data delivery.ORM : In-depth understanding of Object-Relational Mapping (ORM) (e.g., JPA / Hibernate) and its performance implications (e.g., cache management, lazy vs. eager loading).Code Quality : Perform rigorous code reviews focusing on ORM usage, transaction management, and efficient data retrieval to prevent database anti-patterns.Automation : Author scripts (in Java or scripting languages) to automate repetitive DBA tasks and enhance operational monitoring.3. Support and Documentation
SDLC : Experience and knowledge in supporting the application system development life cycle.Documentation : Document data flows, API specifications, and database operational procedures.Collaboration : Implement best practices for efficient data access and database interaction within the Java / Angular environment. Identify and track issues, risks, and action items.Desired Plus : Experience working with IBM DB2 database is highly desired.Required Technical Skills Summary
Skill Area
Required Experience
Key Technologies / Concepts
Database Expertise
10 Years
SQL Server (High Traffic Production), SQL (Expert DDL / DML), Performance Tuning, Backup / Recovery, Data Modeling.
Monitoring
10 Years
Database Monitoring Tools (Prometheus, Grafana, OEM), Custom Alerting.
Java / Integration
5 Years
Java 11+ , JPA (Hibernate / ORM), RESTful web services , JUnit , Code Review.
Soft Skills
N / A
Strong written / spoken communication, Ability to work in a team environment, Execute responsibilities with little direct supervision.