Senior LEADS Database Administrator (Database Admin 3) (20059045)

State of Ohio

Columbus (OH)

On-site

USD 51,000 - 72,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Multiple pay increases over the first
Free Parking!
Free Gym Access & Walking Path!
Daycare On-site!
Cafeteria On-site!

Job summary

The State of Ohio is hiring a Senior LEADS Database Administrator (Database Admin 3) in Columbus. You will lead Oracle RAC deployments, cluster hardware planning, and database monitoring. Gain responsibility for high-availability data services within the Ohio Department of Public Safety, ensuring reliability for critical public safety operations.

Work hours are 8:00am–5:00pm with rotating on-call duties. Primary technology is Oracle, with data warehouse and ETL as secondary functions.

Qualifications

  • 60 mos. combined work experience in high availability databases and support
  • 12 mos. experience with Oracle as primary technology
  • Experience designing and implementing database systems and maintenance

Responsibilities

  • Designs and plans cluster node hardware and Oracle RAC installation
  • Configures cluster nodes/servers for Oracle RAC
  • Monitors ASM storage usage and health of databases
  • Builds and maintains OEM interface for database monitoring
  • Collaborates with IT Architecture and CIO teams on LEADS solutions
  • Monitors DB errors, performance, and work with infra on maintenance
  • Performs performance tuning on Linux, Windows and AIX

Skills

Database Administration

Tools

Oracle

Job description

Senior LEADS Database Administrator (Database Admin 3) (20059045)

Organization

Public Safety

Agency Contact

Kate Veeley | keveeley@dps.ohio.gov

Work Location

1970 West Broad Street
Columbus, Ohio, 43223-1102
United States

Compensation

$44.66 per hour

Schedule

Permanent - Full Time

Work Hours

8:00am to 5:00pm; Serve in rotating on-call schedule with team members

Classified Indicator

Classified

Union

OCSEA

Primary Job Skill

Database Administration

Primary Technology

ORACLE

Position Number

20059045

Requisition ID

req2020

Who We Are

Ohio State Highway Patrol Is aninternationally accredited agency whose mission is to protect life andproperty, promote traffic safety and provide professional public safetyservices with respect, compassion, and unbiased professionalism.

What You’ll Do

Ohio Department of Public Safety – Ohio State Highway Patrol
Report in Location: 1970 W Broad Street, Columbus 43223
Hours Worked: 8:00am to 5:00pm; Serve in rotating on-call schedule with team members

Primary Technology

Oracle

Secondary Technology

Data Warehouse, Database Support, Extract, Transform, and Load (ETL), UNIX/

Perks of Working for the Ohio Department of Public Safety
  • Multiple pay increases over the first years of service!
  • Free Parking!
  • Free Gym Access & Walking Path!
  • Daycare On-site!
  • Cafeteria On-site!
What You’ll Do as a Senior LEADS Database Administrator
  • Designs & plans cluster node hardware selection & makes recommendations on hardware requirements based on current &/or projected usage.
  • Configures & prepares cluster nodes/servers for Oracle database Real Applications Cluster (RAC) software installation.
  • Monitors cluster-aware storage (Oracle Automatic Storage Management (ASM) usage to prevent overallocation).
  • Builds, configures, uses, & maintains Oracle enterprise management (OEM) interface.
  • Works with IT Architecture staff, CIO &/or IT Managers to design solutions that meet LEADS requirements; Assists with analysis of the solution designs business case.
  • Monitors database errors, warnings, load balancing, memory usage & health; Coordinates with infrastructure team on database & system maintenance.
  • Conducts performance tuning system configuration on Linux, Windows & AIX.
Additional Information

This position is essential, meaning the duties this job performs are critical to the continued operations of the Ohio Department of Public Safety during a public safety emergency (OAC123: 1-46-01 & DAS Directive HR-D-11). This position will be required to report for duty during any public safety emergency.

Must obtain & maintain LEADS certification as mandated by Ohio Administrative Code 4501:2-10-03 (G)(3).

Background Check Information

A BCI and FBI fingerprint check, a background check, including a polygraph examination, may be required on all selected applicants. A comparative analysis and/or drug-test may be a requirement of the hiring process.

To request a disability accommodation, please emailHRRequestADA@dps.ohio.gov as soon as possible, or at least 48 hours prior tothe above referenced testing or interview date so any necessary arrangementsmay be made in a timely manner.

Why Work for the State of Ohio

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
  • Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period
  • Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
  • Childbirth, Adoption, and Foster Care leave
  • Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
  • Public Retirement Systems (such as OPERS, STRS, SERS, and HPRS) & Optional Deferred Compensation (Ohio Deferred Compensation)

*Benefits eligibility is dependent on a number of factors. The Agency Contact listed above will be able to provide specific benefits information for this position.

Qualifications

Option 1

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 (Oracle) specified by the agency in the position description & job posting.

Option 2

-Or 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 (Oracle) specified by the agency in the position description & job posting.

Option 3

-Or 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 (Oracle) 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 (Oracle) 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.

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

School Safety Intelligence Analysts (20094526 & 20100281)
School Safety Intelligence Analysts (20094526 & 20100281)

State of Ohio • Columbus (OH)

On-site
USD 38,000 - 54,000
Multiple pay increases over the first
Free Parking!
Free Gym Access & Walking Path!
+2
Database Administration Specialist 1
Database Administration Specialist 1

State of Ohio • Columbus (OH)

On-site
USD 48,000 - 70,000
Medical Coverage
Dental & Vision Insurance
Paid Time Off
+1
Mobile Training Officer (20100257)
Mobile Training Officer (20100257)

State of Ohio • Seven Hills (OH)

Remote
USD 39,000 - 52,000
Multiple pay increases over the first
Free Parking
EEO Senior Analyst (20083755)
EEO Senior Analyst (20083755)

State of Ohio • Columbus (OH)

On-site
USD 38,000 - 54,000
Multiple pay increases over your first
Database Administration Specialist 1 - PNs 20064742, 20064762
Database Administration Specialist 1 - PNs 20064742, 20064762

State of Ohio • Columbus (OH)

On-site
USD 39,000 - 56,000
Enterprise Modernization Manager (IT Manager 1)
Enterprise Modernization Manager (IT Manager 1)

State of Ohio • Columbus (OH), Akron (OH), North Dayton (OH)

On-site
USD 56,000 - 79,000
Medical Coverage
Dental, Vision and Life Insurance
Paid time off + holidays
+1
Highway Patrol Electronic Technician 1 (POOL)
Highway Patrol Electronic Technician 1 (POOL)

State of Ohio • Columbus (OH)

On-site
USD 32,000 - 43,000
Free Parking
Multiple pay increases
Maintenance Repair Worker 2 (20090098)
Maintenance Repair Worker 2 (20090098)

State of Ohio • Lancaster (OH)

On-site
USD 25,000 - 34,000
Free Parking
Multiple pay increases
Customer Service Assistant 2 20050274
Customer Service Assistant 2 20050274

State of Ohio • Columbus (OH)

On-site
USD 27,000 - 38,000
Free Parking!
Free Gym Access & Walking Path!
Daycare On-site!
+3
Information Technology Manager 1
Information Technology Manager 1

Ohio Department of Behavioral Health • Columbus (OH)

On-site
USD 41,000 - 69,000