Tata Consultancy Services
Charlotte, United States
Salary : 15,500 - 19000
Skill: Oracle SQL + Java Developer
Must Have Technical/Functional Skills:
- Primary Skill: Oracle PLSQL.
- Secondary: Core Java, Cassandra, Unix.
- Experience: Minimum 7 years.
Roles & Responsibilities:
Database Development and Optimization:
- Design, develop, and maintain complex PL/SQL packages, procedures, functions, triggers and views for mission critical applications.
- Write high-performance, scalable PL/SQL code for large and complex business logic.
- Write efficient SQL queries for data extraction and transformation.
- Tune PL/SQL code and SQL queries for performance optimization.
- Analyze execution plans and apply indexing strategies.
- Analyze execution plans, optimize SQL and PL/SQL for performance (bulk operations, indexing, pipelined functions).
- Refactor poorly performed queries and stored procedures.
Database Design and Architecture:
- Assist in data modeling and schema design for new feature or systems.
- Ensure normalization, integrity constraints, partitioning, and effective indexing.
- Collaborate with DBAs for capacity planning and system tunning.
- Core Java Integration.
- Build Java components that interact with Oracle database using JDBC/ORM/Spring frameworks.
- Collaborate with Java developers to ensure seamless integration of PL/SQL procedures into application layers.
- Debug and enhance backend services built with Java.
- Data Handling and ETL Support.
- Support ETL operations through PL/SQL logic and scripts.
- Assist in data validation, cleansing, and transformation task.
- Work with large volumes of data across different systems.
Salary Range - $85,000-$115,000 a year
#LI-NS2