Sr SQL DBA/Developer

Sr SQL DBA/Developer
Hybrid Schedule: - days onsite in the loop; work from home rest of the week

Summary
The Sr SQL DBA/Developer sits on a team of SQL DBAs, and has hybrid responsibilities of SQL DBA and Development work. We use SQL Server versions -, 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 SQL
• Design, develop, and implement internal data feeds, data reporting extracts, and ETL processes between disparate systems using SSIS and Visual Studio
• Implement, develop, and support enterprise reporting solutions using SQL Server Reporting Services (SSRS), including datasets, reports, dashboards, and scheduled refreshes
• Implement, develop, and support integrations using SQL Server Integration Services (SSIS), including deployment, configuration, and troubleshooting
• Monitor 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 processes
• Review database objects and create and maintain change controls
• Monitor and maintain database security, including authentication, authorization, auditing, and encryption
• Migrate databases between servers, storage platforms, and environments (on-premises and Azure)
• Analyze, troubleshoot, and resolve SQL Server performance issues, replication issues, and availability failures
• Document data flows, application specifications from a database perspective, and system procedures
• Implement, 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 centers
• Develop and maintain PowerShell scripts to automate administrative tasks, monitoring, deployments, patching, and health checks
• Support and administer Azure-based SQL Server environments, including IaaS SQL Server, Azure SQL, or Managed Instances (as applicable)
• Provide x on-call support on a rotating basis
• Flexible to work off-hours as required

Skills we're seeking

• + years of experience as a SQL DBA Must have experience with both on-prem SQL Server + Azure SQL Expert-level SQL Server performance tuning and troubleshooting experience, including execution plans and indexing strategies SQL Server replication technologies SQL Server Availability Groups, including setup, maintenance, and troubleshooting Experience with SQL Server monitoring tools (, SQL Sentry or equivalent) Experience performing SQL Server patching, cumulative updates, and upgrades
• Experience writing T-SQL queries and optimizing poorly performing T-SQL queries
• Experience writing SQL and/or PowerShell scripts
• Experience supporting SSIS packages
• Experience with SSRS reporting

Nice to haves

• Experience with Power BI
• Experience modernizing legacy SSRS reporting to Power BI
• Bachelor's or Master's Degree in Computer Science or a related field
• SQL and/or Azure certifications