Oracle DBA

WAHEED REHMAN

*** ******* **, ******* **- *****

C: 404-***-****

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

Oracle Database Administrator

PROFESSIONAL SUMMARY

 Over 6 years of IT experience in Oracle Database/Data Warehouse Administration and providing Enterprise level production and development support.

 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/8x as well; using SQL, PL/SQL, SQL*Plus, ORACLE RAC (Real Application Cluster), Standby (Data Guard) Database, Oracle Utilities, Oracle Enterprise Manager & Oracle Management Server on Unix & Windows platforms. Supported and maintained large 24x7 production databases.

 Extensive experience in designing Logical and Physical data models for new developments using ERwin modeler.

 Experience implementing 10g RAC (using raw devices, ASM) for test environment.

 Extensive experience in supporting multiple production databases running 24 x 7 mission-critical OLAP/OLTP applications demanding high availability and increased performance.

 Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance.

 Strong Technical background, excellent analytical ability, good communication skills, team player and highly professional, with a commitment towards excellence.

TECHNICAL SKILLS

Databases: Oracle 8x/9i/10g RAC, 11g, MS Access, MS SQL Server

Operating Systems: Red Hat Linux, Sun Solaris, IBM AIX, HP UX, Win NT / 2000 / XP

Languages: SQL, PL-SQL, Shell scripting (ksh, csh), Perl, Visual Basic 6, HTML

IDE/Tools: OEM, DBArtisan, TOAD, Spotlight, DBVerify, LogMiner, SQL Loader, STATSPACK, tkprof, Explain Plan, SQL Trace, Oracle Discoverer, Oracle Designer 2000, Oracle Partitioning,Oracle Parallel Server, OWB, Informatica

Designing tools: Erwin, MS Visio, Oracle Designer, PowerDesigner

Hardware: Dell RAC, EMC Storage, Netapp filer. HP-9000 series, Sun Sparc/Fire V440, T2000, IBM Risc-6000, Intel Itanium Processor 9000 sequence.

Backup Tools: BMC SQL-Backtrack, Veritas Net backup, RMAN, Data Pump (Import/Export)

EDUCATION AND TRAINING

 MCS (Master of Computer Science)

 BCS (Bachelor of Computer Science)

• Six months diploma in Oracle Database Administration

• Six months diploma in Oracle developer 2000

PROFESSIONAL EXPERIENCE

Wells Fargo Bank, Des Moines, IA June 2008 - Dec 2009

Oracle Database Analyst/Admin

Provided streams replication solution for CORE Data Project replacing Wells Fargo existing shareplex environment. Built about 40 RAC Oracle Servers including 6 RAC on AIX, Linux environment and supported OLTP and ODS environment as well.

Responsibilities

• Installed and configure oracle 10g, 11g databases on Linux, AIX and Solaris based servers and applied the 10.2.0.4 and 11.1.0.7 patch set respectively on Test and Production environment, also applied Quarterly Patches and supported prod and Non Prod Databases.

• Upgrade existing 9.2.0.8, 10.1.0.5 databases to latest 10.2.0.4

• Performed SAN requirement analysis and configuration for the new RAC databases (Linux RHEL) to be built on IBM blade servers, Design and configure SAN, raw partition for OCR, Voting Disk, Oracle Home, ASM HOME and CRS HOME.

• Installed and implemented 2, 3 nodes cluster for Test and Production environment.

• Configured ASM disk groups to store Datafiles, redolog files, and control files.

• ASM Management using RAC utilities like SRVCTL, OCRCHECK, OCRDUMP and CRSCTL.

• Back up of voting disk and OCR using DD command and OCRDUMP.

• Installed and configured Grid Control to monitor RAC and Non RAC instances, patched and upgraded the Grid Control to 10.2.0.4

• Installed Management agent (10.2.0.4) on database servers to discover them in Grid control.

• Point the agents to new grid control by editing url in emd.properties

• Setup the Streams Replication at schema level to capture, propagate and apply the DML, DDL changes to the replicated database. 1 millions rows inserted at source were replicated at destination in 10 mins.

