SQL Database Administrator Remote

Job description

**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, a Fortune 500 company, 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.

We have an exciting opportunity for a **MS SQL Server Database Administrator** to join the IT Operations Center team within the Ferguson IT organization.

In this role, you will be responsible for administering and maintaining database systems, including installation, configuration, monitoring, data management, and troubleshooting, with a main focus on MS SQL Server.

You will work closely with collaborators and multi-functional teams to ensure the performance, security, and reliability of Ferguson’s database environment.

This is a key position to ensure the smooth operation of critical database systems that support business operations across the organization.

Location: This role is approved to be fully remote and can be based anywhere in the United States.

**Duties and Responsibilities:**

+ Provide technical support within the Operations Center to include proactive and reactive incident resolution.
+ Ensure the quality and delivery of technical operations supporting the business in accordance with agreed standards.
+ Collaborate with systems analysts, developers, business analysts, and project teams to offer technical assistance.
+ Perform proactive reviews of system performance metrics, logs, and alerts to ensure event correlation and trend analysis are performed on a regular basis.
+ Provide server and database support, including installation, patching, upgrading, maintenance, restores, and backups on MS SQL Server per Ferguson standards.
+ Ensure team documentation is populated with resolutions, workarounds, known issues.
+ Assist technical staff with MS SQL Server and associated software packages.
+ Stay ahead of the curve when it comes to advancements in database technologies.
+ Write, execute, and peer review T-SQL scripts, packages, and functions, and OS-level scripts.
+ Create, execute, and report on load testing of databases, and servers.
+ Participate in a 24x7 on-call rotation to support after hours issues and planned work.

**Qualifications and Requirements:**

+ Minimum of 5 years of MS SQL Server database administration experience.
+ BA or BS degree preferred.
+ Recent experience and proficiency with Cloud computing platforms, such as Azure, Oracle Cloud, AWS, and GCP.
+ Experience with installation, configuration, patching, and support for MS SQL Server 2016 and newer.
+ Experience implementing High Availability and Disaster Recovery solutions within MS SQL Server.
+ Experience with SSRS, SSIS, and SSAS or Power BI, Azure Data Factory, Azure Analysis Services, Azure SQL, and Azure SQL Managed Instance.
+ Experience in T-SQL and PowerShell scripting.
+ Experience in an enterprise level production data center environment managing enterprise class MS SQL Server databases.
+ Experience in proactively monitoring database health, repairing deadlock errors, performing maintenance packages, monitoring, and indexing strategy.
+ Experience in both OLTP databases and OLAP/data warehousing.
+ Experience with Databricks Administration is desired.
+ MongoDB, Cosmos DB, Postgres, MySql, and Oracle experience is desired.
+ Strong organizational and problem-solving skills.
+ Excellent written and verbal communication skills.
+ Ability to work multi-functionally in a team environment and independently.
+ Ability to handle various tasks with frequent interruptions.
+ Skill to follow guidelines, while also applying acquired knowledge to deviate from those guidelines when necessary.

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._

-

$5,444.76 - $9,537.00
-

**_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 (https://www.ferguson.com/content/careers/reasonable-accommodation)

Required Skill Profession

Other General