Senior SQL Database Developer (Remote)
For further inquiries regarding the following opportunity, please contact our Talent Specialist Abdul at (224) 507-1295
Title: Senior SQL Database Developer (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.
ā¢ 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.
Apply Now
Apply Now
Title: Senior SQL Database Developer (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.
ā¢ 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.
Apply Now
Apply Now