IT Database Engineering Lead - Office of Judicial Administration

Position number: K0227592

Location of Employment: Kansas Judicial Center, Topeka, KS 66612

Position Title and Salary: IT Database Engineering Lead, grade 50

$84,350.00-$107,593.00 annually.

Dependent on experience and time with

Judicial Branch if applicable.

Kansas Judicial Branch Benefits State Employment Center - Benefits (ks.gov)

Internal Applicants will be given first consideration.

The Office of Judicial Administration (OJA) is seeking a highly skilled IT Database Engineering Lead to lead the design, implementation, and management of complex database systems that support the organization’s applications and data strategy. This position will serve as the lead of the data team, providing technical leadership in the development of scalable, secure, and high-performing data infrastructure. This role requires cross-functional collaboration to ensure that the data environment aligns with business goals, performance expectations, and regulatory requirements.

Primary Responsibilities:

Serve as the technical lead of the data team, guiding strategy, architecture, and best practices.

Design and specify comprehensive data architectures for databases, data warehouses, and data lake based on functional and technical requirements.

Develop logical and physical data models to ensure data integrity, consistency, and performance.

Build and implement strategies for data acquisition, archival, recovery, and database deployment.

Manage and troubleshoot data migrations, conversions, and processing issues to support application and business continuity.

Create database schemas, indexes, and views aligned with application requirements and best practices.

Write and optimize SQL queries, stored procedures, functions, and scripts to support efficient data manipulation and reporting.

Implement database backup, recovery, and high-availability solutions, including replication and clustering.

Enforce database security controls and compliance policies to safeguard sensitive data and meet regulatory requirements

Support and automated deployment tools for database development and release management.

Work with DevOps team to build pipelines that support data transformation, ETL processes, and metadata management.

Collaborate with business units and developers to understand and satisfy organizational data needs including but not limited to data sourcing, integration, classification, access and reporting. Required Education and Experience:

Education:

Bachelor’s degree in Computer Science, Information Technology, or a related field. (Education requirement can be substituted with equivalent work experience).Work Experience:

Minimum of seven (7) years of experience in database engineering, including:

Designing, implementing, and maintaining databases and / or data warehouse

Developing data models and database architecture

Performance tuning and optimization

Data migration, backup, and disaster recovery strategies

Enforcing security protocols and regulatory complianceTechnical Skills:

Expert in SQL and writing complex stored procedures, triggers, and functions

Proficient in database systems such as MySQL, PostgreSQL, Oracle, or Microsoft SQL Server

Skilled in data transformation and pipeline development using ETL tools and scripting languages (e.g., Python, Java, C++, Scala)

Strong troubleshooting and problem-solving skills related to database performance and data qualityPreferred Certifications:

Oracle Certified Professional (OCP) – Database Administrator

Microsoft Certified: Azure Database Administrator Associate

Microsoft Certified: Azure Data Engineer Associate

MongoDB Certified Database Administrator

Certified Data Management Professional (CDMP)Applications will be accepted until: Open until filled

The Americans with Disabilities Act ensures your right to reasonable accommodations during the employment process. A request for accommodation will not affect your opportunities for employment with the Judicial Branch. If you wish to request an ADA accommodation, please contact or by TDD through the Kansas Relay Center at or 711.

THE KANSAS JUDICIAL BRANCH IS AN EEO / AA EMPLOYER