DivIHN (pronounced divine ) is a CMMI ML3-certified Technology and Talent solutions firm. Driven by a unique Purpose, Culture, and Value Delivery Model, we enable meaningful connections between talented professionals and forward-thinking organizations. Since our formation in 2002, organizations across commercial and public sectors have been trusting us to help build their teams with exceptional temporary and permanent talent.
Visit us at to learn more and view our open positions.
Please apply or call one of us to learn more
For further inquiries regarding the following opportunity, please contact our Talent Specialist Abdul at
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.
- 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 database 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.
- 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 initiatives.
- Strong analytical, problem-solving, and communication skills.
Professional Competencies
- Ability to operate independently in a complex, multi-stakeholder environment.
- Strong attention to detail and commitment to data quality and accuracy.
- Excellent documentation and communication skills.
- Proven ability to balance performance, compliance, and maintainability.
About us:
DivIHN, the 'IT Asset Performance Services' organization, provides Professional Consulting, Custom Projects, and Professional Resource Augmentation services to clients in the Mid-West and beyond. The strategic characteristics of the organization are Standardization, Specialization, and Collaboration.
DivIHN is an equal opportunity employer. DivIHN does not and shall not discriminate against any employee or qualified applicant on the basis of race, color, religion (creed), gender, gender expression, age, national origin (ancestry), disability, marital status, sexual orientation, or military status.
Never miss an opportunity! Create an alert based on the job you applied for.
