SQL Developer
$110,000
Mechanicsburg, PA
Highlights
Salary
$110,000
Location
Mechanicsburg, PA
Job Type
Full-time, hybrid
We are seeking a skilled SQL Developer to join our team in Mechanicsburg, PA. This hybrid role (onsite 3x/week) blends advanced SQL/T-SQL development with production support and database optimization. The SQL Developer will maintain complex business logic embedded in stored procedures, triggers, and views, supporting Java-based applications and ensuring high-quality, reliable data across integrated systems.
Reporting to the Database or IT Lead, this role requires collaboration with developers, analysts, and testers to deliver scalable solutions while participating in production support and on-call rotations.
Role Highlights
● Investigate and resolve data discrepancies, tracing data flows across complex relational structures
● Optimize SQL queries, stored procedures, and triggers for performance, efficiency, and scalability
● Conduct testing, debugging, and peer code reviews for database scripts and logic
● Maintain and enhance database-driven business logic supporting Java-based applications
● Monitor production systems, ensuring stability, reliability, and data integrity
● Contribute to relational data model design for new features and system integrations
● Modernize legacy database code for improved maintainability and long-term performance
● Participate in weekly on-call rotation for critical systems outside business hours
● Collaborate closely with cross-functional teams to deliver robust solutions
Contact
Dylan Stewart
Requirements
● Advanced expertise in SQL/T-SQL, including stored procedures, triggers, views, and scripts
● Strong relational database design, optimization, and complex query development skills
● Proven ability to troubleshoot production issues and resolve data discrepancies
● Experience integrating database logic with Java applications
● Demonstrated ownership and accountability, delivering accurate and complete work with minimal oversight
● Strong communication skills to explain technical findings to non-technical stakeholders
● Preferred: Experience with SAP Adaptive Server Enterprise (ASE)
● Optional: Knowledge of Java or other object-oriented languages to align with application development