Database developer

Campers Inn RV is a family-operated RV business! We are seeking a Database Developer/DBA to focus on developing and administering ETL pipelines from disparate data sources, database objects, and various SQL Server jobs and procedures. The Database Developer/DBA assists with all types of data needs and projects and will be an integral member of the Campers Inn IT Team.

WHO WE ARE:

NATION'S LARGEST FAMILY-OPERATED RV DEALERSHIP: Campers Inn RV has been the RVer's Trusted Resource for 60 years. It was founded in 1966 by Art and Fran Hirsch, and it remains a family-operated business today.

VALUES-DRIVEN ORGANIZATION: Campers Inn RV is driven by the Core Values of Integrity, Teamwork, Continuous Improvement and Sustainability. All team members are expected to uphold these values when performing their jobs, assisting other team members, and helping customers.

ROLE SUMMARY:

The Database Developer/DBA has the primary goal of developing and maintaining database and ETL servers, objects, data, and processes. The Database Developer/DBA builds SSIS packages to pull data from other SQL databases and from other sources and files, creates and manages SQL Server Agent jobs and schedules, plans and operates SQL Server backup and recovery, and supports existing data operations. The Database Developer/DBA reports directly to the Enterprise Project Management Office and Business Intelligence Manager and will be part of the Campers Inn IT Team.

PRIMARY DUTIES AND RESPONSIBILITIES:

This list of duties and responsibilities is not all inclusive and may be expanded to include other duties and responsibilities as management may deem necessary from time to time. Reasonable accommodations may be made to enable individuals with disabilities.

• Manage and administer all SQL Server instances, databases, objects, data, pipelines, and processes across our on-premises and Azure environments
• Create and maintain ETL pipelines moving data from disparate sources (dealer management, CRM, HR/payroll, financial planning, and vendor data feeds) into SQL Server databases using SSIS and SQL Agent jobs, with growing use of Microsoft Fabric and Azure Data Factory
• Build automation tools, flows, and processes to manage data between source files and databases using PowerShell, Python, and other scripting tools
• Develop and support multiple application and reporting databases, including our enterprise data warehouse
• Optimize performance of queries, stored procedures, views, and reporting datasets through indexing, execution plan analysis, and T-SQL tuning
• Plan, schedule, and monitor database backups, and regularly test restores to meet recovery objectives
• Perform routine maintenance, including index and statistics maintenance, integrity checks, and capacity monitoring
• Manage database security, logins, roles, and permissions following least-privilege principles
• Coordinate SQL Server patching, upgrades, and high-availability/disaster recovery with our managed service provider
• Consult with various teams on data architecture best practices and schema design in SQL databases
• Troubleshoot, debug, and implement fixes and updates to existing custom-built database and ETL objects, and provide Tier 2 and 3 expert support on database- and ETL-related support tickets
• Contribute to the completion of projects and tasks for various business departments
• Document database and ETL details, including schedules, error handling, monitoring, and common failures
• Maintain database objects and ETL code in source control (Git)

KNOWLEDGE, SKILLS, AND ABILITIES:

• “Get it done” team-player attitude
• Demonstrated excellent oral and written communications skills, along with excellent interpersonal skills
• Ability to work flexible hours as required, which may include evenings and weekends
• Ability to multi-task in a fast-paced environment
• Ability to work independently as well as on a team
• Self-motivated and able to work under minimal supervision
• Strong analytical and troubleshooting skills with attention to detail

MINIMUM REQUIREMENTS:

• 3+ years of SQL Server database development experience, including advanced T-SQL, required
• 3+ years of ETL development and administration experience (SSIS or similar) required
• Microsoft Office, Teams, and SharePoint experience required
• Microsoft Azure cloud-based server and database experience required
• Microsoft Power BI experience required
• Microsoft Power Apps experience preferred
• Microsoft Fabric or Azure Data Factory experience preferred
• Python and PowerShell scripting experience preferred
• Experience with Power BI semantic models and DAX preferred
• RV or Auto industry experience preferred

TOOLS AND SOFTWARE USED:

• Microsoft Azure, SQL Server, SSIS, SSRS, SQL Server Management Studio, Azure Data Studio, Microsoft Fabric, Azure Data Factory
• Microsoft Power Platform including Power Apps and Power BI
• PowerShell, Python, and Git
• MS Office including Word, Excel, PowerPoint and Outlook
• Standard office equipment, including computer and phone
• ClickUp Project Management Software
• Other software as applicable

WORK ENVIRONMENT:

• Based in Jacksonville, FL OR Remote position
• Sedentary, works primarily in a climate-controlled environment
• Requires continuous visual ability for use of computer, files and reports

TYPICAL PHYSICAL DEMANDS:

• Ability to sit for long periods of time

Campers Inn RV is proud to be an Equal Opportunity Employer and Drug-Free workplace. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran or status as a qualified individual with disability.