Chicago Housing Authority

Database Administrator/Data Architect

Chicago, IL, US$105,000-$112,000Posted 29 days ago

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 mod...

Apply for this role

Keep looking

Similar Remote IT And Developer Jobs