Job Details Apply via mail and email

Job Description Key Duties and Responsibilities

- Develop and maintain data pipelines using PL/SQL and shell scripting to collect and integrate data from multiple sources into a centralized data lake.
- Analyze database workloads, query execution and processing performance to identify bottlenecks and recommend improvements.
- Support and maintain business-critical production databases in a 24/7 environment, ensuring high availability and reliable access to data.
- Administer Oracle, Microsoft SQL Server and PostgreSQL database environments hosted on AWS and Oracle Cloud Infrastructure.
- Perform database upgrades, patching, cloning and configuration to support operational requirements.
- Plan and execute database migrations, including migrating Amazon RDS for Oracle databases to Amazon Aurora PostgreSQL using AWS Database Migration Service.
- Investigate and resolve database and Oracle E-Business Suite performance issues affecting data processing and application functionality.
- Use Oracle Enterprise Manager, AWR, ASH, ADDM and SQL advisory tools to monitor database performance and optimize SQL queries.
- Develop and implement backup and recovery procedures using Oracle Recovery Manager to protect data and support business continuity.
- Support Oracle E-Business Suite application and database upgrades, including migration to Release 12.2.10 and Oracle Database 19c.
- Install, configure and maintain database monitoring tools, including Oracle Enterprise Manager Cloud Control.
- Provide technical guidance and mentoring to junior team members on database design, administration, data integration and performance optimization.