Privately held and forward-thinking travel company seeking a SQL Server Database Developer for their growing team based in Duluth, GA. Day-to-day responsibilities will include SQL Server database development (tables, stored procedures, indexes, views, etc..), SSIS, ETL development, database performance analysis and optimization, ad-hoc business requested data extractions, and more. This position will be a hybrid role with some onsite required in our Duluth office.
The ideal experience includes a solid mix of the following skills:
The ideal experience includes a solid mix of the following skills:
- Intermediate to strong understanding of the MS SQL Server environment (5+ years of experience)
- Solid T-SQL skills
- Ability to create complex functions, scripts, stored procedures and triggers to support application development.
- Experience with aggregating large data sets, specifically within a data warehouse environment.
- Intermediate to strong understanding of execution plans and plan caching.
- Strong critical thinking and problem solving skills, including a proactive disposition towards identifying problems and providing solutions.
- Familiar with report development paradigms.
- Ability to complete development projects on time without day to day oversight of the task by the project leads.
- Must be able to review and optimize large pieces of SQL code.
- Must be able to work well within a skilled development team. Able to provide and receive peer review.
- Familiar with MS SQL best practices involved with OLTP and data warehouse (OLAP) environments.
- SSAS and PowerBI experience is a bonus.
- Experience with predictive analytics development using Python or R in SQL Server is a bonus.
- Microsoft SQL Server (2005-2019)
- Microsoft SQL Server Integrated Services (SSIS)
- Microsoft SQL Server Analysis Services (SSAS)
- SSMS/Visual Studio/SSDT (any versions)
- Redgate toolset (SQLPrompt, SQLSearch, SQL Source Control, etc.)
- EXCELLENT communication skills
The benefits include full suite of medical, dental, retirement savings, robust PTO, remote work options, travel discounts (hotel, airfare, etc..) and much more!