Database Developer

Database Developer at Brooksource Database Developer at Brooksource in Erwinna, Pennsylvania Posted in 1 day ago.

Type:

full-time

Job Description:

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