Description

You will develop and maintain database solutions using PL/SQL.

Responsibilities

• Design and implement relational database structures, including tables, indexes, and sequences, ensuring efficient data storage.
• Develop triggers, packages, functions, and stored procedures to enforce business rules and automate database events.
• Analyze SQL queries using execution plans and optimize performance bottlenecks to improve system responsiveness.
• Monitor and fine-tune batch processes, implementing strategies like partitioning to meet SLA requirements.
• Execute database scripts and manage routine operations using the Command Line Interface (CLI).

Required Skills

• 6+ years of experience as an Oracle developer (10g/11g).
• Expert-level proficiency in PL/SQL programming, including cursors, exception handling, and bulk operations.
• Strong command of SQL for complex data manipulation and querying.
• Experience designing and optimizing database objects (tables, indexes, sequences).
• Familiarity with Automatic Workload Repository (AWR) and Database Diagnostic and Repair Manager (DDRM) reports.
• Proven ability to write optimized, reusable stored procedures for high-volume transactions.
• Experience in tuning SQL queries based on execution plans.
• Strong communication skills to collaborate with developers, DBAs, and business analysts.

Key Skills

Education

Any Graduate