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:
Post a Comment
Post a Comment