Database Administrator

Important Recruitment Information for this vacancy Job Posting closes: Open Until Filled Agency Information: The Kansas Corporation Commission (KCC) currently has a vacancy for an unclassified Database Administrator for the Topeka, Kansas location . The KCC is a multi-faceted agency responsible for regulating public utilities including electric, natural gas, telecommunication and water companies as well as motor carriers, oil and gas pipelines and oil and gas natural production activities. The Commission's headquarters is in Topeka with the central Conservation office in Wichita and four Conservation district offices located in Dodge City, Wichita, Chanute and Hays. About the Position This position is located in Topeka, Kansas. Who can apply: Anyone with IT database administration work Classified/Unclassified Service : Unclassified Full-Time/Part-Time: Full-Time Regular/Temporary: Regular Work Schedule: Monday - Friday 8 - 5 Eligible to Receive Benefits: Yes Veterans' Preference Eligible: Yes Search Keywords: Database Administration, KCC, Topeka, Shawnee, Kansas Compensation: $68,439 - $78,705 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 program s Visit the Employee Benefits page for more information Position Summary & Responsibilities Position Summary: THIS POSITION IS LOCATED IN TOPEKA, KANSAS and may be eligible for a hybrid (telecommuting) schedule following an evaluation period. IT Database Administration work includes designing, configuring, and managing databases to ensure the integrity, security and accessibility of the organization's data including: Defining standards for physical data storage, maintenance, access, and security administration. Performing backup and recovery using Database Management Systems. Configuring database parameters and defining data repository requirements, data dictionaries, and warehousing requirements. Designing and implementing approaches to improve database performance, capacity, and scalability. Qualifications Education: High School Diploma/GED or completion of a technical school program in information technology, or a relevant field. Minimum Required Experience: One year of experience working in designing, coding, testing and debugging database programs. Familiarity with server operating systems and simple database management. Technical Skills: Knowledge of data base manipulation languages and scripting like PowerShell, PHP, Python, Rueby, or Perl. Knowledge of SQL languages. Need to be able to create and understand database design documentation. Knowledge of REST data services. Knowledge of the Linux operating system. Preferred Certification: Certifications related to database fundamentals, database management systems (DBMS), or specific technologies used such as: Oracle Certified Associate (OCA), Microsoft Certified: Azure Database Administrator Associate, AWS Certified Database Preferred Qualifications: Ability to clearly, effectively, and respectfully communicate in a business environment both orally and in writing. Ability to establish and maintain working relationships with Agency personnel, business associates, industry, the general public and state and federal officials. Possess independent thinking and problem-solving skills and analytical thought to deal with the variety of responsibilities associated with this position including making decisions while working independently, and planning/projecting future operational needs. Experience with Microsoft Word, Excel, Access and Outlook. Post-Offer, Pre-employment Requirements: Kansas Tax Clearance Certificate required in accordance with Executive Order 2004-03. Each applicant (even non-residents) who is selected for a State of Kansas job vacancy must apply for a Tax Clearance Certificate within 10 days from the date of the offer letter by accessing the Kansas Department of Revenue's (KDOR) website at https://www.ksrevenue.gov/taxclearance.html If you need assistance with the tax clearance, please contact Kansas Department of Revenue at (785)296-3199 or by email at kdor_specialprojectsks.gov Recruiter Contact Information Name: Sandra Rak Email: Sandra.Rakks.gov Phone: 785-271-3136 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 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 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.Victorianoks.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.