Proficiency in using Data Modeling tools (e.g., Enterprise Architect, Oracle SQL Developer, Data Modeler, pgmodeler) to create logical and physical data models.
Expertise in translating logical models into physical database designs for both oracle and PostgreSQL, focusing on performance, scalability, and security.
Proficiency in oracle database architecture and administration, including installation, configuration, and upgrades.
Experience in indexing strategies, partitioning, and data distribution for optimal performance.
Strong skills in performance tuning, query optimization, and workload management for both oracle and PostgreSQL databases.
Proficient in writing and optimizing complex SQL queries and PL/SQL code.
Knowledge of oracle features like tablespaces, partitions, and materialized views.
Experience with RMAN, and Data Guard for Backup and Recovery.