Database Administrator II

Qualifications & Requirements

Education, Work Experience, Skills

The Database Administrator II must have a BA/BS in computer science, related field, or equivalent experience with 5+ years’ experience of Microsoft SQL Server Administration.

The ideal candidate must have good judgment, problem-solving, oral, written and interpersonal communication skills, as well as the ability to work in a fast-paced environment and build positive working relationships. In addition, candidates must be self-motivated, organized, and able to multi-task and effectively prioritize competing demands.

• Database administration experience with SQL Server 2014, 2016, 2017, and 2019.
• Proficiency with Transact-SQL including the ability to write, debug, and maintain scripts, stored procedures, functions, and views.
• Experience configuring and maintaining replication, log shipping, and database mirroring.
• Experience installing and configuring SQL Server on virtual machines and stand-alone servers.
• Experience developing SSIS packages.
• Experience optimizing and administering SSRS reports.
• A solid understanding of normalized database design and modeling.
  

Optional Skills

• A working knowledge of Idera, RedGate, and SentryOne database tools.
• Proficiency with PowerShell scripting.
• Experience with SSRS report development.
• Experience with setup and administration of Always On availability groups.
• Experience installing and configuring SQL Server on fail-over clusters.