Senior Database Engineer at Catania-Spagna Corp – Ayer, Massachusetts

Do 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, MA

Join a Legacy. Build the Future

Catania 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 Do

• We 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 Do

• Analyze and optimize SQL Server performance across production systems
• Identify and resolve performance bottlenecks (queries, blocking, deadlocks, IO, memory usage)
• Proactively monitor and tune database systems
• Implement and maintain performance monitoring solutions
• Design, implement, and maintain effective indexing strategies
• Analyze index usage, fragmentation, and performance impact
• Optimize indexing for both transactional and reporting workloads
• Design, develop, and optimize stored procedures, views, and functions
• Refactor legacy SQL code for performance and maintainability
• Establish and enforce SQL coding standards
• Build 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 BI
• Improve query performance impacting dashboards and reports
• Support the evolution toward advanced analytics and data science workflows
• Support schema design and data modeling efforts
• Ensure data consistency, integrity, and security
• Assist with data integration and pipeline design
• Contribute to the design and development of the Microsoft Fabric environment
• Support data movement, transformation, and modeling within Fabric
• Help define best practices for hybrid SQL Server and Fabric architecture
• Act as the primary database partner for reporting and analytics
• Work with application teams to support backend data needs
• Troubleshoot and resolve production issues related to database performance
• Document database structures, optimization efforts, and best practices
• Establish governance for SQL development and performance standards

What You Bring

• 8+ years of progressive experience with SQL Server (or equivalent RDBMS)
• Strong expertise in query optimization and execution plan analysis
• Deep understanding of indexing strategies and performance tuning
• Proven experience writing and optimizing complex stored procedures
• Experience supporting reporting workloads and data pipelines

Preferred Qualifications

• Experience supporting Power BI or similar reporting platforms
• Familiarity with Microsoft Fabric, Azure SQL, or modern data platforms
• Exposure 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 environments

Why 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 Employer