Senior DB Architect: Oracle PL/SQL & SQL Server

Shamrock Foods Company

Phoenix (AZ)

Hybrid

USD 110,000 - 150,000

Full time

14 days+

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

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