Genpact
Location
Noida | India
Job description
With a startup spirit and 115,000+ curious and courageous minds, we have the expertise to go deep with the world&rsquos biggest brands&mdashand we have fun doing it. We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We&rsquore harnessing the power of technology and humanity to create meaningful transformation that moves us forward in our pursuit of a world that works better for people. Now, we&rsquore calling upon the thinkers and doers, those with a natural curiosity and a hunger to keep learning, keep growing., People who thrive on fearlessly experimenting, seizing opportunities, and pushing boundaries to turn our vision into reality. And as you help us create a better world, we will help you build your own intellectual firepower.
Welcome to the relentless pursuit of better.
Inviting applications for the role of Lead Consultant - SQL Developer Support
In this role, you would be primary responsible for supporting and enhancing web application.
Responsibilities
. Responsible for resolving technical issues for consumers, partners, clients, or internal stakeholders by addressing issues assigned to them through the ticketing systems using process specifications following operating procedures.
. Collaborate with our data analysts and other stakeholders to understand business requirements and work to troubleshoot/enhance database structures and queries.
. Write and optimize complex SQL queries.
. Manage SQL code in a source control system.
. Contribute to continual improvement by suggesting improvements/Automation or new technologies.
. Responsible for Debugging and implementing database performance monitoring and tuning.
. Manage and resolve production incidents. Covers system outages, job failures, system defects, data defects and end user support.
. Execute and manage day-to-day 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.
. Lead/participate in SQL code reviews.
. Provide technical support, including troubleshooting and resolving data-related issues.
. Stay current with database and technologies and the direction of the general database industry.
. Provide technical mentoring and coaching for junior and mid-level developers.
Qualifications
Minimum qualifications
. B.E./ B.Tech/ MCA or equivalent
Preferred Qualifications
. Hands on experience in SQL programming, Debugging, Performance tuning, Database Design, Table schema and basic knowledge of database administration.
. Strong Knowledge of creating packages, stored procedures, cursors, triggers, functions, joins, replication and modifying SQL scripts in Oracle.
. Experience with database design, data modeling, and data warehousing.
. Strong knowledge of Relational Databases Management Systems (RDBMS) concepts.
. Strong knowledge of PL/SQL is a must.
. Should have basic knowledge of UNIX environment.
. Knowledge of ETL processes and tools will be an added advantage.
. Strong analytical and problem-solving skills.
. Ability to work independently and in a team environment.
. Should have excellent communication skills to effectively interface with Client.
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 diversity and inclusion, respect and integrity, customer focus, and innovation. For more information, visit . Follow us on , , , and .
Job tags
Salary
