Database Administrator

Job Posting

Important Recruitment Information for this vacancy:

Kansas Bureau of Investigation

The Kansas Bureau of Investigation is the premier criminal investigative agency in the state of Kansas. The KBI is committed to its critical mission of preventing crime and enhancing public safety in Kansas. We employ individuals who exemplify the highest standards of integrity, service, and dedication. Come feel like you're part of something bigger at the KBI.

Kansas Bureau of Investigation

E-Verify: The Kansas Bureau of Investigation (KBI) 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.

About the Position:

• Who can apply: Anyone

• Classified/Unclassified Service: Unclassified

• Full/Part-time: Full-Time

• Regular/Temporary: Regular

• Work Schedule: Monday

• Friday

• Eligible to Receive Benefits: Yes

• Veterans' Preference Eligible: Yes

• Search Keywords: IT, Database, Topeka, KCJIS

Compensation:

• Annual Salary Base:

• Hourly Pay Base: Starting Pay is $31.00

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

• 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 Kansas Bureau of Investigation (KBI) accepting applications to fill an IT Database Administrator position. This position is a specialized Information Technology position that requires prior experience. Dependent on the experience level of the selected candidate, some of the duties involved in database administration at the KBI will include;

• Implementation and maintenance of complex SQL database solutions used for the electronic collection, storage and dissemination of information belonging to the KBI and the Kansas Criminal Justice Information System (KCJIS);

• Implementation and maintenance of data structures;

• Monitoring and implementation of routines for the security and transport of data;

• Ensuring consistent backups are conducted;

• Installing patches and new versions of database software

• Supporting a variety of database oriented systems.

The position will have daily contact with KBI administrative personnel, project management, application development and technical staff. There is continuous contact with supervisors and employees of other units involved in the criminal justice functions of the bureau for information and data integrity.

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

• Implement and maintain agency databases using best practice and KBI standards and procedures. Maintain and test database backup and restore procedures. Coordinate data storage requirements to sustain each application's functionality.

• Review requested database changes and possible issues with application developers, users and project management to coordinate the implementation of changes and to correct identified issues. Estimate work and risks of proposed changes and modifications.

• Maintain and monitor interfaces, internal databases, and external database interfaces.

• Monitor the database management systems, including database growth and database maintenance procedures to proactively identify and correct possible issues.

• Monitor system performance and help identify and implement performance and tuning changes to provide effective and efficient information storage and processing systems.

• Coordinate with program leads to design and maintain data quality checks, and reports, for critical data elements of key databases.

• Research and review database system upgrades. Maintain knowledge of database server systems to help ensure proper planning for application upgrades, projects and other changes.

ADDITIONAL DUTIES

Employees are required to follow any other job-related instructions and to perform any other job-related responsibilities as requested by their supervisor.

• Options for telework part time after initial probation period with performance checks and certain security limitations.

Qualifications:

Minimum Qualifications

• Two years' experience designing/analyzing, coding, testing, debugging database programs or system software programming and analysis

• Experience working with common database administration tools (SQL Management Studio, Red Gate).

• Advanced knowledge of the implementation and maintenance of Microsoft SQL Server.

• Experience working with the design and management of databases within Microsoft SQL Server, including backup and recovery procedures.

• Experience working with Transact-SQL data manipulation language.

• Knowledge of relational database concepts and data migration concepts.

Preferred Qualifications

• Experience within a criminal justice system.

• Experience with Microsoft Excel and Access

• Experience with common SQL reporting tools

• Knowledge of complex data indexing systems and management

• Knowledge of master data management (MDM) concepts and design

• Experience with non-relational database management systems

• Knowledge of database normalization and de-normalization concepts and techniques

• Successful completion of 24 hours in computer science coursework

Physical requirements

• Prolonged periods sitting or standing at a desk and working on a computer.

Post-Offer, Pre-employment Requirements

• As a condition of employment, you will be subject to a pre-employment process to include a polygraph examination, fingerprint based records check, and comprehensive background investigation, including reference check of past and present employers. The pre-employment process will be waived for current KBI personnel who have previously completed the screening requirements

Recruiter Contact Information:

• Name: Luci Zieman

• Email: HumanResources@kbi.ks.gov

• Phone: 785-296-8200

• Mailing Address: 1620 SW Tyler; Topeka, KS 66612

Required documents for this application to be complete:

• On the My Job Applications page, verify these documents are present and valid. Upload or delete and upload new if needed.

• Tax Clearance Certificate, valid

• Transcripts

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

• Inside your Job Application upload these documents:

• Resume (or choose existing if you have one)

• Cover Letter

Kansas Tax Clearance Certificate Required: Each applicant (even non-residents) applying for a State of Kansas job vacancy must obtain a valid Kansas Certificate of Tax Clearance by accessing the Kansas Department of Revenue's website. A Tax Clearance is a comprehensive tax account review to determine and ensure that an individual's account is compliant with all primary Kansas Tax Laws. A Tax Clearance expires every 90 days. All applicants, including current state employees, are responsible for submitting a valid certificate with all other application materials to the hiring agency. This is in accordance with Executive Order 2004-03. If you need assistance with the tax clearance, please contact 785-296-3199.

Visit the Tax Clearance site for more information and where to obtain this Kansas Department of Revenue document.

Job Application Process

• Sign in to your existing account or Register for a new one to apply.

• Complete or review your contact information on the My Contact Information page.

• Upload documents listed in the Required Documents section of the job posting to the appropriate location.

• Check your email and My Job Notifications for written communications from the Recruiter.

• Email - sent to the preferred email listed on the My Contact Information page

• Notifications - view the Careers

• My Job Notifications page

To assist in completing your application, please see helpful links below:

• Instructions:

• Job Search

• Registration & User Account

• Application

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

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 recruiter.