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.