Job Title: Senior Platform Developer [Lead Database Developer]
Work Location: Remote
Employment Type: Full-Time
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.
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 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.
