Database Administrator

Overview

On Site
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 5 month(s)

Skills

dba
Java
CI/CD
SQL Server
restful
IT Support
installations
Recovery
Junit
Conversions
Database Backup
Plan Analysis
DDL

Job Details

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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Stellar Professionals LLC