Wipro - Addison, TX

posted about 2 months ago

Full-time - Senior
Addison, TX
Professional, Scientific, and Technical Services

About the position

Wipro Limited is seeking a skilled PL/SQL Developer to join our team in Addison, Texas. The ideal candidate will have a strong background in Oracle technologies, specifically with a working knowledge of Oracle 19c and Oracle 21c, and will be responsible for developing and maintaining PL/SQL packages, procedures, functions, and triggers. This role requires a minimum of 7 years of experience with PL/SQL and at least 5 years of experience in SQL and SQL tuning. The successful candidate will demonstrate strong programming and development skills, particularly in PL/SQL, and will be proficient in batch coding techniques such as bulk collections, dynamic SQL, and parallel processing. In this position, you will be expected to troubleshoot and diagnose problems quickly, providing effective solutions to enhance system performance. You will also be involved in performance tuning of PL/SQL using tools such as SQL Trace, Explain Plan, and Indexing. The role includes designing and executing test plans, performing gap analysis, and ensuring that business requirements and functional specifications are met. Excellent written and verbal communication skills are essential, as you will be collaborating with various stakeholders to ensure project success. Additionally, familiarity with source control systems and experience in using developer tools like Toad will be beneficial. While Python is not a primary requirement, having knowledge in this area is considered a desirable skill. Wipro is committed to fostering an inclusive workplace and encourages applications from all qualified individuals, regardless of their background.

Responsibilities

  • Develop and maintain PL/SQL packages, procedures, functions, and triggers.
  • Perform performance tuning of PL/SQL using SQL Trace, Explain Plan, and Indexing.
  • Troubleshoot and diagnose problems quickly, providing effective solutions.
  • Design and execute test plans and perform gap analysis to ensure business requirements are met.
  • Utilize source control for version management of code.
  • Collaborate with stakeholders to ensure project success and communicate effectively.

Requirements

  • 7+ years of experience working with PL/SQL.
  • 5+ years of experience in SQL and SQL tuning.
  • Strong programming skills in PL/SQL, including packages, procedures, functions, and triggers.
  • Experience with batch coding techniques such as bulk collections, dynamic SQL, and parallel processing.
  • Excellent written and verbal communication skills.
  • Strong analytical and problem-solving skills.

Nice-to-haves

  • Knowledge of Oracle 19c and Oracle 21c capabilities and functionality.
  • Experience with UNIX and Python programming.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service