Database Developer

Brooksource
Pipersville, PA

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 ExpertiseSQL Server (2019/2022 preferred)
  • Strong T-SQL and SSMS experience
  • Stored procedures, joins, indexing, query optimization
  • Deep Data UnderstandingExperience 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 AwarenessUnderstanding of how applications use database data
  • Ability to connect backend logic to user-facing behavior
  • Experience supporting production systems where data affects functionality

// // //