Estes Forwarding Worldwide
Senior SQL Developer
Estes Forwarding Worldwide, Richmond, Virginia, United States, 23214
Overview:
Estes Forwarding Worldwide (EFW) is a leading domestic and international freight forwarder in the United States, providing customized logistics and warehousing solutions for clients around the world and across all industries via air, ground, and ocean freight. A subsidiary of Estes Express lines with corporate located in Richmond, Virginia, EFW is uniquely backed by Estes Express Lines extensive line haul network providing EFW clients with a hybrid transportation network. The company has received industry awards, including Specialty Carrier of the Year and E-Commerce Delivery Carrier of the Year, and has been recognized by Global Trade Americas as a leading 3PL to watch. We are proud to offer highly competitive pay and a comprehensive benefits package, including: Paid vacation, sick time, and holidays 401(k) plan with company match Medical, dental, and vision insurance Short- and long-term disability plans Life and accidental death & dismemberment insurance Job referral bonus program Responsibilities: The Senior SQL Developer is responsible for production support of all software and integrations developed by the Software Engineering teams, including but not limited to EDI, XML and flat file integrations, managed file transfers, and database integrations, web applications and APIs. The Senior SQL Developer may also be responsible for creating new integrations or making changes to existing integrations in accordance with the engineering teams coding standards and best practices. Duties include but are not limited to: Database Design and Development Design, develop and maintain relational databases and data warehouses. Create efficient database schemas, tables, indexes, and constraints to support business applications. Implement database objects such as stored procedures, triggers, and functions to automate processes and enforce business rules. Participate in code reviews and commit changes to source control (GitHub). SQL Query Optimization Performance tune existing SQL objects using all available metrics and tools. Write and optimize complex SQL queries to extract, manipulate and analyze large volumes of data. Identify and resolve performance bottlenecks in SQL Queries and database operations. Tune database configurations and query execution plans for optimal performance. Data Integration and ETL Design and implement data integration solutions to extract, transform, and load data from various sources into the database. Develop ETL processes to ensure data quality, consistency, and accuracy. Work with stakeholders to understand data requirements and design scalable ETL workflows. Documentation and Best Practices Document database designs, schemas, and processes to ensure knowledge transfer and maintain system documentation. Adhere to best practices in database development, version control, and change management. Stay updated with industry trends and emerging technologies in SQL development and database management. Monitoring and Support Proactively monitor SQL Agent Jobs for failures using all available applications and tools. Respond to support requests using Jira Service Management and Jira Cloud. Issues may include but are not restricted to requests for clarification or information, perceived processing problems, actual processing problems, requests for system changes, procedural issues, and access requests. Make suggestions for changes that proactively prevent future support issues. Communicate effectively with stakeholders and project managers to clarify requirement son support requests. Communicate confidently with internal and external customers. Collaborate with cross functional teams to ensure seamless integration processes. Coordinate testing efforts with trading partners and cross functional teams to make sure that all elements of a data integration are as designed. Participate in an on-call rotation for after hours, weekend, and holiday support. Comply with company C-TPAT and TSA security procedures. Perform other duties as assigned.
Qualifications:
Minimum of a Bachelor's degree (or equivalent) and 3-5 years of experience. However, a combination of experience and/or education will be taken into consideration. Strong proficiency in SQL programming, including complex query writing, optimization, and performance tuning. Experience with relational database management operations for Microsoft SQL Server. Experience with SQL Server upgrades preferred. Knowledge of data modeling techniques and database design principles. Experience with ETL tools and processes. Familiarity with database administration tasks such as backup, recovery, and security. Excellent problem-solving skills and attention to detail. Strong communication and collaboration skills to work effectively in a team environment. Ability to read and interpret complex business and/or technical documents. Ability to write comprehensive reports and detailed business correspondence. Ability to work with groups of people such as other departments and communicate known concepts. Ability to solve problems with a variety of concrete variables through semi-standardized solutions that require some ingenuity and analysis. Ability to draw inferences and follow prescribed and detailed procedures to solve moderately complex problems. Must be eligible to work in the United States. At this time, EFW will not sponsor a new applicant for employment authorization for this position. EFW prides itself on the quality of its employees and as such, candidates who receive a job offer will be required to successfully pass a drug screen and a background check. EFW offers an opportunity to grow and develop your career in an environment that provides a fulfilling workplace for employees, creates an environment for continuous learning, and embraces the ideas and diversity of others. All qualified applicants will receive consideration for employment without regard to sex, pregnancy, race, ethnicity, color, creed, religion, national origin, age, disability status, protected veteran status, marital status, sexual orientation, gender identity or expression, or any other legally protected status. EFW is an Equal Opportunity Employer, Minorities/Female/Disabled/Veteran
Estes Forwarding Worldwide (EFW) is a leading domestic and international freight forwarder in the United States, providing customized logistics and warehousing solutions for clients around the world and across all industries via air, ground, and ocean freight. A subsidiary of Estes Express lines with corporate located in Richmond, Virginia, EFW is uniquely backed by Estes Express Lines extensive line haul network providing EFW clients with a hybrid transportation network. The company has received industry awards, including Specialty Carrier of the Year and E-Commerce Delivery Carrier of the Year, and has been recognized by Global Trade Americas as a leading 3PL to watch. We are proud to offer highly competitive pay and a comprehensive benefits package, including: Paid vacation, sick time, and holidays 401(k) plan with company match Medical, dental, and vision insurance Short- and long-term disability plans Life and accidental death & dismemberment insurance Job referral bonus program Responsibilities: The Senior SQL Developer is responsible for production support of all software and integrations developed by the Software Engineering teams, including but not limited to EDI, XML and flat file integrations, managed file transfers, and database integrations, web applications and APIs. The Senior SQL Developer may also be responsible for creating new integrations or making changes to existing integrations in accordance with the engineering teams coding standards and best practices. Duties include but are not limited to: Database Design and Development Design, develop and maintain relational databases and data warehouses. Create efficient database schemas, tables, indexes, and constraints to support business applications. Implement database objects such as stored procedures, triggers, and functions to automate processes and enforce business rules. Participate in code reviews and commit changes to source control (GitHub). SQL Query Optimization Performance tune existing SQL objects using all available metrics and tools. Write and optimize complex SQL queries to extract, manipulate and analyze large volumes of data. Identify and resolve performance bottlenecks in SQL Queries and database operations. Tune database configurations and query execution plans for optimal performance. Data Integration and ETL Design and implement data integration solutions to extract, transform, and load data from various sources into the database. Develop ETL processes to ensure data quality, consistency, and accuracy. Work with stakeholders to understand data requirements and design scalable ETL workflows. Documentation and Best Practices Document database designs, schemas, and processes to ensure knowledge transfer and maintain system documentation. Adhere to best practices in database development, version control, and change management. Stay updated with industry trends and emerging technologies in SQL development and database management. Monitoring and Support Proactively monitor SQL Agent Jobs for failures using all available applications and tools. Respond to support requests using Jira Service Management and Jira Cloud. Issues may include but are not restricted to requests for clarification or information, perceived processing problems, actual processing problems, requests for system changes, procedural issues, and access requests. Make suggestions for changes that proactively prevent future support issues. Communicate effectively with stakeholders and project managers to clarify requirement son support requests. Communicate confidently with internal and external customers. Collaborate with cross functional teams to ensure seamless integration processes. Coordinate testing efforts with trading partners and cross functional teams to make sure that all elements of a data integration are as designed. Participate in an on-call rotation for after hours, weekend, and holiday support. Comply with company C-TPAT and TSA security procedures. Perform other duties as assigned.
Qualifications:
Minimum of a Bachelor's degree (or equivalent) and 3-5 years of experience. However, a combination of experience and/or education will be taken into consideration. Strong proficiency in SQL programming, including complex query writing, optimization, and performance tuning. Experience with relational database management operations for Microsoft SQL Server. Experience with SQL Server upgrades preferred. Knowledge of data modeling techniques and database design principles. Experience with ETL tools and processes. Familiarity with database administration tasks such as backup, recovery, and security. Excellent problem-solving skills and attention to detail. Strong communication and collaboration skills to work effectively in a team environment. Ability to read and interpret complex business and/or technical documents. Ability to write comprehensive reports and detailed business correspondence. Ability to work with groups of people such as other departments and communicate known concepts. Ability to solve problems with a variety of concrete variables through semi-standardized solutions that require some ingenuity and analysis. Ability to draw inferences and follow prescribed and detailed procedures to solve moderately complex problems. Must be eligible to work in the United States. At this time, EFW will not sponsor a new applicant for employment authorization for this position. EFW prides itself on the quality of its employees and as such, candidates who receive a job offer will be required to successfully pass a drug screen and a background check. EFW offers an opportunity to grow and develop your career in an environment that provides a fulfilling workplace for employees, creates an environment for continuous learning, and embraces the ideas and diversity of others. All qualified applicants will receive consideration for employment without regard to sex, pregnancy, race, ethnicity, color, creed, religion, national origin, age, disability status, protected veteran status, marital status, sexual orientation, gender identity or expression, or any other legally protected status. EFW is an Equal Opportunity Employer, Minorities/Female/Disabled/Veteran