Avint

SAP ASE, Sybase DBA

Avint

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

SeniorLead

Tech Stack

AzureCloudCyber SecurityETLSQL

About the role

  • Migration & Mapping:
  • Lead the technical mapping of legacy SAP ASE / Sybase data attributes to Okta user profiles and universal directories and clearly explain complex legacy schemas to migration and engineering teams.
  • Data Architecture:
  • Develop and implement the data architecture strategy for the legacy SAP ASE / Sybase environment, ensuring database modernization and decommissioning paths align with Federal customer’s Zero Trust goals.
  • Performance & Optimization:
  • Oversee monitoring, installation, troubleshooting, and tuning of SAP ASE / Sybase databases to maintain stability during high-load migration and data extraction activities.
  • ETL & Pipeline Oversight:
  • Collaborate with engineers to build and validate data pipelines (e.g., Azure Data Factory or equivalent) that move data from Sybase to cloud-based identity targets, including identifying and eliminating obsolete or “dead” stored procedure logic that should not be migrated.
  • Security & Governance:
  • Enforce robust database security controls and data quality standards, including metadata management and data lineage, to ensure sensitive identity data remains protected in alignment with Zero Trust principles and federal requirements.
  • Strategic Planning:
  • Formulate long-term strategies for database optimization, risk reduction, and the orderly sunsetting of legacy production environments.
  • Production Support:
  • Provide expert-level operational support for SAP ASE / Sybase and IQ environments, including backup and recovery, replication troubleshooting, patching, and capacity planning.
  • Logic Extraction & Reverse Engineering:
  • Analyze and document complex legacy stored procedures to extract embedded business rules and transformation logic for migration into the new identity framework.
  • Performance Engineering:
  • Perform deep-dive query optimization and indexing strategies to ensure high-volume migration-related data extraction does not impact production availability.
  • Replication Oversight:
  • Manage and troubleshoot Sybase Replication Server to ensure data consistency across legacy nodes, staging environments, and migration pipelines.

Requirements

  • Sybase Expertise:
  • 8+ years of hands-on experience in SAP ASE / Sybase administration, specifically with SAP ASE, Replication Server, and performance-critical stored procedures.
  • Expert-Level T-SQL:
  • 10+ years of Mastery of SAP ASE / Sybase T-SQL, including debugging, refactoring, and optimization of highly complex stored procedures and triggers.
  • Data Modeling:
  • 4+ Years of Proven experience in schema design and data modeling, with the ability to translate relational database structures into modern, identity-centric or non-relational schemas (e.g., Okta / JSON).
  • Cloud Data Integration:
  • Experience with cloud-native ETL and data integration tools to facilitate secure data movement from legacy environments.
  • Identity Awareness:
  • Familiarity with Identity and Access Management (IAM/ICAM) concepts and how database structures support Zero Trust architectures.
  • Governance & Compliance:
  • Knowledge of federal cybersecurity frameworks (NIST, FISMA) and data governance practices, including lineage, metadata, and auditability.
  • Soft Skills:
  • Demonstrated ability to mentor junior engineers and clearly communicate complex legacy-to-modern technical concepts to non-technical stakeholders.
  • Performance Tuning:
  • Proven track record using Showplan, Statistics IO, and DBCC commands to identify bottlenecks and remediate poorly performing queries.
  • System Internals Knowledge:
  • Deep understanding of SAP ASE / Sybase internals, including memory management, lock contention, and I/O behavior, to maintain stability during intensive data migration operations.
  • Education:
  • Bachelor’s degree required; master’s degree preferred.
  • Preferred Qualifications:
  • Demonstrated ability to present technical strategies and architectural decisions to senior leadership and client audiences.
  • Published whitepapers or availability of prior technical writing samples is desirable.
  • Clearance Requirements:
  • Must be a U.S. Citizen (no dual citizenship)
  • Ability to pass a background investigation
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
SAP ASESybaseT-SQLdata modelingETLdata integrationperformance tuningquery optimizationmetadata managementdata lineage
Soft skills
mentoringcommunicationstrategic planningproblem-solvingcollaborationtechnical presentationdocumentationanalytical thinkingleadershipstakeholder engagement
Certifications
Bachelor's degreeMaster's degree