Loading...
Share this Job

Senior Database Administrator

Date: Oct 7, 2021

Location: Bonita Springs, Florida, United States

Company: Herc Rentals

Req #: 34315

Herc Rentals Inc. is a premier, full-service equipment rental firm – providing our customers the equipment, services and solutions they need to achieve optimal performance safely, efficiently and effectively. A pioneer of the equipment rental industry, Herc Rentals continues to evolve and grow through technological innovations, expanded product offerings and value-added services and consultative solutions to support its customers’ projects. 

 

With more than 55 years of equipment rental expertise, approximately 4,900 employees and approximately 270 company-operated locations across North America, Herc Rentals serves a broad range of end markets, including construction; industrial operations, refineries and petrochemical operations; governmental entities and contractors; disaster recovery and remediation; infrastructure; railroad operations; utilities; film, television, live entertainment and special event production; agricultural operations; and facilities management..

 

 

Description

The Senior Database Administrator role is to ensure the stability, integrity, and efficient operation of the inhouse database systems that support core organizational functions. This is achieved by monitoring, maintaining, supporting, and optimizing all networked database systems. Senior database administrator applies proven communication, analytical, and problem-solving skills to help identify, communicate, and resolve issues to maximize the benefit of IT systems investments. 

Responsibilities

Strategy & Planning

  • Design and review new database structures to ensure appropriate performance, indexing, redundancy, resiliency, and cost-effectiveness.
  • Collaborate with network staff to ensure smooth and reliable operation of software and systems for fulfilling business objectives and processes.

Acquisition & Deployment

  • Assists in the development, testing, and operations of database systems.
  • Perform cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions.
  • Evaluate acquired database systems and identify, protection and security remediation need to safeguard data and availability
  • Interact and negotiate with vendors, outsourcers, and contractors to secure database-related products and services.

Operational Management

  • Plan, document, and conduct database upgrade, data migration as the need arise 
  • Plan and periodically test failover for redundant systems
  • Review database monitoring metrics to identify and correct performance bottlenecks
  • Maintain an inventory of databases and key attributes for manageability
  • Gauge the effectiveness and efficiency of existing database systems; develop and implement strategies for improving or further leveraging these database systems.
  • Reviews and administers information security requirements for database system access to determine if they have been designed to comply with established standards.
  • Propose and create system design models, specifications, diagrams, and charts to provide direction to system programmers and development teams.
  • Design and perform database server and security audits, database backup procedures, maintenance plans, and other recovery processes in accordance with the company’s disaster recovery and business continuity strategies.
  • Create and maintain documentation as it relates to system configuration, mapping, processes, and service records.
  • Ensure compatibility and interoperability of in-house computing systems.
  • Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems.
  • Monitor and test system performance; prepare and deliver system performance statistics and reports.
  • Implement replication and database clustering strategies for MS SQL Server.
  • Ensure that new database artifacts meet company standards for readability, reliability, and performance.
  • Proactively identify resource-intensive queries and work with development teams on optimization strategies for improving performance.
  • Advise and educate development teams on efficient database designs and best practices.
  • Maintain documentation for the company’s MS SQL Server database environment.
  • Perform regular database code migrations from the lower environment to stage and production installations
  • Purge/Archive of large production tables and monitor their impact on SQL performance.
  • Working with onsite/offshore team to trace the application problem. 
     

Requirements

Knowledge & Experience

  • Proven experience in overseeing the design, development, and implementation of database systems, applications, and related products.
  • Experience reviewing database system architecture and identifying improvement opportunities to proposed designs
  • Proven experience with designing and implementing highly available database systems.
  • Build database schemas, tables, views, and stored procedures.
  • Experience on AWS services EC2, RDS, S3, CloudWatch, Database Migration Service, IAM.
  • Knowledge on AWS services ECS, S3 Glacier, VPC, Subnets, Security Groups, Directory Svc. 
  • Advanced knowledge of security and configuration best practices including RBAC.
  • Experience with managing all aspects of database administration in a Windows Server stand-alone and clustered environment by developing and maintaining backup and restore architecture, security management, service packs & cumulative updates installation.
  • Advanced T-SQL skills including development and performance optimization.
  • Experience in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
  • Strong experience working on Disaster Recovery, High Availability concepts Always-On Availability Groups, Replication.
  • Excellent understanding of the organization’s goals and objectives.
  • Knowledge of applicable data privacy practices and laws.
  • Good project management skills.
  • Excellent written, oral, and interpersonal communication skills.
  • Ability to conduct research into systems issues and products as required.
  • Ability to communicate ideas in both technical and user-friendly language.
  • Highly self-motivated and directed, with keen attention to detail.
  • Proven analytical and creative problem-solving abilities.
  • Able to prioritize and execute tasks in a high-pressure environment.
  • Strong customer service orientation.
  • Ability to work in a team-oriented, collaborative environment.
     

Experience Required

  • A Bachelor’s degree and 10 years of related experience, associate degree and 12 years related experience, or 15 years related experience.
  • Minimum of five (5) years of database administration experience in a corporate environment
  • ITIL certification is a plus
  • MS SQL Server certification preferred
  • Other IT certifications favorable
  • Master’s degree a plus

Skills

  • 5+ years of SQL Server experience is required. 
  • 1+ years of MySQL and Postgres experience required
  • Experience with optimizing queries required
  • Experience working in an Amazon environment highly desired
  • Linux and Telematic Experience is a plus
  • Experience using scripting languages to automate tasks and manipulate data; programming knowledge is a plus
  • Experience with building/testing/maintaining clustered, multi-AZ and replicated database systems
  • Experience developing technical diagrams and topology maps with various software applications.
  • Experience with all aspects of high availability fault tolerant architectures.
  • Ability to work in a fast-paced environment; ability to multi-task, change direction, effectively prioritize, and meet deadlines
     

 

Our long-term strategy underscores the understanding that our success depends on the dedication and capability of our team members. We are focused on attracting, retaining and empowering talented and dedicated people to build the best team in the equipment rental industry. We also seek to build a team that reflects the variety of people, cultures and communities we interact with every day and to create an inclusive, productive environment in which all team members feel valued and respected.

 

Herc Rentals provides an excellent compensation and benefits package, which includes a competitive salary, retirement savings plan, tuition reimbursement, comprehensive medical, dental, vision care, life insurance coverage, paid vacation and holidays. 

 

Herc does not discriminate in employment based on the basis of race, creed, color, religion, sex, age, disability, nationals origin, marital status, sexual orientation, citizenship status, political affiliation, parental status, military service, or other non-merit factors.

 

#LI-LM1


Job Segment: System Administrator, Medical, Agricultural, Database, DBA, Technology, Healthcare, Agriculture