Database Developer

100 Primoris Services Corporation; Town of Texas (WI); On-site; USD 80,000 - 115,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, reporting, and data migration initiatives. You will write efficient T-SQL, develop objects, troubleshoot issues, and partner with teams to deliver secure, maintainable data solutions.

The role emphasizes data management practices, security, performance tuning, and collaboration with project teams and stakeholders to drive reliable data

Qualifications

• Minimum 2 years' experience in database development or related role.
• Strong experience writing, troubleshooting, and optimizing T-SQL code (procedures, views, functions, triggers).
• Solid understanding of data management, SQL permissions, monitoring, and modeling.
• Bachelor's degree in MIS/CS/CE or equivalent experience.

Responsibilities

• Gather and analyze business and technical requirements; design, develop, test, and implement secure, reliable database solutions.
• Develop, maintain, and optimize T-SQL queries and database objects to support operations, reporting, and migrations.
• Apply database development and data management best practices (security, monitoring, performance tuning, data modeling).
• Support ERP conversion and modernization, including data cleansing, migration validation, and post-implementation support.
• Troubleshoot incidents related to queries, connectivity, integrations, and production defects; document corrective actions.
• Collaborate with development, infrastructure, application, and business teams to improve database environments.
• Review code and provide feedback to ensure quality and adherence to standards.
• Plan work by defining tasks, estimating effort, documenting solutions, and communicating status to stakeholders.
• Participate in change management with risk assessment, deployment/rollback planning, and knowledge sharing.

Skills

T-SQL

Data modeling

Security & permissions

Performance tuning

Data management

Education

Bachelor's degree in MIS/CS/CE

Tools

Viewpoint Vista

SSIS

Boomi

SSRS

Crystal Reports

SAP

JDE

Sage

Spectrum

CMiC

Epicor

Job description

Job Overview

Database Developer Job Overview: Primoris IT is seeking a skilled Database Developer to design, develop, optimize, and support database solutions that enable business operations, application integrations, reporting, and data migration initiatives. This role is responsible for writing efficient T-SQL code, developing database objects, troubleshooting database-related issues, and partnering with technical and business teams to deliver reliable, secure, and maintainable data solutions. The ideal candidate will have strong analytical skills, a solid understanding of data management practices, and the ability to communicate effectively with project teams, system owners, and stakeholders.

Key Responsibilities/Accountabilities

• Gather and analyze business and technical requirements; design, develop, test, and implement secure, reliable, and maintainable database solutions.
• Develop, maintain, and optimize 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 modeling, security and permissions, monitoring, performance tuning, storage, organization, coding standards, and maintainability.
• Support ERP conversion and modernization initiatives through legacy data analysis, data cleansing, conversion scripting, migration validation, reconciliation, and post-implementation support.
• 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 organizational objectives.
• Review database code and provide constructive technical feedback to promote quality, consistency, efficiency, and adherence to established development standards.
• Plan and communicate database-related work by defining tasks, estimating development and testing effort, documenting technical solutions, and reporting status, risks, dependencies, and progress to stakeholders.
• Participate in change management by documenting proposed changes, assessing risk, preparing deployment and rollback plans, supporting Change Advisory Board reviews, validating production implementations, and promoting knowledge sharing and cross training within the team.

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 modeling.
• Bachelor's degree in management information systems, Computer Science, Computer Engineering, or a related discipline; equivalent experience may be considered.

Preferred Qualifications

• Experience working with the Viewpoint Vista database platform.
• Experience supporting or developing within construction ERP database (SAP, JDE, Sage, Spectrum, CMiC, or Epicor).
• Prior experience working in the construction industry or supporting construction-related business processes.
• Experience with SSIS, Boomi or similar integration platforms.
• Familiarity with SSRS and Crystal Reports is preferred.

Company Overview

Primoris Services Corporation is a premier specialty contractor providing critical infrastructure services to the utility, energy, and renewables markets throughout the United States and Canada. Built on a foundation of trust, we deliver a range of engineering, construction, and maintenance services that power, connect, and enhance society. On projects spanning utility-scale solar, renewables, power delivery, communications, and transportation infrastructure, we offer unmatched value to our clients, a safe and entrepreneurial culture to our employees, and innovation and excellence to our communities. To learn more, visit www.prim.com and follow us on social media at @PrimorisServicesCorporation.

Benefits

• 401k w/employer match
• Health/Dental/Vision insurance plans
• Paid time off
• 10 paid holidays
• Stock purchase plan

EEO Statement

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.

Power Your Potential. As a premier specialty contractor, we deliver critical infrastructure services to the utility and energy markets throughout the United States and Canada. We're proud to provide unmatched value to our clients, a safe work environment to our employees, and innovation to our communities. When you're part of our team, the opportunities are endless. From career advancement to worldclass benefits, we value, safeguard, invest in, and motivate our employees as we build the future, together.