Oracle Consultant
First AbuDhabi Bank
Total years of experience :9 years, 10 Months
• Successfully completed 6 Dress Rehearsal as part of final cut over which includes 70 critical Databases of size ranging from 2TB to 23TB.
• Perform Oracle database performance analysis and optimization, define bottlenecks and manage Integration and Production implementation.
• Migrate Database from First Gulf Bank environment to NBAD environment and wise versa.
• BCP testing for all DR and HA solutions.
• Facilitate databases to Integration team for Application testing and developments for core banking applications like T24 & Murex
• Plan and provide solutions for Data migration from Integration environment to production.
• Identify and document Gaps and risk for final cut over from Integration to production.
• Patching for CRS, ASM and Oracle home including PSU.
• Replicate data using Golden gate on rac and non rac environment .
• Participate in design reviews for upcoming application enhancements.
• Provide on-call support in adherence to specific business and customer Service Level Agreements
• Defining database backup and recovery procedures
• Perform deep impact analysis of problems.
• Recommend solutions for High Availability and Disaster Recovery..
• Creating disk groups, adding disks and removing disks from disk group.
• Migrated databases from NON-ASM to ASM.
• Refresh and Clone Databases as per customer requirements.
• Managing partitions (deleting old partitions) in partitioned tables as regular storage management activity.
• Renaming RAC/non-RAC databases using NID utility as per application requirement.
• Installation and configuration of MS SQL databases.
• Deployment of MS SQL cluster and Always ON.
• Installation, Configuration, Maintenance of 11gR2 and 12c RAC
• Configure and setup Oracle Data Guard and manage standby databases.
• Hardening of databases
• Patching for CRS, ASM and Oracle home including PSU.
• Monitor database performance Automatic Workload Repository, Database Control, and Quest Tools.
• Participation in design reviews for upcoming application enhancements.
• Provide on-call support in adherence to specific business and customer Service Level Agreements
• Defining database backup and recovery procedures
• Worked on node eviction issues, Scan listener reallocation, and services management in RAC.
• Creating and managing ASM instance.
• Creating disk groups, adding disks and removing disks from disk group.
• Migrated databases from NON-ASM to ASM.
• Refresh and Clone Databases as per customer requirements.
• Managing partitions (deleting old partitions) in partitioned tables as regular storage management activity.
• Renaming RAC/non-RAC databases using NID utility as per application requirement.
• Monitor database jobs and logs.
• Create users and roles and grant appropriate privileges to users.
• Administer space by creating tablespaces, adding and resizing data files.
* Perform day-to-day database administration and ensure integrity, security, and availability of two node RAC databases with a size of 4TB.
* Defining database backup and recovery procedures
* Plan & size technology infrastructure requirements for the databases with capacity for optimum performance and scalability.
* Install, Upgrade, configure, migrate, apply patches and manage the oracle databases
* Manage High Availability solutions with Oracle 11g RAC & Data Guard.
* Provision the database user security
* Create database structures & objects as per the business requirements and ensure the integrity with the existing objects maintained.
* Deploy database changes into production environment with approved change management process strictly followed to ensure the integrity and availability are maintained.
* Monitor the database performance and co-ordinate with IT infrastructure team for any OS, backup requirements, hardware, network, storage issues/requirements
* Estimating sizing requirements for backup and storage as per the application and database growth and co-ordinate with the IT infrastructure team.
* Manage database scheduled tasks.
* Review logs pertaining to security issues, and create audit trails for the sensitive data objects and co-ordinate with the relevant stakeholders for any security issues.
* Support regular audit to maintain zero percent deficiency
* Disaster recovery planning
* Plan, design and implement oracle database security such as Transparent Data Encryption.
* Provide database performance information to CRIF to support in database objects troubleshooting & problem solving for the tickets raised by AECB for resolving the issues.
* Manage routine administrative task on sql server including backups, restores and DR setup.
• Administer multiple RAC instances with 6 to 8 nodes on Linux/Sun Solaris/AIX environment with size varying from 5TB to 25TB for infrastructure provisioning team.
• Responsible for both production and development Oracle instances.
• Installation, Configuration, Maintenance and upgrading Oracle R12 E- Business Suite application server and Database server.
• Applying the oracle application and database patch sets
• Application and database cloning using Rapid clone
• Setup and configure Oracle Workflow Notification Mailer
• Configure and setup Oracle Data Guard and manage standby databases.
• Implementation of RMAN as a backup solution to take the online backup of Oracle Databases.
• Well versed in performance tuning
• Handling all the Change Management Request (CMR) for production, development and QA databases to manage IT/DBA support.
• Worked on Installation/Configuring/Maintenance of Oracle Golden gate for replication, integration and transmission of data between different databases.
• Performed Golden Gate setup to achieve unidirectional replication.
• Space monitoring, alert log monitoring etc. using Fog light.
• Create new database user and managing database schemas.
• Proactively monitor database growth and space utilization.
• Apply patches as recommended by Oracle using BDA.
• Configure database monitoring using Fog light on new builds.
• Support sql server which includes scheduling backups, recovery, backup encryption, CDC Auditing and replication. Snapshot database creation for testing and reporting
• Installed and configured SQL Server clustering.
• Setup policy based management reports.
• Installation of oracle 10g and 11g
• Implement and administer Oracle Databases running on 10g/11g RAC/GRID.
• EBS Suite R12 installation & upgrade
• Cloning & Patching of r12 instances on UNIX & AIX platforms
• Concurrent Manager Administration and troubleshooting
• Worked on node eviction issues, Scan listener reallocation, and services management in RAC.
• Creating and managing ASM instance.
• Creating disk groups, adding disks and removing disks from disk group.
• Migrated databases from NON-ASM to ASM.
• Moving datafiles from one disk group/filesystem to another disk group.
• Configuring and managing physical standby databases, implemented set of 1 primary and 3 standby database of total 10 nodes.
• Recovered corrupted blocks in multi TB database.
• Database patching for CRS, ASM and Oracle home including PSU.
• Database refreshes using RMAN duplicate command & manually.
• Managing partitions (deleting old partitions) in partitioned tables as regular storage management activity.
• Renaming RAC/non-RAC databases using NID utility as per application requirement.
• Monitor database jobs and logs.
• Create users and roles and grant appropriate privileges to users.
• Administer space by creating tablespaces, adding and resizing data files.
• Identifying fragmented indexes and Rebuilding indexes.
• Preparing backup strategies. Perform logical and physical backups using export and RMAN backups, and failed backup troubleshooting.
• Develop shell scripts to automate database jobs and monitoring scripts.
• Monitoring database performance using AWR and ASH reports.
• Schema/database cloning using EXPDP/IMPDP utilities
• Sql server user creation, backup and recovery.
• Configured log shipping.
• Database health monitoring
• Installing oracle on different platforms as per user request & customizing according to the application.
• Troubleshooting oracle errors, managing users, table spaces
• Database upgradation and patching in different development environments.
• Database security management according to the application.
• Export and import as per the development team request
• Installing Linux and customizing according to the environment.
• Taking oracle backup and recovering if required, database data refresh.