Senior SQL Developer
ShorePoint Inc
full-time
Posted on:
Location Type: Remote
Location: Virginia • United States
Visit company websiteExplore more
Job Level
About the role
- 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 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
Requirements
- Bachelor’s degree; master’s degree preferred
- 10+ years of experience with advanced T-SQL development, including stored procedures, triggers, Common Table Expressions (CTEs), performance tuning and bulk data tools such as Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS)
- 10+ years of experience developing in at least one modern programming language (Python, C# or Java) for automation and custom integration
- 7+ years of proven experience migrating legacy relational systems to modern platforms, including data profiling, schema mapping and transformation to identity-centric models
- Proven ability to analyze complex requirements and translate them into clear, actionable tasks and processes through critical thinking
- Excellent verbal and written communication skills, with the ability to explain complex technical concepts to both technical and non-technical audiences
- Demonstrated ability to design scalable, maintainable data architectures and models that support enterprise identity, access and Zero Trust initiatives
- Ability to operate effectively in a fast-paced environment with evolving priorities as legacy systems are modernized and decommissioned
- Must be a U.S. citizen and eligible to obtain and maintain a security clearance, in compliance with federal contract requirements (no dual citizenship)
Benefits
- 18 days of PTO
- 11 holidays
- 85% of premium insurance covered
- 401k
- Continued education
- Certifications maintenance and reimbursement
- More
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
T-SQLPythonPowerShellSQL Server Integration Services (SSIS)Bulk Copy Program (BCP)data modelingdata extractiondata transformationperformance tuningdata integrity
Soft Skills
critical thinkingcommunicationcollaborationmentoringarchitectural guidanceproblem-solvingadaptabilityanalytical skillsattention to detailleadership