Sybase ASE-IQ Engineer/Developer

ALLTECH CONSULTING SVC INC; Carrollton (TX); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading consulting firm seeks a Database Migration Specialist to lead the transition from Sybase ASE/IQ to SQL Server. The ideal candidate will have a Bachelor’s degree in IT and proven experience in database migration, ensuring seamless operations and data integrity. Responsibilities include planning migrations, optimizing queries, and providing post-migration support. Strong communication and collaboration skills are essential.

Qualifications

• Proven experience with database migration from Sybase to SQL Server.
• Strong understanding of migration methodologies and tools.
• Experience in capital markets or banking desirable.

Responsibilities

• Lead migration of databases from Sybase to SQL Server with minimal disruption.
• Conduct assessments of existing databases, develop migration plans.
• Collaborate with teams for successful migration, perform data validation.

Skills

Database administration

SQL

T-SQL

Stored procedure development

Problem-solving

Attention to detail

Communication

Collaboration

Education

Bachelor’s degree in computer science or Information Technology

Tools

SQL Server Migration Assistant (SSMA)

Sybase ASE/IQ

SQL Server

Oracle

PostgreSQL

Job description

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.