Database Developer

Summary

Primoris Services Corporation is a specialty contractor providing infrastructure services across the utility, energy, and renewables markets. The Database Developer will design, develop, optimize, and support secure database solutions, write and troubleshoot T-SQL code, support ERP conversions and data migrations, and collaborate with technical and business stakeholders.

Responsibilities

• 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

Skills

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

Qualifications

Must Haves

• 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

Benefits

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