Sr SQL DBA Developer
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
Skills we're seeking
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
- 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
