Senior SQL Developer & Database Administrator

As a Senior SQL Developer & Database Administrator at Acme Smoked Fish, you will play a pivotal role in managing and optimizing our SQL databases, ensuring data integrity, and supporting critical business functions. You will not only design, implement, and maintain SQL databases but also write complex SQL queries and stored procedures to support various applications and reporting needs. Industry experience in protein manufacturing and familiarity with Seasoft or Infor M3 Cloudsuite is a significant plus.

What You Will Do At Acme:

• Design, implement, and maintain intricate SQL databases, ensuring top-tier performance, scalability, and data integrity.
• Author and fine-tune complex SQL queries and stored procedures to fulfill diverse application and reporting needs.
• Collaborate closely with cross-functional teams to grasp and address evolving database requirements.
• Execute routine database maintenance tasks, encompassing backup and recovery, indexing, and performance fine-tuning.
• Monitor and analyze database performance, detecting and addressing bottlenecks and performance challenges.
• Implement and uphold security protocols and access controls to protect sensitive data.
• Stay abreast of the latest developments and best practices in database administration, Azure SQL, data warehousing, and Power BI.
• Provide mentorship and guidance to junior Database Administrators and team members.
• Engage in disaster recovery planning and testing.
• Other related duties as assigned.

Your Education & Experience:

• Bachelor's Degree in Computer Science, Information Technology, or related field (Master's preferred).
• 6+ years proven experience as a Database Administrator and SQL Developer a plus.
• Demonstrated expertise as a Senior SQL Developer and database Administrator, with a profound grasp of relational databases.
• Experience in the protein manufacturing industry and familiarity with SeaSoft or Infor M3 Cloudsuite is highly desirable.
• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are advantageous.

Your Skills & Abilities:

• Proficiency in crafting and optimizing intricate SQL queries and stored procedures.
• Excellent command of managing Azure SQL databases and data warehousing solutions.
• Familiarity with data visualization tools, particularly Power BI, is a significant advantage.
• Familiarity with data security best practices and compliance standards.
• Exceptional problem-solving and troubleshooting abilities.
• Excellent communication and collaboration skills.
• Proactive and self-motivated, capable of working independently.
• Completion of training programs as assigned and/or required including standard of work.

Physical Requirements:

• Prolonged periods of sitting at a desk and working on a computer.
• Light Travel (front end travel required to NY for onboarding if not local).
• Role can be hybrid/remote long term with light travel to corporate HQ as needed. Candidates living in NY, NJ, NC, MA, and FL preferred.

What's In It For You:

• Competitive compensation including annual discretionary bonus.
• Opportunity to choose the medical plan that works best for your family.
• Flexible spending accounts (Medical + Dependent Care).
• Health Savings Account option with quarterly employer contributions.
• 401(k).
• Dental Insurance.
• Vision Insurance.
• Company Sponsored Group Term Life.
• Voluntary Life Insurance options for you and your dependents.
• Paid time off including company and floating holidays.
• Tuition Reimbursement.
• Paid Parental Leave.
• CASH employee referral program.

Our Acme Legacy & Culture:

Acme Smoked Fish is a seafood processor, purveyor, distributor and more, built on a foundation of quality, innovation, long lasting relationships, passion, and positive stewardship to our seafood communities. As the largest specialty smoked seafood company in the United States, we stand committed to providing the very best smoked seafood delicacies to our customers, near and far, and take great pride in being at the forefront of the seafood sustainability movement. Our authenticity has transcended from generation to generation and we pursue excellence in everything we produce and everyone we employ. We stand committed to our Values and our culture, providing us the opportunity to serve our friends and neighbors.

Acme manufactures and distributes its products in the U.S. under four core brands (Acme, Blue Hill Bay, Ruby Bay, and Spence) and private labels through leading retail and food service institutions. The company operates manufacturing sites in New York, North Carolina, Florida, Massachusetts, South America and Europe.

Ethics Statement:

Acme Smoked Fish Corporation is committed to creating a diverse and inclusive workplace that fosters respect, collaboration, and innovation. We value the contributions of every employee and expect them to uphold the highest standards of ethical conduct and professional integrity. We are an equal opportunity employer. We do not tolerate or practice any form of discrimination, harassment, or misconduct based on race, color, religion, sex, national origin, age, disability, sexual orientation, gender identity, veteran status, or any other protected characteristic. We comply with all applicable laws and regulations regarding labor rights, human rights, environmental protection, and data privacy.