Avint

SQL Developer

Avint

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

SeniorLead

Tech Stack

CloudETLJavaPythonSQLSSIS

About the role

  • Logic Deconstruction & Translation:
  • 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.
  • Data Architecture & Modeling: ** 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.
  • Custom ETL & Integration Development: ** 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.
  • Performance Optimization: ** Analyze and optimize stored procedures, queries, indexing strategies, and data pipelines to ensure scalability, reliability, and performance in high-volume and mission-critical environments.
  • Data Security & Compliance: ** Implement database-level security controls, auditing, encryption, and least-privilege access patterns in alignment with Zero Trust principles and federal security requirements.
  • Technical Content Creation: ** Produce high-quality technical documentation, architectural diagrams, and repeatable migration recipes to guide developers and stakeholders through the new identity data structures.
  • Solution Design & Requirements Translation: ** Translate business, security, and IAM requirements into scalable SQL and data integration designs that support HUD Zero Trust objectives.
  • Developer Engagement & Technical Leadership: ** Collaborate with product, engineering, and security teams; provide architectural guidance; conduct code reviews; and mentor developers to promote consistent, high-quality data solutions.
  • Data Validation & Reconciliation: ** Develop reconciliation and validation scripts to ensure 100% data integrity between legacy Sybase systems and target identity platforms.

Requirements

  • Expert SQL Development: ** 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.
  • Programming Proficiency: ** 10+ Years of Deep development experience in at least one modern language (Python, C#, or Java) for automation and custom integration tasks.
  • Legacy Migration & Data Mapping Expertise: ** 7+ Years of Proven experience migrating legacy relational systems to modern platforms, including data profiling, schema mapping, and transformation to identity-centric models.
  • Data Architecture Experience: ** Demonstrated ability to design scalable, maintainable data architectures and models that support enterprise identity, access, and Zero Trust initiatives.
  • Problem-Solving & Analytical Skills: ** Strong ability to analyze complex technical challenges and deliver effective, secure solutions.
  • Communication Skills: ** Excellent verbal and written communication skills, with the ability to explain complex technical concepts to both technical and non-technical audiences.
  • Adaptability: ** Ability to operate effectively in a fast-paced environment with evolving priorities as legacy systems are modernized and decommissioned.
  • **Education:**
  • Bachelor’s degree required; master’s degree preferred.
  • **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 Requirements: **
  • 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) **
Benefits
  • Joining Avint is a win-win proposition! You will feel the personal touch of a small business and receive BIG business benefits, from competitive salaries, full health insurance, generous time off, and observation of federal holidays.
  • Additionally, we encourage every Avint employee to further their professional development. To assist you in achieving your goals, we offer reimbursement for courses, exams, and tuition. Interested in a class, conference, program, or degree? Avint will invest in YOU and your professional development!

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
T-SQLStored ProceduresTriggersCTEsPerformance TuningPythonPowerShellData ArchitectureData MappingData Validation
Soft skills
Problem-SolvingAnalytical SkillsCommunication SkillsAdaptabilityTechnical Leadership
Certifications
Bachelor's DegreeMaster's DegreeDHS Suitability