Info Matrix Corp
SQL Developer (Onsite 3x/week)
Info Matrix Corp, Mechanicsburg, Pennsylvania, United States, 17050
Job Description
Info-Matrix Corporation is seeking a proven SQL Developer to join our team! This individual will support services that facilitate information sharing between proprietary management systems and external agencies. While applications are built in Java, a significant amount of business logic resides in database stored procedures, triggers, and views. This role requires both advanced development skills and strong production support capabilities, maintaining datastores, complex T-SQL code, and other database objects.
Key Responsibilities: • Data Quality & Discrepancy Resolution: Investigate and resolve data discrepancies by tracing data flows across complex relational structures. • Performance Optimization: Identify and resolve SQL performance issues; optimize queries, procedures, and triggers for efficiency and scalability. • Testing & Code Review: Conduct detailed testing, debugging, and peer code reviews of database logic and scripts. • Database-Driven Business Logic: Own and enhance complex business logic implemented in stored procedures, triggers, and views that support Java-based applications. • Production Support: Monitor and support existing systems, ensuring reliability, stability, and data integrity across integrated applications. • Data Model Design: Contribute to relational data model design to support new application features and system integrations. • Legacy System Support: Maintain, refactor, and modernize existing database code to improve long-term performance and maintainability. • On-Call Rotation: Participate in weekly on-call support for critical systems outside of standard business hours. • Cross-Team Collaboration: Work closely with Java developers, analysts, and testers to deliver reliable and scalable solutions.
Requirements • Advanced SQL/T-SQL Expertise: Extensive experience in designing and coding stored procedures, triggers, views, and database scripts in client-server environments. • Relational Database Mastery: Deep knowledge of relational database design, optimization, and complex query development. • Troubleshooting & Debugging: Proven ability to diagnose and resolve complex errors, production issues, and data reconciliation challenges in business-critical systems. • Integration with Java Applications: Experience collaborating with Java developers to align database logic with application code. • Ownership & Accountability: Demonstrated ability to self-review and deliver accurate, complete work with minimal oversight. • Communication Skills: Ability to explain technical database findings to non-technical stakeholders. • Preferred Technology: Advanced working knowledge of SAP Adaptive Server Enterprise (formerly Sybase). • Optional but Valuable: Experience with Java or another object-oriented language to better align database logic with application development.
Successful completion of a criminal background check required
Key Responsibilities: • Data Quality & Discrepancy Resolution: Investigate and resolve data discrepancies by tracing data flows across complex relational structures. • Performance Optimization: Identify and resolve SQL performance issues; optimize queries, procedures, and triggers for efficiency and scalability. • Testing & Code Review: Conduct detailed testing, debugging, and peer code reviews of database logic and scripts. • Database-Driven Business Logic: Own and enhance complex business logic implemented in stored procedures, triggers, and views that support Java-based applications. • Production Support: Monitor and support existing systems, ensuring reliability, stability, and data integrity across integrated applications. • Data Model Design: Contribute to relational data model design to support new application features and system integrations. • Legacy System Support: Maintain, refactor, and modernize existing database code to improve long-term performance and maintainability. • On-Call Rotation: Participate in weekly on-call support for critical systems outside of standard business hours. • Cross-Team Collaboration: Work closely with Java developers, analysts, and testers to deliver reliable and scalable solutions.
Requirements • Advanced SQL/T-SQL Expertise: Extensive experience in designing and coding stored procedures, triggers, views, and database scripts in client-server environments. • Relational Database Mastery: Deep knowledge of relational database design, optimization, and complex query development. • Troubleshooting & Debugging: Proven ability to diagnose and resolve complex errors, production issues, and data reconciliation challenges in business-critical systems. • Integration with Java Applications: Experience collaborating with Java developers to align database logic with application code. • Ownership & Accountability: Demonstrated ability to self-review and deliver accurate, complete work with minimal oversight. • Communication Skills: Ability to explain technical database findings to non-technical stakeholders. • Preferred Technology: Advanced working knowledge of SAP Adaptive Server Enterprise (formerly Sybase). • Optional but Valuable: Experience with Java or another object-oriented language to better align database logic with application development.
Successful completion of a criminal background check required