Responsibilities

• Oracle DBA 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.