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