Sr. Database Administrator, Oracle EBS

Saks Fifth Avenue • New York, NY

1d • Hybrid

About The Position

Saks & Company LLC seeks a Sr. Database Administrator, Oracle EBS in New York, NY to perform EBS application installation, maintenance, and administration on version 11 and R12. This role involves utilizing Oracle EBS Suite and supportability matrix to research upgrades and installation requirements for future releases. The administrator will use Discoverer 10g with Oracle E-Business Suite R12 applications to generate BI publisher reports. Responsibilities include managing RDS databases, performing cloud monitoring with AWS CloudWatch and Azure Dashboards, and setting up alerts to diagnose and monitor cloud-managed databases. Automation of manual processes for database and cloud environments using tools like Terraform, Ansible, Github, Powershell, and shell scripts is key. The role also includes administrative tasks such as database creations, upgrades, backups, audit activities, and troubleshooting performance issues. Support for various Oracle Database versions (9i, 10g, 11g, 12c) and Oracle RAC using ASM for load balancing and failover is required. Performance tuning on applications and databases is also a part of the role.

Requirements

• Bachelor’s degree or foreign equivalent in Computer Science or a related field.
• Five (5) years of progressively responsible experience in the job offered or related occupation.
• Installing E-business suite applications from scratch while migrating the EBS 11i environment.
• Performing EBS application and oracle database software installation and clone the applications while migrating the data.
• Applying quarterly and year-end maintenance patches, bug fixes, and Critical Vulnerability Updates (CVU) patches.
• Applying Vertex tax patches on non-production system and migrate the patches to production.
• Implementing single sign on by integrating Oracle OID, OIM with the EBS application which enables user password less login to EBS self-service applications.
• Migrating databases from on-premises to AWS RDS and Azure cloud for modernization.
• Utilizing terraform to provision cloud database resources including RDS for AWS, SQL Managed Instance for Azure.
• Using ansible playbooks to automate the installation of oracle software 11g, 12c, 19c versions for consistency of environment.
• Standardizing the scripts for database maintenance activities and check-in in Github repository.
• Supporting Oracle, SQL Server, DB2, MongoDB, Postgres, Teradata technologies as used by application team.

Responsibilities

• Perform EBS application installation, maintenance, and administration on version 11 and R12.
• Utilize Oracle EBS Suite and supportability matrix to research upgrades and installation requirements for future releases.
• Use Discoverer 10g with Oracle E-Business Suite R12 applications to generate BI publisher reports.
• Manage RDS databases.
• Perform cloud monitoring with AWS CloudWatch, Azure Dashboards and alerts to diagnose and monitor for cloud managed databases.
• Automate manual processes for database and cloud environments using automation tools including Terraform, Ansible, Github, Poweshell, and shellscripts.
• Perform administrative tasks including database creations, upgrades, database backups, audit activities, troubleshoot performance issues, along with other DBA activities.
• Support various Oracle Database versions including 9i, 10g, 11g, and 12c and Oracle RAC using ASM related to load balancing and failover on RAC database for high availability.
• Perform troubleshooting and performance tuning on application and database.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior