Krasan Consulting Services · 1 day ago
Senior Platform Developer
United States
Contract
Remote
Senior LevelKrasan Consulting Services is seeking a Senior Platform Developer who will be responsible for the end-to-end design, optimization, and governance of enterprise-grade relational database systems. This role involves ensuring data integrity, scalability, and compliance for critical environmental compliance data across various system modules.
Cloud ComputingConsultingInformation TechnologyIT ManagementManagement Consulting
Hiring Manager
Kody Kuhlman
Responsibilities
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
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
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
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
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
Qualification
Required
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
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
Company
Krasan Consulting Services
Krasan Consulting Services is a technology management consulting firm and solutions integrator.
Founded in 2019
51-200 employees
H1B Sponsorship
Krasan Consulting Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (42)
2024 (21)
2023 (4)
Funding
Current Stage
Growth StageLeadership Team
Rick Pugh
Chief Operations Officer
Company data provided by crunchbase