Job Summary
Required Skills • Design, develop, and maintain Oracle and PostgreSQL database objects, including tables, views, materialized views, procedures, functions, and triggers. • Optimize database performance through SQL tuning, indexing, partitioning, execution plan analysis, and statistics management. • Manage Oracle-to-PostgreSQL migration initiatives, including schema conversion, code remediation, data migration, validation, and deployment. • Administer Oracle and PostgreSQL databases, including security, backup and recovery, monitoring, troubleshooting, and release management. • Support cloud modernization by migrating and optimizing database workloads on AWS Aurora PostgreSQL. • Implement scalable database solutions using partitioning and materialized views to support large-scale workloads and improve performance.
Key Responsibilities
Required Skills • Design, develop, and maintain Oracle and PostgreSQL database objects, including tables, views, materialized views, procedures, functions, and triggers. • Optimize database performance through SQL tuning, indexing, partitioning, execution plan analysis, and statistics management. • Manage Oracle-to-PostgreSQL migration initiatives, including schema conversion, code remediation, data migration, validation, and deployment. • Administer Oracle and PostgreSQL databases, including security, backup and recovery, monitoring, troubleshooting, and release management. • Support cloud modernization by migrating and optimizing database workloads on AWS Aurora PostgreSQL. • Implement scalable database solutions using partitioning and materialized views to support large-scale workloads and improve performance.
Skill Requirements
Required Skills • Design, develop, and maintain Oracle and PostgreSQL database objects, including tables, views, materialized views, procedures, functions, and triggers. • Optimize database performance through SQL tuning, indexing, partitioning, execution plan analysis, and statistics management. • Manage Oracle-to-PostgreSQL migration initiatives, including schema conversion, code remediation, data migration, validation, and deployment. • Administer Oracle and PostgreSQL databases, including security, backup and recovery, monitoring, troubleshooting, and release management. • Support cloud modernization by migrating and optimizing database workloads on AWS Aurora PostgreSQL. • Implement scalable database solutions using partitioning and materialized views to support large-scale workloads and improve performance.
Other Requirements
Required Skills • Design, develop, and maintain Oracle and PostgreSQL database objects, including tables, views, materialized views, procedures, functions, and triggers. • Optimize database performance through SQL tuning, indexing, partitioning, execution plan analysis, and statistics management. • Manage Oracle-to-PostgreSQL migration initiatives, including schema conversion, code remediation, data migration, validation, and deployment. • Administer Oracle and PostgreSQL databases, including security, backup and recovery, monitoring, troubleshooting, and release management. • Support cloud modernization by migrating and optimizing database workloads on AWS Aurora PostgreSQL. • Implement scalable database solutions using partitioning and materialized views to support large-scale workloads and improve performance.