Job Search
| DB Arcitect || Solution Architect IRC175046
| Job: | IRC175046 |
| Location: | India - Nagpur |
| Designation: | Solution Architect |
| Experience: | 5-10 years |
| Function: | Technology |
| Skills: | Oracle-PL/SQL, PostgreSQL |
Description:
Experience in the successful migration of large datasets from an Oracle database system to a comparable PostgreSQL RDBMS.
10+ Years of experience is required working in same.
Perform migration of PL/SQL code that includes Packages, Procedures and Functions from Oracle to PostgreSQL
Experience in performing Oracle to PostgreSQL migrations and in helping clients port applications from Oracle to PostgreSQL with alternate approaches that are open source
Experience in writing PLpgSQL and migrating Packages and Procedures from Oracle to PostgreSQL.
Experience in writing Oracle PL/SQL code
Experience coding in scripting languages
Requirements:
Join GlobalLogic, to be a valid part of the team working on a huge software project for the world-class company providing M2M / IoT 4G/5G modules e.g. to the automotive, healthcare and logistics industries. Through our engagement, we contribute to our customer in developing the end-user modules’ firmware, implementing new features, maintaining compatibility with the newest telecommunication and industry standards, as well as performing analysis and estimations of the customer requirements.
Preferences:
Oracle-PL/SQL, PostgreSQL
Job Responsibilities:
Knowledgeable in various alternatives for syntax and features only applicable to Oracle e.g. Hierarchical queries in Oracle use CONNECT BY, Oracle uses rownum, etc., so you’re able to find the best alternatives in PostgreSQL for various Oracle features
Knowledgeable in the target data types in PostgreSQL that suit the corresponding Oracle data types while migrating objects from Oracle
Experience using migration tools like Ora2PG or Schema Conversion toolkit from AWS
Experience with multi-tenancy, data security, TDE
What We Offer
Exciting Projects: We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them.
Collaborative Environment: You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!
Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays.
Professional Development: Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings.
Excellent Benefits: We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses.
Fun Perks: We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!