High-Availability DBA & Data Warehouse Specialist

State of Ohio

Columbus (OH)

On-site

USD 52,279 - 74,459

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical Coverage

Dental/Vision/Life Insurance

Paid Time Off

Holidays (11 paid)

Job summary

State of Ohio is seeking a Database Administrator to support the agency's enterprise data environment. The role focuses on designing high-availability database solutions, developing data warehouse and BI structures, and optimizing system performance.

The DBA will collaborate with IT Architecture, CIO leadership, developers, and business partners to ensure secure, reliable, and scalable data systems. Required expertise includes Oracle, PL/SQL, SQL Server, data modeling and enterprise data

Qualifications

60 months combined work experience in database design, implementation, operation and Tier III support.

Responsibilities

Design high-availability clustered database solutions and perform hardware planning, node configuration, cluster ware installation and performance tuning.
Configure replication, log shipping and standby servers to support business continuity and disaster recovery.
Collaborate with IT Architecture, CIO leadership, developers and business partners to resolve Tier III database issues.
Define BI data needs and design data warehouse and data mart structures for enterprise reporting and analytics.
Implement BI tools, dashboards, scorecards and analytic applications.
Develop and document standards for installation, configuration, monitoring, security and migrations.
Perform performance tuning and optimization across platforms including multidimensional data models.
Design secure data exchange standards and align database strategies with business needs.
Mentor peers by providing technical guidance, documentation and training.