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. #LI-PSC 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. Agency Statement We are not accepting resumes from Third Party Recruiting Firms for this position. If you are an Agency or Search firm representative, contact the Primoris Talent Acquisition Manager directly for consideration. Primoris or its subsidiaries will not be responsible for any fees arising from the use of resumes and online response forms through this source. In addition, Primoris or its subsidiaries will not be responsible for any fees on unsolicited resumes that are submitted to any member of the Staffing or Operations team. Primoris has established an approved vendor program for this service and will only consider accepting submissions from those approved firms. For consideration in becoming an approved vendor, contact HR. 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.

Requirements

Must-haves

Database Developer
Gather and analyze business and technical requirements; design, develop, test, and implement secure, reliable, and maintainable database solutions.
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.
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.
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.

Nice-to-haves

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.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: workday
Effort: long

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Paid Time Off