Senior SQL Developer at CRYSTAL MANAGEMENT

Vienna, Virginia, United States -

Full Time

Start Date

Immediate

Expiry Date

07 Apr, 26

Salary

0.0

Posted On

07 Jan, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, T-SQL, Stored Procedures, Data Modeling, Data Integration, Python, PowerShell, Data Migration, Zero Trust, Identity Management, Performance Tuning, Data Security, Technical Documentation, Collaboration, Code Review, Data Integrity

Industry

Business Consulting and Services

Description

Job Details Job Location: VIENNA, VA 22182 Position Type: Full Time Travel Percentage: Negligible Job Category: Information Technology CMiT is seeking a motivated, career, and customer-oriented Senior SQL Developer to join our team in support of a Federal Customer. This high-visibility cybersecurity modernization initiative focuses on advancing customer’s Zero Trust maturity through secure identity, access, and data integration solutions. We are looking for a Senior SQL Developer to serve as a “Data Translator” and technical architect, responsible for extracting business logic from legacy stored procedures and designing modern data models and pipelines that transform Sybase records into identity attributes required by Okta and other Zero Trust–aligned systems. Key Responsibilities Reverse-engineer legacy Stored Procedures to determine how user permissions, entitlements, and roles are calculated, translating that logic into modern, Zero Trust–aligned identity and access models. Design and maintain logical and physical data models that support identity, authorization, and access use cases, including mapping complex relational schemas to flat or attribute-based identity profiles. Design and build custom data extraction and transformation routines using T-SQL and scripting languages (Python/PowerShell) to migrate and integrate data from Sybase into Okta and related platforms. Analyze and optimize stored procedures, queries, indexing strategies, and data pipelines to ensure scalability, reliability, and performance in high-volume and mission-critical environments. Implement database-level security controls, auditing, encryption, and least-privilege access patterns in alignment with Zero Trust principles and federal security requirements. Produce high-quality technical documentation, architectural diagrams, and repeatable migration recipes to guide developers and stakeholders through the new identity data structures. Translate business, security, and IAM requirements into scalable SQL and data integration designs that support HUD Zero Trust objectives. Collaborate with product, engineering, and security teams; provide architectural guidance; conduct code reviews; and mentor developers to promote consistent, high-quality data solutions. Develop reconciliation and validation scripts to ensure 100% data integrity between legacy Sybase systems and target identity platforms. Qualifications Education/Certifications Required Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience) required. Master's Degree preferred. Qualifications Required 10+ years of Mastery of T-SQL including Stored Procedures, Triggers, CTEs, and performance tuning, with experience using bulk data tools such as BCP and SSIS. 10+ Years of Deep development experience in at least one modern language (Python, C#, or Java) for automation and custom integration tasks. 7+ Years of Proven experience migrating legacy relational systems to modern platforms, including data profiling, schema mapping, and transformation to identity-centric models. Demonstrated ability to design scalable, maintainable data architectures and models that support enterprise identity, access, and Zero Trust initiatives. Strong ability to analyze complex technical challenges and deliver effective, secure solutions. Excellent verbal and written communication skills, with the ability to explain complex technical concepts to both technical and non-technical audiences. Ability to operate effectively in a fast-paced environment with evolving priorities as legacy systems are modernized and decommissioned Preferred Qualifications: Experience integrating SQL-based data solutions with cloud or SaaS platforms. Demonstrated ability to present architectural designs and migration strategies to senior leadership and client stakeholders. Clearance Requirement Must be a U.S. Citizen (no dual citizenship) Ability to pass a background investigation Able to obtain and maintain DHS Suitability / Entry on Duty (EOD)

Responsibilities

The Senior SQL Developer will reverse-engineer legacy stored procedures and design modern data models and pipelines for identity attributes. They will also analyze and optimize data processes to ensure performance and security in alignment with Zero Trust principles.