Oracle Sql Server

Adeel Ahmed Syed

Mobile: +971-*********

Email : *****.***@*****.***

P.O Box 267, Abu Dhabi

United Arab Emirates

CAREER OBJECTIVE

To contribute to the growth of my employer using the skill set that I have acquired during my 7+ years of

experience in IT industry and in return benefit from the growth process.

SUMMARY

• With 7+ years of IT experience as an Oracle & SQL Database Administrator, managing production

databases and provide support to the development team.

• Hold Hands on Experience with the database from designing,, implementing and administering it

which includes installations, support, troubleshooting, backup & restorations, monitoring &

managing users/privileges, tuning the performance of databases on 11g / 10g / 9i databases; SQL

Server 2005/ 2008/ 2008R2 databases.

• Supported and maintained large production database. Well familiar with High Availability Oracle

Real Application Cluster and Data Guard.

• Experience in creating new setups for testing and development, migration of the database and

applications from the across different platforms.

• Database Tuning by collecting statistics, generating explain plans for long running queries,

analyzing table and index segments to improve query performance.

• Strong Technical background, excellent analytical ability, good communication skills, team player

with a commitment towards excellence.

WORK EXPERIENCE AS ORACLE & SQL DBA

Jan 2007 – Till Date www.omeir.com

Omeir Bin Yousef Group, Abu Dhabi www.peugeotabudhabi.ae

Database Administrator

• Installed Oracle 11g and 10g databases and Grid Infrastructure on Solaris and Linux platforms

(Install Oracle Solaris 10 O/S on HP DL380G7 Intel based x86 64 bit Server) & created customized

databases. Upgraded and migrated database across different version and platforms.

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes

but is not limited to ensuring successful backups, resolving system issues, opening cases with

technical support to resolve issues, monitoring success and failure of automated jobs, monitor

system availability, updating system documentation, system and database recovery, etc.

Review and applying the latest security & database patch for Oracle & SQL databases.

•

• Creating primary database storage structure, database objects like tables, indexes, views as and

when required. Managing database users, roles and privileges of all the DBs.

• Experience in creating and administering Oracle Data Guard, Setting up of different data protection

modes. Configuring redo transport services, log apply services & Managing archive log gaps

• Experience in creating catalog for multiple target databases, implementing backup strategy.

Experience in Backups, Restore and Recovery operations using cold, hot and RMAN Utility.

• Experience in taking logical export, migrating databases using Data pump utility. Also removing

the table fragmentation.

• Monitoring the DB health, AWR reports, analyzing indexes. Daily Backup check, Database status

check, Mount point status check

• Using OEM to monitor & manage instance activity, user information and estimation of the space

requirement and volume growth of the database.

• Monitor memory, CPU utilization, disk utilization (I/O activity), contentions, runtime of queries,

etc.

• Monitoring space usage and capacity planning for Oracle & SQL databases.

• Scheduled backups using UNIX cron jobs to perform Full and Daily Incremental levels backups

through RMAN.

• Using DBMS packages for gathering table and index statistics, Fine Grain Auditing.

• Managing & Creating MIS Reports in Qlikview BI Application

TECHNICAL SKILLS

Hardware : SUN SPARC V890, HP9000, HP DL380, HP DL160 SGI

Origin 2000 PC's

Operating system : RHEL, OEL, Oracle Solaris, SUN Solaris, 9,10, IRIX, Windows Server

2003/2008/2012, Windows XP/2000/NT/98/95

Databases and Middle tier : Oracle 11g/10g/9i/8i/ 8.x/ 7.x Oracle 10g AS. SQL Server 2005/

2008/ 2008R2

High Availability : 11g RAC, Data Guard. GoldenGate 11g

Virtualizations : VMWare Esxi 5.1, HYPER V,system center 2012

Tools : RMAN, Data Guard, SQL*Plus, SQL Navigator, OEM, ftp, Putty,

WinScp, FileZilla, Datapump. SQL Developer,

Other Business applicatinos : QLIKVIEW BI Solutions, NETSUITE

EDUCATION

Master in Computer Application (MCA) completed in 2006, India

Bachelor in Computer Science ( BSc Computers) completed in 2002, India

CERTIFICATION & TRAINING

Oracle 10g Certified Professional – OCP

Oracle RAC Administration 11g, SQL Star, Hyderabad

Oracle GoldenGate 11g Workshop, PreciseTrace, Abu Dhabi

SUMMARY

Date of Birth 06th Oct, 1981

Nationality Indian

Visa Status Valid UAE Residence Visa

US Visa Holding US Visa for 10 years valid till November 2021

Contact this candidate