Oracle Database Administrator ( DBA)

Job Description

Responsibilities: Designing, implementing, and maintaining Oracle databases Ensuring database security, performance, and availability Performing database backups and recovery procedures Troubleshooting database issues and performance tuning Managing database schemas, users, and access Implementing and maintaining database security policies Monitoring database performance and capacity planning Working with developers to optimize SQL queries and database design Overseeing Oracle Cloud environments Ensuring optimal performance, security, and integration with existing systems Collaborating with various departments to support business objectives Implementing and managing Oracle Cloud solutions Troubleshooting cloud-related issues Managing cloud infrastructure and resources Providing remote technical and functional support to Oracle customers Troubleshooting and resolving technical and functional issues Responding to customer inquiries and requests Translating customer requirements into technical solutions Monitoring specific queues and ensuring timely resolution of issues Creating and maintaining documentation for database configurations, procedures, and troubleshooting steps Assisting with the design and development of database structures and applications Working with other IT professionals, such as developers and system administrators, to ensure smooth database operations Skills: Experienced in Oracle Installation, Upgrade and patching with setting up and configuring Oracle databases, including storage structures and user accounts Experienced in writing and executing SQL, PL/SQL Experienced in database performance tuning through various techniques like query optimization, index management, and resource allocation Experienced in developing and implementing backup and recovery strategies to ensure data integrity and availability using Oracle RMAN and SAP tools BRTools Experienced in database Migration with Oracle provided tools like XTTS, export/import and Goldengate Experienced in implementing and maintaining security policies to protect sensitive data, including user access control and data encryption Experience with Oracle RAC Experience with Oracle ASM and FS storage Experience with database DR with Data Guard, High Availability with Active Active PR/DR with observer nodes Experience with SAP specific Oracle tools like BRTOOLS (BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRSPACE, BRCONNECT) Experienced in identifying and resolving database-related issues, including performance problems, connectivity issues, and data inconsistencies Experienced in assessing any block level corruption at database files and mitigating it Experience with Oracle OEM implementation and support for managing, monitoring and alerting oracle infrastructure Experience in storage monitoring, management and projection management Experienced Oracle Cloud Infrastructure (OCI) Experience with Oracle PaaS and IaaS services Experienced in cloud security Knowledge of cloud-based architecture