Skip Navigation

Search Careers

Home Office

Database Administrator

Location Phoenix, Arizona ID IT-18-6367 Apply Now
Job Responsibilities

Sr. Systems Engineer (Database)

SUMMARYThis is a mid-level position on the Database Administration team. It is also a shift position starting atMonday to Friday8:00am to 5pm, with an on-call weekend rotation every 4 or 5 weeks. The principal duties for this role are 50% project driven and 50% support driven. This position provides an opportunity to play a key role on a dynamic, fast paced, collaborative and highly productive team.

PRINCIPAL RESPONSIBILITIES

  • Maintains the organization’s databases across multiple platforms and computing environments.
  • Analyzes and resolves issues related to information flow and content.
  • Maintains database support tools, database objects, backup and recovery processes & procedures.
  • Advise Data Architects and Developers on best practices in relation to data models, DDL/DML, and suggest areas of improvement for performance and efficiencies.
  • Monitors database resource utilization and performance.
  • Contributes to the library of documentation for database standards, maintenance and support.
  • Ability to manage projects centered on databases supporting specialized applications.
  • Keeping abreast of emerging technologies.
  • Participation in a 24x7 on call rotation.
  • Other duties as assigned.

EDUCATION REQUIREMENTSBachelor’s degree in Computer Science or an equivalent combination of related work experience and education.

Experience and technical skills required

  • Oracle 11g/12c experience

RMAN, ASM, Enterprise Manager Cloud Control, RAC, database patches and upgrades, AWR\ASH analysis, PL/SQL skills, ability to provide recommendations on SQL changes and/or database modifications in order to improve performance

  • SQL Server 2008 – SQL Server 2016

Transact-SQL skills, SQL Azure, database patches and upgrades, ability to provide recommendations on SQL changes and/or database modifications in order to improve performance, working knowledge of SSRS and SSIS

  • Intermediate knowledge of AIX, Linux, and Windows operating systems
  • UNIX shell scripting, PowerShell scripting
  • Working knowledge of VMWare
  • EMC Networker, Pure storage, Solarwinds DPA, and Toad experience is a plus
  • DB2 experience is a plus
  • A minimum of 4-5 years proven experience as an Oracle and SQL Server DBA
  • Proven experience of managing multiple RDBMS on large, complex systems

PREREQUISITE COMMUNICATIONS AND INTERPERSONAL SKILLS

  • Independently identifies issues and enhancement possibilities and addresses documentation needs
  • Able to communicate on both conceptual and technical areas in relevant technologies
  • Able to communicate comfortably at all levels including corporate management
  • Must be able to perform in a fast-paced environment on a very collaborative and highly productive team
  • Able to work effectively in pressure situations
  • Excellent problem-solving skills and the ability to debug complex data issues and environments
  • Excellent verbal and written skills

Submit Resume
Apply Now
Map this Location

Recently Viewed Opportunities

You have no recently viewed jobs.

  • Commerce & Customer Engagement

    The Commerce & Customer Engagement team helps create seamless experiences during all interactions between PetSmart and pet parents. From driving simpler e-commerce transactions to maximizing our mobile applications, this team is always driven by the passion to make a difference in the lives of pets and pet parents.

    "The passion behind our work is truly driven by creating better experiences for pets and pet parents."

    Dawn

    Sr. Business Relationship Director
  • Business Enablement

    If you like streamlining processes for team efficiencies, then our Business Enablement team is a great fit for you. Established 1 year ago, this brand new, fast-growing team focuses on enablement of our business systems. Their goal is to foster system synergies across our different business units to make more strategic, holistic decisions.

    Our IT team isn’t just their own department; they are treated as a valued business partner in every area of our company.

  • IT Solutions

    Focusing on maximizing our BI tools and data management processes, our IT Solutions team provides the technology our business leaders need to make holistic, strategic decisions. The resources that this team develops and maintains are instrumental to the continued growth of our omni-channel business.

    At every level, we empower our technology leaders so they can make decisions that are right for our business.

  • IT Service Delivery

    Whenever there are issues with our technology, the IT Service Delivery team roars into action. Providing round-the-clock technical engineering and support for our organization’s store locations, home offices, and distribution centers, this team is responsible for application, infrastructure, and enterprise information management support across PetSmart.

    We’re always renewing our commitment to technology. In fact, the last two years have been a transformational period in our IT departments.

Meet Mike

Our CIO, Mike Goodwin, is the fearless leader of our innovative IT team. Learn more about his team and why it's a great time to work at PetSmart.

Our culture is very relationship-driven. It’s this collaboration that is the key to moving around and getting things done.

Alison

Project Manager