SQL Database Administrator (REMOTE)

Job Description: We have an exciting opportunity for a SQL Service DBA to join the IT eBusiness Cloud Services (Build.com) team, within the Ferguson IT organization. The ideal SQL Server DBA candidate would have experience supporting complex on-prem environments, who's eager to gain experience in migrating to an Azure cloud native environment. In this role, you will be responsible for administering and maintaining database systems within Ferguson's technical environment to include installation, configuration, development, monitoring, planning, data management, and troubleshooting.This position is approved to sit 100% remote. If local to the Newport News, VA area, you will have access to in-office work within our new HQ3 facility.DUTIES AND RESPONSIBILITIES: •Ensure the quality and delivery of technical operations supporting the business in accordance with agreed standards•Provide level 3 technical support within the Support Center to include proactive and reactive incident resolution•Perform proactive review of systems performance metrics and alerts to ensure event correlation and trend analysis are performed on a regular basis•Ensure knowledge database is populated with resolutions, workarounds, known issues•Review system logs to identify signs of potential problems•Execute software or system releases as requested•Stay current on technologies affecting current systems infrastructure issues with specialization in database technology area•Assist technical staff with the MS SQL Server and associated software packages•Clone, recover, and migrate databases•Respond to requests for database configuration changes as directed by senior staff•Administer third-party applications that require MS SQL Server support as needed•Perform tuning to resolve performance issues in SQL, applications, and at the RDBMS•Write, execute, and peer review SQL, T-SQL, and PL/SQL scripts, packages, and functions•Write, execute, and peer review OS-level scripts•Install, configure, maintain MS SQL Server software and applications per Ferguson standards•Create, execute, and report on load testing of applications, databases, and servers•Participate in a 24\\7 on-call rotation•Strong MS SQL database development background to include the following:o Proper database design and data modelingo Table design and creationo Query creationo Query performance tuning and optimizationo Creating and evaluating Views, Stored Procedures, Triggers and Functionso Index creation and implementing proper indexing and statistics strategiesQUALIFICATIONS AND REQUIREMENTS: •Minimum of 5 years MS SQL Server development experience•Minimum of 5 years MS SQL Server database administration experience•BA or BS degree preferred•Experience with the installation, configuration and support for MS SQL Server 2012 or 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, and Azure Analysis Services•Strong knowledge of database performance tuning and query optimization•Experience with Azure SQL and Azure SQL Managed Instance•Experience in 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, executing maintenance packages, monitoring space and indexing strategy•Experience in both OLTP databases and OLAP/data warehousing•MongoDB, Cosmos DB, Oracle experience desired but not required•Strong organizational skills•Ability to work collaboratively in a team environment•Manage multiple tasks with frequent interruptions•Good problem solving skills•Detail oriented•Demonstrates the ability to follow instructions, while also applying learned knowledge to go outside those instructions•Ability to work independently and to know when to ask for assistance•Excellent written and verbal communication skills•Ability to convey a professional and positive image in all situations•Consistently executes presenting one's thoughts and ideas in an organized manner•Consistently executes documenting findings and solutions that address business needs•Consistently executes in communicating technical concepts and ideas in a business friendly mannerPerks:Ferguson is dedicated to providing meaningful benefits programs and products to our associates and their families-geared toward benefits, wellness, financial protection, and retirement savings. Ferguson offers a competitive benefits package that includes medical, dental, vision, retirement savings with company match, paid leave (vacation, sick, personal, and holiday), employee assistance programs, associate discounts, community involvement opportunities, and much more!We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.#LI-REMOTE-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