PamTen
Sr Oracle Clou DBA
PamTen, Providence, Rhode Island, us, 02912
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 SQlsUser management of ERP Applications over OCI IntegrationSecurity 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 toolHigh 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 AdministratorHands-on experience with database standards and end user applicationsExcellent knowledge of data backup, recovery, security, integrity and SQLFamiliarity with database design, documentation and codingPrevious experience with DBA case tools (frontend/backend) and third party toolsFamiliarity with programming languages APIProblem solving skills and ability to think algorithmically.
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 SQlsUser management of ERP Applications over OCI IntegrationSecurity 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 toolHigh 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 AdministratorHands-on experience with database standards and end user applicationsExcellent knowledge of data backup, recovery, security, integrity and SQLFamiliarity with database design, documentation and codingPrevious experience with DBA case tools (frontend/backend) and third party toolsFamiliarity with programming languages APIProblem solving skills and ability to think algorithmically.