Vikhar Ahmed

Work History

Work History

Rac Dba

As RAC
DBA: ü Deploying a Flash Recovery Area in Oracle Real Application Clusters ü Archiving 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 ü Managing the Database Backups. ü Displaying Backup Reports for Your Oracle RAC Database. ü BackUp Voting Disks ü After installation ü After adding nodes to or deleting nodes from the cluster. ü After performing voting disk add or delete operations. ü Adding and Removing Voting Disks ü Adding an OCR Location, mirroring ü Repairing OCR Configuration on a local node, OCRcheck utility. ü See all the nodes resource status using crs_ stat-t ü Check the daemon status on RAC database. ü Check CSS, CRS & EVM health status. ü Viewing No. Of Nodes configured in Cluster-olsnodes-n-p-i ü Track of active instances-v$ active_ instances ü Check how connections are distributed across the nodes. Project 2: Oracle Application server 10g & 11g(Implementation) Application Server DBA: ü Install, configure and monitor Oracle Application Server 10g ü Install, configure and monitor Oracle Report Server ü Monitoring CPU and memory usage in application servers. ü Monitoring the report jobs running on report servers. ü Monitoring and resolving any issues in the components of Application server namely HTTP Server, Webcache, Report Server, OC4J instance etc. ü Troubleshooting Connectivity issues from Client PC's. ü Managing and maintaining Oracle application Server 10g. ü Assisting the developers in developing efficient SQL code to access and manipulate database objects. ü Scheduling and Monitoring Backup's. ü Staging Application Server for Development purposes. Project 3: Oracle 10g installation on HP-UX(Implementation) Involved in analysis, design, plan to use the storage options for the database. Like type of files, storage options, naming conventions & proper sizing. Given required HP-UX patches to HP team which are pre-requisites for Oracle RDBMS Creating users, roles and granted privileges Controlling and monitoring user access to the database(Using TOAD) Configuration of TCP/IP protocol, Listeners, SQLNET and Tnsnames. Maintaining archived data on multiple disk. Troubleshoot connectivity issues on Client Systems Scheduled backups for the Oracle Database. Interacted with
Dec 2015 - Present

GlobeMed

GlobeMed
Health Insurance company, Qatar 2 month
Dec 2015 - Present

Database Administrator

Al-Khaleej Computers & Electronic Systems
I am appointed as IT Database Administrator since under SEHA project. 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. SEHA PROJECT = Database Architecture Duties ü Planning for the database's future storage requirements ü Defining database availability and fault management architecture ü Defining and creating environments for development and new release installation ü Creating physical database storage structures after developers have designed an application ü Constructing the database by Designing logical and physical databases. ü Determining and setting the size and physical locations of datafiles ü Evaluating new hardware and software purchase ü Researching, testing, and recommending tools for Oracle development, modeling, database administration, and backup and recovery implementation, as well as planning for the future ü Providing database design and implementation ü Understanding and employing the optimal flexible architecture to ease administration, allow flexibility in managing I/O, and to increase the capability to scale the system Handling 5 production & DR databases Performing a Manual Failover Operation using DataGuard Broker STANDBY DATABASE CONFIGURATION FOR MANUAL SWITCHOVER Uploading files using sqlldr Monitoring tablespaces & checking the growth of TBS Recovered DR database Daily monitoring FRA, Planning the Size of the Flash Recovery Area Setting Up a Flash Recovery Area for RMAN Experience in KSA: COMPANY
Jul 2009 - Present

Lead Oracle Dba/oracle Application Server Administrator

SUMMARY
Lead Oracle DBA/Oracle Application Server Administrator: ALKHALEEJ is the company of choice for clients and the leading providers of best valued information technology solutions. Clients have included virtually every Saudi Arabian Government ministry and agency, universities in Saudi Arabia, Kuwait and the United Arab Emirates, as well as domestic and international private sector companies. Client I: Platform: Oracle Forms & Reports on Weblogic. Oracle 11g, 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. Project 1: Plan, Design & Implement Oracle Database 11g on RAC and Oracle Application Server 11g on Weblogic console
2008 - Present

Oracle Database Administrator

SUMMARY
Oracle Database Administrator ü 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,, Linux 5.5, Linux 6.2 ü Applying missing packages using rpm utility ü Installing, configuring, troubleshooting and maintaining Oracle databases. ü Set user privileges within the database environment. ü Providing database related technical support to application developers and network engineers. ü Creating users, roles and granted privileges ü Controlling and monitoring user access to the database(Using TOAD) ü Configuration of TCP/IP protocol, Listeners, SQLNET and Tnsnames. ü Ability to detect and troubleshoot database related CPU, memory, I/O, disk space and other resource contention. ü 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) Created(Active Dataguard) physical standby database as DR Solution for production database using RMAN“ duplicate target database for standby” command. Designed, develop & implemented the standby database/data guard strategy not only for failover but also for the backup purpose. Using RecoveryPoint to recover the database, solution provided by EMC Third party. Experience with the database from designing, developing, implementing and administering, which includes installations, support, troubleshooting, backup & recovery, testing, networking, monitoring & managing of users, performance tuning of applications and the databases Oracle 11g/10g/9i
Jul 2009 - Oct 2015

