ShorePoint Inc · 1 day ago
Senior SQL Developer
United States
Full-time
Remote
Senior Level, Lead/Staff
10+ years expShorePoint Inc is a fast-growing cybersecurity services firm focused on high-profile clients. They are seeking a Senior SQL Developer to support a Zero Trust Architecture modernization initiative, responsible for reverse-engineering legacy data logic and translating it into modern models aligned with Zero Trust principles.
Cyber SecurityNetwork SecuritySecurity
No H1B
Security Clearance RequiredU.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 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
Required
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
Applicants must be a U.S. citizen and eligible to obtain and maintain a security clearance, in compliance with federal contract requirements (no dual citizenship)
Expert-level understanding of relational database design, SQL development and performance optimization in enterprise environments
Strong experience modernizing legacy databases and translating procedural data logic into identity-centric and access-driven models
Deep understanding of how identity, entitlement and authorization data supports Zero Trust architecture
Ability to design secure, auditable and scalable database solutions aligned with least privilege and compliance requirements
Proven capability to document complex technical solutions clearly for both technical and non-technical stakeholders
Experience working in environments where legacy systems are actively being modernized or decommissioned
Preferred
Industry recognized certifications
Experience integrating SQL-based data solutions with cloud or Software as a Service (SaaS) platform
Demonstrated ability to present architectural designs and migration strategies to senior leadership and client stakeholders
Benefits
18 days of PTO
11 holidays
85% of premium insurance covered
401k
Continued education
Certifications maintenance and reimbursement
Company
ShorePoint Inc
ShorePoint recognizes that cybersecurity is the challenge of our generation.
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
unknownKey Investors
CM Equity Partners
2025-11-18Private Equity
Leadership Team
Matt Brown
CEO
Robert Palmer
Executive Vice President & Chief Operating Officer
Recent News
Washington Technology
2025-12-20
2025-12-08
Company data provided by crunchbase