Sr Professional DBA || DMA Exadata At CCHI ( Council of Health Insurance )
Council of Health Insurance
Total years of experience :17 years, 7 Months
Expertise in different databases, such as Oracle Database, PostgreSQL, MS SQL & open to take challenge on other databases ( MongoDB || MySQL & so on )
Exadata Skills
• Good understanding of Exadata Architecture
• Clear understanding of Exadata features like Flash cache, Storage Index, HCC and IORM
• Solid exposure of Exadata hardware
• Understanding of Luns, Cell Disk and Grid disk
• Implementation experience of exadata features
• Understanding of CELLCLI and DCLI
• Performance tuning of Exadata component
• Troubleshooting experience
• Experience of database migration from non-Exadata to Exadata environment
Patching Skill
• Exadata bundle patching includes Storage cell, DB server, PDUs and network switches
• RDBMS and GRID patching experience
• Data guard administration and implementation
Monitoring Tool Skill
• Installation and configuration of OEM 13c
• Integration of OEM 13c with Exadata | ILOM
• Monitoring of Exadata using OEM 13c
• Understanding of ASR
• Experience of ASR implementation and configuration
• Administration experience of ASR
• Management of Exadata through ILOM
• Database Migration for various sites in Australia involves 5k+physical servers across Mount Valley & TM Datacenters
• Migration from legacy Pure & IBM SVC to new Power Max & IBM flash arrays
• Upgraded the Oracle database from 12c - 19c
• Migration of various databases to EC2 instance, RDS ( Oracle to PostgreSQL & Amazon Aurora)
• Relocation of database From Onenode & Twonode RAC in 15 node cluster.
• Hands on Experience in Adding, Dropping & Recreating Disks On Disk Groups
DXC Technology, Bangalore, India as ITO Database expert
Client : Deutsche Bank, Germany, Frankfort
Handling very complex project with more than 20 TB of database size.
Experience in DR Drill, Migrating 11g to 12c RAC databases
Writing scripts to push database RMAN backups to TSM tape library.
Installing Oracle 12c RAC R2 databases, setting & configuring client environment applications.
Experience in supporting 12 node RAC databases
Before implementation, pre documents are prepared & get approved from higher management.
Strong in performance tuning by setting memory tuning, SQL Tuning.
Configured DR for high availability, restore & recover database.
The National Health Insurance Company (NHIC) is a government-owned entity that manages and operates Seha; the national health insurance scheme in the State of Qatar.
NHIC PROJECT
==============
-- Handling 5 production & DR databases
-- Upgrade 10g RAC to 11gR2 RAC ASM
-- Monitoring tablespaces & checking the growth of TBS
-- Performing a manual fail-over operation.
-- Reinstating a Failed Primary Database
-- Daily monitoring FRA,
-- Planning the Size of the Flash Recovery Area
-- Setting Up a Flash Recovery Area for RMAN
-- Refreshing the QA, PRELIVE, DEV databases.
-- Uploading files using sqlldr
Client-I : Ministry of Social Affairs ( MOSA )
Platform : Oracle AS 11g as Middleware, Oracle 9i, 10g & 11g RAC database on HP-UX, OEL
SUMMARY: This Ministry is responsible for social insurance, social care and development. It has charities and co-operative societies, as well as social research, within its jurisdiction.
In keeping with the Kingdom's Islamic foundation, the Ministry is charged with ensuring that the less fortunate citizens of Saudi Arabia, the physically or mentally handicapped, the aged and the destitute, are cared for within a humane society. Throughout the Kingdom, facilities for the disabled and those needing rehabilitation have been established.
Project 1: Managing Oracle Database 11g on RAC and Oracle Application Server 11g on Weblogic (Managing & support)
As Sr. Database Administrator ( DBA ) - Responsibilities:
==============================================
Verify all instances are up.
Look for any new ALERT log entries ( telnet or any comparable program )
Verify free space in tablespaces.
Verify success of database backup ( Full EXP, EXPDP & RMAN )
Verify success of database archiving to tape.
Verify the database to have unique primary keys.
Verify the database which has disables primary keys.
Installing Oracle 10g, 11g on Windows 2003, 2008, Linux 5.5, Linux 6.2
Providing database related technical support to application developers and network engineers.
Controlling and monitoring user access to the database ( Using TOAD )
Maintaining archived data on multiple disk.
Increase the DB User quota.
Collect volumetric data - Nightly Procedures
All indexes should use INDEXES tablespace
Release dead locks on SCHEMA’s, Kill the user if not released the locks.
Supporting developers in their day to day activities.
Cloning the database for DEVELOPMENT, TESTING and TRAINING purpose.
Configured RMAN for Backup of production database & schedule to run at cronjob.
Configured shell scripts to take FULL exp of Oracle 9i & 10g DB
Configured cron job for taking FULL exp
Active Dataguard ( Standby DB )
===============================
1.Created (Active Dataguard) physical standby database as DR Solution for production database using RMAN “duplicate target database for standby” command.
2.Designed, develop & implemented the standby database/data guard strategy not only for failover but also for the backup purpose.
3.Using RecoveryPoint to recover the database, solution provided by EMC Third party.
5.Migrated existing Oracle Databases (8i, 9i, 10g) and Application Servers (Oracle OAS 9, Oracle AS10g, forms and reports) to Oracle 11gR2 and Redhat Linux 5.7.
6.Installed and configured clustered operating system, configured grid, setup rac instances
7.Setup Oracle 11gr2 Grid, Migrated all instances to RAC 11gr2 and ASM
8.Configured ASM disk groups to store Datafiles, redolog files, and control files
9.Installed and configured Grid Control to monitor RAC
BACKUP
=======
1.Plan, Implemented and documented the RMAN backup strategy for new and Existing RAC and Non RAC databases by configuring channels, allocating space for Backupsets, Implementing retention policy for backupsets, clean the archive log after 7 days of backup and write the shell script to automate the backup process by scheduling in crontab.
2.Recover/Cloned the database from ASM to ASM, ASM to File System, File System to ASM using RMAN duplicate command.
3.Extensive use of Data Pump expdp/impdp to clone/refresh Schema, database from Production to Test and Development Environment
As RAC DBA
===========
Deploying a Flash Recovery Area in Oracle Real Application Clusters
Performing Backups of Your Oracle RAC Database
Preparing to Restore and Recover Your Oracle RAC Database
Recovering an Oracle RAC Database
Repairing OCR Configuration on a local node, OCRcheck utility.
Check the daemon status on RAC database.
Check CSS, CRS & EVM health status.
1. Installing Oracle 9i and 10g on Windows/Linux/Unix
2. Installing, configuring, troubleshooting and maintaining Oracle databases.
3. Set user privileges within the database environment.
4. Providing database related technical support to application developers and network engineers.
5. Provides ongoing production support of database systems.
6. Troubleshooting and handling user requests.
7. Creating users, roles and granted privileges according to the business requirements.
8. Activities included allocation and maintenance of Undo segments, tablespaces, data files, redo log files, mirroring of redo log files across multiple disks.
9. Controlling and monitoring user access to the database.
10. Having excellent organizational skills
11. Installing and upgrading the Oracle server.
12. Allocating system storage and planning future storage requirements for the database system.
13. Monitoring the growth of tablespace and taking proper actions.
14. Applying patches and recently migrated from Oracle 10.2.0.2 to 10.2.0.4
15. Creating primary database, database storage structures ( table spaces ) after application developers have designed an application.
16. Creating primary objects ( tables, indexes ) once application developers have designed an application.
17. Maintaining system security.
18. Moving Data between Database using utilities like Export/Import.
19. Configuration of TCP/IP protocol, Listeners, SQLNET and Tnsnames.
20. Supporting developers in their day to day activities.
21. Planning for backup and recovery of database information.
22. Maintaining archived data on multiple disk.
23. Database backup and restoration activities
24. Proficient in DBA tool - Toad, Putty and OEM ( Oracle Enterprise Management )
25. Maintain tablespaces and setting the alert and critical alerts at OEM.
26. Doing schema refresh and database refresh.
27. Check the database uptime in days and hour.
PRIMARY RESPONSIBILITIES
Support LANs, WANs, network segments, Internet, and intranet systems.
Maintain system efficiency.
Ensure design of system allows all components to work properly together.
Troubleshoot problems reported by users.
Make recommendations for future upgrades.
Maintain network and system security.
Analyze and isolate issues.
Monitor networks to ensure security and availability to specific users.
Evaluate and modify system's performance.
Identify user needs.
Received Excellence award for topping the list in 1998-2001 academic year.