Overview
Hybrid
$60 - $70
Contract - W2
50% Travel
Skills
ATP database
OCI
Job Details
Job Title : Oracle Cloud DBA
Duration : Long term
Location : RI Hybrid
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.