Oracle Database Administrator

The Oracle Database Administrator for the Infrastructure team will perform Oracle database Administration for the customer-facing and corporate applications. He/she will provide strong operational support to the internal applications as well as the infrastructure teams.

• Initiates, plans, and coordinates Oracle Database system upgrades on Linux, Unix and Windows environments
• Manages and supports the core systems that include administrative tasks such as monitoring databases as well as application performance, disk and memory usage, log, and database and application assignments; identifies and documents potential issues, and prepares necessary corrective and preventative action plans
• Design, maintain, and document Oracle Database configurations/layouts
• Build and support new LPARs (logical partitions) using Power VM virtualisation
• Responsible for annual upgrades and patching on additional related core databases, including but not limited to application servers
• Troubleshooting Oracle database issues within the agreed SLA. Provide data and reporting of KPI’s and trends in ad-hoc, weekly, monthly and as sought.
• Develop standard operating procedures and best practices, including written policies and protocols that guide to database administration staffing and vendors.
• Installation, configuration and remediation of various security software on the Database environments
• Configuration and Administration of Oracle RAC, ASM, and stand-alone instances
• Responsible for monitoring and alerting on all the Oracle databases, running and maintaining hardening scripts.
• Work under minimal supervision & take ownership of Oracle incidents end-to-end
• Assists application and database teams with data purges, data archival, backups and restorations.
• Review & own technical documentation ensure compliance and accuracy in all documents

• 10+ years of experience in operations and project management of Oracle database administration
• Bachelor's in related technology/business areas
• Advanced knowledge of Oracle Databases version 12 and 19c and their configuration and protocols, terms and concepts.
• Expert-level experience in Oracle RAC, ASM, RMAN and OEM.
• Excellent understanding of OCI and Exadata.
• Excellent understanding of SAN storage technologies.
• Experience with writing shell scripts in ksh or any other scripting language.
• Ability to adapt to established standards and practices.
• Ability to manage several projects concurrently, assess priorities, and allocate resources.
• Exposure to Rubrik enterprise backup solutions
• Exposure to Microsoft SQL Server, Postgres or DB2 is a strong plus.
• Exposure to SAP Hana, AWS Redshift or MongoDB is strongly preferred.
• Oracle Cloud/Amazon AWS hands-on & experience in transitioning infrastructure into various global cloud hosting providers is a plus.
• Proficient in monitoring tools – Oracle OEM, SolarWinds & Nagios a plus