Oracle Management
Resume:
HADI ABDUL
Oracle Database Administrator
*******@*******.***
SUMMARY
Over 6 years of Oracle Database Administration experience in implementing, Design,
Development, Testing and Production support in all industry verticals exclusively Telecom,
Financial, Pharmaceutical, Insurance Industries.
Performed backup & recovery of large databases and provided 24X7 production support to high
critical databases
Provided root cause analysis and permanent fix of production problems
Installation, administration and maintenance of Oracle 11g, 10g
Worked extensively on Oracle Installation, Oracle Version Upgrade, Migrations (from 10g to
11g) and patching
Extensive experience in installation and implementing OEM and TOAD and setup of Oracle
Grid Control.
Migrations and Upgrades, including environments using Oracle Data Guard.
Experience in implementation of enterprise databases on enterprise Storage Solutions using
Storage area Networks (SAN) /Network Attached Storage (NAS).
Experience in Configuring Single instance to multimode, Oracle Real Application Clusters
(RAC) and Automatic Storage Management (ASM) and Data guard and Streams.
Installed, configured and maintained Physical, Logical, Active standby databases supported by
Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
Solid hands on Oracle Streams for site to site Replication.
Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle
Databases.
Management of schemas, objects & Partitioning the tables & indexes, USERS and
PRIVILEGES.
Design, development, and testing of backup and recovery to ensure complete recoverability.
Solid experience in disaster recovery, routine maintenance for Oracle databases.
Security management for database, network, and operating systems.
SQL Net installation/configuration/troubleshooting (Server and Client side
Storage Management including fragmentation detection, tablespace growth ratio.
Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK,
SQL Trace & TKPROF, EXPLAIN PLAN.
Experienced in Systems Testing, Integration Testing, and Software Quality Standards, Training,
Documentation and implementation in a business environment.
Setup/Monitored Golden Gate for table replication
Worked extensively on created development, testing, staging, production, RAC and standby
databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN,
VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration
(NETCA) Extensive experience in 7*24 production database support.
Expert in systems analysis and architecture, capacity planning, backup/recovery, installation,
configuration, apply patches, troubleshooting, performance monitoring and tuning.
Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.
AREAS OF EXPERTISE
RUP, SDLC, UML,AGILE
Software development methodologies:
Front End Tools: MS Excel, MS Word, MS Visio, MS Project,
Oracle 11g, Oracle 10g, Oracle 9i,SQL SERVER,DB2
Databases:
Oracle Database tools: SQL*Loader, TKPROF, Toad, OEM,
TKPROF, EXPLAIN PLAN, STATSPACK, AWR,
ADDM, ASH, SQL Developer, DBArtisan,
12 C Grid Control,Toad
Solaris 10/9/8, Sun Sparc, Linux RHEL 5.X/4.X,
Operating Systems:
OEL, HP UX 11i, AIX, Windows 2000/2003/2008
server
PROFESSIONAL EXPERIENCE
AT&T Middletown, NJ May 2014 – Present
Oracle DBA
Responsibilities:
• Worked closely with Application Developers to design/create new Oracle
databases/create new schemas/database objects, as well as making database changes
from DEV to PROD, via TEST following requests/demands from the development
team.
• Organized various migration review meetings with the application team to discuss
the migration strategy based on their requirements.
• Resizing and reorganization of database objects: Tables, Indexes, Rollback segments
and Redo log files of existing production and development systems. Resizing
Tablespaces, Tables, indexes, Rollback segments.
• Hands on experience in Replication using snapshot MV and Golden Gate.
• Build Oracle Data Guard with high availability and performance configurations and
participated in Data Guard Fail over.
• Migrating from Oracle 10.2.0.4 on Solaris/AIX databases to Oracle 11.2.0.4 on
Cloud Linux.
• Design of databases following OFA: Creating Databases schemas, profiles, database
links, Snapshots and Synonyms of objects as required to ensure data quality and
security to comply with company's business rules. Oracle scripting in
Windows/Linux and UNIX platform.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of
Terabytes size using various tools like STATSPACK, AWR, SQL Trace, Tk prof,
Analyze, ADDM and Explain Plan Methods.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN
utilities (scheduling full/incremental/cumulative backups, hot/cold backups
writing/editing UNIX Shell Scripts for RMAN).
• Experience in LOGICAL BACKUPS and Database migration tools with Data Pump,
Export/Import and Transportable Table spaces.
• Good experience in PATCHING AND UPGRADATION. Expertise in upgrading
Oracle Development and Production databases from 9i to 10g & 11g
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers etc
• Experience in database cloning with RMAN, Capacity Planning, Database Refresh
• Installation, Configuration and Maintenance of RAC on Linux and Solaris using
ASM and RAW devices and Oracle CRS, Stand by database.
• Experience as On Call 24x7 production DBA support, application DBA.
• Data Refresh from Production to Test and Development, Staging and UAT
environments using RMAN Duplicate, datapump and export and import .
• Create and Scheduled jobs through Oracle Job Scheduler
• Extensive knowledge on database administration for Oracle 9i, 10g and 11g, with
experience in very large scale database environment and mission critical large OLTP
and OLAP systems.
• Evaluated mix of backup and recovery methods based on organizational needs.
Implemented, tested and documented various backup/recovery scenarios for
knowledge base.
• Deploy new changes in production.
• Creating and dropping of users, granting and revoking rights as and when required
• Experience in a variety of hardware and software platforms including; MS Windows
2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP UX & AIX and RHEL.
• Troubleshoot installation errors both independently and with Oracle support (via
My oracle Support)
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O
using UNIX command line utilities.
• Maintain and administer change management policies and updating the ticketing
system using Remedy.
Environment: Oracle 8i, Oracle 9i, 10g and 11g . SQL Server 2008, DB2, RMAN, Data pump,
AWR/ADDM SQL TRACE, TKPROF, EXPLAIN PLAN, HP UX 11, Linux, AIX, HP UX,
Windows, Sun Solaris 10.0.
Reynolds Packaging Group Richmond, VA June 2012 – May2014
Oracle DBA
Responsibilities:
• Wrote scripts to create tables, views, indexes and synonyms required meeting
developer needs. Working with Java J2EE developers to develop and formulate
capacity planning for 11g databases.
• Excellent experience in Installation and configuration of Oracle 10g,11g in
UNIX/LINUX and Windows environment.
• Worked on in house installation of Oracle on different platforms, loaded user data to
reproduce the problem, applied new Oracle patch, managed database backup using
RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.2
• Build Oracle Dataguard environments for Max Protection, Max Performance & Max
Availability
• Set up 12C OEM Grid Control to monitor all databases centrally. Monitor health,
availability, performance, cloned and schedule backups using 12c Grid Control
• Database reorganizations and refresh schema using Export/Import. Creating the
database, table spaces, tables, indexes, setting privileges and user logins.
• Creating physical databases with multiple table spaces from logical and physical
data model
• Prepared scripts to tune developer SQL codes to maximize result return time
• Worked on large databases in Oracle 11g with multiple instances using Veritas
Cluster.
• Performed Cold backups, Hot Backup.
• Cloned databases using scripts as well as RMAN. Installation, setup and
configuration of Data guard
• Performance tuning for optimized results using tools like EXPLAIN PLAN,
SQL*Trace, TKPROF, AWR and ADDM reports.
Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster
•
recovery of the databases and database objects.
Performed full & incremental backup (cumulative and differential) using RMAN and
•
implemented recovery strategies.
Refreshed/cloned databases using RMAN utility.
•
Performed Database upgrade from Oracle 10g (10.2.0.3) and to Oracle 11g (11.2.0.1) RAC
•
database.
Successful in applying RDBMS patches, security patches for improving the security and
•
functionality of the databases.
Achieved optimized performance for the databases by rebuilding indexes, on tables and
•
indexes.
Automated the processes like moving files, managing alert log, efficient backup by developing
•
UNIX scripts.
Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node
•
RAC (Real Application Cluster) with ASM file system on AIX platform.
Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
•
Installed ASM environment and migrated databases from NON ASM to ASM.
•
• Involved in design and enforcing of standards in place to ensure that all application
design and code is produced with proper integrity, security and performance
• Refreshed schema using Export/Import. Created the database, tablespace, tables,
indexes, set privileges and user logins
• Monitored and performed database sizing, tablespace management and rollback
tablespace management, transaction management and security administration
• Data migration between databases using both Oracle 10g and 11g export/import
utility and Oracle 11g exp/imp data pump.
• Scheduled daily Exports/Imports to serve as temporary backups.
• Installation and configuration of Oracle 10g and 11g Enterprise Editions, OEM with
Oracle Diagnostic and Tuning packs.
• Documentation of Oracle database operations.
Environment: MS SQL Server 2005, SQL Server 2012 Oracle RMAN, Grid Control, Oracle 11g
(11.2.0.2), DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN,SQL SERVER
AA Prestige Transportation Charlotte, NC Feb 2009 – June 2012
Oracle DBA
Responsibilities:
Managed Oracle Databases on Windows and Linux platforms.
•
Extracted data from SQL Server for report, backup, testing purposes.
•
Performed Cold Backups, Hot Backups, RMAN incremental backups.
•
Set up OEM grid Control to Monitor Database
•
• Work closely with Systems Analysts, Systems Engineers/Admins & Application
•
Developers through the SDLC from Development to Production, via Tech Test in
•
Needs Assessment, Requirements Gathering (Server hardware/OS specifications for
Oracle Installs), Database Designing (Physical & Logical) and Implementation,
database user creation and database access both at role & table levels, as well as final
Project Performance.
Backup / Recovery methodology specification for mission critical databases
•
Monitor database systems and provide technical support for database system issues
•
and application performance enhancement/improvement using both Oracle 10g Grid
Control & SQL*Plus, as well as UNIX shell scripts.
Performed activities like monitoring the database and provide maximum uptime.
•
Created and granted users the privileges and roles and resizing the datafiles to
•
manage database growth.
Defined and implemented database backup and security strategies, tested the
•
backups periodically for consistency and reliability
Identified long running database queries, refining queries for better performance,
•
and working with end users to implement changes
Created primary database objects (tables, views, indexes) once application
•
developers have designed an application
Monitored the alert logs and troubleshot the errors.
•
Scheduled the backup jobs such as export through cron job in UNIX environment.
•
Rebuilt indexes and analyzed tables to ensure good performance of database.
•
Installed Oracle 9i and 10g on multiple platforms.
•
Performed up gradation of 9i to 10g.
•
Performed traditional Cold backup in appropriate environments via OS commands as
•
well as logical exports.
Created the database objects such as Tables, Indexes, Views, Database Triggers,
•
Procedures, Functions, etc.,.
Environment: Oracle 10.2.0.1, Oracle 9i (9.2.0.8),RMAN, Data pump, SQL TRACE, TKPROF,
EXPLAIN PLAN, HP UX 11, Sun Solaris 10.0, Windows 2003, SQL Server..
US Steel Plant Birmingham, AL Nov 2008 – Mar
2009
Network Engineer
Responsibilities
Integration of Cisco IP Phones with Switches in VLAN environment
•
Policy configuration and management of firewalls
•
DNS changes as per client requests
•
Planning about new product requirements, Contacting Vendors for product
•
purchases
Contacting Service providers to troubleshoot issues on WAN connectivity
•
in planning and designing team for network upgrades/changes
•
Configuring NAT Policies, Global VPN Client Policies
•
Establishing Site Site VPN Connections
•
Maintenance of DHCP Server.
•
Enabling high availability and high capacity features such as Spanning Tree and
•
link aggregation on Switches
Responsible for service request tickets generated by the helpdesk in all phases such
•
as troubleshooting, maintenance, upgrades, patches, fixes, and all around technical
support
Basic Configurations and Maintenance of various Switches, Routers, Firewalls and
•
Wireless Access Points at different client locations
Responsible for interaction with third party technicians on site
•
Performed network support involving daily wiring maintenance of cabling, switch
•
maintenance, network port re enabling, and cable room
Documentation of all new software installation procedures, troubleshooting
•
procedures
Responsible for implementation of new network infrastructure includes Cabling,
•
Switching, Routing
Establishing MAN Connectivity between their different braches
•
Involved in Loop back tests and troubleshooting issues during establishment of T1
•
Line
Dynamic VLAN implementation using IEEE 802.1x protocol and RADIUS Server
•
Environment: Cisco 2900, 3560, 1800, 3700, 3800, 7200, 2900, 3500
Contact this candidate