• Used the Grid Control to monitor and manage Streams Replication which includes the availability of queue for queuing messages, Number of messages received by destination queue, messages spilled by destination queue and time it took to dequeue the messages. Put the Apply queue in order if it was broken by instantiating the Objects and removing the errors from the queue.

• Used DATA PUMP/export import to instantiate SCN to avoid conflict at destination, created different rule sets to propagate and apply process.

• Purge the data queue by using DBMS_packages available before re-sync the streams.

• Design schemas (Star, Snowflake) for dev and test databases using ErWin.

• Creating the partitioned table using Range, hash, list partitioning.

• Creating and rebuilding partitioned bitmap indexes on the columns of fact tables to enhance the query performance and fast response.

• Translated business requirements into data mart design.

 Used Star Schema approach for designing of Data Warehouse

 Designed and maintained logical and physical enterprise data warehouse schemas using ERWin.

 Creating the partitioned table using Range, hash, list partitioning and indexing them.

• Created (Dataguard) physical standby database as DR Solution for production database using RMAN create standby database command, also setup Data Guard Broker to manage data guard environment.

• Plan, Implemented and documented the RMAN backup strategy for new and Existing RAC and Non RAC databases by configuring channels, allocating space for Bakupsets, Implementing retention policy for backupsets, clean the archive log after backup and write the shell script to automate the backup process by scheduling in crontab.

• Provide and implemented RMAN backup strategy with retention policy of 35 days to keep the latest 2 days backupsets on disk and move rest of the backupsets to tape. Configured RMAN for above scenario, write shell script and set a cron job to automate the backup process nightly bases for ASM environment.

• Performed the RMAN complete recovery, tablespace recovery, datafile recovery, controlfile recovery, online redo log file recovery.

• Recover/Cloned the database from ASM to ASM, ASM to File System, File System to ASM using RMAN duplicate command.

• Extensive use of Data Pump expdp/impdp to clone/refresh Schema, database from Production to Test and Development Environment.

• Cloned databases using cold backup, by re-creating controlfile, using RMAN duplicate command, putting the database in backup mode in case of production environment.

• Moved columns containing Lob Objects to a new tablespace to improve the Database performance, rebuild indexes after table or column move.

• Extensive use of AWR to generate database statistics, ADDM to find the performance issues and get recommended solution to improve the performance.

• Install the Oracle 10gR2 in silent mode, Upgrade the database to 10.2.0.4 in silent mode using response files, Created listener using NETCA, Created the database in silent mode by Passing Parameter to DBCA.

• Enable the SQL tracing at session level by setting the SQL_TRACE parameter to true.

• Rename the database, and its ID using DBNEWID (nid) feature.

Environment: Oracle 10g RAC, 11gR1,R2, Streams Replication, Data Guard, RMAN, Data Pump, Shell Scripting, Linux Enterprise 5.3, AIX, SAN, IBM Blade Server, Grid Control, TOAD

Lycoming Textron, Williamsport PA (Short Term Project) Mar-08 – May-08

Oracle Database Analyst/Admin

Assisted team of DBAs in Upgrading Oracle Database from 8i, 9i to 10.2.0.3 to meet their project deadlines and upgraded about 20 oracle databases.

 Provide Assistance in compiling invalid objects after upgrade, setting new Oracle Home, configuring listener Services in new 10.2.0.3 Oracle Home, Removed Obsolete Parameters from old 7.3.4 Database.

 Installed and configure the two nodes RAC Using ASM in Windows Server 2003 Environment. Created Raw Partitions for ASM Instance using ASMTOOLG utility.

 Installing Cluster ware (Voting Disk, OCR) on a separate partition using OUI.

 Used RMAN to Migrate the Non-ASM Database to ASM Database.

 Installation of Oracle database 10g with RAC using OUI.

Environment: Oracle 9i/10g RAC, Oracle Apps 11i, 10.7, RMAN, EXP/IMP, Shell Scripting, Windows Server 2003, UNIX, SAN.

