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.
Similar Jobs
What We Do
Headquartered in Santa Clara, California, and backed by renowned private equity firms Advent International and Warburg Pincus, Encora is the preferred technology modernization and innovation partner to some of the world’s leading enterprise companies. It provides award-winning digital engineering services including Product Engineering & Development, Cloud Services, Quality Engineering, DevSecOps, Data & Analytics, Digital Experience, Cybersecurity, and AI & LLM Engineering. Encora's deep cluster vertical capabilities extend across diverse industries, including HiTech, Healthcare & Life Sciences, Retail & CPG, Energy & Utilities, Banking Financial Services & Insurance, Travel, Hospitality & Logistics, Telecom & Media, Automotive, and other specialized industries.
With over 9,000 associates in 47+ offices and delivery centers across the U.S., Canada, Latin America, Europe, India, and Southeast Asia, Encora delivers nearshore agility to clients anywhere in the world, coupled with expertise at scale in India. Encora’s Cloud-first, Data-first, AI-first approach enables clients to create differentiated enterprise value through technology
