SQL/ETL Developer

Mi-Case; Indianapolis (IN); On-site; USD 105,000 - 145,000; Full time

Job summary

Mi-Case in the United States is seeking an ETL SQL Developer to design, develop, and optimize data integration and migration solutions. You will work with PL/SQL or T-SQL to create procedures, views, and scripts while ensuring performance and scalability.

The role emphasizes collaboration with analysts, data engineers, and project managers to meet business requirements. Expect on-site work three days a week at the Desert Ridge location.

Qualifications

• 8+ years of experience in SQL development, with strong proficiency in Postgre pgSQL, Oracle PL/SQL (preferred) or Microsoft SQL Server T-SQL.
• Experience with data migration, ETL processes, and database performance tuning.
• Familiarity with source control tools and DevOps processes is a plus.
• Ability to read and understand existing codebases and refactor or optimize as needed.
• Strong analytical and debugging skills.
• Excellent communication and teamwork abilities.

Responsibilities

• Collaborate with analysts and data engineers to understand requirements and implement reliable data solutions.
• Design, develop, and optimize stored procedures, triggers, functions, and views using PL/SQL (preferred) or T-SQL or PL/SQL.
• Act as an Architect for Data Migration on Licensing Models, document database designs, coding standards, and technical specifications.
• Build and maintain complex queries and scripts to support data migration, reporting, and integration tasks.
• Analyze legacy system data structures and participate in data mapping and conversion efforts.
• Participate in code reviews, performance tuning, and troubleshooting.
• Perform unit testing and support QA with test case creation and defect resolution.
• Monitor and maintain database jobs, schedules, and overall performance.

Skills

SQL development

PostgreSQL

Oracle PL/SQL

T-SQL

Data migration

ETL processes

Performance tuning

Code refactoring

Communication

Teamwork

Education

Bachelor’s degree in Computer Science/IT

Tools

Source control tools

DevOps processes

Job description

Founded in 1992, Mi-Case is the industry leader in fully integrated offender management software solutions and provides industry expertise and consulting within Criminal Justice and Public Safety systems. Mi-Case leverages a unique combination of technical, functional and industry specialization as well as partnerships with key software vendors to deliver maximum value add projects.

About the Role

As an ETL SQL Developer, you will play a key role in supporting data integration, transformation, and migration efforts across various projects. You’ll be responsible for designing, developing, and optimizing stored procedures, packages, and scripts using PL/SQL (preferred) or Microsoft SQL Server (T-SQL). This role requires strong hands-on experience in relational database development, excellent problem-solving skills, and the ability to collaborate across cross-functional teams. You will work closely with application developers, data analysts, and project managers to ensure that data processes are efficient, scalable, and meet business requirements. The role will require 3 days a week on site in our Desert Ridge Location.

Responsibilities

• Collaborate with analysts and data engineers to understand requirements and implement reliable data solutions.
• Design, develop, and optimize stored procedures, triggers, functions, and views using PL/SQL (preferred) or T-SQL or PL/SQL.
• Act as an Architect for Data Migration on Licensing Models, document database designs, coding standards, and technical specifications.
• Build and maintain complex queries and scripts to support data migration, reporting, and integration tasks.
• Analyze legacy system data structures and participate in data mapping and conversion efforts.
• Participate in code reviews, performance tuning, and troubleshooting.
• Perform unit testing and support QA with test case creation and defect resolution.
• Monitor and maintain database jobs, schedules, and overall performance.

Qualifications

• Bachelor’s degree in computer science, Information Technology, or a related field.

Required Skills

• 8+ years of experience in SQL development, with strong proficiency in Postgre pgSQL, Oracle PL/SQL (preferred) or Microsoft SQL Server T-SQL.
• Experience with data migration, ETL processes, and database performance tuning.
• Familiarity with source control tools and DevOps processes is a plus.
• Ability to read and understand existing codebases and refactor or optimize as needed.
• Strong analytical and debugging skills.
• Excellent communication and teamwork abilities.

Preferred Skills

• Experience with source control tools and DevOps processes.
• Experience working in Criminal Justice or Public Safety domains.