Data Architect

Senior Data Architect – Sybase to PostgreSQL Migration

Job Summary:

Seeking an experienced Data Architect with strong expertise in Sybase ASE to PostgreSQL migration, database modernization, data modeling, and performance optimization. The candidate will lead architecture, migration planning, schema conversion, data validation, and PostgreSQL implementation for enterprise applications.

Key Responsibilities:

Lead end-to-end Sybase ASE to PostgreSQL migration projects.

Assess existing database structures, dependencies, and application integrations.

Design scalable PostgreSQL database architectures.

Migrate schemas, stored procedures, views, triggers, and data.

Develop migration, testing, validation, and cutover strategies.

Perform PostgreSQL performance tuning and optimization.

Ensure data integrity, security, and high availability.

Collaborate with development, infrastructure, and business teams.

Required Skills:

10+ years of experience in Data Architecture and Database Technologies.

Strong hands-on experience with Sybase ASE and PostgreSQL.

Proven experience leading large-scale database migration projects.

Expertise in SQL, data modeling, database design, and performance tuning.

Experience with migration tools, ETL processes, and data validation.

Knowledge of PostgreSQL replication, partitioning, backup, and recovery.

Experience with cloud platforms (AWS/Azure/Google Cloud Platform) is preferred.