Oracle Db Developer

Tata Consultancy Services; Tampa (FL); On-site; USD 90,000 - 115,000; Full time

Job summary

Tata Consultancy Services Limited in Tampa, Florida seeks an Engineer with strong Oracle SQL and PL/SQL development to design, optimize, and maintain complex database components. You will translate business requirements into robust database solutions and ensure performance and data integrity.

The role requires tuning complex queries, working with large datasets, shell scripting, and collaboration in an Agile environment. Banking/Finance experience is a plus.

Qualifications

• Strong hands-on experience in Oracle SQL and PL/SQL development.
• Expertise in developing stored procedures, packages, functions, triggers, cursors, views, and complex SQL queries.
• Strong knowledge of SQL performance tuning, including execution plans, indexing, query optimization, and troubleshooting.
• Experience working with large-volume transactional databases and complex data structures.
• Strong understanding of Oracle database concepts, relational data models, joins, constraints, and database objects.
• Experience in data analysis, data validation, reconciliation, and data migration using SQL/PLSQL.
• Ability to analyze business requirements and translate them into technical/database solutions.
• Experience with Unix/Linux and Shell Scripting.
• Familiarity with Git, JIRA, and Agile development methodologies.
• Experience in Banking, Financial Services, or Capital Markets is preferred.
• Strong analytical, debugging, and problem-solving skills.

Responsibilities

• Design, develop, test, and maintain complex Oracle SQL and PL/SQL components.
• Develop and enhance procedures, packages, functions, triggers, views, and database scripts.
• Analyze and optimize complex SQL queries to improve application and database performance.
• Perform query tuning, execution-plan analysis, indexing, and database performance optimization.
• Work closely with Business Analysts, application developers, QA, and business teams to understand requirements and deliver database solutions.
• Support data extraction, transformation, validation, reconciliation, and migration activities.
• Troubleshoot application/database issues and perform root-cause analysis.
• Support UAT, production deployments, release activities, and post-production validation.
• Participate in code reviews and ensure adherence to database development standards and best practices.
• Maintain technical documentation covering database designs, data flows, implementation details, and production-support procedures.
• Track development activities, defects, and deliverables through JIRA.

Skills

Oracle SQL

PL/SQL

Stored procedures

Packages

Functions

Triggers

Cursors

Views

Complex SQL queries

SQL performance tuning

Execution plans

Indexing

Query optimization

Troubleshooting

Large-volume databases

Relational data models

Joins

Constraints

Database objects

Data analysis

Data validation

Data reconciliation

Data migration

Unix/Linux

Shell scripting

Git

JIRA

Agile

Banking/Finance

Education

Bachelor's degree in Computer Science

Tools

Unix/Linux

Shell scripting

Git

JIRA

Job description

Job Description

Must Have Technical/Functional Skills

• Strong hands-on experience in Oracle SQL and PL/SQL development.
• Expertise in developing stored procedures, packages, functions, triggers, cursors, views, and complex SQL queries.
• Strong knowledge of SQL performance tuning, including execution plans, indexing, query optimization, and troubleshooting.
• Experience working with large-volume transactional databases and complex data structures.
• Strong understanding of Oracle database concepts, relational data models, joins, constraints, and database objects.
• Experience in data analysis, data validation, reconciliation, and data migration using SQL/PLSQL.
• Ability to analyze business requirements and translate them into technical/database solutions.
• Experience with Unix/Linux and Shell Scripting.
• Familiarity with Git, JIRA, and Agile development methodologies.
• Experience in Banking, Financial Services, or Capital Markets is preferred.
• Strong analytical, debugging, and problem-solving skills.

Roles & Responsibilities

• Design, develop, test, and maintain complex Oracle SQL and PL/SQL components.
• Develop and enhance procedures, packages, functions, triggers, views, and database scripts.
• Analyze and optimize complex SQL queries to improve application and database performance.
• Perform query tuning, execution-plan analysis, indexing, and database performance optimization.
• Work closely with Business Analysts, application developers, QA, and business teams to understand requirements and deliver database solutions.
• Support data extraction, transformation, validation, reconciliation, and migration activities.
• Troubleshoot application/database issues and perform root-cause analysis.
• Support UAT, production deployments, release activities, and post-production validation.
• Participate in code reviews and ensure adherence to database development standards and best practices.
• Maintain technical documentation covering database designs, data flows, implementation details, and production-support procedures.
• Track development activities, defects, and deliverables through JIRA.

Salary Range: $90,000 to $115,000 per year

Location

Tampa, FL

Function

TECHNOLOGY

Role

Engineer

ID

436564

Skills

Oracle

Salary Range: $90,000 - $115,000

Desired Candidate Profile

Qualifications

BACHELOR OF COMPUTER SCIENCE