Manager Oracle

AZEEMUDDIN K.A. 973-***-****

AZEEMUDDIN

Oracle Database Administrator ***.**********@*****.***

* **** ***** ** ********** in Oracle Database Administration encompassing Installation, Configuration, Patch

Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory

Management, Performance Monitoring and Tuning, RAC, Data Guard, Streams, Grid Control and Enterprise

Manager.

Installation and administration of Oracle 11g/10g on OEL, RHEL, Windows, HP-Unix, IBM-AIX

•

and Sun Solaris in OLTP and OLAP environment.

Hands on working experience on 12C OEM (Oracle Enterprise Manager).

•

Performed Migration and Upgrade of databases to 11g and 10g

•

Up gradation of databases applying patches, patch sets and critical patch updates.

•

Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g and

•

10g in different operating systems for OLTP environment on Very Large Databases(VLDB).

Experience on Oracle 11g/ASM/RAC and up gradation of standalone databases to 11g RAC

•

environment

Configuration of Automatic Storage Management (ASM)

•

Configuration and Management of Data Guard on RHEL and OEL.

•

Worked on Oracle streams.

•

• Configuring O racle Golden Gate for replications.

Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-

•

prod databases.

Extensive experience in installation and implementing OEM and setup of Oracle Grid Control.

•

Experience on Data Replication using Snapshot, Materialized views and import/export.

•

Installation and configuration of RMAN with and without Recovery Catalog.

•

Design and implementation of Backup and Recovery strategies (both cold and hot backups) and

•

performing periodical backup, restoration and recovery using RMAN(full and incremental)

Testing and implementing different physical and logical backup and recovery methods including point

•

in time, media recovery, full/partial, and data pump export/import.

Migrating the databases from one platform to another platform.

•

Implementation of Flashback Technology.

•

Extensively used BMC Remedy and Service Now Ticketing systems for monitoring.

•

Detecting and diagnosing production system performance problem by analyzing STATSPACK reports,

•

Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database

activity, Querying Oracle dynamic performance views.

Monitoring and Optimization of database performance through database tuning, system tuning and

•

application tuning.

Experience in SQL Tuning, Optimization, cost based optimization and Hints.

•

Implemented sql plan manager and sql -t for pinning better plans for slow running jobs.

•

Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN,

•

TKPROF, STATSPACK, SQL TRACE.

Proficient in INDEX REBUILDING and INDEX TUNING.

•

Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle

•

Linux monitoring using NMON and TOP commands.

Experience working with Database Resource Management

•

Working experience in creating materialized views.

•

Proficient in writing PL/SQL Procedures, Functions and Triggers.

•

24*7 on-call production database support and maintenance including remote database support

•

Assisting in implementation of change control process in production.

•

Ability to work in a team as well as to take individual responsibility.

•

TECHNICAL SKILLS:

Operating Systems OEL, Red Hat Linux RHEL 2.1, 3.x, 4.x,5.x, 11.x, Sun Solaris 9.0/10.0 and AIX 5.1, 5.2

Data Bases Oracle 11gRAC/10gRAC/10g.

Languages SQL, PL/SQL, C, C++, UNIX Shell Scripting.

Tools/Utilities RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, Patch

Management, SQLNET, ODBC, Export/Import, Data pump, Dataguard, VMware and CronTab.

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation Putty, Telnet, FTP.

PROFESSIONAL EXPERIENCE

Client: Best buy Corp, MN Jul2013-Present

Oracle Database Administrator

Responsibilities:

Maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g and 11.2.0.2

•

to 11.2.0.4.

Worked on databases ranging from 500GB to 45TB.

•

Performed 12c Upgrade of RAC cluster ware from 11g.

•

Database Refresh from one version to another version.

•

Migration of database from one server to another server.

•

Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC

•

environment for production database.

Performed Physical standby database rebuild using SRDF technology when gap is unrecoverable.

•

Worked on Oracle streams and performed trouble shooting.

•

Performed complete rebuild of streams.

•

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with

•

ASM.

Addition of asm disks to a database disk group.

•

Done migration of non ASM database to ASM database.

•

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups for production and

•

prod like databases.

Implemented EMC Data Domain Boost on servers for quicker backups and recovery.

•

Performed conversion Non RAC single instance to Real Application Cluster (RAC) database

•

instances.

Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of

•

time.

Performed patching on Oracle Database Server 10g and 11g using Opatch utility.

•

Supported Applications HR, Oracle Apps, Enterprise customer care, Data ware housing, Retek,

