SQL Developer at Estes Forwarding Worldwide, LLC in Richmond, Virginia

Job Description:

SQL Developer

US-VA-Richmond

Job ID: 2024-5796
Type: Regular Full-Time
# of Openings: 1
Category: Information Technology
EFW

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

This role involves designing, developing, and maintaining relational databases and data warehouses, optimizing SQL queries and database performance, and implementing ETL processes. The candidate will monitor database operations, troubleshoot issues, collaborate with cross-functional teams, and provide support via Jira. Strong SQL development skills, experience with Microsoft SQL Server, and proficiency in data integration and query optimization are essential. The position also requires excellent communication, problem-solving abilities, and adherence to best practices. Participation in an on-call rotation for after-hours support is expected.

To perform this job successfully, an individual must satisfactorily perform each essential duty. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential duties.

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.
• Other duties and functions as assigned.
• Comply with company C-TPAT and TSA security procedures.

Qualifications

The qualifications listed below are representative of the minimum knowledge, skill, and/or ability required.

SKILLS AND ABILITIES

• 3+ years of experience in SQL development and database administration.
• 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.
• Must pass a pre-employment drug screen, random drug and/or alcohol tests, and will be subject to a criminal history 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.

SUPERVISION

Position functions with supervision and has no direct reports.

EDUCATION/EXPERIENCE

Bachelor's degree (or equivalent) preferred

LICENSES/CERTIFICATIONS

None required.

TRAVEL

None required.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential duties.

Typically sitting at a desk or table. Intermittently sitting, standing, walking or stooping.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential duties of this job. Reasonable accommodations will be made to enable individuals with disabilities to perform essential duties.

Normal office situation.

EFW is an Equal Opportunity Employer, Minorities/Female/Disabled/Veteran.

PI251756980

Apply Now