Senior Platform Developer

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