SQL Database Administrator II

SQL Database Administrator II Job

ID220893

Location Shawnee County Full/Part TimeFull-Time AgencyDept of Health & Environment Job Posting Important Recruitment Information for this vacancy Job Posting closes: May 12, 2026 Required documents uploaded by: May 12, 2026

Kansas Department of Health and Environment:

Our agency is led by Secretary Janet Stanek, who was appointed by Gov. Kelly in Dec 2021. KDHE is comprised of three divisions: Public Health, Environment, and Health Care Finance (which includes the State's Medicaid program, KanCare). We are the only agency in the nation to have these three entities under one roof which allows us to take a holistic approach to improving and protecting the health and well-being of all Kansans. Verification of identity and employment eligibility to work in the United States is required by federal law. For a list of acceptable documents that establish these criteria, please refer to the federal Form

I-9. KDHE

does not provide sponsorships for this position.

E-Verify:

Kansas Department of Health and Environment (KDHE) participates in E-Verify and will provide the federal government with your I-9 information to confirm that you are authorized to work in the U.S. For additional information regarding E-Verify, please click here. For additional information regarding Immigrant and Employee Rights (IER) please click here. http://www.kdhe.ks.gov/ About the Position Who can apply: KDHE Agency Only (Employees of KDHE)

Classified/Unclassified Service:

Unclassified

Full-Time/Part-Time:

Full-Time

Regular/Temporary:

Regular

Work Schedule:

Monday-Friday, 8am-5pm (Flexible schedules available) Eligible to

Receive Benefits:

Yes

Veterans' Preference Eligible:

Yes

Sponsorship:

KDHE does not provide sponsorship for this position.

Compensation:

Hourly Pay Range:

$43.00 - $43.51 • Salary can vary depending upon education, experience, or qualifications. Employment Benefits Comprehensive medical, mental, dental, vision, and additional coverage Sick & Vacation leave Work-Life Balance programs: parental leave, military leave, jury leave, funeral leave Paid State Holidays (designated by the Governor annually) Fitness Centers in select locations Employee discounts with the STAR Program Retirement and deferred compensation programs Visit the Employee Benefits page for more information… Position Summary & Responsibilities

Position Summary:

The SQL Database Administrator II position (K0227357) will design, implement, and maintain new SQL Server databases. Modify existing databases and database management systems or work directly with programmers and analysts to make these changes. Test database related programs and databases, correct errors and make necessary modifications. Specify users and user access levels for each database. Design, develop, implement and maintain SSIS packages. Work on data acquisition, data import, data export and data management activities. Manage physical database resources to include: assist in installation and specify initial installation options; perform database software maintenance; review and monitor system and instance resources to insure continuous database operations (i.e. database storage, memory, CPU, network usage, and I/O contention); and upgrade/migrate databases to current release levels. Serve as a back Oracle database administrator. Cross train the Oracle database administrator to learn the SQL Server administration duties and skills. Design, implement, and maintain new Oracle Server databases. Modify existing databases and database management systems or work directly with programmers and analysts to make these changes. Test database related programs and databases, correct errors and make necessary modifications. Specify users and user access levels for each database. Design, develop, implement and maintain Oracle jobs. Work on data acquisition, data import, data export and data management activities. Manage physical database resources to include: assist in installation and specify initial installation options; perform database software maintenance; review and monitor system and instance resources to insure continuous database operations (i.e. database storage, memory, CPU, network usage, and I/O contention); and upgrade/migrate databases to current release levels. Job Responsibilities may include but are not limited to the following: Direct and monitor the work of the junior DBA position. Train the JDBA as needed and report progress and performance to supervisor. Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. Approve, schedule, plan and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases. Monitor database performance and take steps, when necessary, to improve performance. Implement, maintain, and test backup and recovery strategies. Review procedures for making changes in database management systems manuals. Review project requests describing database user needs to estimate time and costs required to accomplish projects. Train users and answer questions.

Kansas Tax Clearance Certificate:

A valid Kansas Tax Clearance Certificate is a condition of employment for all employees of the State of Kansas. Applicants (including non-residents) who receive a formal job offer for a State job, are required to obtain a valid Tax Clearance within ten (10) days of the job offer. A Tax Clearance can be obtained through the Kansas Department of Revenue who reviews individual accounts for compliance with Kansas Tax Law. If you have a missing tax return(s) or you owe taxes to the State of Kansas, please know that the Kansas Department of Revenue will work with you. The Kansas Department of Revenue can set you up on a payment plan to receive a Tax Clearance so you can get a job working for the State of Kansas. The Kansas Department of Revenue can be contacted at 785-296-3199. Kansas Department of Revenue - Tax Clearance Frequently Asked Questions Qualifications

Education:

High School, GED

Licensing & Certification:

Valid Driver's License - Incumbent is required to have and maintain a valid driver's license when operating a state vehicle, a private vehicle, or a rental vehicle for the benefit of the State.

Minimum Qualifications:

Successful completion of 24 hours in computer science coursework or certification and three years experience designing/analyzing, coding, testing, debugging database programs or system software programming and analysis or four years experience designing/analyzing, coding, testing, debugging database programs or system software programming and analysis.

Preferred Qualifications:

4 years direct experience with Information Technology or computer information systems. 2 years direct experience with Information Technology or computer information systems. Microsoft Office Proofreading, editing, attention to detail

SQL, SSIS, VB.NET, C

#, Windows Server SQL Server 2000+, T-SQL, Oracle Organizational skills Communication skills At least 3-5 years of experience with Oracle and SQL Server 2000+. Expert in Microsoft SQL Server 2000+ administration. Expert in relational database design. Very knowledgeable with writing SQL Queries. Strong knowledge of writing Stored Procedures. Knowledge of database driven Internet applications. Very knowledgeable in SSIS.

Post-Offer, Pre-employment Requirements:

Recruiter Contact Information

Name:

Melody Hazard

Email:

melody.hazard@ks.gov

Mailing Address:

1000 SW Jackson St. Suite 580 Topeka, KS 66612