Database Administrator

Important Recruitment Information for this vacancy

• Job Posting closes: Open until Filled
• Required documents uploaded by: All required documents listed below must be attached to your application within 2 days of applying for your application to be considered complete.

Agency Information:

Kansas Department for Aging and Disability Services

Protecting Kansans, Promoting Recovery and Supporting Self Sufficiency

About the Position

Who can apply: Anyone

Classified/Unclassified Service: Unclassified

Full-Time/Part-Time: Full-Time

Regular/Temporary: Regular

Work Schedule: M-F

Eligible to Receive Benefits: Yes

Veterans' Preference Eligible: Yes

Disability Preference Eligible: Yes

Search Keywords: Database Administrator

Compensation: Up to a maximum salary of $59,140 annually.

• 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 incumbent identifies and documents requirements for new or modified database systems within the Kansas Department for Aging and Disability Services (KDADS). The incumbent develops database specifications based on requirements, then creates and documents database structures, definitions and constraints in the Oracle database environments. The incumbent develops, tests, documents, installs and maintains software for creating database structures, loading into and extracting from databases, performing data edits and security procedures, interfacing databases with systems external to KDADS, and performing database maintenance activities. The incumbent maintains documentation of data definitions and usage within KDADS systems. Software and databases developed and maintained by the Applications Development Branch perform statewide, mission-critical capture, storage, processing and dissemination of data on KDADS program customers, their health, their financial and social conditions, the services they receive, and fiscal and performance measures of program effectiveness and efficiency.

Job Responsibilities may include but are not limited to the following:

Database configuration and maintenance

Configures and maintains Oracle database instances on agency servers, including disk space allocation, security, synchronization of multiple database instances, performance monitoring, and performance tuning. Performs database backups and data recovery, configures database user accounts, and manages Unix files involved with database exports and imports.

Development

Performs database modeling, development and testing with desktop computers. Produces routine documents, e-mail and spreadsheets using office automation software.

Determines Processing Requirements

Determines and documents requirements for processing and storing business data in KDADS information systems. Uses automated tools to model databases and generate program code. Integrates software products with database system. Tests and documents application software using the database. Corrects errors in data values or processing logic. Assists users with use and interpretation of stored data. Reviews project requests describing database user needs to estimate time and costs required to accomplish project goals.

Provides Information Security Systems

Plans, coordinates, and implements security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.

Completes special projects and performs other duties as assigned including but not limited to ensuring the agency is adequately staffed during and immediately following natural and/or manmade disasters, infectious disease outbreaks, and/or acts of terrorism. Assists other employees in the work unit in accomplishing assignments as necessary.

Qualifications

Minimum Requirements:

• Successful completion of 24 hours in computer science coursework or certification and one year experience designing/analyzing, coding, testing, debugging database programs or system software programming and analysis or two years' experience designing/analyzing, coding, testing, and debugging database programs or system software programming and analysis.
• Oracle Server environment (Solaris and Windows)
• Oracle Application Server – installation, maintenance, tuning, with cross-database integration.
• Oracle Data Base administration – from 10g through current Oracle data base release configuration.
• SQL Server DBMS experience.
• Extensive knowledge of SQL, SOA services, Java, JavaScript, XML, and HTML
• Travel

Post-Offer, Pre-employment Requirements:

• Must be able to pass a background check prior to employment.

Recruiter Contact Information

KDADS – Human Resources Recruiter

503 S. Kansas Ave

Topeka, KS 66603

Phone:

Fax:

Email:

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 : "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

• DD214 (if you are claiming Veteran's Preference)

Upload these on the Attachments step in your Job Application

• Cover Letter
• Resume

Helpful Resources at : "How, What, & Where do I Upload Documents"

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 Kansas Department of Revenue - Tax Clearance Frequently Asked Questions

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 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 scanned and emailed to , or can be mailed/delivered in person to:

ATTN: Disability Hiring Preference Coordinator

Office of Personnel Services

Docking State Office Building

915 SW Harrison Ave, Suite 260

Topeka, KS 66612

Equal Employment Opportunity

The State of Kansas is an Equal Opportunity Employer. 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 : $59,140