Estes Forwarding Worldwide (Efw) - North Chesterfield, VA
posted about 2 months ago
The Senior SQL Developer at Estes Forwarding Worldwide (EFW) plays a crucial role in the production support of all software and integrations developed by the Software Engineering teams. This includes a variety of integration types such as EDI, XML, and flat file integrations, as well as managed file transfers, database integrations, web applications, and APIs. The position requires a strong focus on creating new integrations or modifying existing ones, adhering to the engineering teams' coding standards and best practices. Key responsibilities include database design and development, where the Senior SQL Developer will design, develop, and maintain relational databases and data warehouses. This involves creating efficient database schemas, tables, indexes, and constraints to support business applications, as well as implementing database objects like stored procedures, triggers, and functions to automate processes and enforce business rules. The role also emphasizes SQL query optimization, requiring the developer to performance tune existing SQL objects and write complex SQL queries to handle large volumes of data effectively. In addition to database management, the Senior SQL Developer will be responsible for data integration and ETL processes, ensuring data quality, consistency, and accuracy. Documentation of database designs and adherence to best practices in database development are also critical components of the role. The developer will proactively monitor SQL Agent Jobs for failures and respond to support requests, collaborating with cross-functional teams to ensure seamless integration processes. Participation in an on-call rotation for after-hours support is also expected, along with compliance with company security procedures.