Manager Oracle

Mohammed Ansari

(***-***-

****)

PROFESSIONAL SUMMARY:

. Over 5 years of solid IT experience.

. Over 4 years of Oracle DBA experience which includes experience in

10g, 11g and RAC.

. OCA Certified on Oracle 10g, OCP Certified on Oracle 10g.

. Implementation and maintenance of Grid Control.

. Implementation and maintenance of RAC.

. Proficient in NT and all flavors of UNIX.

. Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of

database Administration.

. Performed backups, recoveries, installations, database performance

tuning, tuning applications, database monitoring and operating system

configurations.

. Proven experience in upgrading and migrating mission critical

databases both manually and with DBUA (8.x.x.x / 9.x.x.x / 10.2.0.1 /

10.2.0.3 / 10.2.0.4)

. Experience in data (hot and cold) backup and recovery procedures.

. Experience in schema management, tablespace, datafile and extent

management, as well as user and privilege management.

. Extensive experience with VLDB (Very Large Databases) with clear

understanding in large table partitioning.

. Experience monitoring Oracle RDBMS availability, database exports,

tablespace, and extents reports.

. Managing Database Structure, Storage Allocation, Table/Index/BLOB

segments, and Rollback segments, Constraints, Database Access, Roles

and Privileges.

. Comfortable with both command-line and GUI interface.

. Experience in managing BLOB segments

. Load balancing in RAC nodes using TAF

. Possess strong UNIX skills; light administration skills.

. Possess excellent written and oral communication skills.

. Configured and Implemented Physical Standby on 10g Databases (Data

Guard).

. Planning and scheduling Backups and taking Logical Backups (with

Export/Import).

. Tablespace point in time recovery TSPITR.

. Transportable Table Space (TTS) migration AIX to Linux

. Manage Backup and Recovery Program for all Oracle Databases. Install,

implement and configure RMAN. Oversee, improve and implement scripts,

processes, emergency procedures and testing of all RMAN operations.

. Regular practice of Disaster Recovery Scenerios.

. Work independently and as well working extremely well with other teams

and the customer on a daily basis

. Provided database technical consultation to other teams

. Effective communication skills with Project manager, account team, and

customer on technical issues and resolutions

. Implementing ASM file system and its maintenance

. Adding node to RAC environment.

. Deleting node(s) from RAC environment

. Troubleshoot network issues to connect to database.

. Troubleshoot performance issues by generating statspack report.

. Provided 24/7 support whenever on call.

. Dealt with Oracle by opening an SR or calling their customer support

whenever necessary.

. Written custom made scripts to send archivelogs to multiple locations

(before Dataguard came in picture)

. Restored databases on different hosts.

CERTIFICATIONS:

OCA (Oracle Certified Associate) version 10g

OCP (Oracle Certified Professional) version 10g

TECHNICAL SKILLS:

Languages SQL, PL/SQL

Script and Markup Unix bash shell programming,,

Languages

OS & Administration Sun Solaris, HPUX, Linux, VMWARE, AIX, Windows

Database Oracle 8i, 9i, 10g, 11g

Utilities [pic]

Concepts and Data Guard (Standby)

Administration

Real Application Cluster (RAC)

Automatic Storage Management (ASM)

Applications Peoplesoft, JdEdwards, Java, Lawson

PROFESSIONAL EXPERIENCE:

IBM Dubuque, IA

Feb' 10 - Present

Project Name: DBA Support

Project Description: Daily Database Administration Tasks.

Roles and Responsibilities: Daily activities of managing and

troubleshooting High Availability Real Application 4 node cluster. Tuning

SQL queries to improver overall cost of the query. Other responsibilities

include refreshing schema and tables from production to non-production

databases, patching up security and other application required patches.

Created and managed ASM disk and disk groups using bind raw devices and

ASMLib packages. Troubleshoot net connectivity issues.

. Installed 10g and 11g databases and Clients on RHEL platform.

. Upgraded CRS 10.2.0.1 to 10.2.0.4

. Configure ASM packages on Linux.

. Installed ASM disks.

. Manage ASM diskgroups via ASMCMD and database control.

. Managed 4 node RAC cluster.

. Troubleshoot RAC issues with olsnode, crs_stat, crs_register,

crs_unregister, crsctl check crs, crsctl check cssd, crsctl check

crsd, crsctl check evmd, crstctl stop, crsctl stop, srvctl nodeapps,

crsctl status, ocrconfig, etc.

. TTS migrated Sun Solaris to Linux on 10g

. Multiplex OCR and Voting Disk to different location for higher

availability.

. Add and delete node in RAC environment.

