Roles and Responsibilities :
- Design, implement, and maintain large-scale data warehouses using Oracle and PostgreSQL databases.
- Develop ETL processes to extract, transform, and load data from various sources into the target database.
- Optimize database performance by analyzing query logs, identifying bottlenecks, and implementing indexing strategies.
- Collaborate with cross-functional teams to design scalable architectures for big data processing pipelines.
Job Requirements :
- 6-9 years of experience in SQL Database Administration (DBA) role.
- Proficiency in Oracle and PostgreSQL databases with expertise in performance tuning and optimization techniques.
- Solid understanding of ETL concepts and ability to develop complex ETL processes using various tools such as SQL Server Integration Services (SSIS).
- Experience working on large-scale projects involving high-volume data processing.