SQL & Data Solutions Engineer – ERP & Migrations

100 Primoris Services Corporation; Town of Texas (WI); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

401k w/employer match

Health/Dental/Vision insurance plans

Paid time off

10 paid holidays

Stock purchase plan

Job summary

Primoris Services Corporation is seeking a Database Developer to design, develop, optimize, and support database solutions that enable business operations, application integrations, reporting, and data migration initiatives.

You will write efficient T-SQL code, develop database objects, troubleshoot database-related issues, and partner with technical and business teams to deliver reliable, secure, and maintainable data solutions.

Qualifications

• Minimum of 2 years of experience in database development or a related database-focused role.
• Strong experience writing, troubleshooting, and optimizing T-SQL code, including queries, stored procedures, views, functions, and triggers.
• Solid understanding of data management practices, including SQL permissions, security, monitoring, performance tuning, and data modelling.

Responsibilities

• Gather and analyse business and technical requirements; design, develop, test, and implement secure, reliable, and maintainable database solutions.
• Develop, maintain, and optimise T-SQL queries and database objects, including stored procedures, views, functions, triggers, and conversion scripts, to support business operations, reporting, system integrations, and data migrations.
• Apply database development and data management best practices, including data modelling, security and permissions, monitoring, performance tuning, storage, organisation, coding standards, and maintainability.
• Troubleshoot database-related incidents, including query performance, application connectivity, failed integrations, data discrepancies, and production defects; identify root causes and implement and document corrective actions.
• Partner with development, infrastructure, application, and business teams to maintain stable and secure database environments, evaluate database tools and services, and deliver improvements aligned with organisational objectives.

Skills

T-SQL

SQL optimization

Data modelling

Analytical skills

Communication

Education

Bachelor's in MIS/CS/CE

Tools

Viewpoint Vista

SSIS

Crystal Reports

SSRS

Job description

Primoris Services Corporation is seeking a Database Developer to design, develop, optimize, and support database solutions that enable business operations, application integrations, reporting, and data migration initiatives.

You will write efficient T-SQL code, develop database objects, troubleshoot database-related issues, and partner with technical and business teams to deliver reliable, secure, and maintainable data solutions.