Responsibilities
:Database Design & Architecture:
Design, implement, and optimize Oracle database architectures to meet application and business requirements.Develop and maintain logical and physical data models, including database schemas and entity-relationship diagrams (ERDs).Collaborate with developers and stakeholders to ensure Oracle database design aligns with application needs and business goals.SQL & PL/SQL Development:
Write, review, and optimize complex SQL queries, PL/SQL scripts, stored procedures, and triggers.Support developers by designing and reviewing efficient SQL and PL/SQL queries, ensuring optimal data access patterns.Performance Tuning:
Proactively monitor and troubleshoot Oracle database performance issues, including query performance, indexing, partitioning, and resource contention.Implement performance tuning techniques such as query optimization, indexing s...