|HYBRID| Azure SQL Database Administrator |DBAS3|

Job highlights
Identified by Google from the original job post
Qualifications
The successful candidate must be an influential technical leader with deep database expertise and a collaborative style that promotes a culture of innovation and well managed excellence
We are seeking an experienced Azure SQL & other Azure Database Administrator with extensive knowledge of Cloud database management with systems, security, and resilient database design
The candidate will be working with other database administrators across several database platforms, including (but not limited to): Oracle Database, Microsoft SQL Database, IBM Information Management System Database, and IBM DB2 Database
60 mos
Designing and implementing high availability solutions
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;
Designing and implementing high availability solutions
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 system
combined work experience in any combination of the following:
Designing and implementing high availability solutions
Equivalent of minimum class qualifications for employment noted above
18 months
30 months
Database Administration
Database Administration
Benefits
Occasional training or professional development opportunities may require travel
This position is in the State of Ohio’s OCSEA Pay Schedule, Pay Range 36
Unless required by legislation or union contract, starting salary will be the minimum salary of that pay range (step 1, currently $42.74 per hour)
These ranges provide a standardized pathway for pay increases
With continued employment, new hires move to the next step in the range after 6 months and annually thereafter
Cost of Living Adjustments increase wages in these ranges each fiscal year
The current step progression wages are in the table below
Pay Range 36
$42.74
$44.85
$47.06
$+7,885
$42.74
Public Assistance
Workforce Development
Unemployment Insurance
Responsibilities
Provides technical leadership that fosters database innovation and champions automation
Supports strategic planning for database architecture, resource management, and capacity planning and growth
Ensures best practices in database planning, design, configuration, performance, and resilience
Evaluates and proposes design and process improvements to achieve performance and cost optimization
Identifies inefficiencies in current database designs and oversees the implementation of improved solutions
Plans and implements capacity and resource expansion to ensure scalability of databases
Implements effective risk management controls and owns adherence to all compliance related items (exceptions, waivers, risks, technical compliance, and access control)
Leads incident resolution efforts and engages appropriate resources to complete corrective actions as quickly as possible
Manages root cause analysis and problem management activities for continuous improvement initiatives, incident reduction, and performance enhancements
Plans and participates in disaster recovery exercises, system failover planning, and testing
Conducts research and provides recommendations on database products, services, protocols, and standards in support of procurement and development efforts
Virtualized Infrastructure running various Unix, Linux, and AIX operating systems
Altering storage structures to meet the evolving needs of the Organization
Regularly updating the database security protocols, patching
Provides technical expertise in the development of technical, structural and organizational specifications
Determine appropriateness of data for storage and optimum storage organization
Designs, develops and integrates highly complex database systems for internal and external users/clients
Creates, documents and implements standards and/or complex modeling to monitor and enhance the capacity and performance of the database
Codes complex programs and derives logical processes on technical platforms
Performs complex analyses and reviews applications being released into production
Remains abreast of and analyzes new and emerging technologies and tools for applicability to the field
Provides leadership and work guidance to less experienced personnel
Work with project management to support and ensure timely and effective client communications about deployments and upgrades
Schedule: Position requires 8 hours a day/5 days a week between 7a & 6p
In the event of emergencies or service outages, work outside these hours will be required
Travel: Travel is not expected
Performing solutions design
Providing technical Tier III database support
Developing project plans with project manager
Recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases systems
Performing solutions design
Providing technical Tier III database support
Developing project plans with project manager
Recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases system
Performing solutions design
Providing technical Tier III database support
Developing project plans with project manager
Recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases systems
We will be a leader in customer satisfaction
Job description
Office of Information Services

The Office of Information Services (OIS) works to support the business functions and the delivery of health, human, and employment services through the application of information technology. OIS supports the delivery of programs to millions of recipients through the development and round-the-clock operation of automated information systems. Due to the number of end-users and technologies supported, OIS is one of the largest and most complex IT organizations within Ohio state government. Learn more about the Office by visiting the ODJFS OIS webpage.

What You’ll Do

