Database Developer

Database DeveloperContract to hireHybrid (1 day/ week)Pipersville, PA Position SummaryHands-on SQL Server Database Developer supporting net-new development and enhancements driven by business initiatives across ERP, e-commerce, CRM, and logistics data. This is a development role, not an administration role. The developer will build and tune database objects, write and maintain ETL, profile and cleanse data sourced from legacy ERP systems, and partner with the existing Data Architect to deliver against a steady project backlog.Core ResponsibilitiesDesign, write, and optimize T-SQL stored procedures, views, functions, triggers, and indexes in SQL Server.Diagnose and resolve performance issues using execution plans, SQL Profiler traces, wait statistics, and index analysis.Build and maintain SSIS packages moving data between legacy ERP, e-commerce platforms, CRM, and downstream consumers.Profile source data, write validation and reconciliation queries, and implement cleansing logic for data sourced from legacy ERP systems.Translate business requirements from non-technical stakeholders into database designs, ETL flows, and reporting structures.Debug data defects, ETL failures, and procedural logic errors end to end.Contribute to schema design decisions alongside the Data Architect; uphold existing patterns and conventions.Document objects, jobs, and data lineage sufficient for handoff and on-call support.Required SkillsSQL Server Management Studio (SSMS) — daily development environment.SQL Profiler — workload capture, deadlock and blocking analysis, slow-query identification.SQL performance tuning — index design, statistics, query rewrites, execution plan reading, parameter sniffing mitigation, set-based logic.Debugging and troubleshooting across stored procedures, ETL jobs, and data pipelines.Deep data understanding — profiling, validation, insight extraction, cleansing, reconciliation.Preferred SkillsSSIS — control flow, data flow, parameterization, SSISDB deployment.ERP and/or e-commerce backend database development (product, order, customer, inventory schemas).Working knowledge of inventory, accounting, or financial transaction concepts (GL posting, inventory valuation, order-to-cash, procure-to-pay).Soft SkillsDirect, clear communication with technical and business stakeholders.Self-starter; drives requirement clarification rather than waiting for fully specified tickets.Assertive in technical discussions; comfortable as the second technical voice on the team.Data DomainsLegacy ERP systems — large data volumes, migration and integration work.E-commerce — public retail storefront, product and item catalog, client accounts.CRM — customer master and account data.Logistics — shipping, warehouse, and fulfillment data.What’s in it For You…?Join a team dedicated to building and enhancing digital technology and directly impact the member experience and enhance how members interact with technology. Get access to Brooksource technical training meant to rapidly enhance your technical ability and a senior mentor to be your source of truth. Get your foot in the door of a massive health insurance network that is on the cusp of a massive digital revolution and create a direct impact in said revolution. Enroll in weekly paychecks, comprehensive health benefits, and more. About Us:At Brooksource, relationships are the foundation of everything we do. Since 2000, we’ve built lasting partnerships with clients, consultants, and internal teams to deliver an exceptional experience across every engagement. As a trusted IT and Engineering services provider, Brooksource supports Fortune 500 organizations through Experience-Driven Staffing, Professional Services, and Elevate, our proprietary Workforce Transformation program. Whether you're hiring for software development, cloud computing, cybersecurity, data analytics, or enterprise IT, our customized staffing solutions are designed to align with your company’s unique goals, culture, and technology stack. We offer flexible hiring models, including contract, contract-to-hire, and direct placement to meet your evolving business needs.We are a certified partner of leading platforms, including Salesforce, AWS, Microsoft, and Google Cloud, enabling us to deliver scalable, end-to-end technology solutions. With a growing national footprint, Brooksource is redefining expectations in IT consulting, engineering services, and technology workforce solutions.EEO Statement:Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Benefits & PerksBenefits & Perks: Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc. Pay Disclaimer:The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.