Lead Consultant - PLSQL developer

Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125000 people across 30 countries are driven by our innate curiosity entrepreneurial agility and desire to create lasting value for clients. Powered by our purpose the relentless pursuit of a world that works better for people we serve and transform leading enterprises including the Fortune Global 500 with our deep business and industry knowledge digital operations services and expertise in data technology and AI.

Inviting applications for the role of Lead Consultant PL/SQL developer
In this role you will be responsible for developing testing implementing and maintaining PL/SQL code for various applications and databases.

Responsibilities
Design develop and maintain PL/SQL procedures functions packages and triggers to support application requirements.
Optimize SQL queries and database performance to ensure high availability and scalability.
Work closely with software engineers and system architects to integrate PL/SQL code with application logic and business processes.
Participate in database design and schema modeling activities to ensure data integrity and efficiency.
Perform code reviews and collaborate with team members to ensure coding standards and best practices are followed.
Troubleshoot and debug issues in PL/SQL code identify root causes and implement solutions.
Create and maintain technical documentation for PL/SQL code database schemas and data models.
Stay updated on emerging technologies and trends in database development and recommend improvements to existing systems and processes.
Execute and manage daytoday operations via ticketing tools and processes.
Ensure appropriate tool is updated in accordance with SLA specifications with case notes status updates and case closure information.
Responsible to test the application features should understand any testing tool.

Shift requirement:

Flexible to work in morning/afternoon/evening/night shifts on a rotation basis as the candidate may have to work with global teams in different time zones.

Qualifications we seek in you!
Minimum Qualifications / Skills
B.E./ B. Tech/ MCA or equivalent

Preferred Qualifications/ Skills
Advanced degree or certifications in database development or related field.
Experience with other programming languages such as Java Python or C#.
Knowledge of database security best practices and data encryption techniques.
Experience working in Agile development environments and using version control systems such as Git.
Should be able to handle client call manage & mentor team.
Proven experience as a PL/SQL developer or similar role with a strong understanding of relational database concepts and SQL.
Proficiency in writing efficient PL/SQL code including stored procedures functions packages and triggers.
Experience with Oracle Database and related tools such as SQL Developer TOAD or PL/SQL Developer.
Familiarity with database performance tuning and optimization techniques.
Strong analytical and problemsolving skills with the ability to troubleshoot complex issues and propose effective solutions.
Excellent communication and collaboration skills with the ability to work effectively in a team environment.
Attention to detail and a commitment to delivering highquality solutions on time.
Ability to be learn and apply new processes and tools.
Technical understanding of products/services and/or ecosystem being supported.

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race color religion or belief sex age national origin citizenship status marital status military/veteran status genetic information sexual orientation gender identity physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values respect and integrity customer focus and innovation. Get to know us at and on LinkedIn X YouTube and Facebook.
Furthermore please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a starter kit paying to apply or purchasing equipment or training.