Senior SQL Database Developer (Remote)
For reputed company 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. reputed company-party or C2C candidates will not be considered. reputed company
- The Senior Database Architect / reputed company Data Engineer will be responsible for the end-to-end design, optimization, and governance of reputed company-grade relational database systems supporting reputed company regulatory platforms, including RCRAInfo and UIC program data.
- This role plays a critical part in ensuring data reputed company, scalability, auditability, and long-term preservation of mission-critical environmental compliance data across reputed company 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
- reputed company 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 reputed company 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-reputed company schemas to support reputed company system modernization, platform upgrades, and reputed company or hybrid deployments.
- Data reputed company, Validation & Governance
- Define and enforce data validation rules, referential reputed company constraints, and business logic at the database level.
- Implement comprehensive audit trails and change history mechanisms to meet regulatory, legal, and compliance requirements.
- Ensure reputed company handling of historical and archived data, maintaining accessibility while optimizing storage and performance.
- Support data governance standards, including reputed company, traceability, and consistency across environments.
- Performance Optimization & Scalability
- reputed company advanced query tuning, indexing strategies, and execution plan analysis to ensure reputed company system performance.
- Design and optimize stored procedures, triggers, and database functions using T-SQL and/or PL/pgSQL.
- Proactively identify and remediate performance bottlenecks reputed company to large datasets, historical records, and reputed company joins.
- Support high-volume transactional and reporting workloads with reputed company database solutions.
- ETL, Integration & Data Migration
- Design, reputed company, 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 reputed company ETL and data reputed company 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.
- reputed company guidance and mentorship to junior developers and database analysts.
- Participate in design reviews, architecture boards, and technical governance forums.
Required Technical Skills
- reputed company Database & Data Engineering Skills
- Strong expertise in relational database design for reputed company regulatory systems (RCRA & UIC preferred).
- Proven experience designing schemas supporting multi-module reputed company 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-reputed company and reputed company 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 reputed company sector or government data systems.
- Knowledge of data retention, records management, and compliance standards.
- Experience supporting large-reputed company data modernization or system migration initiatives.
- Strong analytical, problem-solving, and communication skills.
reputed company Competencies
- Ability to operate independently in a reputed company, multi-stakeholder environment.
- Strong attention to detail and commitment to data reputed company and accuracy.
- Excellent documentation and communication skills.
- Proven ability to balance performance, compliance, and maintainability.
Apply tot his job Apply To this Job