• 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. • 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. • Oversee monitoring, installation, troubleshooting, and tuning of SAP ASE / Sybase databases to maintain stability during high-load migration and data extraction activities. • 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. • 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. • Formulate long-term strategies for database optimization, risk reduction, and the orderly sunsetting of legacy production environments. • Provide expert-level operational support for SAP ASE / Sybase and IQ environments, including backup and recovery, replication troubleshooting, patching, and capacity planning. • Analyze and document complex legacy stored procedures to extract embedded business rules and transformation logic for migration into the new identity framework. • Perform deep-dive query optimization and indexing strategies to ensure high-volume migration-related data extraction does not impact production availability. • Manage and troubleshoot Sybase Replication Server to ensure data consistency across legacy nodes, staging environments, and migration pipelines.

• Collaborate with design and development teams to create database designs that meet specified business and technical requirements • Perform database modeling and effectively communicate schema structures to development teams, ensuring clarity in how schemas support application development • Apply a thorough understanding of relational database concepts, implementing them using SQL DDL to support project goals • Gather requirements from software product managers and architects, and design relational database objects tailored to software objectives • Maintain and update databases used by the product development team across multiple versions of Jenzabar software • Work closely with the Quality Assurance team to test and verify database changes for each release cycle • Provide support in troubleshooting and resolving complex database issues within the customer base • Collaborate with the Data Services team on technical challenges related to data conversions • Stay informed about new releases of Microsoft SQL Server and evaluate their potential impacts on Jenzabar software • Design enterprise-wide database solutions aligned with application design goals

• Own end-to-end Oracle database performance engineering: AWR/ASH analysis, wait event tuning, SQL trace, Statspack, and optimizer plan management. • Design and execute data migration strategies for consolidating EDB, IVM, and VistA REE data into the modernized ES, ensuring data integrity, lineage, and auditability. • Develop and optimize PL/SQL, partitioning strategies, indexing, and materialized views for high-volume eligibility and enrollment workloads. • Implement GoldenGate and/or native Oracle replication strategies to support phased cutovers, near–zero downtime transitions, and rollback plans. • Harden database platforms to VA standards (FedRAMP, FISMA, IRS 1075, HIPAA): encryption at rest (TDE), in-transit (SSL/TLS), key rotation, and privileged access controls. • Engineer backup/recovery and DR patterns (RMAN, Data Guard) with validated RPO/RTO; conduct routine failover testing and RCA following incidents. • Establish observability baselines using Splunk/Microsoft Azure Monitor; publish performance SLOs and weekly capacity reports to the Product Lifecycle Team. • Collaborate with DevSecOps to integrate schema migrations into CI/CD (Liquibase/Flyway), automate change promotion, and enforce configuration management. • Support database security operations: auditing, least privilege, separation of duties, STIG alignment, and vulnerability remediation. • Lead data quality and reconciliation activities post-migration; define controls for duplicates, referential integrity, and cross-system consistency. • Provide Tier 3 escalation for production incidents; perform query rewrites, plan baselines, and emergency performance triage during peak loads. • Contribute to capacity planning and cloud architecture decisions for VAEC-hosted Oracle workloads; right-size compute/storage and IOPS.

• Analyze, maintain, and optimize PostgreSQL database environment to ensure 99.9% availability and data integrity. • Analyze, maintain, and optimize Microsoft SQL database environment to ensure 99.9% availability and data integrity. • Identify and resolve bottlenecks, optimize SQL queries, and enhance data retrieval efficiency for PostgreSQL and Microsoft SQL. • Update database architecture, build schemas, tables, stored procedures, and manage permissions. • Manage, improve, and work with Legacy databases and Platform as a Service databases. • Provide recommendations on policies, procedures, and emerging technologies. • Monitor systems for availability, oversee database mirroring, replication, and failover. • Support advanced PostgreSQL features like JSON, full-text search, and PostGIS for geospatial queries. • Generate queries and reports using PostgreSQL tools like pgAdmin, psql, and third-party tools such as DataGrip. • Create, populate, and maintain PostgreSQL databases, materialized views, and indexes for analysis and reporting. • Restore PostgreSQL databases from backups and support disaster recovery activities using WAL archiving and point-in-time recovery. • Collaborate with developers, analysts, and IT teams to design, implement, and troubleshoot PostgreSQL database issues. • Assess future storage and performance needs, and create and maintain comprehensive PostgreSQL documentation. • Work with Platform as a Service pre-built database to optimize and manage as needed for growing solutions. • Communicate effectively with customers, stakeholders, and technical specialists.