Database Analyst Full Time NEW

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.