Ahmed

Oracle DBA

-

PROFESSIONAL SUMMARY:

Over 5 years of experience as Oracle DBA on 10g, 11gR2 database servers with high availability.

Pose strong experience working as an Oracle DBA which includes experience in 10g, 11g, ASM, Grid Control, 12 Cloud Control, Materialize Views, Data Guard, RAC, GoldenGate and managing databases using Toad and dictionary tables and views.

Worked with large database

Build RAC Clusters from scratch on Linux

Worked with offshore DBAs

Supported multiple projects in parallel.

Created Data Guard for RAC and standby servers.

Provided 24*7*365 DBA on-call

Worked on RMAN backups, restores and cloning of databases.

Strong experience in OEM (Oracle Enterprise Manager) and TOAD.

Worked with Developers during Deployments and SQL tuning

Worked on instance tuning as per the best practices.

Identified root cause of performance issue using ASH, AWR, ADDM, SQL Advisor, tkprof, execution plan etc.

Worked on databases ranging from a few GB to up to few TB.

Worked on Oracle 10g and 11g R2 database server installs from scratch.

Upgraded database from 10g to 11g R2 and 11.2.01 to 11.2.0.2 to 11.2.0.3

Monitored databases using Grid control and 12 cloud control

Used Export Import / Data Pump, DBLinks for data movement.

Experience in writing Shell and SQL Scripts.

Oracle RAC Good knowledge of Flashback technology.

Performed Database Migrations.

Performed Database Upgrades.

Worked with Storage Admins for carving out partitions for datafile systems.

Worked with SAN, NAS for ASM disks.

Experience in schema management, Tablespace, datafile and extent management, as well as user and privilege management.

Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.

Experienced in Database Security Administration using roles/grants.

Managed SQL Server Databases

Installed SQL Server 2005, SQL Server 2008 databases

Strong administrative skills in Windows and Linux.

Tablespace Management

Capacity planning

Database installation using Oracle Silent Install.

Applied Quarterly CPU and PUS patches.

Troubleshoot Oracle Networking Issues

Worked with Oracle in resolving issues.

Very familiar with Oracle Dictionary

Implementation of Golden Gate

TECHNICAL SKILLS:

OperatingSystems RHEL,HP-UX, Windows, Sun Solaris, CentOS RDBMS Oracle 10g R2, 11g R2, 12c Database, SQL Server 2005/2008

High Availability RAC, Data Guard, ASM, GoldenGate Languages SQL, PL/SQL

Tools RMAN, OEM, SQL Loader

PROFESSIONAL EXPERIENCE:

TDS TELECOM, WI Aug 2011 – Present

Oracle DBA

Role & Responsibilities:

Responsible for new 11g database installation

Upgraded and patched existing Oracle homes.

Build 2-node 11g R2 cluster from scratch on Linux.

Build Data Guard.

Designed roles and assigned permissions

Responsible to improve the performance by Using the Hints, Indexes, Explain Plan

Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace

Automating the backup processes using shell scripts.

Build RAC clusters and added nodes.

Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space

Export and Import of User, Tables and Database using exp/imp and Data Pump

Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces, and Temporary Tablespaces.

Used exp/imp, data pump and dblinks to move the data

Worked on standard and enterprise edition of the Oracle RDBMS.

Worked on database backup using RMAN for HOT backup and scripts written for COLD backup.

Worked on schema Reorganizations for better space management

Performed Database Refreshes and Database Copies for Development, Test and Production databases

Installed, Migrated, configured and tested Oracle 9i databases in various environments

Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.

Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers

Data modeling / Logical database design and implementation (including index design)

Migration of system and applications from Oracle 9i to 10g.

Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks

Create and maintain multiple databases.

Create multiple 11g databases on RHEL5 in development.

Schedule backup in 11g using db console.

Monitoring frees space in tablespaces, Archive log destination, Database/Listener availability, Blocking Locks monitoring etc.

Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Standby databases to ensure high availability, data protection and disaster 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

Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.

Implemented backup strategies which involved taking an incremental backup and enabled the block change tracking feature.

Implemented unidirectional GoldenGate replication for schema/table level

Worked with Oracle in troubleshooting issues.

Worked with Development team in deployments.

Environment: Oracle 10g, 11g R2, RAC, Oracle Data Guard, Oracle GoldenGate EDUCATION:

-

Pursuing Bachelors in Computer Science

Contact this candidate