Our Mission: Partnering to Promote Safety and Responsibility through Best Practices. Our Vision: Transforming Lives for the Safety of All. Our Beliefs: Our employees are our most influential resource. Everyone has worth and will be treated with dignity and respect through our words and actions. Everyone deserves compassion, empathy, and support. Everyone has the potential for future success through effective development and support. Transformative change is accomplished through teamwork and collaboration. Trust, honesty and transparency are essential to our success. Inclusive practices, acceptance and diversity are the foundation of our mission.
Join Us Today and Make a Lasting Difference!
Work Authorization & Employment Eligibility
The Kansas Department of Corrections (KDOC) does not sponsor employment visas for any positions and does not participate in the STEM-OPT extension program. All candidates must be legally authorized to work in the United States at the time of application and throughout the duration of employment without the need for current or future visa sponsorship.
Verification of identity and employment eligibility to work in the United States is required by federal law. For a list of acceptable documents, please refer to the federal Form I-9.
E-Verify Participation
KDOC participates in E-Verify and will provide the federal government with the information from your Form I-9 to confirm authorization to work in the United States. For more information about E-Verify, please visit E-Verify.gov. For information about your rights under the Immigrant and Employee Rights Section (IER), please visit justice.gov/crt/immigrant-and-employee-rights-section.
KDOC is an Equal Opportunity Employer. We value diversity and are committed to creating an inclusive environment for all employees.
Offered salary will be determined by experience, qualifications, and skill set that the candidate brings to the position. Though this position is unclassified, the posted starting salary is equivalent to classified Pay Grade 34, step 6. Please contact Recruitment Coordinator for further details.*
Employment Benefits
=======================
###
Comprehensive medical, mental, dental, vision, and additional coverage
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:
---------------------
This position is responsible for database architecture and modeling, database development, maintenance, and monitoring. This covers transactional databases and data warehouses as needed for business applications.
This position will provide support in transitioning from legacy system databases to new SQL and other cloud based databases.
Job Responsibilities may include but are not limited to the following:
Design of database architecture, design of databases, specification of data elements, procedures, and processes.
Working with other IT staff to develop project requirements for databases.
Monitoring database performance.
Provide user support
Other duties as assigned.
Qualifications
==================
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. Education may be substituted for experience as deemed relevant by the agency.
BA in computer technology and 3 years of experience administering and maintaining SQL Server and MySQL production database environments.
Knowledge of:
Principles and practices of database administration, including data communication protocols and topologies, and web- and windows-based software.
Database and web application domain-specific programming languages and tools.
Entity Relationship Modelling
Data warehouse and data marts
Data Flow Diagrams
Microsoft SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
Data backup and recovery processes.
Skill in:
Manage databases through all stages of the development life cycle and provide senior-level technical support in resolving database problems.
Using MS SQL systems for online analytical processing (OLAP) and data mining functionality for business intelligence applications.
Ability to diagnose and resolve technical problems.
Coordinate a variety of skilled technology services functions.
Assess user/stakeholder support needs and implement effective solutions.
Establish a good working relationship with co-workers and clients.
Work individually and in a team environment.
Communicate effectively both verbally and in writing.
Post-Offer, Pre-employment Requirements
: Must possess and maintain a valid driver's license. Must pass a criminal history background check and a drug test.
Upload these on the Careers - My Job Applications page
Tax Clearance Certificate
College Transcripts (if applicable)* DD214 (if you are claiming Veteran's Preference)*
Upload these on the Attachments step in your Job Application
Cover Letter
Resume
Helpful Resources at jobs.ks.gov: "How, What, & Where do I Upload Documents" and "Save Tax Clearance Certificate as a PDF"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
within 10 days following the offer of employment
by accessing the Kansas Department of Revenue's website. In the event that an individual who has been offered employment cannot provide proof of a tax clearance certificate, the individual will be required to enter into a payment plan with KDOR and remain current on such payment plan or make other arrangements with KDOR to achieve the tax clearance required under Executive Order 2004-03. 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 to the hiring agency. If you need assistance with the tax clearance, please contact 785-296-3199.
Visit the Tax Clearance site for more information on and where to obtain this Kansas Department of Revenue document.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.
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 Gustavo.Victoriano@ks.gov, 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.
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.
Job Detail
Job Id
JD5962801
Industry
Not mentioned
Total Positions
1
Job Type:
Full Time
Salary:
USD
Employment Status
Permanent
Job Location
KS, US, United States
Education
Not mentioned
Apply For This Job
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.