•

Resa,RMS and Beast.

Established performance tuning best practices used by the DBA and Development teams.

•

Daily Health Check Up of the Database using AWR, ADDM.

•

Used 12c grid control for monitoring performance issues and High CPU using sessions in database.

•

Tuned slow running jobs and sql queries using sql tuning advisor.

•

Pinned better plans for jobs to improve performance

•

Implemented sql plan manager and sql -t for pinning better plans for slow running jobs.

•

Gathered statistics for tables and indexes using DBMS package.

•

Performed index rebuild activity when it is in unusable state.

•

Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures,

•

Rollback Segments, Logs and Alerts.

Manage customer relations on a daily basis.

•

Attended Developer’s code review meetings and made recommendations to improve Efficiencies

•

Streamlined and improved job efficiency by creating scripts for common maintenance tasks

•

Performed day to day administrative tasks by analyzing the database like checking for failed

•

processors, verifying the query for particular issues and validating disk space.

Created Users with limited rights as per specific module under specific client. Granting roles and

•

profiles as per system study to users.

Provided a positive impression of support centre by documenting, tracking, and following-up on all

•

solutions making sure end-user problems were resolved to their satisfaction

Replication of tables to cross platform and Creating Materialized Views.

•

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas

•

etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for

easy and effective management of Oracle networking. Configured listener for external procedure calls.

Also configured database cloning using RMAN.

•

Provided appropriate security for users of databases, applications, servers, and systems, by setting

•

and managing accounts, keeping sensitive data secure

Develop and enforce both database and OS-level security policies for data protection. Administer all

•

databases in the areas of maintenance, tuning, performance, and troubleshooting.

Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, SQL*Net,

•

IMPORT/EXPORT, and RMAN.

Creation of new scripts to automate the procedures to generate statistics on database space

•

management for proactive monitoring.

Worked in shifts and on call support for one weekend every month.

•

Environment : Oracle 10g, 11g, 12c, Linux 4/5, OEM12c, OEM10g RMAN, Grid, RAC, ASM, Data guard,

SQL*LOADER, AWR, ADDM, ASH, Data pumps, Exports/Imports

Client: Sky mall, Phoenix, AZ Jun2011-Jun13

Oracle Database Administrator

Responsibilities:

Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from

•

Oracle 10g to 11g.

Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC

•

environment.

Database Refresh from one version to another version.

•

Migration of database from one server to another server.

•

Worked on databases ranging from 500GB to 5TB.

•

Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.

•

Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC

•

environment for production database.

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with

•

ASM.

Done migration of non ASM database to ASM database.

•

• Installed Golden Gate for replication of d atabase on 11gR2 RAC environment .

• Configured parameters for the B i-di rectional replication using Golden-Gate .

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.

•

Performed conversion Non RAC single instance to Real Application Cluster (RAC) database

•

instances.

Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of

•

time.

Performed patching on Oracle Database Server 10g and 11g using Opatch utility.

•

Daily Health Check Up of the Database using AWR, ADDM.

•

Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures,

•

Rollback Segments, Logs and Alerts.

Performed day to day administrative tasks by analyzing the database like checking for failed

•

processors, verifying the query for particular issues and validating disk space.

Created Users with limited rights as per specific module under specific client. Granting roles and

•

profiles as per system study to users.

Replication of tables to cross platform and Creating Materialized Views.

•

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas

•

etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for

easy and effective management of Oracle networking. Configured listener for external procedure calls.

Also configured database cloning using RMAN.

•

Develop and enforce both database and OS-level security policies for data protection. Administer all

•

databases in the areas of maintenance, tuning, performance, and troubleshooting.

Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER,

•

STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.

Developed Scripts for transferring data from production server to testing/development servers.

•

Shell scripting and PL/SQL programming to resolve business problems of various natures.

•

Managing databases on multiple servers.

•

Environment : Oracle 10g, 11g, Linux 4/5, OEM, DBUA, RMAN, Golden gate, Grid, RAC, ASM, Data

guard, SQL*LOADER, AWR, ADDM, ASH, Data pumps, Exports/Imports.

Client: ABC Inc, Chicago, IL Apr 2009-May 2011

Oracle Database Administrator

Responsibilities:

Installed and Configured 2node RAC on Linux.

•

Working Knowledge of installation and configuration of GOLDENGATE in Unix environment

•

Resolving the conflicts between the target and source database.

•

Installed and Configured and maintained oracle 10g and 11g.

•

Oracle Grid Control 11g Installation and Configuration.

•

Involved in supporting 50+ production and development databases on RHEL.

•

Refreshing the Database from one version to another version.

•

Configuration of Physical Standby database for maximum performance mode – Oracle Data Guard

•

Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various

•

environments.

Migration of databases from 10g to 11g using export/import and data pump export/import utilities

•

Performed rolling patch upgrades on RAC environment for bug fixing

•

Setup of Jobs using the Oracle Enterprise Manager (OEM) database control

•

Weekly Data Refresh from Production to Development and Test environments using data pump

•

export/import.

Daily incremental backup and weekly full backup of databases using RMAN

•

Involved in migration of applications of the clients.

•

Loading data into database tables using SQL *Loader

•

Implemented Materialized views, database links

•

Regular database management on 10g and 11g OEM

•

Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and

•

rebuilding Indexes and running scripts given by the clients.

Table space monitoring, Performance monitoring and tuning for performance improvement

•

Creating batch files and automating the tasks

•

Granting roles and privileges to end users

•

Managing, troubleshooting and resolving oracle database and application issues.

•

Daily health check up of the database using TKPROF, AWR, ADDM.

•

Monitoring alert log/system log and managing Database Locks and blocking sessions

•

Defragmentation of tables and indexes for improved performance and efficiency.

•

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL

Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML

Health & Hospitals Corp, NYC Jan 2008-Feb2009

Oracle Database Administrator

Responsibilities:

Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from

•

10g to 11g

Maintenance of around 20 databases combined on all the production, development and testing

•

environments.

Install and configured Oracle databases on windows server 2003 and 2008 platform.

•

Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-

•

ware and responsible for high availability and load balancing.

Configured Oracle Data guard for Oracle Disaster recovery.

•

Achieved High Availability, Data protection and Maximum performance by maintaining both

•

physical and logical standby databases.

Restoration and Recovery of databases at the times of occurrence of critical failures.

•

Responsible for installing, upgrading and configuring the Oracle environment by creating databases,

•

storage structures and objects, database backup and recovery, monitoring and optimizing

database performance.

Implemented Oracle database backup & recovery solutions using RMAN.

•

Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers.

•

Performed large batch jobs, and tuning of SQL queries and database systems.

•

Created User accounts, Roles and granting required access permissions and privileges to the database

•

based on the applications they are accessing.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups

•

and Logical backups.

Performed automated backups and scheduling using scripting.

•

Responsible for migration of databases.

•

Written Stored Procedures and Triggers for database maintenance and management using PL/SQL;

•

UNIX Shell Scripts for backups.

Experienced in performing Point in time recovery using RMAN.

•

Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating

•

databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network

Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,

Involved in designing logical and physical data models using Erwin.

•

Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database

•

Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace.

Created indexes to facilitate easy user interface implementation and tuning.

•

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic

•

Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.

Tested database performance issues (monitoring and tuning) to ensure database optimization.

•

Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7

•

operational environment.

Involved in gathering requirements from end users.

•

Clear documentation was prepared on all the processes like program specification, bugs fixing logs &

•

change requests for future reference.

Estimate growth of database size by detail analysis of the company’s future policies and generating

•

reports for the management to act in advance.

Environment: Oracle 11g/10g/9i, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM,

Oracle 10g RAC, TOAD, Erwin, STATSPACK, EXPLAINPLAN

Reliance communication Pvt Limited, Hyderabad, India March2006-Oct2007

Junior Oracle Database Administrator

Responsibilities:

Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH

•

and BULK INSERT features.

Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.

•

Involved in optimizing SQL statements using Indexes and Hints.

•

Made use of the REF CURSORS in stored procedures for report generation.

•

Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures

•

and Triggers.

Involved in writing complex SQL statements.

•

Developed backup and recovery strategies, batch processing, performance monitoring, log

•

maintenance and automating functions wherever possible.

Co-ordinated with System administrators, application developers for various activities.

•

Maintained database security by managing users roles, privileges. Implemented new security rules via

•

roles as per the company policies.

Tuned the performance of the SQL’s using TkProf and Statspack reports.

•

Performed security management and accessibility control by managing OS and Password file

•

authentication, creating profiles, privileges and roles.

Environment: PL/SQL, Oracle 10g, TOAD, SQL PLUS, PL/SQL Developer, HP-UX 11.0

EDUCATION :

Bachelor's Degree.

Kakatiya University, INDIA.

Contact this candidate