About the Role
We are seeking an experienced PL/SQL Developer with strong expertise in relational database management systems, specifically Oracle PL/SQL and PostgreSQL. You will be responsible for designing, developing, and maintaining complex database architectures, writing advanced procedural code, and driving database optimization and migrations.
Key Responsibilities
- Design and develop efficient database architectures, stored procedures, functions, packages, and triggers in both PL/SQL and PostgreSQL (PL/pgSQL).
- Optimize complex SQL queries, views, and indexes to resolve performance bottlenecks.
- Manage data migration, data transformation, and cross-database integration (e.g., Oracle to PostgreSQL).
- Collaborate with application developers to integrate backend business logic seamlessly.
- Ensure data integrity, security, and high availability across production databases.