Tata Consultancy Services (TCS) is seeking highly skilled and experienced Oracle PL/SQL Developers to join our dynamic and growing team. This is a fantastic opportunity for professionals who have a strong technical background in Oracle PL/SQL development and are looking to contribute to impactful projects across various industry domains.
As an Oracle PL/SQL Technical Consultant, you will be involved in the design, development, enhancement, and support of robust PL/SQL-based solutions. You will work closely with functional teams, business analysts, and project stakeholders to deliver high-quality software aligned with business needs. If you are passionate about enterprise-level application development, problem-solving, and technology innovation, we would love to hear from you.
Key Responsibilities
- Design, develop, and maintain complex PL/SQL procedures, functions, packages, and triggers in an Oracle database environment.
- Work across the full software development lifecycle including requirements gathering, design, development, testing, and deployment using Agile methodologies.
- Develop and optimize PL/SQL code for performance, scalability, and maintainability.
- Create and manage database objects such as tables, views, indexes, constraints, and synonyms.
- Implement normalization and data modeling best practices, ensuring database integrity and optimization.
- Develop PL/SQL Producers and custom modules to support various business processes.
- Customize and generate Oracle Reports and Forms as per user requirements.
- Register concurrent programs, reports, and forms within Oracle Applications (E-Business Suite preferred).
- Participate in performance tuning of database queries, PL/SQL code optimization, and troubleshooting.
- Provide production support and resolve issues in a timely manner ensuring minimal impact to end-users.
- Work collaboratively with cross-functional teams including QA, DevOps, and Business Analysts.
- Provide mentoring and technical guidance to junior developers as needed.
Required Skills and Qualifications
- A minimum of 8 years of hands-on experience in Oracle PL/SQL development and support.
- Strong understanding of relational databases, data modeling, and normalization techniques.
- Solid experience with Oracle Forms, Reports, and concurrent program registration.
- In-depth knowledge of PL/SQL best practices, coding standards, and debugging techniques.
- Proven experience working on full-lifecycle development projects using Agile/Scrum methodologies.
- Experience working on medium to large-scale enterprise software applications.
- Excellent analytical, problem-solving, and decision-making skills.
- Effective communication and interpersonal skills, with a proactive and collaborative work style.
- Ability to learn new technologies quickly and adapt to dynamic project environments.
Preferred Qualifications
- Experience working in a consulting or client-facing environment is a plus.
- Exposure to Oracle E-Business Suite (EBS) or other ERP systems is highly desirable.
- Knowledge of performance tuning tools and techniques for Oracle databases.
- Familiarity with DevOps practices and version control tools (e.g., Git).
Why Join TCS?
- Opportunity to work with one of the world’s leading IT services and consulting organizations.
- Work on diverse and challenging projects across global clients and industries.
- Continuous learning and development with access to cutting-edge technologies and resources.
- A collaborative and inclusive workplace that values innovation, integrity, and excellence.
- Strong career growth prospects and support from a global community of experts.
If you are ready to take your PL/SQL expertise to the next level and make a meaningful impact, apply now to be a part of TCS, where your ideas shape the future.