Required over 2 years
Working in database: Oracle, SQL Server
1 Query Optimization: Skills in optimizing SQL queries and database performance, including proper indexing, query tuning, and analyzing execution plans.
2 Database Administration: Creating database objects like Tables, packages, procedures.. or changes into existing objects, security, monitoring
3 ETL (Extract, Transform, Load): Understanding of ETL processes and experience in data extraction, transformation, and loading from various sources into a databse. Create/ Execute/ Monitor Oracle jobs
4 Data Warehousing: Familiarity with concepts related to data warehousing, including dimensional modeling, star schemas, and data aggregation.
1 Communication and Collaboration: Strong communication skills to effectively work with stakeholders, gather requirements, and collaborate with teams on database-related projects.
2 Prepare & writing the Technical Document or update (Diagram and data architect)
3 Use TOAD as GUI, Sql navigator…