Sybase ASE-IQ Engineer/Developer

Responsibilities:
· Lead the migration of databases from Sybase ASE/IQ to SQL Server, ensuring minimal disruption to business operations.
· Conduct detailed assessments of existing Sybase ASE/IQ databases, including schema, data, and stored procedures.
· Develop and implement migration plans, including timelines, resource allocation, and risk management.
· Utilize SQL Server Migration Assistant (SSMA) and other tools to automate and streamline the migration process.
· Modify and optimize SQL queries, stored procedures, and database objects to ensure compatibility and performance in SQL Server.
· Collaborate with cross-functional teams, including application developers, business analysts, and IT support, to ensure successful migration.
· Perform thorough testing and validation of migrated data to ensure accuracy and integrity.
· Provide post-migration support, including troubleshooting and performance tuning.
· Document migration processes, procedures, and best practices.

Requirements:
· Bachelor’s degree in computer science, Information Technology, or a related field.
· Proven experience with Sybase ASE/IQ and SQL Server, including database administration and development.
· Strong understanding of database migration methodologies and tools, particularly SSMA.
· Proficiency in SQL, T-SQL, and stored procedure development.
· Experience in the capital markets or banking domain is highly desirable.
· Excellent problem-solving skills and attention to detail.
· Strong communication and collaboration skills.

Preferred Qualifications:
· Experience with other database technologies such as Oracle or PostgreSQL.
· Knowledge of data warehousing concepts and ETL processes.