Job Information
PamTen, Inc. Sr Oracle Clou DBA in United States
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.