Freelance Web Developer — WordPress, SQL Server, API Integrations (US-Based, Ongoing Retainer)

US A Goff Limousine & Bus Company is a veteran-owned luxury transportation business based in Barboursville, Virginia.

We operate motor coaches, minibuses, SUVs, and sedans across nine states.

We also own SuperMax Motors, a motorcoach dealership (supermaxmotors.com).

We’re looking for a reliable, US-based freelance developer for ongoing work across both businesses.

SCOPE OF WORK This is an ongoing retainer engagement (15-20 hrs/month) covering multiple projects: 1.

Web Application Recovery & Rebuild Assess and recover/replicate two existing web applications (online quote system and check-in caller management tool).

Some source code available.

Server/hosting access in place. 2.

WordPress Website Redesign Redesign agoffbus.com and optimize supermaxmotors.com.

Build landing pages for driver recruitment, services, and lead generation.

SEO and mobile optimization. 3.

Digital Marketing Integration Integrate and optimize ZoomInfo and HubSpot for outbound email marketing.

Connect Facebook marketing (we manage 3 groups with ~50K members) into HubSpot CRM. 4.

Hiring Automation Build automated pipeline: Indeed job postings → AI screening → video interviews (HireVue/Hireflix) → onboarding partner handoff.

Zapier or direct API integrations. 5.

Database & Reporting Write and deploy SQL Server queries against our dispatch/billing database (LiveryCoach).

Build automated reporting for payroll analysis, route profitability, vehicle utilization.

Deploy to on-premise Windows server. 6.

Ongoing Maintenance Deploy code developed with AI assistance (Claude).

WordPress updates, security patches, troubleshooting.

REQUIRED SKILLS • WordPress (theme customization, plugin development, landing pages)

Brief overview of your relevant experience 2. 2-3 examples of similar work (small business web dev, database reporting, automation) 3.

Your hourly rate and weekly availability 4.

Confirmation you’re US-based and comfortable signing an NDA 5.

Brief description of how you’d approach recovering an existing web application with partial source code This is an ongoing engagement with a 30-day trial period.

We’re looking for a long-term partner, not a one-off contractor. xxxxxxxxxxxxxxxxxx Hours per WeekLess than 30 hrs/week Time Requirement 15-20 hours per week (may increase during active projects) xxxxxxxxxxxxxxxxxx Screening Questions 1.

Are you based in the United States? (required) 2.

Do you have experience with both WordPress and SQL Server? 3.

Have you integrated HubSpot or ZoomInfo with other platforms? 4.

Describe a project where you recovered or rebuilt an existing web application. 5.

What is your weekly availability and preferred working hours? xxxxxxxxxxxxxxxxxxx Written by Claude, based on and reviewed by Dan Goff.