SQL Developer

Mi-Case; Phoenix (AZ); Hybrid; USD 100,000 - 115,000; Full time

Job summary

A leading software solutions provider is seeking an ETL SQL Developer in Phoenix, AZ. This role involves designing and optimizing data processes using PL/SQL or T-SQL, collaborating with cross-functional teams, and ensuring efficient data integration. The ideal candidate has 4+ years of SQL development experience and possesses a Bachelor's degree in a related field. This is a full-time position that requires 3 days onsite at the Desert Ridge location.

Qualifications

• 4+ years of experience in SQL development.
• Experience with ETL processes.
• Familiarity with source control and DevOps is a plus.

Responsibilities

• Design and develop stored procedures and triggers using PL/SQL or T-SQL.
• Build and maintain complex queries for data migration.
• Collaborate with analysts and data engineers.

Skills

Oracle PL/SQL proficiency

SQL development

Database performance tuning

Data migration experience

Analytical skills

Communication skills

Teamwork abilities

Education

Bachelor’s degree in computer science or related field

Tools

Microsoft SQL Server (T-SQL)

Source control tools

DevOps processes

Job description

This range is provided by Mi-Case. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$100,000.00/yr - $115,000.00/yr

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 will 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

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

Qualifications

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

Required Skills

• 4+ years of experience in SQL development, with strong proficiency in 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.
• Experience working in Criminal Justice or Public Safety domains is a plus.

Preferred Skills

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

Additional Details

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Information Technology
• Industries: Government Administration, IT Services and IT Consulting

Note: This description reflects the role responsibilities and requirements as provided by the employer. It does not include any contingent or unrelated postings.