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

Database Administrator

KonnectITChicago, Illinois, US
Full-time
Quick Apply

The ideal candidate will have extensive expertise in.This role is critical in ensuring data integrity, availability, and security across the organization’s systems.Administer, monitor, and optimize... Show more

Senior Database Administrator (Remote Opportunity)

Hyatt CorporationChicago, IL, United States
Remote
Full-time

The OpportunityHyatt seeks an enthusiastic Senior Database Administrator to join our Corporate Information Technology department, where you will join a team of six professionals who love what they ... 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

Senior Backend Engineer (Scala/C++) Remote-Eligible

NinjaTraderChicago, IL, United States
Remote
Full-time

A leading trading platform company is seeking a Senior Software Engineer II to design and develop backend systems using Scala.The role requires extensive experience with Kubernetes and real-time ap... 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

Remote Solutions Architect - Salesforce & Data Systems

ElevateChicago, IL, United States
Remote
Full-time

A nonprofit organization in Chicago is seeking a Solutions Architect to design and implement robust technical solutions that enable efficient program delivery.The role involves overseeing system ar... 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

Sr. SAP Architect - Product

ProteraChicago, IL, US
Remote
Full-time
Quick Apply

Welcome to Protera Technologies, where we’re reimagining how SAP-centric organizations work in the cloud.Since 1998, we’ve been pioneers in bringing SAP and related applications to the cloud—think ... Show more

Sr Developer - Integration (SAP IS)

Medline Industries - Transportation & OperationsNorthbrook, IL, US
Full-time

Job Summary Worksite: Northbrook, IL Hybrid Schedule: Onsite Tues - Thurs | Remote: Mon & Fri JOB SUMMARY We are seeking a seasoned Senior SAP Integration Developer with deep expertise in SAP Cloud... 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

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

Remote Enterprise Data Governance Architect (OneTrust)

Alrek Business Solutions IncChicago, IL, United States
Remote
Full-time

A leading data solutions firm is seeking a Resource Specialist to lead data governance initiatives.This remote role requires over 10 years of experience in data governance, data mapping, and catalo... 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

Remote Data Analyst - SQL & Visualization Lead

JPS Tech SolutionsChicago, IL, United States
Remote
Full-time

A leading IT consulting firm is seeking a skilled Data Analyst to join its Product Analytics team in Chicago.The role involves analyzing complex datasets, ensuring data integrity, and using data vi... Show more