Oracle PL/SQL Developer

Must Have Technical/Functional Skills We are seeking a highly experienced Oracle PL/SQL Developer with 10+ years of professional experience in designing, developing, tuning, and monitoring Oracle-based systems. The ideal candidate should be proficient in writing complex queries, managing database objects, and optimizing performance using tools like Oracle Enterprise Manager (OEM). A strong background in SQL, PL/SQL, and Java, along with the ability to work on enterprise-level solutions, is essential for this role. 1. Must-Have Technical /

Functional Skills:

Core Database Skills:

10+ years of hands-on experience in Oracle Development. Expert-level proficiency in SQL and PL/SQL. Strong experience in designing database objects such as tables, triggers, procedures, and partitions. Ability to write and optimize complex

SQL/PLSQL

queries for data analysis and processing.

Performance Tuning & Tools:

In-depth knowledge of SQL Tuning, SQL traces, SQLLDR, and other Oracle utilities. Hands-on experience with OEM (Oracle Enterprise Manager) for monitoring and performance optimization. Familiarity with transaction monitoring and use of third-party tools.

Additional Skills:

Experience with Java and integration of database logic with Java-based applications. Strong debugging, troubleshooting, and performance improvement capabilities. Roles & Responsibilities Design, develop, and maintain robust PL/SQL programs, stored procedures, triggers, and packages. Work with application teams to integrate database solutions and ensure data accuracy and consistency. Tune SQL queries for performance optimization using Oracle tools and best practices. Monitor and troubleshoot database performance issues using OEM and other diagnostic tools. Participate in database design discussions and ensure proper indexing, partitioning, and storage management. Collaborate with QA and DevOps teams to support builds, deployments, and defect resolution. Document technical solutions, queries, and procedures for maintainability and compliance. Provide production support and proactively monitor database health and performance.

TCS Employee Benefits Summary:

Discretionary Annual Incentive.

Comprehensive Medical Coverage:

Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support:

Maternal & Parental Leaves.

Insurance Options:

Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth:

Commuter Benefits & Certification & Training Reimbursement.

Time Off:

Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance:

Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range:

$100,000-$115,000 a year Location Jersey City, NJ Job Function

TECHNOLOGY

Role Engineer Job Id 411525 Desired Skills Oracle | PL/SQL Salary Range $100,000-$115,000 a year

Desired Candidate Profile Qualifications :

BACHELOR OF COMPUTER

SCIENCE