Database Administrator

Distribution Lebanon, Indiana


Description

SUMMARY:   We are searching for a Database Administrator with knowledge of Microsoft SQL Server, Sybase ASE Server and Oracle to manage the databases for the Distribution Center.  This position is responsible for the continued up-time operation of a large fulfillment system which interfaces to the corporate systems for data downloads and uploads and to a local external system for picking and product movement as well as for transportation of all shipments.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

  • Ongoing Database Administration support, enhancement and project work.
  • Monitor the Microsoft, Sybase and Oracle databases for continued operation with emphasis on performance, database growth, system bottlenecks, deadlocks, and user sessions.
  • Administration of database middleware software, processes, and procedures
  • Investigate path for conversion from Sybase ASE Server to Microsoft SQL Server.
  • Ensure that backup procedures are implemented according to planned design.
  • Responsible for performance monitoring and tuning and consistency checks of databases.
  • Responsible for requested start-up and shutdown of a given database.
  • Maintain inter-database gatweays.
  • Maintain and manage multiple databases for Development, Testing, and Special Projects.
  • Analyze system monitoring reports to make recommendations on hardware and operating system needs.
  • Offer support and suggestions on efficiency to developers, with an emphasis on optimizing indexes, table design, etc.
  • Validate recovery procedures on a regular basis to ensure integrity of the backups and procedures.
  • Handle problem resolution, reporting, and tracking.
  • Implement scripts to automate batch processing.
  • Maintain separate test and production images of source code for tables, procedures, triggers, etc.; Work with vendor provided utilities to facilitate this task.
  • Review devoloper’s scripts and command files when readying application for test and production.
  • Participate in the on-call rotation for after hours support.
  • Document standards, procedures, and naming conventions for database development and usage.

ADDITIONAL DUTIES AND RESPONSIBILITIES:

  • Work with Operations Personnel as needed to ensure continued operation as upgrades and patches are planned and installed for all database systems.
  • Participate in future planning strategy discussions.
  • Participate in annual database education and training classes.
  • Help in training users and other systems administration personnel.
  • Special or as needed duties assigned by Manager.

SUPERVISORY RESPONSIBILITIES:  N/A

QUALIFICATION REQUIREMENTS:  To perform this position successfully, an individual must be able to perform each essential duty satisfactorily.  The requirements listed below are representative of the knowledge, skill, and/or ability required.  Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

SKILLS REQUIRED:

  • Knowledge of Microsoft SQL Server 11, 13, and 15;
  • Knowledge of Sybase ASE Enterprise Server 15 and 16;
  • Knowledge of Oracle 18c Enterprise Server and Oracle Transparent Gateways;
  • Knowledge of Linux operating system, command language and shell scripting;
  • Strong analytical skills needed to determine issues in existing systems;
  • Strong SQL programming skills;
  • Previous Warehouse Management System experience is helpful;

EDUCATION AND EXPERIENCE:  It is preferred that candidates will have at least a Bachelors degree or equivalent experience, and 3-5 years of relevant professional experience.

Hachette Book Group provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.