Senior Database Engineer

DescriptionDo you take pride in doing things right the first time? Looking for a stable job with room to grow? Ready to join a team that treats you like family? We want to hear from you!Senior Data Base Engineer – Ayer, MAJoin a Legacy. Build the FutureCatania Oils, a fourth-generation, family-owned business with 125 years of excellence in the edible oils industry, is looking for a passionate and driven Senior Data Base Engineer to join our team. If you thrive in a fast-paced environment, love solving problems, and know how to bring out the best in people—this is your moment.Our Core Values Drive Everything We DoWe Are Family – We treat every team member with respect and support, just like family.Own It – We take responsibility, celebrate wins, and learn from challenges.Job Well Done – We strive for excellence and take pride in delivering quality work.Customer Focused – We go beyond expectations to ensure our customers succeed.Authenticity at Our Core – We act with integrity and stay true to our values, even under pressure.What You’ll DoAnalyze and optimize SQL Server performance across production systemsIdentify and resolve performance bottlenecks (queries, blocking, deadlocks, IO, memory usage)Proactively monitor and tune database systemsImplement and maintain performance monitoring solutionsDesign, implement, and maintain effective indexing strategiesAnalyze index usage, fragmentation, and performance impactOptimize indexing for both transactional and reporting workloadsDesign, develop, and optimize stored procedures, views, and functionsRefactor legacy SQL code for performance and maintainabilityEstablish and enforce SQL coding standardsBuild and maintain optimized data structures for reporting (views, staging tables, semantic-ready models)Partner with the reporting developer to ensure efficient data delivery to Power BIImprove query performance impacting dashboards and reportsSupport the evolution toward advanced analytics and data science workflowsSupport schema design and data modeling effortsEnsure data consistency, integrity, and securityAssist with data integration and pipeline designContribute to the design and development of the Microsoft Fabric environmentSupport data movement, transformation, and modeling within FabricHelp define best practices for hybrid SQL Server and Fabric architectureAct as the primary database partner for reporting and analyticsWork with application teams to support backend data needsTroubleshoot and resolve production issues related to database performanceDocument database structures, optimization efforts, and best practicesEstablish governance for SQL development and performance standardsRequirementsWhat You Bring8+ years of progressive experience with SQL Server (or equivalent RDBMS)Strong expertise in query optimization and execution plan analysisDeep understanding of indexing strategies and performance tuningProven experience writing and optimizing complex stored proceduresExperience supporting reporting workloads and data pipelinesPreferred QualificationsExperience supporting Power BI or similar reporting platformsFamiliarity with Microsoft Fabric, Azure SQL, or modern data platformsExposure to Python or data science workflows (supporting role)Experience working in cross-functional teams (database, reporting, applications)Experience with industrial data systems or SCADA platforms (e.g., Ignition, Iconics) in PLC-driven environmentsWhy Catania Oils?Be part of a company that values teamwork, respect, and continuous improvement Work in a culture that blends tradition with innovation Make a real impact in a company that’s committed to sustainability and quality. We offer competitive pay and benefits Catania Oils is an Equal Opportunity EmployerSalary Description$135,000-$145,000