SQL Server Database Administrator

HD Supply Holdings   •  

Orlando, FL

Industry: Wholesale

  •  

5 - 7 years

Posted 173 days ago

This job is no longer available.

Major Tasks, Responsibilities and Key Accountabilities

  • Partners with Sr. DBA's to create physical database structures for small projects based on physical design for development, test, and production environments.

  • Performs routine maintenance, including upgrades and patches. Resolves issues via service tickets. Performs daily data back-up and recovery as needed. Generates scheduled and ad hoc reports.

  • Partners with Sr. DBA's and engineers to configure servers for DBMS product installation and small database creation.

  • Provides on-call support for assigned databases 24/7 to include investigating and troubleshooting problems.

  • Configures and maintains DBMS product software on small database and application servers.

  • Manages conversions of data from legacy/acquired systems as required. Reports escalated issues to Sr. DBA.

  • Monitors and adjusts database parameters for better performance.

  • Assists application teams with tuning of SQL statements.

Nature and Scope

  • Demonstrates skill in data analysis techniques by resolving missing/incomplete information, inconsistencies/anomalies in more complex research/data.

  • Nature of work requires increasing independence; receives guidance only on unusual complex problems or issues. Work review typically involves periodic review of output by supervisor and/or direct "customers" of the process.

  • May provide general guidance/direction to or train junior level support personnel or professional personnel.

Work Environment

  • Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.

  • Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.

  • Typically requires overnight travel less than 10% of the time.

Education and Experience

  • Typically requires BS/BA in related discipline. Generally 2-5 years of experience in related field; certification is required in some areas OR MS/MA and generally 2-4 years of experience in related field. Certification is required in some areas.

Preferred Qualifications & Job Specific Details

Required Skills:

  • 4+ years of demonstrated experience in Microsoft SQL Server database administration, performance tuning, backup and recovery, high availability, and security

  • Extensive knowledge of SQL Server versions 2012, 2014, and 2016

  • Expert in Transact SQL (T-SQL), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)

  • Experienced in implementing and supporting SQL Server Availability Groups as well as SQL Server Mirroring.

  • Highly skilled in troubleshooting performance related issues

Desired Skills:

  • Certified Microsoft SQL Server Administrator

PRID

PRID135

Job ID 2018-29272