Oracle Database Administrator

Mohd Sohail Sufiyan

****************@*****.*** Cell # 055*******

Career Objective

To seek a career that provides motivation, ambiance, upward mobility & exposure to innovative technology & to achieve a challenging position in the field of Information Technology.

Current Role: Oracle Database Administrator, Oracle Applications Database Administrator Responsibilities:

Installation, configuration and maintenance of EBS R12.1.1 & R12.2.0

Installation, configuration and maintenance of Oracle Database 12C, 11g.

Installed, configured and supported Solaris servers

Creating and Maintaining Zones in Solaris 10.

Installed, configured, maintained and troubleshoot zones on Sun Solaris

Managing and Installation Solaris S/W on Standalone & Servers

Maintaining Service Management Facility (SMF) in Solaris 10.

Performed operational tasks such as disk space cleanup, capacity planning and performance tuning.

Performed patching and upgrading of Solaris OS.

Performed troubleshooting and repairing of Servers.

Management of Users, Groups, File systems, Passwd Policies, File/Directory

To Patch Oracle EBS Application Tier, Fusion middleware components and Oracle Database.

To Clone EBS application tier and database tier and RAC environments.

To take hot, cold and RMAN backups of the complete environment that include Application servers, standalone databases and RAC databases.

To upgrade database from 11.1.0.7 to 11.2.0.4.

User Access Administration.

Applied latest releases of RDBMS Patches using OPatch Utility.

To monitor the complete environment frequently and to perform daily health checkup of DB and Apps.

To provide technical support to developers.

Applied Essential patches (AD.I .x, Rup2-Patch, Help-Patch, C.P.U-Patch).

Applying latest releases of the patches from Oracle to the instance to resolve few application issues.

Cloning the instances from production to Test, Development instance to test.

Cloning. (Refresh, Complete)

Concurrent Managers administration and troubleshooting

Monitoring and Troubleshooting Concurrent manager.

Performing Recompiling invalid objects, concurrent requests, Purging and archiving data, Stopping and restarting apache server, Gathering statistics.

Performed Sysadmin activities like Creating Users Assigning responsibilities, request groups, Defining Request Groups etc.

Compiling the fmbs and pll on different instances.

Provided 24x7 database support for Production database

Creating TARs and helping the functional with TARs.

Checking ALERT logs to know types of Bottlenecks recorded during the day if any, and raising to counter them.

Educational & Technical Qualifications

B.TECH Computer Science & Engineering from Jawaharlal Nehru Technical University, Hyderabad (A.P).

Oracle Certified Associate (OCA)

Oracle Certified Professional (OCP)

ITIL Foundation (Trained)

Certifications

Oracle 11g OCA certified DBA

Oracle 11g OCP certified DBA

Hardware Platforms worked

Worked Different Platforms:

Linux Red Hat

Solaris 9,10

Windows NT / 2003 systems

Software Systems & Applications worked.

Primary Skills : Oracle database 10g, 11g and R12/11i EBS Applications

ERP : Oracle E-business Suite R12 and 11i (Ver.11.5.9/11.5.10)

Database/Scripting : DBA-Oracle10g/11g, SQL

Tools: : Remedy Ticketing Tool

Operating Systems Platforms: Linux (RHEL 4/5, ),Solaris

Programming Languages : SQL,

Networks/Security : TCP/IP, DNS, DHCP, FTP

Backup/DR : Symantec NetBackup v 4.5/5.1/6.0, RMAN

Other Packages OEM, OAM,

TOAD, PUTTY, VPN .

Awareness : ITIL® Standards.

Experience Summary

Currently working as Oracle Apps DBA/DBA for Innovative Foods KSA from March 2014-Till Date

Worked as Database Administrator/Apps DBA for Ministry of SFD from January 2013-Feb 2014.

Innovative Foods KSA

Role : Oracle Core DBA

Responsibilities : Maintenance of Oracle 11g and 12C Databases

Oracle Software Installation and Configuring new database.

Managing and supporting Oracle 12C, 11g, 10g and databases as part of database team

Configuring and Maintaining RAC Environment

Tuning database for high availability, batter performance

Implementing and Configuring databases for Production, Development, Testing, Data Recovery and Support

Managing Tablespaces, Datafiles, Control files, Redo Log files

Creating users as per the ticket, allocating quotas, granting privileges and roles.

Tuning database to ensure high availability, performance and optimum utilization of hardware resources and batter performance

Monitoring database activities to ensure proper services available to clients, troubleshooting database related issues with minimum database downtime

Supporting developers and troubleshooting issues related to network and databases

Managing database by using Oracle Diagnostic tools OEM and Grid Control

Monitoring and Tuning Oracle database and System performance

Managing and Creating users, assigning roles and profiles, maintaining system security through monitoring user access to the database

Responsible for automating Backup & Recovery strategies using RMAN

Check database and listener are up and running.

Check the database backup is valid / Archive is valid.

Performed full backups, incremental backups using Scripts.

Experience with logical backups of the database using Data Pump (Expdp and Impdp)

Applied patches on database using OPATCH utility

Configuring and Managing Data Guard and Standby databases

Cloning database for Production, Development and Testing purpose

Cloning the databases using hot-backup, cold-backup and RMAN backup

Preparing and maintaining the environment management sheets of maintained servers with its environment ids, server names, configurations, owners, authorized owners, requestors, leased time periods and database credentials

Working closely with different IT teams and updating the customers on operations downtime/ support requests

Supporting database team out of hours, online, on-call work, and available 24/7 whenever required

Role : Oracle Apps DBA

Responsibilities : Maintenance of Oracle R12/11i Application

Installation of Oracle Applications R12 and Release 11i on Linux and windows platforms( Single & Multi node) installation

Upgrade from Release 11i oracle Applications System to Release 12 full and database upgrade on Linux

Cloning Oracle Application R12 and 11i Multi-single and Single-multi, online and offline(hot & cold)cloning

Patching Oracle Applications using ad patch, merge patch and Database patches

Concurrent Managers related issues by monitoring and handling concurrent requests

Configuring Workflow Mailer and bounced the workflow services whenever required.

Performing Recompiling invalid objects, concurrent requests, restarting apache server, Gathering statistics.

Code Migration through FNDLOAD Utility.

Worked with various Oracle Applications Utilities such AD Administration, AD Controller, Autoconfig, AD patch, AD ctrl etc.

Creating users, creating profile and Assigning responsibilities

Configure the Oracle Enterprise Manager using grid control to manage the databases.

Maintaining all Oracle E-business Application Standards and Principles, Contacting Metal ink and implementing best practice methods

Providing effective day-to-day support for on-going operations.

Effective planning the critical databases to align with business goals.

Working closely with different IT teams and updating the customers on operations downtime/ support requests

Supporting database team out of hours, online, on-call work, and available 24/7 whenever required

Personal Profile :

Nationality : Indian

Languages Known : English, Arabic, Urdu

Marital Status : Single

Present Address : Riyadh

Driving license : available (Saudi)

Visa category : Computer Technician

Contact this candidate