- Strong hands-on experience in PostgreSQL database administration and development
- Experience in Oracle to PostgreSQL migration, including:
- Schema conversion (tables, views, packages, procedures, functions)
- Data type mapping and transformation
- Performance tuning and optimization post-migration
- Familiarity with tools like Oracle SQL Developer, AWS Schema Conversion Tool (SCT), or pgAdmin
- Ability to write and optimize PL/pgSQL procedures
- Knowledge of foreign data wrappers (FDW) and PostgreSQL-specific features
- Understanding of data validation techniques post-migration