L
Job Description
Lensa is a career site that helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes jobs on LinkedIn on behalf of its direct clients, recruitment ad agencies, and marketing partners. Lensa partners with DirectEmployers to promote this job for Ferguson Enterprises. Clicking "Apply Now" or "Read more" on Lensa redirects you to the job board/employer site. Any information collected there is subject to their terms and privacy notice.
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.
- 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.
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)
If you have questions about this posting, please contact [email protected]
Similar Jobs
Explore other opportunities that match your interests
Visa Sponsorship
Relocation
Remote
Job Type
Part-time
Experience Level
Executive
co studio advertising services...
United State
Visa Sponsorship
Relocation
Remote
Job Type
Full-time
Experience Level
Executive
laxmint
United State
Visa Sponsorship
Relocation
Remote
Job Type
Contract
Experience Level
Mid-Senior level
Veridian Tech Solutions, Inc.
United State