Arizona Public Service (APS), Phoenix, AZ Oct 07 – Feb 08

Oracle Data Warehouse DBA/Analyst

Supported the Data Services group for their Dev, Test and Production environment as well as upgraded about 60+ Production and non Production Databases.

Responsibilities:

 Plan, design, test and implement upgrades for the Databases (from 9.2.0.6, 10.1.0.4 to 10.2.0.3) and applied quarterly security patches. Upgraded 60 databases to 10.2.0.3

 Works closely with the development staff on all issues related to the Oracle Databases.

 Responsible for 24*7 production support on a rotation basis for all oracle databases.

 Extensive work experience on oracle 10g RAC, on Linux/AIX environment.

 CRS_STAT to collect statistics of nodes and services running on Clustered Database.

 Used the SRVCTL utility to manage, start and stop Oracle Database and services.

 Extensive use of export and import to refresh data in fact table of Data Warehouse and OLTP Databases.

 Databases refresh using RMAN duplicate database command from production to development and testing.

 Heavy data load using direct load insert technique.

 Creating the partitioned table using Range, hash, list partitioning.

 Creating and rebuilding partitioned bitmap indexes on the columns of fact tables to enhance the query performance and fast response.

 Analyzing slow-running SQL queries and generating statistics using the Execution Plan and recommending solutions for faster execution.

 Use of ADDM to diagnose the problems and recommendations.

 Oracle performance Monitoring using the OEM grid control and DBArtisan.

 Strong skills in performance tuning with STATSPACK/AWR for database objects and components, Shared pool, Buffer cache, Redo logs, disk utilization and Sort operation, SQL tuning and use of Oracle Expert, SQL Trace with tkprof, Explain Plan, Analyze and dbms_stats.

 Installed and configured OEM agent to discover the nodes in the grid control.

 Installation of Oracle Clients, Databases on various OS as required.

 Used DBArtisan to perform schema compares between environments, generate missing ddl and sync different environments, especially before and after production releases.

Environment: Oracle 9i/10g RAC, Sun Solaris, AIX, HP-UX, RMAN, Shell Scripting, BMC SQL-Backtrack, HP Open View Service Desk, OEM Grid Control, DBArtisan, ETL Support, table and Index Partitioning.

Verizon Business/MCI, Alpharetta, GA Nov 06 – Sep 07

Oracle Database Architect/Analyst

Worked with team of DBAs to meet their project deadlines to make their 9i/10g databases DST (Day light saving) compliant as DST was extend by one hour by US Govt. Applied DST patches on 200 plus databases in dev, test and production environment and Installed JDK, Java/JVM and Xdb packages make them DST compliant.

Responsibilities:

 Experience working in a large enterprise environment supporting 50 databases as primary DBA and 150 plus production databases while on call.

 Managing and Administrating oracle 9i/10g RAC databases in UNIX Environment (AIX, Solaris, Linux, HP-UX).

 Built oracle databases in non RAC and RAC environment using oracle cluster ware, ASM.

 Used the SRVCTL utility to manage, start, stop Oracle Database and services.

 CRS_STAT to collect statistics of nodes and services running on Clustered Database.

 Performed the schema migration from dev into test and UAT environment.

 Recovered and restore the instance, tablespaces, codes, stored procedure from a serious database crash.

 Managed user accounts and ensured security of databases using roles and privileges.

 Upgrading OEM repository and Installing OEM 10Grid Control to monitor all the databases

 Lead coordinator between technical operations team (DBA) and applications users.

 Setting up privileges to create local and remote objects

 Create refresh groups and assign materialized views to refresh data at regular intervals.

 Designing, installing and maintaining complex functions of major database systems including access, allocations, validity checks, security, documentation and tuning

 Upgraded/Migrated from Oracle 8i, 9i to 10g.

 Cloning/refreshing production databases to test/ development environments using RMAN scripts.

 Writing shell scripts to automate RMAN, hot and cold backups.

 Configuring & maintaining OMS/Repository/Intelligent Agents in three-tier architecture

 Installing/configuring and analyzing Statspack on all production servers.

 Scheduling Statspack through DBMS_JOB to collect snapshots at regular intervals to generate daily reports to analyze and fine tune performance overheads.

 Analyze and monitor wait events on production databases to implement improvements for buffer busy waits/sequential & scattered read contentions.

 Timely monitoring of key tables to collect statistics on row-chaining/migration and implement methods to avoid redundancy thus eliminating performance bottle-necks.

 Analyzing slow-running SQL queries and generating statistics using the Execution Plan and recommending solutions for faster execution.

 Tune the SGA components like buffer cache, shared pool to avoid paging & swapping hence reducing I/O bottle-necks in 9i, 10g environment.

 Reviewing and resizing redo logs (wherever possible) to reduce the redo log space requests and ensuring multiplexing/mirroring of members.

 Reviewing and resizing conspicuously over allocated tablespaces (wherever possible) thus improving the time-frame for cold backups.

