Sr. PL/SQL Developer
- Oracle database development life cycle, including data modeling, architecture design, SQL/PLSQL development, unit testing, and production support.
- Good exposure of new Oracle version's inbuilt functions and features.
- Create, enhance, and maintain reusable database objects.
- Perform SQL query optimization and tuning to maximize speed and scale.
- Apply working knowledge of Oracle REST Data Services (ORDS) and API Gateway Cloud for database integration and API management.
- Demonstrate deep expertise in PL/SQL programming, covering:
Advanced data types – BLOBs CLOBs, cursors, and exception handling. Collections and merge statements
Analytic functions, Index, views, and materialized views. Table functions, stored procedures, functions, and packages. Database triggers and dynamic SQL. External tables and object programming. SQL built-in functions, joins, and aggregate functions. Comprehensive performance tuning techniques