Senior SQL Server DBAChicago, IL (Remote to start)What You'll Be DoingSupport, administer, and maintain development, test, and production SQL Server 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.Troubleshoot server and database performance problems and identify solutions to resolve the problems.Administer SQL Server security and protect sensitive data.Adhere to the Firm's IT Service Delivery standards and Change Control processes.Adhere to the Firm's Security and Governance requirements across all administered applications.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.Requirements5+ years of experience with SQL Server DBA experienceIdeally 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 availability groups.Experience installing and configuring SQL Server on virtual machines.Experience developing SSIS packages.Experience optimizing and administering SSRS reports.A solid understanding of normalized database design and modeling.Nice to Have ExperienceA working knowledge of Idera, RedGate, and SentryOne database tools.Proficiency with PowerShell scripting.