Hybrid Telework Oracle Database Administrator/Database Administration Specialist 3, Office of Database, PN 20064537

Based on job duties, this position is designated as telework eligible on a hybrid basis (i.e., working at least 2 days per week in the office); the selected applicant must complete the initial training period prior to being eligible to telework. All requests to telework are reviewed and must be approved by ODOTs Chief Human Resources Officer.

Who We Are:

The Ohio Department of Transportation (ODOT) oversees building and maintaining the nation’s 5 th largest interstate system and the 2 nd largest number of bridges. We take pride in providing safe and efficient roadways for the people of Ohio and to the people traveling within our great state. And in order to achieve that, we do A LOT! From Planning, Engineering, Construction to Law, HR, Communications, IT and everything in between, ODOT has a career for just about everyone. ODOTers are hardworking, passionate, and dedicated to public service. We strive to achieve our agency’s vision every day: To be a long term, reliable, professional, and highly productive organization.

ODOT’s Mission Statement:

To provide easy movement of people and goods from place to place. We will:

-Take care of what we have

-Make our system work better

-Improve safety

-Enhance capacity

What You Will Do:

– Performing upgrades of the databases and software to new release levels

– Creating Oracle databases

– Managing users and security

– Starting up and shutting down databases

– Installing Oracle software

Who we are looking for:

– Ambitious

– Honest

– Patient

– Flexible

– Creative

Benefits to you:

-Extensive benefits including medical, vision, dental and basic life insurance

-11 paid holidays per year

-Paid time off with vacation, sick and personal leave accruals

-At least a 14% employer contribution in to your OPERS pension plan

-Pay increases pursuant to the OCSEA Collective Bargaining Agreement

-Employee Tuition reimbursement programs

-Work/Life Balance

-The opportunity to work on an important mission

Official Position Description:

Primary Technologies: Oracle and SQL Server

Designs & implements high availability solutions; designs/plans cluster nodes hardware selection & recommendations; configures/sets-up cluster nodes, sets-up interconnects, configures cluster-aware storage; installs cluster ware & DBMS software on all nodes; monitors load balance, tunes cluster parameters for high performance; configures standby servers; configures & implements log shipping; configures & implements replication. Works with IT Architecture staff, CIO &/or IT Managers to design solutions that meet agency requirements; assists with analysis of the solution design’s business case; authors portions of the solution business case. Understands business intelligence data needs; defines the data warehouse/business intelligence design; implements data warehouses & data marts; implements business intelligence tools & user interfaces; implements enterprise reporting, management dashboards & scorecards; implements analytic applications; replicates & transforms data for business intelligence. Develop standards/best practices; creates documentation of installation procedures monitoring procedures, security policies, configuration changes, migration procedures & 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. Works with multidimensional models.

Develops database strategies to support business needs. Applies principles, theories, practices & techniques of project planning. Plans & conducts formal mentorship activities for peers &/or lower-level staff via verbal instruction or technical documentation.

Job duty, knowledge, skill, & ability statements at a lower-level are understood to be able to be performed at any higher level.

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.

Job Category
Job Type
Salary
Country
City
Career Level
Company
JOB SOURCE