Description

Key Skills: PL/SQL, SQL, Oracle, Stored Procedures, Functions, Query Optimization, Database Design, Performance Tuning, Data Integration, Documentation

Roles & Responsibilities:

• Develop, optimize, and maintain PL/SQL code, including stored procedures, functions, triggers, and packages.
• Design and implement efficient database structures to support application functionality.
• Write and optimize complex SQL queries for data extraction, transformation, and reporting.
• Perform debugging, troubleshooting, and tuning of PL/SQL code and database performance.
• Collaborate with application developers and business analysts to gather and analyze requirements.
• Create and maintain technical documentation, including data models, process flows, and coding standards.
• Ensure database security, integrity, and compliance with organizational standards.
• Provide support for database migrations, upgrades, and data integration tasks.
• Conduct regular system health checks and performance reviews.

Experience Requirement:

• 6-13 years of hands-on experience in PL/SQL development and Oracle database management.
• Extensive experience in writing and tuning complex SQL queries for high-performance applications.
• Proven expertise in designing normalized and denormalized database structures.
• Experience in debugging and performance tuning PL/SQL code using tools like SQL Developer or TOAD.
• Experience with database migration, integration, and version control practices.

Education: Any Graduation

Key Skills

Education

Any Graduate