Job Summary:
Dental City is a nationwide distributor in the dental supply industry located in Green Bay, WI. They are seeking an experienced SQL Developer to support and enhance their SQL Server environment, data warehouse solutions, and reporting capabilities.
Responsibilities:
โข Maintain, support, and enhance SQL Server data warehouse environments using T-SQL and SSIS; develop advanced stored procedures, functions, triggers, and SQL Agent jobs.
โข Develop and support integrations with internal and external systems.
โข Create and maintain SSRS reports, including parameterized, drill-down, and matrix reports; design, implement, and maintain queries, dashboards, reports, and data solutions.
โข Troubleshoot production issues with minimal supervision and provide database support to web developers and reporting teams.
โข Document system processes, procedures, and technical workflows; support end users with Microsoft SQL Server and Microsoft Dynamics GP applications.
โข Collaborate within Agile development environments and participate in continuous improvement initiatives.
Qualifications:
Required:
โข Bachelor's degree in Computer Science, Information Systems, or equivalent experience.
โข 7+ years of experience with IT applications, relational databases, and software development, preferably MS SQL Server.
โข 5-7 years of experience supporting ERP/CRM integrations and IT development initiatives using web technologies and architectures.
โข SQL Server 2012+ and Azure SQL; SSMS, SQL Profiler, and Database Tuning Advisor.
โข SSRS and SSIS development; data warehousing, ETL, and data integration.
โข JIRA and Azure DevOps.
โข ODBC connectivity and report-writing tools.
โข Microsoft Office applications, particularly Excel and Access.
โข Strong database performance tuning and optimization experience.
โข Ability to analyze complex problems and develop practical solutions.
โข Understanding of large-scale system integrations and application development concepts.
โข Excellent documentation, communication, and collaboration skills.
โข Ability to quickly learn new technologies and understand technical documentation.
Preferred:
โข Experience with sales order processing, purchasing, inventory control, warehousing, or wholesale distribution is a plus.
โข Microsoft Dynamics GP (preferred)
Company:
Dental City is a medical device company offering dental instruments and device. Founded in 1993, the company is headquartered in Green Bay, USA, with a team of 51-200 employees. The company is currently Growth Stage.