Database Developer

Join the best in the industry at Nextech and embark on a rewarding career journey! For over 30 years, we've built our success on a foundation of Quality, Value, and Integrity, fostering enduring partnerships with thousands of satisfied customers. With over 2,000 team members nationwide, Nextech sets itself apart from other companies by being America’s largest HVAC/R service provider.

As we continue to grow, we're committed to offering an exceptional work experience for our employees with numerous opportunities for development and advancement. If you pride yourself on quality work, integrity, and dedication, we want you on our team. Nextech boasts outstanding review ratings on Indeed and Glassdoor, making it the premier destination for HVAC professionals. Elevate your career by joining Nextech today!

Role: 

The MS SQL Database Developer plays a pivotal role in the success of our organization. The MS SQL Database Developer leads the design, implementation, and maintenance of our critical Infor ERP system. Collaboration with our software development and IT teams is instrumental in guaranteeing that our database infrastructure performs optimally, remains secure, and scales effectively to meet our evolving needs.

Benefits:

• Excellent Health Insurance options including a FREE employee only option
• Dental, Vision, Accident, Critical Illness, Disability and Supplemental Life Insurance options
• FREE life insurance equal to your annualized pay rate
• 401k with a 50% match up to the first 6% of your contributions
• 7 paid Holidays
• 2 paid Personal days
• 10 paid Vacation days

• Designs, develops, and maintains SQL Server databases, including data modeling, schema design, and performance optimization
• Writes and optimizes SQL queries, stored procedures, functions, and triggers to support application development and reporting needs
• Collaborates with developers to design, develop, test, debug, and document applications within a large-scale Infor ERP system
• Analyzes organizational needs and creates effective database systems according to specifications
• Collects and analyzes data, designs algorithms, creates flowcharts, and implements code to support logic developed through algorithms and flowcharts
• Conducts database testing and performance testing to ensure proper operation
• Troubleshoots potential issues, creates and submits test reports, and recommends database improvements
• Develops and maintains database documentation and operational manuals
• Works closely with management to identify and specify complex business requirements and processes
• Integrates database modules with the front-end development team
• Provides hands-on development, support, maintenance, and enhancements as required
• Researches and evaluates alternative solutions for expanding existing system functionality and participating in planned technology enhancements
• Designs, develops and maintains Infor ISM screens
• Provides information, generates reports, and alerts from the database as needed
• Acts as an intermediary between vendors and management to drive projects to completion
• Troubleshoots and solves product defects

Applicant must have knowledge of application design including but not limited to:

• Proven experience as an MS SQL Database Developer or a similar role
• Proficiency in SQL Server, T-SQL, and SSMS (SQL Server Management Studio)
• Strong knowledge of database design principles and best practices
• Experience with database performance tuning and optimization
• Excellent problem-solving and troubleshooting skills
• Strong communication and collaboration skills
• Knowledge of other database technologies (e.g., NoSQL, PostgreSQL) is a plus
• .NET Application programming experience is a plus
• Infor ERP and/or Microsoft Dynamics Experience is a plus
• Excellent interpersonal skills for effective collaboration with stakeholders across the organization
• Ability to work both independently and in a team environment
• Quick learner with high motivation and strong attention to detail
• Familiar with GIT Source Control

Education/ Experience:

• Bachelor’s Degree in Computer Science, Information Technology, or a related field (or equivalent work experience)
• Minimum of 5 years of hands-on experience in database development
• Microsoft SQL Server certification(s) is a plus, demonstrating your expertise.
• Familiarity with Agile Methodologies
• Previous experience in the HVAC Industry or a related service business is preferred

Physical Requirments:

• Continuously able to work in office environment
• Continuously able to operate a computer and other office productivity machinery, such as a copy machine, telephone, and computer printer
• Continuously able to sit at a computer for up to 8 hours
• Able to alternate between sitting and standing, as needed throughout the day
• Occasionally able to lift up to 15
• Continuously requires vision, hearing, twisting, and talking
• Occasionally requires walking, lifting, carrying, reaching, kneeling, pushing/pulling, bending, and crouching
• Rarely requires climbing
• Ability to travel on occasion