Apply on Employer Site

Avint · 1 day ago

SQL Developer

United States

Full-time

Remote

Senior Level, Lead/Staff

$170K/yr - $180K/yr

10+ years exp

Avint is seeking a motivated, career, and customer-oriented Senior SQL Developer to join our team in support of a Federal Customer. The role focuses on advancing the customer's Zero Trust maturity through secure identity, access, and data integration solutions, requiring expertise in SQL development, data architecture, and integration tasks.

ConsultingCyber SecurityInformation Technology

No H1B

U.S. Citizen Only

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

Qualification

T-SQLPythonData ArchitectureLegacy MigrationData MappingPerformance TuningCommunication SkillsProblem-SolvingAdaptability

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

Bachelor's degree required; master's degree preferred

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)