• Provide infrastructure-level support for IBM DB2 environments (LUW). • Plan, design, and execute DB2 migration and upgrade activities across versions and platforms. • Assess and validate compatibility, dependencies, and risks for DB2 upgrade projects. • Collaborate with architecture, application, and system engineering teams to ensure smooth transitions with minimal downtime. • Implement DB2 patches, and security updates in alignment with vendor recommendations and customer standards. • Troubleshoot and resolve complex infrastructure-related DB2 issues in development, test, and production environments. • Support performance tuning, capacity planning, and storage optimization during migrations. • Automate routine DB2 administrative and upgrade tasks using scripting (Shell, Python, Ansible, etc.). • Ensure compliance with enterprise security policies, backup/recovery standards, and audit requirements. • Provide on-call support.

• Administer, operate, and maintain computerized database systems, including database dictionaries, standards, procedures, file structures, and storage management. • Plan and project long-range requirements for database administration and design in coordination with information systems leadership. • Design, develop, implement, and maintain complex databases in a client/server environment, including access methods, performance optimization, storage allocation, security controls, and documentation. • Perform database quality control, auditing, validation, and programming to ensure data accuracy, integrity, appropriate use, and support systems integration and application development. • Advise users on database access, usage, and data availability across client/server systems. • Apply database technologies, development methodologies, and programming languages (e.g., SQL) to support database and system design.

• 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