SEARCH OUR OPENINGS

Senior Oracle Database Administrator in Huntersville, NC at American Tire Distributors

Date Posted: 9/30/2021

Job Snapshot

  • Employee Type:
    Full-Time
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
    9/30/2021

Job Description

We look forward to your application! When applying, please be sure to put your Full Legal First Name and Last Name for legal and processing purposes.

Are you looking for an opportunity to turn your ambition and your people skills into a rewarding career with an industry leader? Join our team at American Tire Distributors! As the nation's premier tire distributor, ATD’s coast-to-coast distribution network provides approximately 80,000 customers across the U.S. and Canada with rapid and frequent delivery of high quality tires, custom wheels and shop supplies. 

Position Description: 

The senior oracle database administrator is responsible for managing and supporting database platforms, working closely with the vendors, external consultants, application support teams, technical support team, and oracle database administrators; recognizing areas for improvement in the team; taking appropriate action to initiate changes; installing, configuring, upgrading, and maintaining database instances; recommending and implementing database security policies; recommending and implementing database backup, recovery, and redundancy strategies; implementing automated monitoring to ensure proactive handing of issues; working independently to perform database performance analysis, capacity planning, system sizing and ongoing maintenance; recommending best practices and performing other tasks assigned by the supervisor.



Essential Duties & Responsibilities

  • Develop and maintain specialist knowledge of database concepts, object and data modelling techniques and design principles and a detailed knowledge of database architectures, software, and facilities.
  • Analyze data requirements to establish, modify, or maintain object/data models.
  • Evaluate potential solutions, demonstrating, installing, and commissioning selected products.
  • Contribute to the availability management process and its operation and performs defined tasks.
  • Analyze service and component availability, reliability, maintainability and serviceability.
  • Implement arrangements for disaster recovery and documents recovery procedures.
  • Conduct testing of recovery procedures.
  • Use database management system software and tools to collect agreed performance statistics.
  • Carry out routine configuration/installation and reconfiguration of database and related products.
  • Monitor service delivery performance metrics and liaises with managers and customers to ensure that service level agreements are not breached.
  • Analyze service records against agreed service levels regularly to identify actions required to maintain or improve levels of service, and initiates or reports these actions.


Direct Report Position Title(s)

N/A – Individual Contributor


Qualifications

Required

  • Bachelor’s degree in Computer Science or related field or equivalent combination of industry related professional experience and education
  • Working experience in installing, configuring, administering, and tuning database technologies.
  • Working experience writing PL/SQL triggers and/or procedures.
  • Working experience with configuring and managing advanced queues.
  • Working experience configuring, refreshing, and managing replication.
  • Working experience with stored procedures, triggers, functions, packages, partitioning, streams and indexes.
  • Working experience with Oracle Relational Database Management systems and related tools.
  • Working experience with various operating systems.
  • Experience with work flow techniques (WFM).
  • Oracle EBS experience
  • Hybris experience
  • Oracle, Google, Azure Cloud experience

Preferred

  • Master’s degree in Computer Science or related field or equivalent combination of industry related professional experience and education
  • Working experience with UNIX and shell scripts.
  • Experience with iSeries and Mainframe environments a plus.
  • Experience with SQL-Server, MySQL and DB2.
  • Escalate/Blue Martini Experience.
  • Experience with project management, security, and architecture.
  • Experience with various data base management and visualization tools.


Candidate Skills and Competencies

Technical

  • Working knowledge of database structures, theories, principles, and practices.
  • Knowledge of applicable data privacy practices and laws.

Professional (to be added by HR)

Competencies

  • Database/ Repository Design & Implementation (DBDS)
  • Maintain and apply up to date, specialist knowledge of database concepts, object and data modelling techniques and design principles, and a detailed knowledge of the full range of database architectures, software and facilities available.
  • Analyze data requirements, to establish, modify or maintain a data model.
  • Interpret the model into an appropriate database schema within set policies.
  • Demonstrate, install and commission selected products.
  • Ensure that operational documentation for database solutions are fit for purpose and current.
  • Availability Management (AVMT)
  • Analyze service and component availability, reliability, maintainability and serviceability.
  • Ensure that services and components meet and continue to meet all of their agreed performance targets and service levels.
  • Implement arrangements for disaster recovery and documents recovery procedures.
  • Conduct testing of recovery procedures.
  • Service Level Management (SLMO)
  • Ensure that service delivery meets agreed service levels.
  • Diagnose service delivery problems and initiates actions to maintain or improve levels of service.
  • Establish and maintain operational methods, procedures and facilities in assigned area of responsibility and reviews them regularly for effectiveness and efficiency.
  • Database Software Installations/Decommissioning (HSIN)
  • Manage database configuration including installing and upgrading software and maintaining relevant documentation.
  • Evaluate new database software, review database software updates and identify those that merit action.
  • Ensure that database software is tailored to facilitate the achievement of service objectives.
  • Plan the installation and testing of new versions of database software.
  • Investigate and coordinate the resolution of potential and actual service problems.
  • Advise on the correct and effective use of database software.
  • Database Support (DBAD)
  • Draft and maintain procedures and documentation for databases.
  • Ensure conformance to standards for database objects.
  • Monitor database activity and resource usage.
  • Optimize database performance.
  • Performance Management (PEMT)
    • Supervise individuals and teams.
    • Allocate routine tasks and/or project work.
    • Provide direction, support, and guidance as necessary, in line with individuals’ skills and abilities.
    • Monitor progress against agreed quality and performance criteria.
    • Act to facilitate effective working relationships between team members.
  • Resourcing (RESC)
    • Implement resource plans, including conducting recruitment interviews.
    • Facilitate selection, assessment and onboarding processes, and internal resource allocation.
    • Contribute to transitioning of resources, complying with relevant statutory or external regulations and codes of good practice.
  • Professional Development (PDSV)
    • Maintain skills framework, or information about access to standard frameworks.
    • Advise on required outcomes for learning or skills frameworks and organizational development needs.
    • Assist practitioners with the process of creating development plans based on outcome statements.
    • Monitor practitioners’ continuing professional development records, ensuring that achievements and enhanced capabilities are recorded and references to the outcome statements.


Additional Details (work environment, specializations, etc.)

This job description in no way states or implies that these are the only duties to be performed by the employee occupying the position.  Employees will be required to follow any other job-related instructions and to perform any other job-related duties requested by their supervisor, subject to reasonable accommodations.  Nothing in this job description creates a contract of employment in any way for any person.   All employees hired by American Tire Distributors, Inc. are employees at will and the company reserves the right to terminate employees at any time for any reason or no reason at all.

Build a challenging and rewarding career with us!

American Tire Distributors is an Equal Opportunity Employer and Drug Free Workplace


Shift Type:
Job ID: R15093