SQL Database Administrator II

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

Job Application Process

• First Sign in or register as a New User.
• Complete or update your contact information on the Careers> My Contact Information page. *This information is included on all your job applications. 
• Upload required documents listed below for the Careers> My Job Applications page. *This information is included on all your job applications.
• Start your draft job application, upload other required documents, and Submit when it is complete.
  • Manage your draft and submitted applications on the Careers> My Job Applications page.
• Check your email and My Job Notifications for written communications from the Recruiter.
  • Email – sent to the Preferred email on the My Contact Information page
  • Notifications – view the Careers> My Job Notifications page

Helpful Resources at jobs.ks.gov: “How to Apply for a Job – Instructions” and “How to Search for a Job – Instructions"

Required Documents for this Application to be Complete

Upload these on the Careers - My Job Applications page

• Transcripts
• DD214 (if you are claiming Veteran’s Preference)

Upload these on the Attachments step in your Job Application

• Resume
• Cover Letter

Helpful Resources at jobs.ks.gov: “How, What, & Where do I Upload Documents” 

How to Claim Veterans Preference

Veterans' Preference Eligible (VPE): Former military personnel or their spouse that have been verified as a "veteran"; under K.S.A. 73-201 will receive an interview if they meet the minimum competency factors of the position.  The veterans' preference laws do not guarantee the veteran a job.  Positions are filled with the best qualified candidate as determine by the hiring manager.

Learn more about claiming Veteran’s Preference

How to Claim Disability Hiring Preference

Applicants that have physical, cognitive and/or mental disabilities may claim an employment preference when applying for positions. If they are qualified to meet the performance standards of the position, with or without a reasonable accommodation, they will receive an interview for the position. The preference does not guarantee an applicant the job, as positions are filled with the best qualified candidate as determined by the hiring manager.

Learn more about claiming Disability Hiring Preference

PLEASE NOTE: The documentation verifying a person's eligibility for use of this preference should not be sent along with other application materials to the hiring agency but should be sent directly to OPS. These documents should be sent either by fax to (785)296-7712, scanned and emailed to Gustavo.Victoriano@ks.gov, or can be mailed/delivered in person to:

ATTN: Disability Hiring Preference Coordinator
Office of Personnel Services
Landon State Office Building
900 SW Jackson, Rm 401
Topeka, KS 66612 

Equal Employment Opportunity

The State of Kansas is an Equal Opportunity Employer.  We value diversity, equity, and inclusion as essential elements that create and foster a welcoming workplace.  All qualified persons will be considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, political affiliation, disability or any other factor unrelated to the essential functions of the job.

If you wish to identify yourself as a qualified person with a disability under the Americans with Disabilities Act and would like to request an accommodation, please address the request to the agency recruiter.

Salary : $89,440 - $90,501