. Stop and start nodes via srvctl and manually.

. Reconfiguring Services via srvctl utility

. Working with Oracle to solve multiple RAC issues.

. Troubleshoot connectivity issues and solved listener configuration.

. Worked with Unix Administrators to create new two Node RAC cluster.

. Configure and installed Database Control.

. Managed Agents for Database Control monitoring tool.

. Troubleshoot OEM repository

. Update sysman passwords to troubleshoot OEM connection issues.

. Manage security and grants for database users.

. 9i to10g upgrade.

. Responsible for writing shell scripts to automate tasks.

. Responsible for managing daily full backups.

. Created scripts to transfer archivelogs to remote server for manual

Dataguard purpose for Standard Edition database.

. Use of Opatch for quarterly security patches and other patches for

database.

. User creation and giving proper grants and privileges.

. Created profiles from grants and privileges.

. Managed incremental and cumulative backups both from database control

and shell scripts.

. Export / Import using DataPump.

. Analysis of requirements for hardware/software upgrades

. Pre-Upgrade Planning, study and analysis of Applications and database

. Refreshing tables/schemas on a regular basis.

. Refreshed database from production to non-production.

. Upgraded 10g R1 to 10g R2.

Environment: Production and Non-Production on Linux/HPUX and NT.

FedEx Services Colorado Springs, Co

Feb '09 - Feb' 10

. Implemented 2 node RAC 10g on LINUX

. High Availability Features for RAC.

. Installed ASM disks

. Monitor, administrator ASM, RAC.

. Performed Database Administration using TOAD, Oracle Enterprise

Manager, SQL scripts and DB Artisan

. Performance Tuning of database, SQL tuning for Application

. Performance Tuning of Applications/Databases using various

Oracle tools like SQL trace, TKPROF, Explain Plan

. Physical and Logical database design.

. Database sizing, Capacity Planning.

. Analyze database objects.

. Managed database sizes up to 5 TB

. RMAN backup

. Refreshing tables/schemas on a regular basis.

. Refreshed database from production to non-production.

. Export / Import using DataPump.

. Analysis of requirements for hardware/software upgrades

. Planning capacity for Oracle Streams

. Troubleshoot OEM repository

. Update sysman passwords to troubleshoot OEM connection issues.

. Manage security and grants for database users.

. Responsible for writing shell scripts to automate tasks.

. Reconfiguring Services via srvctl utility

. Working with Oracle to solve multiple RAC issues.

. Troubleshoot connectivity issues and solved listener

configuration.

. Used TOAD for various database Administration tasks.

. Used SQL*Loader to move data from flat files into an Oracle

database.

. Worked as secondary on-call DBA

. 24/7/365 DBA support for 45-50 Oracle databases with users

located all over the world

. Installed, Migrated, configured and tested Oracle 10g databases

in various environments

. Erwin and Power Designer Modeling tool

Environment: SQL, SQL*Plus, 10g; Linux, HP UX, TOAD, OEM, GRID, DB

Artisan

Lake Michigan College, Michigan

Dec '08 - Feb '09

Oracle DBA Lead

Roles & Responsibilities:

. Evaluate current backups

. Re structure the database

. Configure and manage Data Guard on Linux

. Upgraded from 10.2.0.1 to 10.2.0.4

. Perform Backup and Recovery thru RMAN.

. Created multiple databases for Development and Testing.

. TTS migrated from Linux to HP-UX 10g

. Actively involved in designing/Testing of Disaster Crash recovery.

. Performed Database Administration using TOAD, Oracle Enterprise

Manager and SQL scripts.

. Performed database cloning/exp/imp to setup identical databases in

the production and development environments.

. Used DBV utility to verify backups

. Provided technical troubleshooting and give consultation to

development teams.

. Performed Database Refreshes and Database Copies for Development,

Test and Production databases.

. Involved in monitoring the lock processes, releasing locks in case of

resource blockage and gathering statistics.

. Used top utility for overall performance of server in Linux

Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, 10g; Linux, Windows

NT/2000, HP UX,TOAD, OEM

MERCY HEALTH SYSTEM, Missouri July

'07 - Dec '08

Oracle DBA Lead

Roles & Responsibilities:

. Implemented 2 node RAC 10g on AIX. Performed various tasks like

Administering RAC using SRVCTL, Adding nodes and instances,

Administering Storage Components, Parameter Management, Configuring

. High Availability Features for RAC.

. Installed ASM disks

. 24/7 support.

. Worked on DATA WAREHOUSE database 3.0TB.

. Upgrade 3.0 TB Data warehouse Database from 8K block size to 32K

block size to optimize performance in PROD.

. Worked on DATA WAREHOUSE and OLTP

. Upgraded from 10.2.0.1 to 10.2.0.4

. Created multiple databases for Development and Testing.

. Actively involved in designing/Testing of Disaster Crash recovery.

. Improving the performance of the database by tuning SQL and database

instance parameters using Automatic Database Diagnostic Monitor and

SQL Tuning Advisor in Oracle 10g.

. Performance Monitoring and Tuning of Oracle Application Servers using

Statspack, TKPROF, and OEM for tuning on 9i and on 10g using SQL

access manager, SQL tuning manager.

. Performed database cloning/exp/imp to setup identical databases in

the production and development environments.

. Created and maintain users, roles and privileges.

. Involved in discussions with the management regarding the

advantages/disadvantages and upgrade plans.

. Perform Backup and Recovery thru RMAN.

. Applied patch (opatch utility) in PROD and TEST and DEV.

environments

. Performed Export/Import through Data Pump.

. Used Grid Control for Monitoring 45+ database.

. Provided technical troubleshooting and give consultation to

development teams.

. Performed Database Refreshes and Database Copies for Development,

Test and Production databases.

. Involved in monitoring the lock processes, releasing locks in case of

resource blockage and gathering statistics.

. Used Oracle 10g, AWR & ADDM to monitor database activities and

performance tuning.

. Performed Database Administration using TOAD, Oracle Enterprise

Manager and SQL scripts and DB Artisan

. Unix Shell Scripting for ETL and CDW.

. Used NMON and TOPAS for performance and monitoring in all AIX

environment.

. Used nmon_analyzer tool to analyzes the captured performance data.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 8i, 9i, 10g; AIX, Linux,

Windows NT/2000, HP UX,TOAD, OEM,SQL Developer

Wells Fargo

Feb' 05 - July' 07

Project Name: DBA Support

Project Description: 24/7 DBA Support

Roles and Responsibilities: Responsible as an Oracle DBA for

installation, administration, tuning and recovery, of Oracle 8.x/9.x,

databases. Setup and monitored, Oracle backups using export/import,

cold/hot backups, Standby Database and RMAN. Extensive automated data

uploads, from multiple flat data files, using SQL*Loader. Provided Oracle

schema design, development and tuning support to the development team's

for Oracle backend programming on major network management. Creation of

Clone databases for high availability. Resolved connectivity issues on

Oracle, Client/Server. Extensive use of monitoring tools like STATSPACK,

UTILESTAT & UTILBSTAT, Oracle Enterprise Manager, Performance Monitor etc

for the performance tuning. Other responsibility includes:

. Responsible for administration and supporting Oracle database on Sun

Server.

. Installed, upgraded, migrated and configured Oracle 8i and 9i

database.

. Installed and configure Oracle 10.0.1 on Sun SPARC/Solaris 8 64 bit

server for development.

. Configure RAC environment for multiple sets of 4 database instances in

Oracle 9.2.0

. Successfully created Development/Test databases, create schema, users,

create database objects, security management etc.

. To upgrade Oracle 8.0.6 on Solaris8 - 32 bit server to Oracle 9.0.2 on

SPARC/Solaris 8 - 64 bit server

. To upgrade Oracle 8.0.6 on Solaris8 - 32 bit server to Oracle 10.0.1

on SPARC/Solaris 8 - 64 bit server

. Performed database tuning with StatsPack, Sqltrace, tkprof

. Set up and maintain automatic hot standby database for disaster

recovery (DR)

. Cloned Database and transfer data between Production and Development

database

. Estimated database capacity managed system disk space and system

resources.

. Implemented hot backups and recovery procedures using RMAN.

. Setup Oracle Enterprise Manager and STATSPACK to support monitoring

and performance diagnosing

. Created scripts to monitor database alert activities, growth, and key

performance indicators.

. Created scripts to automate and standardize various database

maintenance tasks.

. Provided guidance to developers on data design, query tuning and

security issues.

. Designed and implemented disaster recovery and backup/restoration

procedure using Shell scripts

. Unix shell scripting to exp/imp schemas

. Provided technical troubleshooting and give consultation to

development teams.

Environment: Oracle 8i/9i, Sun Solaris, Oracle Enterprise Manager,

Solaris, HP UNIX, PL/SQL, TOAD and SQL *Plus.

EDUCATION

DeVry University - CIS (In Progress)

SRVCTRL ASMCMD Import/Exp Data Pump AWR

ort

DBVERIFY SQL*Loade NETCA TKPROF TOAD

r

Contact this candidate