Database Administration Specialist 3, Office of Database, PN 20064558

Ohio Department of Administrative Services • Ohio Township, KS

6h

About The Position

Database Administration Specialist 3, Office of Database, PN 20064558

Database Administration Specialist 3, Office of Database, PN 20064611
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.
Benefits to you:
· 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.
For a list of all the State of Ohio benefits, please visit the Total Rewards website!

Requirements

• 60 mos. combined work experience in any combination of the following: designing and implementing high availability solutions, performing solutions design, providing technical Tier III database support, developing project plans with project manager or recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases systems 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: designing and implementing high availability solutions, performing solutions design, providing technical Tier III database support, developing project plans with project manager or recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases systems 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: designing and implementing high availability solutions, performing solutions design, providing technical Tier III database support, developing project plans with project manager or recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases systems 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. Note: 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 to ensure maximum system uptime.
• 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 to ensure efficiency.
• Establish data exchange standards, define security models, and maintain technical documentation for installation and monitoring.
• 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