Database Administration Specialist 2, Office of Database, PN 20064611

Ohio Department of Administrative Services • Columbus, OH

3d

About The Position

What You Will Do:
High Availability Architecture: Design and configure cluster nodes, standby servers, log shipping, and replication to ensure maximum system uptime.

BI & Data Warehousing: Manage ETL processes (utilizing SSIS for SQL Server) to replicate and transform data while monitoring warehouse data loads.

Performance Optimization: Tune system configurations and data manipulation models across multiple platforms to ensure efficiency.

Standards & Security: Establish data exchange standards, define security models, and maintain technical documentation for installation and monitoring.

Strategy & Mentorship: Create database strategies that support business needs and provide technical mentorship to peers.

Requirements

• 60 mos. combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.
• completion of associate core program in computer science or information systems; 42 mos. combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.
• completion of undergraduate core program in computer science or information systems; 36 mos. combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.
• equivalent of minimum class qualifications for employment noted above.
• The official position description on file with the designated agency is to reflect the required, primary technology directly relating to the duties of the position.
• Only those applicants possessing the experience in the required, primary technology listed in the position description & job posting are to be considered for any vacancies posted.
• The job posting must list the required technology commensurate with the position in question.
• Job Skills: Database Administration

Responsibilities

• Design and configure cluster nodes, standby servers, log shipping, and replication
• Manage ETL processes (utilizing SSIS for SQL Server) to replicate and transform data while monitoring warehouse data loads
• Tune system configurations and data manipulation models across multiple platforms
• Establish data exchange standards, define security models, and maintain technical documentation
• Create database strategies that support business needs and provide technical mentorship to peers

Benefits

• Enjoy an excellent work/life balance.
• Receive paid time off with vacation, sick and personal leave.
• Receive 11 paid holidays per year.
• Receive regular pay increases; 1st increase after 4 months.
• Receive an extensive benefits package; including Medical and FREE Vision, Dental and Basic Life Insurance after completion of eligibility period.
• Experience growth opportunities within organization.
• Participate in employee tuition reimbursement programs.
• Receive a pension plan with 14%25 employer contribution.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree