Atif Laik Ahmed Bhure

Mobile :-+919*********

Email :addasw@r.postjobfree.com

Skype id:-addasw@r.postjobfree.com

OBJECTIVES:

Seeking challenging role in IT sector as Oracle DBA in an organization which provides me avenues for a professional learning and makes good use of my skills and encourages individual growth. Looking forward to build career in Database (Oracle) where I would like to leverage my knowledge and deliver services at my level best in overseas preferably (middle-east). I would like to grow more as a part of excellent employer.

PROFESSIONAL STRENGTH & SKILLS Oracle Core DBA

Hands on experience in handling Oracle Database of its various versions 9i, 10g,11g, 12c,18c and having a good knowledge of their architecture.

Oracle database dictionary views and their usage.

User management (creation, deletion) of user managing user roles and permission, profiles.

Tablespace management capacity Monitoring.

Good knowledge in creation, maintenance & customization of oracle objects (tables, index, views, synonym, procedure, packages, trigger etc.)

Good knowledge in dealing with various Oracle network architecturelister.ora,sqlnet,tnsnames.ora.

Planning Backup/Restoration strategy-taking hot, cold or logical backups (datapump)along with RMAN.

Data Security, Flashback database, Backup & Recovery RMAN and disaster recover scenarios.

Performance Tuning (gather statistics, re-org table, tuning memory components, interpreting AWR, statspack& ADDM report,TKPROF,SQLTRACE, SQL Tuning, Memory tuning,SQL plan managementetc).

Implementation, administration, maintenance of disaster recovery sight for Oracle database. (DR,Standby,Dataguard).Its Failover/switchover of standby Administration.

Implementation, troubleshooting, administration, maintenance in Oracle RACenvironment (Real Application Cluster).

Having a good knowledge of handling instance in ASMenvironment (Automatic Storage Management).

Applying Oracle CPU,PSU,BUG patch in standalone and non-RAC environment. Patching activity on RAC/non-RAC environment.

Upgradation of Oracle database from (9i to 10g, 11g, 12c).

Implementing daily monitoring & reporting tool (cron) for table space errors, alert errors, listener down error, database down errors.

Troubleshooting Oracle database from ORA- error, raising SR with Oracle support.

Administrative command on various OS UNIX (linux,Solaris,aix,RHEL,HP-UX &windows).

Fully aware of ITIL standards (incident, problem & change management).

Highly proactive, independent, mature team member in respondingto enquiries fromstaff, administrators,service provider,site personnel andoutside vendors etc. to provide technical assistance and support extensive documentation and training experience.

ACADEMIC QUALIFICATION:

Passed Bachelor of Computer Science (B.Sc. -Computer Science) from University of Pune, India in the year 2009.

TECHNICAL TRAINING/ COURSE:

Completed extensive 3 months Technical course which cover, Oracle SQL Basics, Unix basics and database administration from Wilshire technology, Hyderabad, India.

Completed one and half month of training in Oracle RAC 11g release 2 from Hash zone, Hyderabad India.

Completed one and half month of training in Oracle apps DBA from Hash zone, Hyderabad

India.

TECHNICAL CERTIFICATIONS:

Oracle (OCA11g)

Oracle Certified Associate

Oracle (OCP11g)

Oracle Certified Professional

Oracle EBS 12.1

Oracle apps certified

TECHNICAL EXPERTISE:

Databases:

Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c

Operating System:

Windows Platform, Red Hat Enterprise Linux, Sun Solaris 8, HP Unix and IBM AIX

Oracle Tools/Utilities:

SQL *Plus, 10g OEM, RMAN, Putty, VNC, Oracle Agent’s client, DBMS Scheduler, Statspack, AWR, ADDM, SQL Tuning Advisor and Datapump, Physical standby, Database cloning, Database upgrade, RDA,DB Verify, Tkprof,ASM.VERITASnetbackup

Ticketing Tools:

USD,servicenow,remedy

WORK EXPERIENCE:

A)National Cables Industry

Job Role :Senior Oracle Database Administrator

Duration :17thNov 2015 -Present

Job Responsibilities: Senior Oracle DBA

National cables industry is the manufacturing company based in United Arab Emirates which mainly deals with cables and is a group of company of Riyadh Cables. Here I am working as a lead in Oracle DBA maintaining and managing production environment in production and UAT environment.

Performance Tuning (gather statistics, re-org table, tuning memory Components, interpreting AWR, statspack& ADDM report, SQL Tuning, tkprof).

Implementing daily monitoring & reporting tool for table space errors, alert errors, listener down error, database down errors.

Implementing daily maintenance scripts such as dump location maintenance, alert log and listener log purging.

Creating Oracle Service Request with Metalink for ORA-600/7445 error and other Generic issues.

Managing access to user along with their security and profiles.

Refreshing UAT, test database from prod database periodically.

Performing various health checks on database periodically.

Scheduling managing RMAN (INCR 0,INCR1,Archive) with frequency weekly, monthly, daily, yearly,EXPDP backups and dealing with their errors.

Performing various health checks on database periodically.

Performing various backup validity check periodically and disaster recovery critical situation.

Performing various type of capacity management on databases and monitoring their growth.

Managing and maintaining standby database daily monitoring and resolving their lag issue.

Resolving daily basis user problems and providing SLA based support to customer.

Worked with backup tools (VERITAS netbackup) dealing its policy creation and monitoring the backups.

Fixing Backup issues by Cleaning Old backups and reinitiating backups.

Coordinating with other teams like testing / Developers for fixing up issues.

Involved in setting up Development ASM Databases.

