Talent.com
1872 Consulting
Sr SQL DBA/Developer1872 Consulting • Chicago, IL
Sr SQL DBA/Developer

Sr SQL DBA/Developer

1872 Consulting • Chicago, IL
30+ days ago
Job type
  • Full-time
Job description

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

Create a job alert for this search

Sr SQL DBA/Developer • Chicago, IL

Similar jobs

Solutions Architect, Data, Google Cloud

GoogleChicago, IL, United States
Full-time

The application window will be open until at least May 4, 2026.This opportunity will remain online based on business needs which may be before or after the specified date.Note: By applying to this ... Show more

 • Promoted

Senior SAP BW/4HANA Analytics Consultant

Ardagh GroupChicago, IL, United States
Full-time

A leading global packaging company is seeking a Senior SAP BW 4/Hana Consultant in Chicago.This role focuses on designing and deploying reporting solutions, including dashboards and data integratio... Show more

 • Promoted

Senior BI Architect: ThoughtSpot & Cognos Expert (Hybrid)

ESR HealthcareChicago, IL, United States
Full-time

A leading company in the Information Technology sector is seeking a Business Intelligence Architect in Chicago.The role involves designing and developing BI solutions, leading development teams, an... Show more

 • Promoted

Data Architect I — Hybrid ETL & Healthcare Analytics

Ann & Robert H. Lurie Children's Hospital of ChicagoChicago, IL, United States
Full-time

A prominent pediatric hospital in Chicago is seeking a Data Architect I to design and manage data integration solutions.The role involves developing custom analytics solutions and supporting data a... Show more

 • Promoted

Data & BI Solution Architect

Inizio Partners CorpChicago, IL, United States
Full-time

About the job Data & BI Solution Architect.Our client provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting‑edge analytics techniques, and a ... Show more

 • Promoted

Sr Mobile API Database Developer

LorienChicago, IL, United States
Full-time

Mobile-First API Development: Design and build secure, scalable REST/JSON (or GraphQL) APIs optimized for mobile consumption, including authentication, authorization, and versioning.Cloud-Native Ba... Show more

 • Promoted

Senior Director, Enterprise Software & AI Enablement

Northern Trust CorpChicago, IL, United States
Full-time

A leading financial institution is seeking a seasoned technology leader in Chicago with deep alternative investments expertise.This role involves strategic design of end-to-end platforms and mentor... Show more

 • Promoted

SQL DBA / Systems Analyst

CGS Federal (Contact Government Services)Chicago, IL, United States
Full-time

CGS Federal (Contact Government Services) is seeking a SQL DBA / Systems Analyst to join our team supporting a wide-ranging technical support initiative for a large Federal agency.CGS brings motiva... Show more

 • Promoted

Data QA Lead - SQL, BigQuery & ETL Validation

TechDigital GroupChicago, IL, United States
Full-time

An innovative firm is seeking a detail-oriented SQL Specialist to enhance data validation processes.In this role, you will leverage your deep SQL knowledge to debug complex queries and ensure data ... Show more

 • Promoted

Senior Cloud Architect: Strategy, Design & Scalable Infra

Children’s Research FundChicago, IL, United States
Full-time

A prominent healthcare organization located in Chicago is seeking a Cloud Architect to define and implement their cloud strategy.Responsible for cloud management and infrastructure, this role requi... Show more

 • Promoted

Database Development

TradeJobsWorkForce60546 Riverside, IL, US
Full-time

Database Development Job Duties: Database Developers are responsible for data gathering before development of ... Show more

 • Promoted

Databricks Tech Lead: Data Platform Architect

Ender-ITChicago, IL, United States
Full-time

A leading staffing and recruiting firm seeks a Databricks Technical Lead in Chicago, IL.This role requires extensive experience with Databricks and Spark, guiding the design and implementation of d... Show more

 • Promoted

SAP MDG Architect: Master Data Governance & Integration

IBMChicago, IL, United States
Full-time

A global technology and consulting firm is seeking a Mid-Senior Level SAP MDG Architect to enhance data governance and integration.The role involves defining data models, collaborating with stakeho... Show more

 • Promoted

Senior AVP, Data Architecture & Engineering Leader

Vizient, IncChicago, IL, United States
Full-time

A leading healthcare solutions provider is seeking an AVP for Solutions Data Architecture in Chicago, Illinois.This senior technical leader will manage engineering teams, ensuring delivery excellen... Show more

 • Promoted

Solutions Architect, Data, Google Cloud

Google Inc.Chicago, IL, United States
Full-time

The application window will be open until at least May 4, 2026.This opportunity will remain online based on business needs which may be before or after the specified date.Note: By applying to this ... Show more

 • Promoted

Lead Data Architect for Data Mesh & Governance

JPMorganChaseChicago, IL, United States
Full-time

JPMorganChase is seeking a Lead Data Architect to establish standards for organizing digital content and data within the Corporate Technology team.The role involves developing data models, collabor... Show more

 • Promoted

Oracle Database Developer

Innova SolutionsChicago, IL, United States
Full-time

Be among the first 25 applicants.Direct message the job poster from Innova Solutions.Innova Solutions is immediately hiring for a.Position: Oracle Database Developer.Locations: Chicago, IL and Char... Show more

 • Promoted

Data Modeler - BI Analytics & Data Warehouse (Onsite)

The Dignify Solutions, LLCChicago, IL, United States
Full-time

A technology solutions provider is seeking a Data Modeler specializing in BI Analytics for an onsite full-time position.The ideal candidate will have over 5 years of data modeling experience, exper... Show more