[Hiring] Database Developer @1a4baf7a-1837-4d5b-a378-2e0865aece76

Role Description

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.

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.
• Supports existing data operations.

Qualifications

• 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.

Requirements

• 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).

Benefits

• 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.

Company Description

Campers Inn RV is a family-operated RV business and the nation's largest family-operated RV dealership, trusted for 60 years. Founded in 1966 by Art and Fran Hirsch, it remains a family-operated business today.

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.