Support, administer, and maintain development, test, and production environments.
Work with project teams comprised of project managers, developers, application vendors, application engineers, and application users to provide DBA support for database deployments and upgrades.
Create and maintain SQL Server Integration Services (SSIS) packages.
Review, deploy, and administer security for SQL Server Reporting Services (SSRS) reports.
Develop and maintain troubleshooting, configuration, and integration documentation for administered systems.
Function as a primary or backup DBA for assigned applications. Have a working knowledge of all database applications.
Work with server engineers, storage engineers, and network engineers to resolve issues and prevent downtime.
Provide 24x7 operational support. On-call support responsibilities are rotated among the members of the DBA team.
The SQL DBA 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 2008 R2, 2012, 2014 and 2016.
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.
Nice to Haves
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.