Oracle PL/SQL Developer

Tata Consultancy Services Limited
Jersey City, United States of America
14 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 115K

Job location

Jersey City, United States of America

Tech stack

Java
Data analysis
Databases
Database Design
Database Schema
Software Debugging
DevOps
Java Web Services
Oracle Applications
Oracle SQL Developer
Performance Tuning
SQL Stored Procedures
PL-SQL
SQL Databases
Diagnostic Tools
Data Storage Management
Oracle Enterprise Manager
Database Performance
Indexer
Information Technology

Job description

  • 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.

Requirements

Do you have experience in Transaction monitoring?, Do you have a Bachelor's degree?, 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., Qualifications : BACHELOR OF COMPUTER SCIENCE

Benefits & conditions

3.93.9 out of 5 stars Jersey City, NJ $100,000 - $115,000 a year, Pulled from the full job description

  • Pet insurance
  • Health insurance
  • Vision insurance
  • Dental insurance
  • Commuter assistance, 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

Apply for this position