> Markdown version of [/jobs/ext/537826-database-administrator-data-architect](https://www.wearedevelopers.com/jobs/ext/537826-database-administrator-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Database Administrator/Data Architect - **Company:** Chicago Housing Authority - **Location:** Chicago, IL, United States (Remote available) - **Experience:** Experienced - **Salary:** $105,000.0 - $112,000.0 - **Contract:** Permanent contract - **Skills:** Application Services, Databases, Data Architecture, Data Dictionary, Data Governance, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Structures, Data Systems, Data Warehousing, Relational Databases, Database Security, IT Management, JSON, Log Shipping, Metadata Standards, Microsoft SQL Server, Operational Data Store, Oracle (Applications), Performance Tuning, Query Optimization, Power BI, Microsoft SharePoint, Software Engineering, SQL Databases, SQL Server Reporting Services, SQL Server Agent, Data Streaming, Transact-SQL, Extensible Markup Language (XML), File Transfer Protocol (FTP), Indexer, Data Strategy, Data Lineage, Data Analytics, Integration Frameworks, Tools for Reporting, Physical Data Models, SQL Server Management Studio (SSMS), Api Design, Database Tools and Utilities - **Published:** June 13, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=e0c90926de3528b1 ## About the Role Do you have experience in T-SQL?, Do you have a Bachelor's degree?, 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. ## Description 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., 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Dynamic Entities in .NET: Building Low-Code Systems on Top of Entity Framework Core](https://www.wearedevelopers.com/videos/100218-dynamic-entities-in-net-building-low-code-systems-on-top-of-entity-framework-core) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)