Avint Logo

Avint

SQL Developer

Reposted 7 Hours Ago
Remote
Hiring Remotely in United States
170K-180K Annually
Senior level
Remote
Hiring Remotely in United States
170K-180K Annually
Senior level
The Senior SQL Developer will extract business logic from legacy systems, design modern data models, and build custom ETL solutions to support Zero Trust initiatives.
The summary above was generated by AI

Avint 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.

Position Responsibilities

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. 

 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) 

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. 

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! Salary Range $170,000.00 - $180,000.00

Top Skills

Bcp
Powershell
Python
SQL
Ssis
T-Sql

Similar Jobs

5 Days Ago
Remote or Hybrid
New York, NY, USA
105K-130K Annually
Mid level
105K-130K Annually
Mid level
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
The Software Engineer will develop and maintain solutions for NBCU's title and metadata systems, focusing on scalable features across various media types. Candidates should possess a collaborative spirit and eagerness to learn and grow in a dynamic environment.
Top Skills: Asp.NetAWSAws Step FunctionsC#.NetLambdaMs SqlPythonRestful Web ServicesTerraform
5 Days Ago
Remote or Hybrid
New York, NY, USA
105K-130K Annually
Mid level
105K-130K Annually
Mid level
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
Seeking a Software Engineer passionate about technology and teamwork to develop global solutions for NBCUniversal's titles and metadata. Responsibilities include building scalable features and contributing to a collaborative engineering culture.
Top Skills: Asp.NetAWSC#.NetMs Sql ServerRestful Web Services
5 Days Ago
In-Office or Remote
Herndon, VA, USA
Senior level
Senior level
Artificial Intelligence • Information Technology • Software • Cybersecurity
Support Zero Trust Architecture modernization by reverse-engineering data logic, designing secure databases, and migrating legacy systems to identity-centric models.
Top Skills: Bulk Copy ProgramOktaPowershellPythonSQLSql Server Integration ServicesSybaseT-Sql

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account