Lead SQL Database Administrator

Ferguson Enterprises, LLC; United States; Remote; USD 60,000 - 80,000; Full time

Job summary

Join a forward-thinking company as a Lead SQL Database Administrator, where you'll play a crucial role in enhancing and maintaining enterprise-level database systems. This position offers the opportunity to work with innovative technologies in a dynamic environment, ensuring the seamless operation of our Supply Chain processes. You will collaborate with various teams to implement robust backup solutions and optimize performance across SQL Server and Oracle environments. If you are passionate about database management and eager to contribute to meaningful projects, this role is perfect for you.

Benefits

Health Insurance

Dental Insurance

Vision Insurance

Paid Time Off

401(k) with Company Match

Mental Health Coverage

Paid Parental Leave

Community Involvement Opportunities

Qualifications

• 10+ years of experience in MS SQL Server administration.
• Proficiency in cloud platforms and database performance tuning.

Responsibilities

• Administer and maintain SQL database systems ensuring 24/7 availability.
• Collaborate with teams to manage database software and perform upgrades.

Skills

MS SQL Server Administration

Database Performance Tuning

PowerShell Scripting

Oracle Database Management

Cloud Platforms (AWS, Azure)

NoSQL Databases

Disaster Recovery Solutions

Data Modeling

Education

Bachelor's Degree in Computer Science

Certifications in Database Management

Tools

SQL Server Management Studio

Azure Data Factory

SSIS

SSRS

Oracle Cloud

Job description

Lead SQL Database Administrator page is loaded

Lead SQL Database Administrator

Apply locations Remote time type Full time posted on Posted 3 Days Ago job requisition id R-124817

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 and creation
• Query creation and optimization
• Creating and evaluating views, stored procedures, triggers, and functions
• Index creation and implementing proper indexing and statistics strategies

Additional Responsibilities:

• Know the latest on technologies affecting current systems infrastructure, with specialization in database technology.
• Ensure the knowledge database is populated with resolutions, workarounds, and known issues.

Qualifications and Requirements:

• Minimum of 10 years of MS SQL Server database administration experience.
• Minimum of 5 years of MS SQL Server development experience.
• Experience with Oracle 12c and newer, including RAC, is a plus.
• Experience with NoSQL databases such as Cosmos DB and MongoDB is a plus.
• Installation, configuration, and support for MS SQL Server 2012 or newer.
• Implementing High Availability and Disaster Recovery solutions within MS SQL Server.
• Proficiency with SSRS, SSIS, SSAS, Power BI, Azure Data Factory, and Azure Analysis Services.
• Solid understanding of Disaster Recovery and Business Continuity practices.
• Expertise in database performance tuning and query optimization.
• Experience with Azure SQL and Azure SQL Managed Instance.
• Proficient in PowerShell scripting.
• Managing enterprise-class MS SQL Server databases in a production data center environment.
• Proactive database health monitoring, deadlock error resolution, maintenance package execution, and space/indexing strategy monitoring.
• Experience with both OLTP databases and OLAP/data warehousing.
• Knowledge of data modeling and data typing.
• Strong organizational skills and ability to manage multiple tasks with frequent interruptions.
• Excellent problem-solving skills and attention to detail.
• Capability to independently apply knowledge, with awareness of when to request help.
• Excellent written and verbal communication skills, with the ability to convey technical concepts in a business-friendly manner.
• Professional and positive demeanor in all situations.

At Ferguson, we care for each other. We value our well-being just as much as our hard work. We are committed to a holistic approach towards benefits plans and programs that support the mental, physical and financial well-being of our associates. Our competitive offering not only includes benefits like health, dental, vision, paid time off, life insurance and a 401(k) with a company match, but our associates also enjoy additional meaningful and inclusive enhancements that are adaptable to their diverse situations and needs, including mental health coverage, gender affirming and family building benefits, paid parental leave, associate discounts, community involvement opportunities and more!

-

Pay Range:

-

Actual pay rate may vary depending upon location. The estimated pay range for this position is below. The specific rate will depend on a candidate’s qualifications and prior experience.

-

$8,470.59 - $14,834.37

-

Estimated Ranges displayed are Monthly for Salaried roles OR Hourly for all other roles.

-

This role is Bonus or Incentive Plan eligible.

-

Ferguson complies with all wage regulations. The starting wage may be higher in certain locations based on local or state wage requirements.

-

The Company is an equal opportunity employer as well as a government contractor that shall abide by the requirements of 41 CFR 60-300.5(a), which prohibits discrimination against qualified protected Veterans and the requirements of 41 CFR 60-741.5(A), which prohibits discrimination against qualified individuals on the basis of disability.

Ferguson Enterprises, LLC. is an equal employment employer F/M/Disability/Vet/Sexual Orientation/Gender Identity.

Equal Employment Opportunity and Reasonable Accommodation Information