Creation of disk groups and add a disk to disk groups in ASM instances.

Monitor the databases using OEM HTML reports.

Supporting Production and Development databases in 24x7 Environments.

Configuring Dataguard, rebuilding dataguard using RMAN, Verifying sync between Primary and Standby databases. Creating Duplicate Databases for Development.

B)TATA CONSULTANCY SERVICES

Job Role :Senior Oracle Database Administrator

Duration :6thOct 2014–18thJuly 2015

Job Responsibilities: Senior Oracle DBA

Supporting current production Infrastructure based on Oracle database environment. The project which we support is related to online retail shop name BESTBUY for Canada and United States region. Where customer by their related item online and get it delivered to their addresses.

Creating Oracle Service Request with Metalink for ORA-600/7445 error and other Generic issues.

Tuning Indexes by rebuilding and finding unused indexes dropping.

Scheduling and customizing various cron jobs on server related to monitoring, maintenance.

Performance Tuning (gather statistics, re-org table, tuning memory components, interpreting AWR, statspack& ADDM report, TKPROF.

Applying CPU,PSU,BUGoracle database Patch on standalone and RAC environment on quarterly basis on test,UAT& prod environment.

Troubleshooting various issue in RAC environment.

Managing and maintaining standby database daily monitoring and resolving their lag issue.

Managing RMAN,EXPDP backups and dealing with their errors.

Dealing with various disaster recovery scenarios.

Performing various health checks on more than 100 databases periodically.

Administrating and monitoring Oracle databases with using OEM.

Managing and maintaining standby database daily monitoring and resolving their lag issue.

Configuring Dataguard, rebuilding dataguard using RMAN, Verifying sync between Primary and Standby databases. Creating Duplicate Databases for Development.

Resolving daily basis user problems and providing SLA based support to customer.

Coordinating with the other team (backup,Unix,storage,application) during major outages.

Working on RFC (Request for Change), Problem management, and incident management.

C) Company Name :- KPIT CUMMINS

Job Designation : Senior Oracle Associate Engineer

Duration : 21stOct-2013 – 28thMarch 2014

Job Responsibilities: Senior Oracle DBA

Supporting current production Infrastructure based on Oracle database environment. We were supporting prod/UAT/test databases remotely for United States for one of the top leading company in manufacturing spare parts of auto mobile engine name CUMMINS.

Daily handling queries of application team/customer regarding slowness in performance in Oracle database.

Collecting and generating hourly stats by AWR Report whenever there are performance issues.

Performance Tuning by using Explain and Tkprof utility

Creating Oracle Service Request with Metalink for ORA-600/7445 error and other Generic issues.

Tuning Indexes by rebuilding and finding unused indexes dropping.

Giving all the necessary suggestion to the user which will improvise the performance of production database.

Implementing daily monitoring & reporting tool for table space errors, alert errors, listener down error, database down errors

Detecting fragmentation on database objects and performing re-org on table and also on database.

Monitoring Filesystem usage, CPU Utilization, Tablespace growth and creating room in the Filesystem by also giving recommendation to additional space.

Supporting Production and Development databases in 24x7 Environments.

Cross-platform migration of databases(eg-HP-UX to IBM-AIX).

Working on RFC (Request for Change), Problem management, incident management.

D)Company Name :-AtoS

Job Role :Junior Oracle Database Administrator

Duration :10thMay-2010–27thSeptember 2013

Job Responsibilities :Oracle Associate Engineer

Supporting current production Infrastructure based on a Oracle database environment.Our customer where spanned acrossNorth America(Federal Home loan bank,Bakers Hugs,Bristol,First Group America,Stanley,Schlumberger,Stanley works). ForUK (National Farmers Union Mutual, Arriva Trains Wales, RSP LENNON,RLA,PSE, USD, Electro components, Rail application)

CreatingUsersandgrantingPermissions,Passwordresetting,UnlockingUsers,Managing roles.

Installation of oracle 11g and 10g,9i on Unix windows.

Refresh of main production database for Testing and developers purpose.

Purging of data monthly basis using TTS backup and Export backup.

Testing backups of production databases and refreshing UAT databases form production databases backups.

Resolving daily basis user problems and providing SLA based support to customer.

Monitoring regular issues of more than 100 databases.

Experienced in the Up gradation of Database in patchset Level (9.2.0.x and 10.2.0.x) and also in version Level (9i to 10g) (10g.to 11g).

MonitoringFilesystemusage,CPUUtilization,TablespacegrowthandcreatingroomintheFilesystem by also giving recommendation to additional space.

Fixing Backup issues by Cleaning Old backups and reinitiating backups.

Managing Archive log backups and Full Back up by RMAN. Freeing up Obsolete backups.

Moving or backing up old archives with RMAN, if File system is filled.

Coordinating with other teams like testing / Developers for fixing up issues.

Data Refresh using Advance 11g Datapump with greater Performance.

Supporting Production and Development databases in 24x7 Environments.

Involved in setting up Development ASM Databases.

Configuring Dataguard, rebuilding dataguard using RMAN, Verifying sync between Primary and Standby databases. Creating Duplicate Databases for Development.

Working on RFC (Request for Change), Problem management, incident management.

Implementing daily monitoring & reporting tool for table space errors, alert errors, listener down error, database down errors.

Implementing daily maintenance scripts such as dump location maintenance, alert log and listener log purging.

PERSONAL INFORMATION:

Date of Birth :

8th Nov, 1987

Nationality :

Indian

Gender :

Male

Language :

English, Hindi & Marathi.

Marital status :

Married

Contact this candidate