Sr Oracle Dba

Al-Khaleej Computers & Electronic Systems
Sr Oracle DBA at‘ ' 6 years
Oct 2008 - Jun 2009

Najm for Insurance Services

Najm for Insurance Services
Oracle n SQL DBA at‘ ', 9 months
Oct 2008 - Jun 2009

Sr. Database Administrator

Description: Worked as an Oracle 10g
Sr. Database Administrator(DBA)/Oracle Application Server Administrator DBA/Application Server Administrator at NAJM for insurance. Job Description: ü Install, configure and monitor Oracle Application Server 10g ü Install, configure and monitor Oracle Report Server ü Upgrade Opatch ü Patching the Application Servers, Report Servers. ü OC4J creation for application deployment. ü Deploy Java applications and troubleshoot application deployment issues. ü Report Server Tuning ü Creating service requests with Oracle support ü Monitoring CPU and memory usage in application servers. ü Monitoring the report jobs running on report servers. Achievements: ü Quickly learned Oracle Application Server 10g & Oracle Report Server ü Coordination with Onsite/Offshore team for issues.
Nov 2005 - Sep 2008

Oracle Dba

CELESTICA
Oracle DBA at on(Oracle 9i and Oracle 10g) 3 years
Nov 2005 - Sep 2008

Oracle Database Administrator

CELESTICA” EMS Hyderabad.
Oracle Database Administrator at“ CELESTICA Inc. is a multinational electronics manufacturing services(EMS) company headquartered in Toronto, Canada. CELESTICA operates a global manufacturing network with operations in Asia, Europe and the Americas, providing a broad range of integrated services and solutions to leading OEMs(original equipment manufacturers). Job Responsibilities: ü Installing Oracle 9i and 10g on Windows/Linux ü Installing, configuring, troubleshooting and maintaining Oracle databases. ü Set user privileges within the database environment. ü Providing database related technical support to application developers and network engineers. ü Provides ongoing production support of database systems. ü Troubleshooting and handling user requests. ü Creating users, roles and granted privileges according to the business requirements. ü Activities included allocation and maintenance of Undo segments, tablespaces, data files, redo log files, mirroring of redo log files across multiple disks. ü Controlling and monitoring user access to the database. ü Having excellent organizational skills ü Configuration of TCP/IP protocol, Listeners, SQLNET and Tnsnames. ü Planning and performing ONLINE(HOT BACKUP) as well as OFFLINE(COLD BACKUP) backup. ü Supporting developers in their day to day activities. ü Planning for backup and recovery of database information. ü Maintaining archived data on multiple disk. ü Database backup and restoration activities ü Proficient in DBA tool-Toad, Putty and OEM(Oracle Enterprise Management) ü Maintain tablespaces and setting the alert and critical alerts at OEM. ü Doing schema refresh and database refresh. ü Check the database uptime in days and hours. ü Takes weekly and monthly backup using Veritas. ü Installed Symantec Backup Exec 10D Windows server. ü SQL DBA Skills: Administering SQL Server Production Database. ü Backup and Restore. ü Monitoring SQL Server Jobs. ü Installing, Configuring database servers. ü Capacity planning and monitoring database growth. ü Managing SQL Server security and logins. ü Designing disaster recovery strategies. ü Dealing with performance issues on production servers. ü Moving objects from QA to Production databases. ü Indexing database and making sure required indexes are present on all objects.
Oct 2003 - Oct 2005

Oracle Dba

SRITECH SOLUTIONS
Oracle DBA at“ ” Hyderabad. 2 years
2001 - 2003

System Administrator

Aurora Universtiy
System Administrator at 2 years 14 YEARS Technical Skills: Servers HP: HP 9000 rp 7400, 7420, HP Storage Works, Blade servers BL20, HP Proliant DL 300, 00 TAPE-HP Storage works, DAT 40, DAT 72, MSL 5000 Series library. Operating Systems HP-UX, Linux, Windows 2000, 2003 & 2008 Storage Area Networks: Open View storage management, HP storage works HSV100, EMC Storage Oracle 12c/11g/10g/9i DBA, Oracle RAC, ASM, Data Guard, Performance Tuning, Upgrades, RMAN backups, Oracle AS11g, AS10g Forms & Reports Server on Weblogic Fusion Middleware, TOAD, OEM, Spotlight, SHELL SCRIPTING, Grid Control Key responsibilities: Oracle 11g RAC RDBMS software installation completed successfully on 2 NODE infrastructure. Implemented ASM 11gR2 Installation & Configuration using OS Role separation. Implemented Oracle 11g grid infrastructure installation successfully on Oracle Enterprise Linux. Designed and implemented Oracle Real Application Clusters(RAC) for an OLTP application with Transaction Application Failover. Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes. Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database. Experience with‘ graceful' switchover and switchback between primary and standby databases. Replicated to a disaster recovery site for increased server manageability and availability. Qatar experience

Education

Education
2001

B.Sc

College
1996 - 1998

MPC Teresa's Junior College Jyothi Bala Mandir HS