Senior Database Engineer

Catania-Spagna CorpAyer, MA
Onsite

About The Position

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 their team. The company values teamwork, respect, continuous improvement, and a culture that blends tradition with innovation. They operate with core values including treating team members like family, taking responsibility, striving for excellence, being customer-focused, and acting with integrity. The ideal candidate will thrive in a fast-paced environment, love solving problems, and know how to bring out the best in people.

Requirements

  • 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

Nice To Haves

  • 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

Responsibilities

  • 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

Benefits

  • 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
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service