Senior Software Engineer (PL/SQL & TSQL)

Shamrock Foods Company; Phoenix (AZ); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Health insurance

401(k) Savings Plan

Profit Sharing

Paid Time Off

Education opportunities

Wellness programs

Job summary

Shamrock Foods Company is recruiting an experienced Senior Database Developer to design, implement, and optimize enterprise database solutions across Oracle and SQL Server. You will collaborate with software engineers, analysts, and stakeholders to ensure data integrity, performance, and scalable data architectures supporting critical business applications.

The role involves mentoring junior developers, participating in architecture reviews, and driving best practices for data management,

Qualifications

• Bachelor’s degree in computer science, Information Technology, Software Engineering, or related field or 7+ years of equivalent experience.
• 7+ years of database development experience in enterprise environments.
• 5+ years of advanced Oracle PL/SQL development experience.
• 5+ years of advanced Microsoft SQL Server T-SQL development experience.
• Experience designing and supporting high-volume transactional databases.
• Experience integrating data across multiple systems and platforms.
• Expert-level Oracle PL/SQL development.
• Expert-level Microsoft SQL Server T-SQL development.
• Advanced SQL query design and optimization.
• Database performance tuning and troubleshooting.
• Data modeling and database design.
• ETL development and data migration.
• Experience with database version control and deployment processes.

Responsibilities

• Design, develop, test, and maintain complex database solutions using Oracle PL/SQL and Microsoft SQL Server T-SQL.
• Create and optimize stored procedures, functions, packages, triggers, views, and database objects.
• Design logical and physical data models to support business requirements.
• Develop scalable database architectures and data structures for enterprise applications.
• Implement database standards, naming conventions, and development best practices.
• Analyze and optimize SQL queries, execution plans, indexing strategies, and database performance.
• Monitor and troubleshoot database bottlenecks, locking issues, and resource utilization.
• Conduct performance tuning activities to improve application responsiveness and scalability.
• Implement database partitioning, indexing, and optimization strategies
• Develop and support data migration, integration, and ETL processes.
• Design and maintain interfaces between enterprise systems.
• Ensure data accuracy, consistency, and integrity across platforms.
• Support data warehousing and reporting initiatives.
• Partner with business stakeholders to gather and analyze technical requirements.
• Provide technical leadership and mentorship to junior developers.
• Participate in architecture reviews and strategic technology initiatives.
• Conduct code reviews and promote development best practices.
• Implement database security controls and access management.
• Ensure compliance with organizational policies and regulatory requirements.
• Support backup, recovery, disaster recovery, and business continuity initiatives.
• Maintain audit and data governance standards.
• Other duties as assigned

Skills

Oracle PL/SQL

Microsoft SQL Server T-SQL

Data modeling

Performance tuning

ETL development

Azure Data Factory

SSIS

.NET development

Education

Bachelor’s degree in computer science or related field

Tools

SQL Server Management Studio

Oracle SQL Developer

Azure Data Factory Studio

SSIS design tools

Job description

Job Details

Posting Details

• Posted on August 31, 2026

Locations

Showing 1 location

• Phoenix, AZ 85016, USA
• Hybrid
• Information Technology
• Full-Time
• Requisition #: SENIO011616

Description

Design, develop, optimize, and support enterprise database solutions across Oracle and Microsoft SQL Server platforms using deep expertise in PL/SQL and T-SQL, strong data modeling and performance tuning experience, and a proven ability to develop scalable, secure, and high-performing database solutions that support critical business applications.

This role requires collaboration with software developers, business analysts, architects, and stakeholders to analyze requirements, implement database solutions, and ensure the integrity, availability, and performance of organizational data assets.

Ideal candidates will have experience beyond database development, including Azure Data Factory (ADF), SQL Server Integration Services (SSIS), and Microsoft .NET development.

Essential Duties

• Design, develop, test, and maintain complex database solutions using Oracle PL/SQL and Microsoft SQL Server T-SQL.
• Create and optimize stored procedures, functions, packages, triggers, views, and database objects.
• Design logical and physical data models to support business requirements.
• Develop scalable database architectures and data structures for enterprise applications.
• Implement database standards, naming conventions, and development best practices.
• Analyze and optimize SQL queries, execution plans, indexing strategies, and database performance.
• Monitor and troubleshoot database bottlenecks, locking issues, and resource utilization.
• Conduct performance tuning activities to improve application responsiveness and scalability.
• Implement database partitioning, indexing, and optimization strategies
• Develop and support data migration, integration, and ETL processes.
• Design and maintain interfaces between enterprise systems.
• Ensure data accuracy, consistency, and integrity across platforms.
• Support data warehousing and reporting initiatives.
• Partner with business stakeholders to gather and analyze technical requirements.
• Provide technical leadership and mentorship to junior developers.
• Participate in architecture reviews and strategic technology initiatives.
• Conduct code reviews and promote development best practices.
• Implement database security controls and access management.
• Ensure compliance with organizational policies and regulatory requirements.
• Support backup, recovery, disaster recovery, and business continuity initiatives.
• Maintain audit and data governance standards.
• Other duties as assigned

Qualifications

• Bachelor’s degree in computer science, Information Technology, Software Engineering, or related field or 7+ years of equivalent experience.
• 7+ years of database development experience in enterprise environments.
• 5+ years of advanced Oracle PL/SQL development experience.
• 5+ years of advanced Microsoft SQL Server T-SQL development experience.
• Experience designing and supporting high-volume transactional databases.
• Experience integrating data across multiple systems and platforms.
• Expert-level Oracle PL/SQL development.
• Expert-level Microsoft SQL Server T-SQL development.
• Advanced SQL query design and optimization.
• Database performance tuning and troubleshooting.
• Data modeling and database design.
• ETL development and data migration.
• Experience with database version control and deployment processes.
• Strong understanding of relational database concepts and normalization.
• Preferred certifications include Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator Associate, and Microsoft SQL Server certifications.

Corporate Summary

At Shamrock Foods Company, people come first – our associates, our customers, and the families we serve across the nation. A privately‑held, family‑owned and -operated Forbes 500 company, Shamrock is an innovator in the food industry and has been since being founded in Arizona in 1922.

Our Mission

At Shamrock Foods Company, we live by our founding family’s motto to “treat associates like family and customers like friends.”

Why work for us?

Benefits are a major part of your overall compensation, and we believe offering them at an affordable cost is not only the right thing to do, but it helps keep you and your family healthy. That’s why Shamrock Foods pays for the majority of your health insurance, allowing you to take home more of your paycheck. And it doesn’t stop there - our associates also enjoy additional benefits such as 401(k) Savings Plan, Profit Sharing, Paid Time Off, as well as our incredible growth opportunities, continued education and wellness programs.

• 401(k) Savings Plan
• Profit Sharing
• Paid Time Off
• incredible growth opportunities, continued education and wellness programs

Equal Opportunity Employer

At Shamrock Foods Co all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, veteran status, sexual orientation, gender identity or any other basis protected by applicable law.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.