Database Administrator II

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., 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:

Development of database components and processes.

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., * 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.

Do you have a valid Driver's License license?, Do you have experience in Windows?, Do you have a Bachelor's degree?, 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., Post-Offer, Pre-employment Requirements: Must possess and maintain a valid driver's license. Must pass a criminal history records check.

Pulled from the full job description

• Military leave
• Parental leave
• Health insurance
• Employee discount
• Vision insurance
• Dental insurance
• Bereavement leave, Helpful Resources at jobs.ks.gov: "How, What, & Where do I Upload Documents" and "Save Tax Clearance Certificate as a PDF"