Lead SQL Database Administrator

Job Posting:

Since 1953, Ferguson has been a source of quality supplies for a variety of industries. Together We Build Better infrastructure, better homes and better businesses. We exist to make our customers’ complex projects simple, successful, and sustainable. We proactively solve problems, adapt and grow to continuously serve our customers, communities and each other. Ferguson is proud to provide best-in-class products, service and capabilities across the following industries: Commercial/Mechanical, Facilities Supply, Fire and Fabrication, HVAC, Industrial, Residential Trade, Residential Building and Remodel, Waterworks and Residential Digital Commerce. Ferguson has approximately 36,000 associates across 1,700 locations. Ferguson is a community of proud associates who operate with the shared purpose of building something meaningful. You will build a career that you are proud of, at a company you can believe in.

Are you an experienced Lead SQL Database Administrator with a passion for supporting enterprise-level systems in a dynamic and fast-paced environment? Join Ferguson's Supply Chain Solutions & Infrastructure (SCS&I) team, where you’ll play a meaningful role in maintaining and enhancing the database systems that power our Supply Chain operations. Our team is responsible for creating, updating, and supporting applications that drive Ferguson’s order management, inventory control, warehouse automation, and fulfillment processes, including innovative solutions using conveyors and robotic systems.

In this role, you’ll apply your expertise to administer and maintain SQL database systems, ensuring 24/7 availability for our enterprise operations. You’ll collaborate with internal customers, team members, and sponsors to manage database software, perform installations, upgrades, and maintenance, and implement robust backup solutions across MS SQL Server and Oracle environments. With a focus on performance optimization, automation, and cloud integration, you’ll work with innovative technologies, including SQL Server 2016 or higher, Always On Availability Groups, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS), while using scripting tools such as T-SQL, PowerShell, and other automation frameworks.

If you have proven track record in database management, proficiency with cloud platforms like AWS, Azure, or Oracle Cloud, and a track record of supporting enterprise-level databases in production environments, we want to hear from you!

Location: This role is approved to be either Remote within the United States or Hybrid for associates in Newport News, VA, in accordance with company policy.

Duties and Responsibilities:

• Ensure the quality and delivery of technical operations supporting the business according to agreed standards.
• Provide technical support within the Supply Chain Command Center, including proactive and reactive incident resolution.
• Install, configure, and maintain MS SQL Server software and applications in both standalone and high availability configurations per Ferguson standards.
• Participate in a 24x7x365 on-call rotation, currently required every day due to team structure. This may change to a less frequent rotation in the future.
• General knowledge of Windows, Networking, and product Security methods (Linux is a plus).
• Perform proactive reviews of system performance metrics and alerts to ensure regular event correlation and trend analysis.
• Review system logs to identify potential problems.
• Create backup and recovery methodologies.
• Implement software or system releases (patches or upgrades) as requested.
• Assist technical staff with MS SQL Server and associated software packages.
• Clone, recover, and migrate databases.
• Respond to requests for database configuration changes as directed by senior staff or project leads.
• Administer third-party applications requiring MS SQL Server support as needed.
• Perform tuning to resolve performance issues in SQL, applications, and at the RDBMS level.
• Write, execute, and peer review SQL, T-SQL, and PL/SQL scripts, packages, and functions.
• Write, execute, and peer review OS-level scripts.
• Create, execute, and report on load testing of applications, databases, and servers.

Technical Expertise:

• Strong MS SQL database background, including:
• Installation and service
• Operating system knowledge
• Server setup and installation
• Standalone and high availability configurations
• Backup and recovery
• Patching and upgrading
• Troubleshooting (tracing, identifying and removing locks, code performance, etc.)
• Development skills:
• Proper database design and data modeling
• Table design an