ROSINE ESAMBE

• Installed, configured and maintained oracle databases on Linux and Solaris environment.
• Created Database as per requirements using DBCA and scripts.
• Startup and Shutdown of individual instance on RAC 2 node environments
• Implemented and supported three node RAC environments.
• Managed ASM disk groups and database control
• Worked on replication technologies such as Data guard.
• Setup jobs and events using Enterprise Manager (OEM) console.
• Implemented data guard (physical) for high availability/disaster recovery solution.
• Used Import/Export and SQL
• Loader utilities to move data and objects Configured and Tested Backups for Oracle Databases by restoration
• Write shell scripts and scheduled them in CRON for monitoring and health checks of database.
• Monitoring Database growth and space administration
• Frequent analysis of objects and schemas
• Experience in developing, maintaining and debugging procedures, packages and functions using SQL developer.
• Export & import at full, schema, and object level.
• Responsible for Online/Offline database backups and managing Database recovery with RMAN.
• Worked on backup and recovery strategies using RMAN.
• Performed database tape backups using NetBackup and RMAN
• Installed, configured and resolved issues on golden gate replication technology.
• Refreshing or cloning databases from production to development using RMAN and OS level scripts.
• 24X7 support for databases and production operations teams
• Add, adjust and manage tables space issues as needed for business continuity purposes.
• Created Database objects like Tables, Table spaces, Rollback Segments, Multiplexing Control files, Data files, Redo log files, Partition tables, Views, Indexes, Clusters, Synonyms, Materialized views.
• Audited
• Implemented scripts/tools to help rollout and manage Oracle in global distributed environment.
• Implemented disaster recovery plans to safeguard against unexpected events, minimizing potential losses.
• Ensured reliable data integrity by enforcing strict adherence to organizational policies during data management processes.
• Trained junior DBAs in best practices for Oracle database management, improving overall team performance.
• Provided technical support during application development processes to ensure seamless integration with existing databases.
• Reduced downtime by proactively monitoring system health and identifying potential problems before they escalated.

• Perform installation, configuration and of Oracle databases on Solaris, Linux, HP-UX and VMware
• Determined and implemented best practices for Oracle Setup, Installation, Configuration, Monitoring, Sizing, Capacity Planning, Backup and Recovery strategies
• Migrated and upgraded oracle database from 12c to 19c from Core to Azure
• Refreshing or cloning databases from production to development using RMAN and OS level scripts
• Created Database objects like Tables, Tablespaces, Rollback Segments, Multiplexing Control files, Data files, Redo log files, Partition tables, Views, Indexes, Clusters, Synonyms, Materialized views
• Audited, implemented scripts/tools to help rollout and manage Oracle in a global distributed environment
• Interacted with Functional & Technical experts, system administrators, security analysts and other members of the project team to ensure optimum operation of the database
• Setup jobs and events using Enterprise Manager(OEM) console, enrolled users and maintained system security by controlling and monitoring user access to the database
• Responsible for developing different databases at various stages of implementation of Projects (Databases for conversion of data, interfaces, training and development)
• Used Import/Export and SQL
• Loader utilities to move data and objects
• Monitored and maintained database growth and tablespace utilization
• Devised backup/recovery strategies and implemented it in line with Business requirements (RMAN)
• Configured and Tested Backups for Oracle Databases by restoration and recovery
• Involved in the performance tuning and query optimization
• Experience in Performance Tuning by using tools/utilities by Automated Workload Repository (AWR)
• Upgraded Oracle Database from 12c and 19c
• Code reviews of host and interface applications to ensure optimum database connections, resource usages, locks, query response times
• Designed and Implemented Oracle Disaster Recovery Solutions for customers
• Applied patches in production and test instances
• Managing Database (User management, Table space management, Performance related issues)
• Knowledge on basic architecture and functioning of Golden Gate technology
• Strong hands-on partitioning and performance tuning skills
• Assisting Developers in writing and tuning their queries

Monitoring and maintaining 2/3 node RAC database on Red Hat Linux, Providing support to development team and handling release schedules.

• Maintaining sound backup and recovery policies and procedures using RMAN as well as scheduled backup procedures for daily basis using cron and Autosys
• Use ASH, ADDM and AWR reports to monitor database performance and also do Database refresh using export /import and data pump
• Perform Database Tuning & Performance issues, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries
• Implement SQL outline to get better execution plan for offending queries.
• On Day-to-Day General Administration, I do Table space Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles
• Performed various tasks like Administering RAC using SRVCTL, adding nodes and instancing for High Availability purposes.
• Refreshed multiple databases for Development and Testing upon short request and served as part of 40-member DBA team which was involved in maintenance of Oracle 10g/11gdatabases for Production as well as development environments.
• Actively involved in designing/Testing of Disaster Crash recovery
• Improving performance of database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Work closely with customers on daily basis to understand their needs, support business change and deliver consistently high-quality customer experience.
• Support client customizations, sharing implementation and best practices advice.
• Provide hands-on assistance using proprietary tools in test environment, Or via remote client connectivity.