Environment: Supported 50 Oracle 8i/9i/10g RAC, Sun Solaris, AIX, HP-UX, Linux, RMAN, Shell Scripting, TOAD, OEM, GRID Control, DB Artisan.

Electronic Systems Resources, New York NY Sep 05 – Oct 06

Oracle DBA/Architect/Modeler

Designed Star data mart for their clients using Visio and translated business requirements into it and implemented logical design physically into Oracle Database. Also, performed the following routine DBA activities

Responsibilities:

• Translated business requirements into data mart design.

 Used Star Schema approach for designing of Data Warehouse

 Designed and maintained logical and physical enterprise data warehouse schemas using ERWin.

 Designed, develop & implemented the standby database/data guard strategy not only for failover but also for the backup purpose

 Upgrading OEM repository and Installing OEM 10Grid Control to monitor all the databases

 Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists

 Creating data models for new developments using Erwin modeler.

 Managing and Administrating oracle 9i/10g RAC databases in Unix Environment (AIX, Solaris, Linux, HP-UX).

 Used the SRVCTL utility to manage, start, stop Oracle Database and services.

 CRS_STAT to collect statistics of nodes and services running on Clustered Database.

 Upgrading/Migration from Oracle 8i databases to 9i and to 10g.

 Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.

 Planning & developing strategies in carefully migrating Dictionary managed tablespaces to locally managed tablespaces.

 Activating Table monitoring on Production boxes to collect statistics using DBMS_STATS thus reducing the performance window time-frame.

 Reviewing and resizing redo logs (wherever possible) to reduce the redo log space requests and ensuring multiplexing/mirroring of members.

 Reviewing and resizing conspicuously over allocated tablespaces (wherever possible) thus improving the time-frame for cold backups.

Environment: Oracle 8i/9i/10g RAC, Sun Solaris, Linux, RMAN, Shell scripting, OEM, Grid Control, EMC Clarion, TOAD, Statspack, Visio, Erwin

Integrates Systems Research, Pvt Ltd, Karachi Aug 03 – Aug 05

Oracle Developer/DBA

Responsibilities:

 Oracle DBA support including installations, configurations, backup/restore & recoveries, database performance tuning, tuning applications, database monitoring & operating system configurations, assisting in the logical and physical database and providing general support to developers

 Using EXPLAIN plan utility to analyze the cost involved in query processing and tune it for faster retrieval.

 Maintain data security by creating views, DB owners/users and granting/revoking permissions and roles

 Data extraction, loading and manipulating using SQL*Loader, Export/Import utilities using direct and conventional paths

 Monitoring Alert log and background trace files for warning, alerts and error messages

 Writing back end objects like stored procedures, functions, anonymous blocks, triggers, views using PL/SQL

 Using parameterized / non-parameterized explicit and implicit cursors, UTL file functionality on PL/SQL blocks.

 Writing exception handling routines to trap error codes / messages on PL/SQL blocks.

 Writing scheduled scripts/batch procedures for database backups.

Environment: Oracle 8i/9i, Crystal Reports 9.0, Linux, Apache, IBM AIX, Veritas NetBackup, Windows, Oracle Forms/Reports.

Contact this candidate