Oracle Database Developer

Job Title: Oracle Database Developer Location: Tampa, FL Job Type: Permanent Hire Salary: $115K per annum with benefits

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.