Sr Oracle Clou DBA

Responsibilities Database Administration : Administer and maintain Oracle ATP databases , including installation, configuration, user management, schema management, storage management, backup and recovery, and performance tuning. Backup and Recovery: Implement and maintain backup and recovery strategies to safeguard data against loss or corruption and perform regular backups and restores as needed. Database Upgrades and Patching: Plan and execute database upgrades and patching to keep systems up-to-date and secure, while minimizing downtime and disruptions. Monitoring and Performance Tuning : Monitor database performance , identify bottlenecks , and optimize system resources to ensure optimal performance and scalability. Ability to tune the performance bottleneck queries w .r.t ANSI-89 and ANSI 92 SQls User management of ERP Applications over OCI Integration Security Management : Implement and enforce security policies and procedures to protect sensitive data and ensure compliance with regulatory requirements. DB scaling management - knowledge on DB storage scaling. Oracle ATP DB monitoring via OCI performance tool High Availability and Disaster Recovery: Implement and maintain high availability and disaster recovery solutions, such as Oracle Data Guard, Oracle RAC, and standby databases. Capacity Planning and DB environment maintenance : Forecast future capacity requirements and plan database resources accordingly to support business growth and scalability. JIRA and Reporting: Maintain documentation, including system configurations, procedures, and best practices, and generate reports on database performance and health. Collaboration and Support : Collaborate with development, infrastructure, and support teams to troubleshoot issues, provide technical support, and ensure smooth operation of database systems. Requirements Strong analytical skills for business and technical requirement analysis. P&C Insurance knowledge is an added advantage. Proven working experience as a Database Administrator Hands-on experience with database standards and end user applications Excellent knowledge of data backup, recovery, security, integrity and SQL Familiarity with database design, documentation and coding Previous experience with DBA case tools (frontend/backend) and third party tools Familiarity with programming languages API Problem solving skills and ability to think algorithmically.

Created: 2024-11-05