The Ohio Department of Job & Family Services (ODJFS), Office of Information Services (OIS), is seeking an experienced database administrator who will drive high-caliber database design, solution delivery, and support in a fast-paced and collaborative environment. The successful candidate must be an influential technical leader with deep database expertise and a collaborative style that promotes a culture of innovation and well managed excellence. We are seeking an experienced Azure SQL & other Azure Database Administrator with extensive knowledge of Cloud database management with systems, security, and resilient database design. The candidate will be working with other database administrators across several database platforms, including (but not limited to): Oracle Database, Microsoft SQL Database, IBM Information Management System Database, and IBM DB2 Database.
• Provides technical leadership that fosters database innovation and champions automation.
• Supports strategic planning for database architecture, resource management, and capacity planning and growth.
• Ensures best practices in database planning, design, configuration, performance, and resilience.
• Evaluates and proposes design and process improvements to achieve performance and cost optimization.
• Identifies inefficiencies in current database designs and oversees the implementation of improved solutions.
• Plans and implements capacity and resource expansion to ensure scalability of databases.
• Implements effective risk management controls and owns adherence to all compliance related items (exceptions, waivers, risks, technical compliance, and access control)
• Leads incident resolution efforts and engages appropriate resources to complete corrective actions as quickly as possible.
• Manages root cause analysis and problem management activities for continuous improvement initiatives, incident reduction, and performance enhancements.
• Plans and participates in disaster recovery exercises, system failover planning, and testing.
• Conducts research and provides recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
• Virtualized Infrastructure running various Unix, Linux, and AIX operating systems.
• Altering storage structures to meet the evolving needs of the Organization.
• Regularly updating the database security protocols, patching.
• Provides technical expertise in the development of technical, structural and organizational specifications. Determine appropriateness of data for storage and optimum storage organization.
• Designs, develops and integrates highly complex database systems for internal and external users/clients.
• Creates, documents and implements standards and/or complex modeling to monitor and enhance the capacity and performance of the database. Codes complex programs and derives logical processes on technical platforms.
• Performs complex analyses and reviews applications being released into production.
• Remains abreast of and analyzes new and emerging technologies and tools for applicability to the field.
• Provides leadership and work guidance to less experienced personnel.
• Work with project management to support and ensure timely and effective client communications about deployments and upgrades.

Schedule: Position requires 8 hours a day/5 days a week between 7a & 6p. In the event of emergencies or service outages, work outside these hours will be required.

Travel: Travel is not expected. Occasional training or professional development opportunities may require travel.

PN(s): 200388+2

Option 1

The ideal candidate, at minimum, must have the following:
• 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
• Recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases systems

AND
• 12 mos. work experience in the primary technology specified by the agency in the position description & job posting

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
• Recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases system

AND
• * 12 mos. work experience in the primary technology specified by the agency in the position description & job posting

Option 3
• Completion of undergraduate core program in computer science or information system

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

Recommending approach through defining tasks and/or leading meetings relating to design, implementation, operation and ongoing maintenance of databases systems

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

Tips For Your Application

When completing the different sections of this application, be sure to clearly describe how you meet the minimum qualifications outlined in this job posting. We cannot give you credit for your Work Experience and Education & Certifications if you do not provide that information in your online application. Information in attached resumes or cover letters must be entered into your application in the appropriate Work Experience or Education & Certification sections to be considered.

Pay Information

This position is in the State of Ohio’s OCSEA Pay Schedule, Pay Range 36. Unless required by legislation or union contract, starting salary will be the minimum salary of that pay range (step 1, currently $42.74 per hour). These ranges provide a standardized pathway for pay increases. With continued employment, new hires move to the next step in the range after 6 months and annually thereafter. Cost of Living Adjustments increase wages in these ranges each fiscal year. The current step progression wages are in the table below.

Pay Range 36

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step +

Hourly

$42.74

$44.85

$47.06

$4+.36

$51.77

$54.3+

$57.10

$5+.+4

$62.+5

Annual

$88,8++

$+3,288

$+7,885

$102,66+

$107,682

$113,131

$118,768

$124,675

$130,+36

Months of Employment

At Hire

6 months

18 months

30 months

42 months

54 Months

66 Months

78 Months

+0 Months

Organization

Job & Family Services

Agency Contact Name and Information

odjfscareers@jfs.ohio.gov

Unposting Date

Dec 8, 2024, 11:5+:00 PM

Primary Location

United States of America-OHIO-Franklin County-Columbus

Compensation

$42.74

Schedule

Full-time

Classified Indicator

Classified

Union

OCSEA

Primary Job Skill

Database Administration

Technical Skills

Database Administration

Professional Skills

Results Oriented

Primary Technology

SQL Server

Agency Overview

Who We Are

The Ohio Department of Job and Family Services (ODJFS) supports Ohioans and their families through the following programs:
• Public Assistance
• Workforce Development
• Unemployment Insurance
• Adult Protective Services
• Child Support

Public service is an honorable way to serve the community in a hands-on dedicated way. You can make a difference in someone’s world!

Guiding Principles
• We will be a leader in customer satisfaction.
• We will have a reputation that attracts and retains talented, diverse, and dedicated employees.
• We get better at what we do everyday.