Sign upLog in

Sr SQL DBA/Developer

1872 Consulting

Chicago, IL

Apply
JOB DETAILS
SKILLS
Administrative Skills, Analysis Skills, Auditing, Authentication, Change Control, Change Management, Clustering Software, CompTIA Server+, Computer Science, Cryptography, Data Recovery, Data Sets, Database Administration, Database Extract Transform and Load (ETL), Database Optimization, Database Replication, Disaster Recovery, Failover, Identify Issues, Information/Data Security (InfoSec), Infrastructure as a Service (IaaS), Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Visual Studio, Microsoft Windows Azure, Network Operations Center, On Call, Performance Tuning/Optimization, Power BI, Query Optimization, Relational Databases (RDBMS), Replication and Remote Mirroring, Reporting Dashboards, Resource Utilization, SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Scripting (Scripting Languages), Server Clusters, Software Patches, Stored Procedures, System Migration, Testing, Windows PowerShell, Work From Home
LOCATION
Chicago, IL
POSTED
30+ days ago
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

About the Company

1

1872 Consulting