Job Description

  • Requisition ID
    2018-6649
    Location : Address
    2540 North 29th Avenue
    Category
    Information Systems
    Location : City
    Phoenix
    Location : State/Province
    AZ
    Location : Postal Code
    85009
  • Summary and Essential Duties

    Summary: Under minimal supervision provide the necessary technical expertise to coordinate, maintain, and support the corporate database environment. The duties include database performance tuning, monitoring, capacity planning, utilization tracking, security, archiving, planning and monitoring of backups, disaster recovery, and documentation based on Shamrock Foods Company corporate policies, industry best practices, and customer-based business requirements. The position requires a strong background of SQL and Oracle database administration with an emphasis on coding design and development, including but not limited to stored procedures, views, functions, and data manipulation scripts. The position will ensure highly available, stable, secure, and recoverable databases in a 24/7 environment.

    Responsibilities:

    • Perform database administration tasks supporting databases within the enterprise environment including backups, restores, recovery models, storage management, replication, database security configuration and administration
    • Provide expert-level application tuning and query optimization and provide SQL design and coding direction and advice to the development staff
    • Detect and troubleshoot database performance issues impacting CPU, memory, I/O, disk space, and other resource contention
    • Install, patch, and upgrade database software and associated support software
    • Design and implement disaster recovery for the database environment
    • Design and implement capacity planning techniques and procedures for quarterly reviews
    • Design and implement long-term strategic goals and short-term tactical plans for managing and maintaining corporate database systems and software
    • Track and manage database licensing compliance
    • Recommend direction and support migration to cloud solutions
    • Participate in applicable team rotations, including after-hours 24x7 On Call support
    • Design and support cloud implementations
    • Document technical processes and procedures
    • Answer technical questions and assist developers
    • Participate in internal and enterprise projects
    • Follow documented processes, procedures, and expectations

    Essential Abilities:

    • Demonstrate strong interpersonal and communication skills
    • Possess strong analytical skills and demonstrate the ability to identify, troubleshoot, and resolve systematic issues
    • Provide accurate data collection and maintain standardized documentation
    • Track all work and changes in applicable ticketing system
    • Multitask and prioritize to maintain productive work performance
    • Adapt to a changing environment and work independently or as part of a team
    • Prioritize and execute tasks in a high-pressure environment
    • Exhibit integrity, honesty, dignity, respect, and open communication
    • Possess analytical, conceptual, and problem-solving abilities
    • Adhere to all Shamrock Foods Company rules, policies, procedures, instructions, and expectations

    Qualifications

    Position Requirements:

    • Bachelor’s degree in the technology field and/or 8+ years of job experience/certification
    • Lead the support and maintenance of a highly available database infrastructure
    • Patch and upgrade the database environment
    • Develop and enhance scripts to automate and execute various DBA tasks
    • Train and mentor development staff on database best practices and coding techniques
    • Scale the database infrastructure to support the business demands
    • Establish and recommend policies/procedures/standards
    • Produce and maintain architecture and technical support documentation
    • Advanced understanding and administration of the below listed Required Skills

    Required Skills:

    • Backup and recovery
    • Database schema creation and management
    • Metadata management and repository usage
    • Performance management and tuning
    • Data integrity management
    • Data security management
    • Database design
    • Availability
    • Change management adherence
    • Reporting and metrics
    • SQL code reviews
    • Procedural design
    • Disaster recovery
    • Capacity planning
    • General database management
    • ERP and business knowledge
    • Extensible data type administration
    • Web-specific technology expertise
    • Storage management techniques

    SQL Server Specifics

    • SSIS, SSAS, and SSRS usage and administration

    • Microsoft Dynamics AX

    • Failover clustering, AlwaysOn Availability Groups

    • Data Warehouse design and tuning

    • Kerberos and SPNs

    • Solarwinds Database Performance Analyzer (DPA)

    • RedGate SQL Compare

    • SQL LiteSpeed

    • Windows platform

    • Azure Cloud solutions

    Corporate Summary

    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, wellness programs, and much more!

    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.

    Not ready to apply? Connect with us for general consideration.

    Application Instructions

    Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

    Apply Online