Top 43 Sql Server Architect Jobs in Chicago, IL

Database Administrator/Data Architect
The Chicago Housing Authority —Chicago, IL
- $105,000 - $112,000 a year
- Full-time
- Bachelor's degree
- Mentoring
- SharePoint
- Disability insurance
- Health insurance
Senior Full Stack Developer / Solutions Architect
Confidential —Clarendon Hills, IL
- $130,000 - $150,000 a year
- Full-time
- Azure
- Computer Science
- System design
- Dental insurance
- 401(k)
Quick Apply
Middleware Integration Developer / Architect
Sonsoft Inc —Chicago, IL
- Full-time
- Azure
- Computer Science
- Word processing
Quick Apply
Middleware Integration (GC-USC)
Sonsoft Inc —Chicago, IL
- Full-time
- Azure
- Computer Science
- Word processing
Quick Apply
Middleware Integration (GC-USC)
Sonsoft Inc —Chicago, IL
- Full-time
- Azure
- Computer Science
- Word processing
Quick Apply
Middleware Integration ( USC OR GC ) ONLY
Sonsoft Inc —Chicago, IL
- Full-time
- Azure
- Computer Science
- Word processing
Quick Apply
Middleware Integration (GC-USC)
Sonsoft Inc —Chicago, IL
- Full-time
- Azure
- Computer Science
- Word processing
Quick Apply
Junior Architect / Senior Data Engineer - Remote
Optum —Schaumburg, IL
- $91,700 - $163,700 a year
- Full-time
- Hybrid work
- 5 years
- Pass drug screening
- System design
2d
Azure Data Architect
Anblicks —Addison, IL
- Full-time
- Analysis skills
- 1 year
- Senior level
Solution Architect
Barrow Wise Consulting —Chicago, IL
- $70,000 - $150,000 a year
- Full-time
- Remote
- Software troubleshooting
- 8 years
- Bachelor's degree
- Health insurance
- 401(k)
Quick Apply
Data AI Architect
SPR —Chicago, IL
- $150,000 - $185,000 a year
- Management
- Computer Science
- Java
- AD&D insurance
- Paid holidays
2d
Enterprise Architect
Contact Government Services, LLC —Chicago, IL
- $126,186.67 - $171,253.34 a year
- Full-time
- Hybrid work
- Writing skills
- Windows
- Organizational skills
- Health insurance
- Dental insurance
Quick Apply
Senior Architect, Data Engineering
West Monroe —Chicago, IL
- $199,100 - $223,400 a year
- Email
- SQL
- AWS
- Senior level
Quick Apply
Dotnet Sr. Architect
Robotics Technologies —Chicago, IL
- 5 years
- SQL
- Continuous improvement
Adobe AEP Architect
Capgemini —Berwyn, IL
- $73,150 - $174,000 a year
- Full-time
- Hybrid work
- Windows
- Presentation skills
- Bachelor's degree
- Paid holidays
- Disability insurance
Sr. Staff Software Architect
Abbott Laboratories —Chicago, IL
- $113,300 - $226,700 a year
- Full-time
- Computer science
- Azure
- Computer Science
- Health insurance
- Tuition reimbursement
Adobe AEP Architect
Capgemini Sogeti —Berwyn, IL
- $73,150 - $174,000 a year
- Full-time
- Hybrid work
- Windows
- Presentation skills
- Bachelor's degree
- Paid holidays
- Disability insurance
Architect IT
Medline Industries —Northbrook, IL
- $134,000 - $201,000 a year
- Full-time
- Computer Science
- 5 years
- SQL
- Health insurance
- 401(k)
Software Team Architect
Ecentria —Northbrook, IL
- $100,000 - $140,000 a year
- Full-time
- Computer Science
- System design
- Mid-level
- Paid parental leave
- Paid holidays
Quick Apply
13d
Technical Analyst III
CohnReznick —Chicago, IL
- Remote
- 7 years
- Azure
- Computer Science
- Paid time off
- Parental leave

I want to receive the latest job alert for Sql Server Architect in Chicago, IL

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

Sql Server Architect jobs near Chicago, IL

Database Administrator/Data Architect

The Chicago Housing Authority -
Chicago, IL

Apply Now

Job Details

Full-time
$105,000 - $112,000 a year

Benefits

401(a)
Disability insurance
Health insurance
Dental insurance
Paid time off
Pension plan
Vision insurance
401(k) matching
Life insurance
Pet insurance

Qualifications

Performance tuning
Data replication
Data Integration (Data management)
Database compliance measures
Database backup and recovery
Data recovery
Database security hardening
Server backup and recovery
Database security management
Database server management
ETL process automation
Data backup
Access control management
System tuning
Database replication implementation
Metadata management
T-SQL

Full Job Description

POSITION SUMMARY

Reporting to the Manager of Data Analytics, the Database Administrator/Data Architect is a dual-function role responsible for the administration, security, and performance of on-premises Microsoft SQL Servier environments, as well as the design and governance of enterprise data architecture. This position plays a strategic role in modernizing data infrastructure, establishing data modeling standards, and ensuring that the organization’s information assets are structured, accessible, and reliable.

