Job Information
DivIHN Integration, Inc Database architect (UIC & RCRA) - Remote in Hoffman Estates, Illinois
This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/13269213
For further inquiries regarding the following opportunity, please contact our Talent Specialist Abdul at (224) 507-1295
Title: Database architect (UIC & RCRA) - Remote
Duration: 5.5 Months
Location: Remote
Only W2 candidates are eligible for this position. Third-party or C2C candidates will not be considered.
Role Overview
The Senior Database Architect / Lead Data Engineer will be responsible for the end-to-end design, optimization, and governance of enterprise-grade relational database systems supporting complex regulatory platforms, including RCRAInfo and UIC program data.\ This role plays a critical part in ensuring data integrity, scalability, auditability, and long-term preservation of mission-critical environmental compliance data across all system modules.\ The position requires deep expertise in relational database architecture, schema design, performance optimization, ETL processes, and data lifecycle management, with a strong emphasis on regulatory compliance, historical data preservation, and migration readiness.
Key Responsibilities
Database Architecture & Design\ Lead the design and implementation of relational database schemas supporting RCRA and UIC master data domains, ensuring accuracy, consistency, and extensibility.\ Architect and maintain schemas supporting all eight (8) RCRAInfo functional modules, ensuring seamless integration and data interoperability across modules.\ Apply advanced data normalization techniques while balancing performance and reporting needs.\ Design migration-ready schemas to support future system modernization, platform upgrades, and cloud or hybrid deployments.
Data Integrity, Validation & Governance\ Define and enforce data validation rules, referential integrity constraints, and business logic at the database level.\ Implement comprehensive audit trails and change history mechanisms to meet regulatory, legal, and compliance requirements.\ Ensure proper handling of historical and archived data, maintaining accessibility while optimizing storage and performance.\ Support data governance standards, including lineage, traceability, and consistency across environments.
Performance Optimization & Scalability\ Perform advanced query tuning, indexing strategies, and execution plan analysis to ensure optimal system performance.\ Design and optimize stored procedures, triggers, and database functions using T-SQL and/or PL/pgSQL.\ Proactively identify and remediate performance bottlenecks related to large datasets, historical records, and complex joins.\ Support high-volume transactional and reporting workloads with scalable database solutions.
ETL, Integration & Data Migration\ Design, develop, and optimize ETL workflows using SSIS or equivalent ETL tools to support data ingestion, transformation, and synchronization.\ Collaborate with application, integration, and reporting teams to ensure reliable and efficient data pipelines.\ Support legacy data migration, ensuring data accuracy, completeness, and reconciliation during system transitions.\ Implement error handling, logging, and monitoring for all ETL and data movement processes.
r
Collaboration & Documentation\ Work closely with application developers, architects, QA teams, and business stakeholders to translate requirements into robust data solutions.\ Produce detailed technical documentation, including data models, schema definitions, ETL designs, and operational procedures.\ Provide guidance and mentorship to junior developers and database analysts.\ Participate in design reviews, architecture boards, and technical governance forums.
Required Technical Skills
Core Database & Data Engineering Skills\ Strong expertise in relational atabase design for complex regulatory systems (RCRA & UIC preferred).\ Proven experience designing schemas supporting multi-module enterprise applications.\ Advanced knowledge of data normalization, indexing, and query optimization.\ Hands-on experience implementing audit trails, change history, and archival strategies.\ Expertise in data validation rules, constraints, and database-level business logic.\ Experience designing migration-ready and future-proof schemas.\ Strong proficiency in stored procedures, triggers, and ETL optimization.
Technologies\ SQL Server and/or PostgreSQL\ SSIS or equivalent ETL tools\ T-SQL and/or PL/pgSQL\ Advanced indexing strategies and performance tuning techniques
Preferred Qualifications
Experience working with RCRAInfo, environmental compliance systems, or regulatory data platforms.\ Familiarity with public sector or government data systems.\ Knowledge of data retention, records management, and compliance standards.\ Experience supporting large-scale data modernization or system migration i