Sr SQL DBA/Developer

Sr SQL DBA/DeveloperThe Sr SQL DBA/Developer sits on a team of 5 SQL DBAs, and has hybrid responsibilities of SQL DBA and Development work. We use SQL Server versions 2016-2022, and are getting ready to migrate many of these databases to Azure SQL. In addition to DBA responsibilities, we're also looking for this individual to write SQL and PowerShell scripts, T-SQL queries, support SSIS packages and SSRS reporting.What you'll be doing:Optimize stored procedures, functions, and ad-hoc SQLDesign, develop, and implement internal data feeds, data reporting extracts, and ETL processes between disparate systems using SSIS and Visual StudioImplement, develop, and support enterprise reporting solutions using SQL Server Reporting Services (SSRS), including datasets, reports, dashboards, and scheduled refreshesImplement, develop, and support integrations using SQL Server Integration Services (SSIS), including deployment, configuration, and troubleshootingMonitor relational databases to optimize performance, resource utilization, backup/recovery, and physical implementation using SQL monitoring tools such as SQL Sentry (or equivalent)Perform SQL Server patching, cumulative updates, and version upgrades, ensuring minimal downtime and adherence to change management processesReview database objects and create and maintain change controlsMonitor and maintain database security, including authentication, authorization, auditing, and encryptionMigrate databases between servers, storage platforms, and environments (on-premises and Azure)Analyze, troubleshoot, and resolve SQL Server performance issues, replication issues, and availability failuresDocument data flows, application specifications from a database perspective, and system proceduresImplement, configure, and maintain data distribution and disaster recovery solutions, including replication, log shipping, failover clustering, and SQL Server Availability Groups, and troubleshoot issues across multiple data centersDevelop and maintain PowerShell scripts to automate administrative tasks, monitoring, deployments, patching, and health checksSupport and administer Azure-based SQL Server environments, including IaaS SQL Server, Azure SQL, or Managed Instances (as applicable)Provide 24x7 on-call support on a rotating basisFlexible to work off-hours as requiredSkills we're seeking:5+ years of experience as a SQL DBAMust have experience with both on-prem SQL Server + Azure SQLExpert-level SQL Server performance tuning and troubleshooting experience, including execution plans and indexing strategiesSQL Server replication technologiesSQL Server Availability Groups, including setup, maintenance, and troubleshootingExperience with SQL Server monitoring tools (e.g., SQL Sentry or equivalent)Experience performing SQL Server patching, cumulative updates, and upgradesExperience writing T-SQL queries and optimizing poorly performing T-SQL queriesExperience writing SQL and/or PowerShell scriptsExperience supporting SSIS packagesExperience with SSRS reportingNice to haves:Experience with Power BIExperience modernizing legacy SSRS reporting to Power BIBachelor's or Master's Degree in Computer Science or a related fieldSQL and/or Azure certifications 1872 Consulting