Sr SQL DBA/Developer
Hybrid Schedule: 1-3 days onsite in the loop; work from home rest of the week
Summary
The 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 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 24x7 on-call support on a rotating basis
• Flexible to work off-hours as required
Skills we're seeking
• 5+ 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 (e.g., 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