The Database Administrator/Data Architect will lead efforts in performance tuning, backup and recovery, capacity planning, and database lifecycle management, while simultaneously contributing to enterprise-wide data strategy, including data modeling, data governance frameworks, integration design, and reporting architecture. This role collaborates closely with application development teams, business stakeholders, and IT leadership to align data systems with organizational goals.

DUTIES AND RESPONSIBILITIES

Database Administration & Platform Operations

Manage SQL Server environments end ‑ to ‑ end, including installation, configuration, maintenance, upgrades, patching, and ongoing performance optimization through query tuning, indexing, capacity planning, and validated backup/recovery strategies.
Oversee database security and governance, including access control, encryption, auditing, and compliance with change ‑ control requirements.
Support reporting needs by designing SQL ‑ based reports and data extracts, optimizing data structures for analytics, and supporting SSRS and other reporting tools.
Administer SharePoint and application platforms by managing server health, permissions, account configuration, site governance, job monitoring, and coordinating maintenance with application owners

Data Architecture & Design

Design and maintain enterprise data architecture by creating conceptual, logical, and physical data models, enforcing modeling standards, and managing schema best practices.
Lead data integration design by defining ETL/ELT data flows and supporting structured and semi‑structured formats such as JSON, XML, and API‑based exchanges.
Evaluate and recommend data warehousing, operational data store, and reporting-layer architecture patterns, while collaborating with development teams on scalable data model changes.
Improve performance and maintainability by consolidating, normalizing, or restructuring legacy data, and by maintaining data dictionaries, ERDs, and data flow documentation.
Partner with business analysts to translate reporting and analytics needs into sound data architecture aligned with business requirements.

Data Governance & Quality

Lead data governance efforts, including ownership, stewardship, lineage tracking, policy compliance, metadata standards, and contributions to the enterprise data catalog.
Define and monitor data quality rules and work with business teams to identify, remediate, and prevent data quality issues.
Ensure all database and data architecture decisions comply with organizational security policies and regulatory requirements.

Collaboration & Leadership

Coordinate with Application Services, DBAs, developers, and business stakeholders to align data systems with organizational priorities and support change control reviews.
Provide mentorship to junior staff and guide developers on database best practices.
Evaluate and recommend database tools, platforms, and emerging technologies that support the organization’s data strategy.
Perform all other duties and projects assigned.

QUALIFICATIONS

Bachelor’s degree in a technical field or equivalent experience, with 4+ years of hands ‑ on SQL Server administration (2016+), including data modeling for transactional and analytical systems. Strong proficiency in T ‑ SQL development, query optimization, performance tuning tools, and designing/validating backup, recovery, and high ‑ availability solutions (Always On, log shipping, mirroring). Experience managing database security (roles, permissions, TDE, auditing) and working with ETL/ELT workflows, data integration patterns, SFTP transfers, and SQL Agent automation. Solid data modeling skills (ER diagrams, normalization, dimensional design) plus effective communication, participation in 24×7 on ‑ call rotation, and familiarity with ITSM tools like JIRA or FreshService.

Experience with data governance frameworks, including catalogs, lineage, and stewardship tools. Knowledge of SSRS or Power BI, including reporting architecture and DAX for advanced modeling. Familiarity with Oracle or other RDBMS, SharePoint administration, and data warehousing concepts. Highly desirable: Microsoft SQL certifications such as DP ‑ 300 or equivalent.

BENEFITS AT-A-GLANCE

Vacation, Sick and Personal, competitive PTO package
Medical (HMO, PPO, and No employee cost High-Deductible PPO) Dental, Vision, and Life Insurance
Short-Term and Long-Term Disability Insurance
Long-Term Care Insurance
Pet Insurance
Parking Transit
Prepaid Legal Services
Brightstar 529 College Savings Plan
Identity Theft Protection
Hospital Indemnity Insurance
Voluntary Critical Illness Insurance
Deferred Compensation Plan: Empower 457/401(a) with a 3% employer match
Pension Plan: CHA makes contributions on behalf of the employee, along with the employee's 3% contribution; 100% vesting occurs after 6 years of continuous employment or opt-out of CHA's Retirement Plan and continues to participate in the Municipal Employees Annuity and Benefit Fund of Chicago
Hybrid work schedule (position specific) This position may be eligible for remote work following a successful completion of a 90-day probationary period according to CHA’s established policies and procedures.

Salary Range: $105,000 – 112,000

Grade: S9

FLSA: Exempt

Union: None

"Applications will be accepted for 30 days from the date of posting. However, the position may be closed at any point if a sufficient number of qualified applications are received.”

Apply Now

Refine Your Search

Sql Server Architect jobs in Chicago, IL

Database Administrator/Data Architect

Senior Full Stack Developer / Solutions Architect

Middleware Integration Developer / Architect

Middleware Integration (GC-USC)

Middleware Integration (GC-USC)

Middleware Integration ( USC OR GC ) ONLY

Middleware Integration (GC-USC)

Junior Architect / Senior Data Engineer - Remote

Azure Data Architect

Solution Architect

Data AI Architect

Enterprise Architect

Senior Architect, Data Engineering

Dotnet Sr. Architect

Adobe AEP Architect

Sr. Staff Software Architect

Adobe AEP Architect

Architect IT

Software Team Architect

Technical Analyst III

I want to receive the latest job alert for Sql Server Architect in Chicago, IL

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected