Senior DataBase Administrator

Hachette Book Group - Lebanon, IN

Full-time - Senior

Lebanon, IN

Publishing Industries

About the position

The Senior Database Administrator is responsible for managing and maintaining the databases for the Distribution Center, ensuring their availability, security, and stability. This role involves monitoring database performance, validating data accuracy, and overseeing performance tuning to provide fast response times for users. The Senior Database Administrator collaborates with the Software Development team to design and maintain database structures that meet the organization's needs, while also performing regular updates to adapt to evolving technologies.

Responsibilities

• Perform ongoing Database Administration functions for support and enhancement.
• Monitor the Microsoft and Oracle databases for continued operation with emphasis on performance, database growth, system bottlenecks, deadlocks, and user sessions.
• Ensure that backup procedures are implemented according to planned design.
• Perform monitoring, tuning and consistency checks of databases.
• Work with the entire Software Development team on the design of new database structures to support the ever-changing business needs.
• Offer support and suggestions on efficiency to developers, with an emphasis on optimizing indexes, table design, and other database elements.
• Review developer's scripts and command files when readying application for test and production.
• Implement scripts to automate batch processing.
• Execute processes to extract and load data between databases in different environments.
• Maintain and manage multiple databases for Development, Testing, and Special Projects.
• Maintain direct cross-database links and inter-database gateways.
• Administer database middleware software, processes, and procedures.
• Analyze system monitoring reports to make recommendations on hardware and operating system needs.
• Validate recovery procedures on a regular basis to ensure integrity of the backups and procedures.
• Handle problem resolution, reporting, and tracking.
• Maintain separate test and production images of source code for tables, procedures, triggers, etc.; Work with vendor provided utilities to facilitate this task.
• Participate in the on-call rotation for afterhours support.
• Document standards, procedures, and naming conventions for database development and usage.

Requirements

• Knowledge of Microsoft SQL Server 14, 15, and 16.
• Knowledge of Oracle 18c Enterprise Server and later versions Oracle Transparent Gateways.
• Strong analytical skills needed to determine issues in existing systems.
• Strong SQL programming skills.
• Ability to manage multiple responsibilities and work effectively in a fast-paced environment.
• Proven work ethic, reliable and confidential.
• Knowledge of Linux operating system, command language and shell scripting is a plus.
• Previous Warehouse Management System experience is a plus.
• Bachelor's degree or equivalent experience, and 8-10 years of relevant professional experience.

Nice-to-haves

• Knowledge of Linux operating system, command language and shell scripting.
• Previous Warehouse Management System experience.

Benefits

• Equal employment opportunities without discrimination or harassment.