Featured Post

Cognizant is hiring for DevOps Engineer Associate - Apply Now - GETLIVEJOB

DevOps Engineer Associate at Cognizant Do you thrive in a collaborative environment and enjoy automating tasks to improve efficiency?  Do you have a passion for DevOps and cloud technologies? If so, then Cognizant wants to hear from you! We are seeking a DevOps Engineer Associate to join our high-cali…

Genpact is hiring for Lead Consultant – SQL Developer Support - Apply Now!

Genpact is Looking for a Lead Consultant - SQL Developer Support 

                                                                        

Do you have a passion for SQL and a knack for problem-solving?

Genpact is seeking a talented Lead Consultant to join our team and provide exceptional support for our web applications. In this role, you will be responsible for troubleshooting technical issues, collaborating with stakeholders, and ensuring the smooth operation of our databases.

Responsibilities:

  • Resolve technical issues for clients and internal teams.
  • Collaborate with data analysts to understand business needs and enhance database structures and queries.
  • Write and optimize complex SQL queries.
  • Manage SQL code in a source control system.
  • Suggest improvements, automation, and new technologies for continual process improvement.
  • Implement database performance monitoring and tuning.
  • Manage and resolve production incidents, including system outages and data defects.
  • Oversee day-to-day operations through ticketing tools and processes.
  • Test application features.
  • Lead and participate in SQL code reviews.
  • Provide technical support and troubleshooting for data-related issues.
  • Stay up-to-date on the latest database technologies and industry trends.
  • Mentor and coach junior and mid-level developers.

Qualifications:

  • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent).
  • Hands-on experience in SQL programming, debugging, performance tuning, database design, and table schema.
  • 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 understanding of cloud-hosted database models and schema.
  • Expertise in normalization, data modeling (logical and physical).
  • In-depth knowledge of Relational Database Management Systems (RDBMS) concepts.
  • Experience in database performance tuning.
  • Familiarity with Azure Data Factory and Azure SQL.
  • Ability to analyze existing SQL queries for performance improvement.
  • Strong knowledge of PL/SQL.
  • Basic knowledge of the UNIX environment.
  • Experience with ETL processes and tools (a plus).
  • Excellent analytical and problem-solving skills.
  • The ability to work independently and collaboratively.
  • Strong communication skills for effective client interaction.
Genpact offers a dynamic work environment that values diversity, inclusion, and innovation. To learn more and apply, visit our careers page!

Apply Link:

Related Posts

Post a Comment

Post a Comment