Senior PL/SQL Developer

Job Title: Senior PL/SQL Developer
Experience: 10+ Years
Job Type: Contract W2

Job Summary

We are looking for an experienced Senior PL/SQL Developer with 10+ years of experience in Oracle database development, SQL programming, performance tuning, and database optimization. The ideal candidate should have strong expertise in PL/SQL, stored procedures, packages, triggers, and complex query development.

Key Responsibilities

• Develop, maintain, and optimize complex SQL queries, PL/SQL procedures, functions, packages, and triggers.

• Perform database performance tuning, query optimization, and troubleshooting.

• Design and maintain database objects, including tables, views, indexes, and materialized views.

• Analyze business requirements and develop efficient database solutions.

• Work with large volumes of data and improve database performance.

• Perform data migration, validation, and reconciliation activities.

• Collaborate with application developers, business analysts, and QA teams.

• Identify and resolve production issues and support database-related deployments.

• Participate in code reviews, technical documentation, and development best practices.

Required Skills

• 10+ years of experience in Oracle PL/SQL development.

• Strong expertise in SQL, PL/SQL, stored procedures, functions, packages, and triggers.

• Experience with Oracle databases, query optimization, and execution plans.

• Knowledge of indexing, partitioning, bulk processing, and performance tuning.

• Experience with database debugging, troubleshooting, and production support.

• Strong analytical, problem-solving, and communication skills.

• Experience with Unix/Linux shell scripting is preferred.

Preferred Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.

• Experience working in enterprise applications and large-scale database environments.

• Familiarity with ETL processes, data integration, and database migration.