Database Developer (Pipersville)

Role Overview

We are seeking a Database Developer (Level 2) to join a highly customized and data-driven environment supporting critical business and e-commerce systems.

This is a hands-on, execution-heavy role focused on solving complex data problems, supporting production systems, and improving database performance in a legacy and highly customized environment where data directly drives application behavior.

Core Responsibilities

• Develop and optimize SQL Server databases and data structures
• Write and maintain T-SQL stored procedures for data retrieval and processing
• Support data workflows, APIs, and internal system integrations
• Work within legacy systems and ERP environments
• Support daily data processing and production issue resolution
• Rebuild and troubleshoot database tables and indexing strategies
• Collaborate across: Data team, Development team, Business/Data Engineers (BDEs)
• Support e-commerce and transactional data systems

Day-to-Day Focus

• Hands-on SQL development and troubleshooting
• Debugging cases where data is missing, incorrect, or not returned properly
• Rewriting or fixing stored procedures and SQL scripts
• Improving query performance through indexing and optimization
• Investigating root causes of data issues in production systems
• Working closely with developers to understand application behavior
• Rebuilding or correcting data structures as needed

Required Technical Skills

• SQL Expertise SQL Server (2019/2022 preferred)
• Strong T-SQL and SSMS experience
• Stored procedures, joins, indexing, query optimization
• Deep Data Understanding Experience working directly within data (not just reporting or extracting)
• Ability to diagnose and resolve data integrity issues
• Experience with data cleansing, correction, and validation
• Understanding of how data impacts application behavior
• Application/Logical Awareness Understanding of how applications use database data
• Ability to connect backend logic to user-facing behavior
• Experience supporting production systems where data affects functionality