Experience: 12 Years
Employment Type: Contract (W2)
We are seeking an experienced Senior PL/SQL Developer with strong expertise in Oracle Database, PL/SQL programming, SQL development, performance tuning, and database optimization. The ideal candidate should have hands-on experience developing complex stored procedures, packages, functions, triggers, and database solutions for enterprise applications.
Design, develop, and maintain complex PL/SQL procedures, packages, functions, and triggers.
Write and optimize complex SQL queries for large-scale databases.
Perform SQL and PL/SQL performance tuning and query optimization.
Develop database objects, views, indexes, and materialized views.
Analyze business requirements and translate them into technical database solutions.
Troubleshoot database performance issues and production defects.
Perform data migration, data validation, and data reconciliation.
Work with ETL processes and data integration solutions.
Collaborate with application developers, business analysts, and database administrators.
Support database deployments, testing, and production releases.
Database: Oracle 11g, 12c, 19c, 21c.
Programming: PL/SQL, Advanced SQL.
PL/SQL Objects: Stored Procedures, Packages, Functions, Triggers, Cursors.
Performance Tuning: Explain Plan, AWR, ADDM, SQL Trace, Index Optimization.
Database Concepts: Partitioning, Materialized Views, Indexes, Joins.
ETL Tools: Informatica, Oracle Data Integrator (ODI).
Tools: SQL Developer, TOAD, Oracle Enterprise Manager.
Scripting: Unix/Linux Shell Scripting.
Version Control: Git, SVN.
12+ years of experience in Oracle PL/SQL development.
Strong hands-on experience with complex SQL and PL/SQL programming.
Expertise in database performance tuning and optimization.
Experience working with large-volume transactional databases.
Knowledge of database design, data modeling, and troubleshooting.
Strong analytical and problem-solving skills.
Experience with Oracle Forms and Reports.
Knowledge of Oracle RAC and database architecture.
Experience with banking, financial services, insurance, or healthcare applications.
Exposure to cloud databases and database migration projects.