Important Information
Location: India
Experience: 10+ years
Job Mode: Full-time
Job Summary
The SQL-to-Postgres Data Migration Specialist will play a key role in data modernization initiatives by leading the migration of legacy SQL Server databases, including T-SQL stored procedures and SSIS packages, to PostgreSQL. This role requires deep expertise in database administration, migration strategies, and tools to ensure minimal downtime, data integrity, and a seamless transition to a modern, scalable cloud-based architecture. The specialist will leverage tools such as Babelfish, generative AI, or custom frameworks to optimize the migration process and ensure compatibility across systems.
Responsibilities and Duties
- Database Migration & Compatibility:
- Lead the migration of complex SQL Server environments, including stored procedures and SSIS packages, to PostgreSQL.
- Use Babelfish for Aurora PostgreSQL or other tools to streamline compatibility with legacy T-SQL code.
- Analyze existing SQL Server structures to identify potential issues and develop robust solutions for smooth transitions.
- Data Transformation & Integration:
- Design and implement ETL processes to transform and migrate data accurately while maintaining its integrity.
- Collaborate with the data engineering team to integrate workflows using tools such as AWS Glue and Apache Airflow.
- Optimization & Performance Tuning:
- Optimize database performance during and post-migration, ensuring the new environment supports existing and future workloads.
- Perform tuning for PostgreSQL systems to meet performance benchmarks and scalability requirements.
- Collaboration & Stakeholder Engagement:
- Work closely with the Solution Architect, Data Architect, and QA Lead to align migration strategies with project objectives and quality standards.
- Partner with the client’s in-house team to validate migrated components and ensure compatibility with application logic.
- Tool & Framework Utilization:
- Evaluate and implement tools such as Babelfish or generative AI frameworks to automate and ease T-SQL to PostgreSQL translation.
- Develop scripts and workflows for automating migration tasks and minimizing manual intervention.
- Documentation & Knowledge Transfer:
- Prepare detailed documentation for migrated components, including database structures, stored procedures, and ETL pipelines.
- Conduct training sessions for the client’s technical team to ensure they are equipped to maintain and operate the new system
Qualifications and Skills
- 10+ years of experience in database administration, with significant expertise in SQL Server and PostgreSQL.
- Proven track record in large-scale database migration projects, including stored procedure and ETL package migration.
- Hands-on experience with Babelfish for Aurora PostgreSQL or similar tools to aid SQL Server compatibility.
- Strong understanding of ETL frameworks such as AWS Glue and Apache Airflow.
- Expertise in database performance tuning and optimization.
- Strong collaboration and communication skills to work effectively with technical teams and stakeholders.
- Attention to detail and a proactive approach to identifying and mitigating migration risks.
- Ability to work in a fast-paced environment and deliver results within tight deadlines
Additional Requirements
- Experience using generative AI tools or frameworks to support database migration and compatibility tasks.
- Familiarity with microservices architecture and API-driven database interaction.
- Knowledge of cloud-native platforms, particularly AWS Aurora and Snowflake.
- Strong analytical skills for troubleshooting and problem resolution during complex migrations.
About Encora
Encora is a global company that offers Software and Digital Engineering solutions. Our practices include Cloud Services, Product Engineering & Application Modernization, Data & Analytics, Digital Experience & Design Services, DevSecOps, Cybersecurity, Quality Engineering, AI & LLM Engineering, among others.
At Encora, we hire professionals based solely on their skills and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality.