Primary Technology: SQL Server
Secondary Technologies: DB2, Oracle, Database Support, IBM Z/OS
About Us:
The Ohio Department of Administrative Services (DAS), Office of Information Technology (OIT) is seeking an experienced and motivated IT professional to serve as a Database Administration Specialist 3 for the Infrastructure Services Division, Enterprise Computing Services team.
Led by Director Kathleen C. Madden, the Ohio Department of Administrative Services is the engine of state government, providing innovative solutions and supporting the efficient operation of state agencies, boards and commissions. The Office of Information Technology at DAS delivers information technology (IT) and telecommunication services to State of Ohio agencies, boards and commissions.
What You'll Do:
Designs and implements high availability solutions:
- Designs/plans cluster nodes hardware selection and recommendations.
- Configures/sets-up cluster nodes, sets-up interconnects, configures cluster-aware storage; installs cluster ware and DBMS software on all nodes.
- Monitors load balance, tunes cluster parameters for high performance.
- Configures standby servers.
- Configures and implements log shipping.
- Configures and implements replication.
- Works with IT Architecture staff, CIO and/or IT Managers to design solutions that meet agency requirements.
- Assists analysis of the solution design's business case.
- Authors' portions of the solution business case.
- Issues Tier III resolution.
- Defines the data warehouse/business intelligence design.
- Implements data warehouses and data marts.
- Implements business intelligence tools and user interfaces.
- Implements enterprise reporting, management dashboards and scorecards.
- Implements analytic applications.
- Replicates and transforms data for business intelligence.
- Develop standards/best practices.
- Creates documentation of installation procedures monitoring procedures, security policies, configuration changes, migration procedures and best practices for development teams.
- Tunes data manipulation model.
- Designs standards for the exchange of data between systems, including data security models.
- Works with multidimensional models.
- Applies principles, theories, practices and techniques of project planning.
- Plans and conducts formal mentorship activities for peers and/or lower-level staff via verbal instruction or technical documentation.
At the State of Ohio, we take care of the team that cares for Ohioans. We provide a variety of quality, competitive benefits to eligible full-time and part-time employees. For a list of all the State of Ohio Benefits, visit our Total Rewards website ! Our benefits package includes:
Medical Coverage
- Quality, affordable, and competitive medical benefits are offered through the available Ohio Med plans.
- Dental, vision, and basic life insurance premiums are free after completed eligibility period . Length of eligibility period is dependent on union representation.
- Paid time off, including vacation, personal, and sick leave
- 11 paid holidays per year
- Childbirth/Adoption leave
- The State of Ohio offers a variety of educational and professional development funding that varies based on whether you are a union-exempt employee or a union-represented employee.
- OPERS is the retirement system for State of Ohio employees. The employee contributes 10% of their salary towards their retirement. The employer contributes an amount equal to 14% of the employee's salary. Visit the OPERS website for more information.
- The Ohio Deferred Compensation program is a 457(b) voluntary retirement savings plan. Visit the Ohio Deferred Compensation website for more information.
Qualifications
Minimum Qualifications:
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.
-Or 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.
-Or 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.
-Or 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.
Primary Technology: SQL Server
Secondary Technologies: DB2, Oracle, Database Support, IBM Z/OS
Knowledge:
- Oral & written communication tools & techniques.
- Customer support & personal service.
- Technical writing & documentation practices.
- Technology design.
- Mathematic principles relative to assigned area in IT.
- IT principles, methods & practices in assigned specialty area.
- State & agency policy, procedures & applicable laws*
- Vision, mission & goals of agency*
- Systems performance management.
- IT lifecycle concepts.
- Project management principles & methods.
- Develop system specific specifications.
- Back-up & recovery procedure.
- Interrelationships of multiple IT specialties.
- Database management principles & methodologies for data modeling.
- Database management principles & methodologies for data structures, warehousing, transaction & high availability processing.
- DB2
- SQL Server
- Database Support
- IBM Z/OS.
- Oracle.
Skills:
- Reading comprehension.
- Speaking.
- Service orientation.
- Troubleshooting.
- Critical thinking, using data recovery tools & techniques.
- Complex problem solving, judgment & decision making.
- Assuring quality.
- Identifying & specifying business requirements.
- Lead work.
- Database analysis & evaluation.
- Developing & interpreting policy & strategies governing the planning & delivery of IT services.
Abilities:
- Prepare meaningful, accurate & concise reports.
- Stay abreast of current technologies in area of IT assigned.
- Provide expert technical advice, guidance, & recommendations to management & other technical specialists on critical IT issues.
- Define problems, collect data, establish facts & draw valid conclusions.
*Developed after employment.