Database Developer
About The Position
Campers Inn RV is seeking a Database Developer/DBA to develop and administer ETL pipelines from disparate data sources, database objects, and SQL Server jobs and procedures. The role supports a range of data needs and projects and is an integral member of the Campers Inn IT Team. The primary goal is to develop and maintain database and ETL servers, objects, data, and processes. The Database Developer/DBA builds SSIS packages to pull data from SQL databases and 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 role reports directly to the Enterprise Project Management Office and Business Intelligence Manager. The position may be based in Jacksonville, Florida, or performed remotely. Work is primarily sedentary in a climate-controlled environment and involves continuous visual use of a computer, files, and reports.
Requirements
- At least 3 years of SQL Server database development experience, including advanced T-SQL.
- At least 3 years of ETL development and administration experience using SSIS or similar.
- Experience with Microsoft Office, Teams, and SharePoint.
- Experience with Microsoft Azure cloud-based servers and databases.
- Experience with Microsoft Power BI.
- Excellent oral and written communication and interpersonal skills.
- Ability to work flexible hours as required, which may include evenings and weekends.
- Ability to multitask in a fast-paced environment and work independently as well as on a team.
- Self-motivation and ability to work under minimal supervision.
- Strong analytical and troubleshooting skills with attention to detail.
- A team-player attitude.
Nice To Haves
- Microsoft Power Apps experience.
- Microsoft Fabric or Azure Data Factory experience.
- Python and PowerShell scripting experience.
- Experience with Power BI semantic models and DAX.
- RV or automotive industry experience.
Responsibilities
- Manage and administer SQL Server instances, databases, objects, data, pipelines, and processes across on-premises and Azure environments.
- Create and maintain ETL pipelines moving data from disparate sources 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 application and reporting databases, including the enterprise data warehouse.
- Optimize 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 and disaster recovery with the managed service provider.
- Consult with 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.
- Provide Tier 2 and Tier 3 expert support on database- and ETL-related support tickets.
- Contribute to 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).
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Education Level
No Education Listed
