Oracle Core Technology and Applications Database Administrator
ETS Innovations is looking for an Oracle Database Administrator (DBA) to join our team The DBA needs to have both Oracle Core and Applications knowledge and experience.
The DBA will wear multiple hats – at different customer locations - and they will be responsible for installing and maintaining the database software, building storage structures, setting up user accounts, troubleshooting faulty applications, producing backups, and regularly managing database security.
The role will perform Applications DBA tasks at some customers and Core technology tasks at other customers.
Therefore, knowledge of both areas of responsibility is critical.
Oracle Cloud Knowledge – Oracle Cloud Infrastructure experience would be considered as an advantage.
Migration experience from On Premise to OCI would be an advantage.
Roles and Responsibilities
Oracle Core Technology:
Duties & Responsibilities
Core competencies, knowledge, and experience:
Oracle Database
In-depth knowledge of Oracle Database 19c.
(Versions 12 to 19c) (Version 23 an advantage)
· Experience with Oracle RAC, Grid Infrastructure, and ASM.
· Proficiency in SQL, PL/SQL, and RMAN.
· Experience with database replication technologies (e.g., Data Guard, GoldenGate).
· Knowledge of backup technologies like Veem / Comvault.
Oracle GoldenGate (OGG) – optional
Experience with configuring and managing Oracle GoldenGate for data replication.
· Experience with OGG monitoring and troubleshooting.
Other
Experience in Oracle Linux administration.
Proficiency in scripting languages (e.g., Shell, Python, Perl)
Strong problem-solving and analytical skills.
Excellent communication and collaboration skills.
Oracle Applications Technology:
Duties & Responsibilities
Core competencies, knowledge, and experience:
Oracle Applications Database tasks
·
Installation and Configuration:
Installing and configuring Oracle E-Business Suite, Oracle databases, and associated middleware components.
Applying patches, updates, and upgrades to both the Oracle applications and databases to ensure security, stability, and access to new features.
Managing user accounts, responsibilities, profiles, concurrent managers, and printers within the Oracle Applications environment.
Monitoring and optimizing the performance of Oracle applications and databases, including database tuning, application tuning, and concurrent manager optimization.
Cloning or refreshing development, testing, and other non-production environments from production.
Diagnosing and resolving technical issues related to Oracle applications and databases, providing support to development teams and end-users.
Requirements and Skills
The role is suitable for the candidate who has sufficient experience in both technology areas – but still wants to grow and is willing to keep their knowledge at the highest level.
Must have technical / professional qualifications:
5 or more years of Technical experience across Oracle technologies.
Relevant Oracle DBA qualifications / certifications.