What are the responsibilities and job description for the Lead Database Modernization Architect position at Galent?
Role: Lead Database Modernization Architect
Location – Dallas, TX / Raleigh, NC
Key Responsibilities
- Lead end-to-end current-state assessment of Sybase database environments and associated application ecosystems.
- Identify and inventory applications, services, databases, interfaces, reports, APIs, ETL processes, and batch jobs impacted by the migration from Sybase ASE to SQL Server.
- Analyze database schemas, stored procedures, triggers, views, scheduled jobs, and application code to determine migration impacts and complexity.
- Build application-to-database dependency maps and document upstream and downstream integrations.
- Assess business criticality, ownership, usage patterns, operational dependencies, and migration readiness of in-scope applications.
- Facilitate stakeholder interviews and workshops with application owners, architects, developers, operations teams, and business stakeholders.
- Perform SQL Server compatibility assessments and identify Sybase-specific functionality requiring remediation.
- Develop migration complexity scoring models and categorize assets based on migration effort and risk.
- Identify technical debt, modernization opportunities, and remediation requirements.
- Utilize automation, scripting, metadata analysis, and AI-assisted discovery tools to accelerate assessment activities.
- Produce executive-ready assessment reports, architecture documentation, dependency inventories, readiness dashboards, and migration recommendations.
Required Experience
- Strong experience in application architecture, database modernization, or enterprise technology consulting.
- Strong experience with Sybase ASE, Microsoft SQL Server, and relational database technologies.
- Experience performing application portfolio assessments, technology discovery, and dependency analysis.
- Deep understanding of database objects including stored procedures, triggers, views, indexes, and batch processes.
- Experience identifying impacts across applications, reporting platforms, integrations, middleware, and data pipelines.
- Proven experience creating migration strategies, modernization roadmaps, and transformation plans.
- Strong stakeholder management and workshop facilitation skills.
- Ability to work across architecture, development, infrastructure, and business teams.
Preferred Qualifications
- Experience leading large-scale database modernization or cloud transformation initiatives within financial services.
- Experience with application discovery tools, static code analysis tools, CMDBs, and dependency mapping platforms.
- Experience with GitHub Copilot, AI-assisted discovery approaches, or automated assessment accelerators.
- Knowledge of ETL frameworks, batch scheduling platforms, reporting ecosystems, and enterprise middleware.
We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law. https://www.e-verify.gov/sites/default/files/everify/posters/IER_RighttoWorkPoster.pdf