Primary Location: United States of America-OHIO-Franklin County-Columbus

Work Locations: Children&Youth N. High Complex 246 North High Street Columbus 43215

Organization: Department of Children and Youth

Classified Indicator: Classified

Bargaining Unit / Exempt: Exempt

Schedule: Full-time

Compensation: $40.70

Unposting Date: May 1, 2024, 10:59:00 PM

Primary Job Skill: Database Administration

Technical Skills: Cloud computing, Data Analytics, Network Administration, Database Administration, Information Technology

Professional Skills: Attention to Detail, Collaboration, Continuous Improvement

Primary Technology: ORACLE

Agency Contact Name: DCY Human Resources

Agency Contact Information: DCY.HumanResources@childrenandyouth.ohio.gov

Database Administration Specialist 3

(240003YX)

Job Duties

About us:

Our mission is to promote positive, lifelong outcoming for Ohio youth through early intervention, quality education, and family support programs.

At DCY, we offer our employees a rewarding work experience in public service helping Ohioans achieve a sustainable lifestyle that includes generous benefit options and a flexible work life balance making our agency a great place to work!

• Low-cost health care benefits with FREE dental and vision after completed eligibility period

• Guaranteed 11 paid holidays each year

• Significant employer paid OPERS contributions

• Employee tuition reimbursement programs

• Wellness incentives for healthcare participants

• And much more!

To learn more about DCY, please visit our website at Department of Children and Youth | Ohio.gov.

Major Duties and Responsibilities

Under general direction, designs and implements high availability solutions, performs solutions design, provides technical Tier III support, develops project plans with project manager, or recommends approach through defining tasks and/or leading meetings relating to design, implementation, operation, and ongoing maintenance of databases systems: designs/plans cluster nodes hardware selection and recommendations; configures/sets-up cluster nodes, sets-up interconnects, and configures cluster-aware storage; installs cluster ware and database management system (DBMS) software on all nodes; monitors load balance and tunes cluster parameters for high performance; configures standby servers; configures and implements log shipping; configures and implements replication; works with IT Architecture staff, Chief Information Officer (CIO), and/or IT Managers to design solutions that meet agency requirements; assists in analysis of the solution design's business case; authors' portions of the solution business case.

Determines business intelligence data needs; 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; develops standards/best practices; creates documentation of installation procedures, monitoring procedures, security policies, configuration changes, migration procedures, and best practices for development teams.

Conducts performance tuning system configuration running on multiple platforms; tunes data manipulation model; designs standards for the exchange of data between systems, including data security models; analyzes multi-dimensional models.

Develops database strategies to support business needs; applies principles, theories, practices, and techniques of project planning to assist IT Project Managers in achieving successful project outcomes; plans and conducts formal mentorship activities for peers and/or lower-level staff via verbal instruction or technical documentation.

Job duty, knowledge, skill, and ability statements at a lower-level are understood to be able to be performed at any higher level. May be placed on-call 24 hours a day, 7 days a week. Required to carry and respond to pager/cellular phone as assigned. Travel required, as needed. Must provide own transportation or, in order to operate a state vehicle, you must have a valid drivers license.

Hybrid Work Details

Subject to DCYs teleworking policy and an approved teleworking agreement, this position is eligible to work from a remote location on a hybrid basis. The selected applicant may be required to complete initial trainings prior to being eligible to telework. All requests to telework are reviewed on a case-by-case basis and must be approved by DCY’s Deputy Director of Human Resources and management, subject to the conditions outlined in the agency policy and teleworking agreement.

Drug-Free Workplace

The State of Ohio is a drug-free workplace which prohibits the use of marijuana (recreational marijuana/non-medical cannabis). Please note, this position may be subject to additional restrictions pursuant to the State of Ohio Drug-Free Workplace Policy (HR-39), and as outlined in the posting.

Qualifications

OPTION 1

• Completion of undergraduate core program in computer science or information systems; AND
• 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

OPTION 2

• Completion of associate core program in computer science or information systems; AND
• 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.

OPTION 3

• 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.

OPTION 4

• Equivalent of minimum class qualifications for employment noted above.

Preferred minimum qualifications:

• Experience in maintaining/managing the Relational databases such as ORACLE/MSSQL are very essential to this position.
• Hands on Experience with RAC (Real Application Clusters), multitenancy, and Data Guard will also be essential to maintain large scale databases/applications. Experience in managing databases in UNIX/Linux/AIX environments is preferrable.
• Experience with Always On and clustering will be required to support MSSQL Server environments.
• PL/SQL skills in Oracle & SQL server environment will be a plus.

• 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 ADA Statement

Ohio is a Disability Inclusion State and strives to be a model employer of individuals with disabilities. The State of Ohio is committed to providing access and inclusion and reasonable accommodation in its services, activities, programs and employment opportunities in accordance with the Americans with Disabilities Act (ADA) and other applicable laws.

Knowledge of: oral and written communication tools and techniques, customer support and personal service, technical writing and documentation practices, technology design, mathematic principles relative to assigned area in IT, IT principles, methods and practices in assigned specialty area, state and agency policy, procedures and applicable laws*, vision, mission and goals of agency*, systems performance management, IT lifecycle concepts, project management principles and methods, develop system specific specifications, back-up and recovery procedures, interrelationships of multiple IT specialties, database management principles and methodologies for data modeling, database management principles and methodologies for data structures, warehousing, transaction, and high availability processing.


Skill for: reading comprehension, speaking, service orientation, troubleshooting, critical thinking, using data recovery tools and techniques, complex problem solving, judgment and decision making, assuring quality, identifying and specifying business requirements, lead work, database analysis and evaluation, developing and interpreting policy and strategies governing the planning and delivery of IT services.

Ability to: prepare meaningful, accurate and concise reports, stay abreast of current technologies in area of IT assigned provide expert technical advice, guidance, and recommendations to management and other technical specialists on critical IT issues, and define problems, collect data, establish facts and draw valid conclusions.

(*)Developed after employment.

Unless required by legislation or union contract, starting salary will be the minimum salary of the salary range 36 (step 1, currently $40.70 per hour) associated with this position.

All answers to the supplemental questions must be supported by the work experience/education provided on your civil service application.

Unless the posting requires, please do not include attachments, as attachments will not be considered as part of your application.

Background Check Information

Background Check Information

The final candidate selected for the position will be required to undergo a criminal background check. Criminal convictions do not necessarily preclude an applicant from consideration for a position. An individual assessment of an applicant's prior criminal convictions will be made before excluding an applicant from consideration.

Status of posted positions

You can check the status of your application online be signing into your profile and clicking the “My Jobpage” tab to view completed submissions and submission details. If you have questions other than your applications status, please direct them to DCY.HumanResources@childrenandyouth.ohio.gov.