Oracle Database Administrator

Job Summary
A Database Administration professional responsible for managing, maintain, securing and optimizing oracle database environment to ensure database availability, performance, integrity and
reliability and reliability for enterprise applications.

Roles and Responsibilities
Install, configure, and upgrade Oracle databases (11g/12c/19c or as per requirement).
Install, configure, upgrade, and maintain SQL Server databases (2012/2014/2016/2017/2019/2022).
Install and configure MySQL, PostgreSQL databases.
Perform backup and recovery, restore operations and implement retention policies using SQL Server native tools / third-party tools.
Monitor and optimize system performance using indexes, execution plans, SQL Profiler, Extended Events, DMVs.
Perform routine database maintenance tasks such as monitoring, patching, and tuning.
Manage tablespaces, users, roles, and privileges.
Backup, Recovery & DR
Create and manage RMAN backup and recovery strategies.
Perform point-in-time recovery and database cloning.
Handle Data Guard setup, monitoring, and switchover/failover operations.

Qualifications:
Bachelor degree in Computer Science, IT or related field
Oracle certifications such as OCA/OCP

Skills and Experience:
• Strong communication and documentation skills.
• Ability to work independently and within a team.
• Troubleshooting mindset and attention to detail.
• Experience with Oracle Cloud (OCI), AWS RDS Oracle.
• Exposure to Goldengate.
• Familiarity with DevOps tools (Git, Jenkins, Ansible).
• Knowledge of other databases (MySQL, PostgreSQL) .
• Scripting T-SQL, PowerShell
• Cloud (preferred) Azure SQL, Managed Instance, SQL on Azure VM / AWS RDS SQL
• Tools SSMS, SQL Profiler, Azure Data Studio, Redgate tools, OEM/Monitoring