Database Developer

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Information Technology Full Time Corporate Jacksonville, FL, US

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 Power Shell, 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,…