Manager Oracle
Resume:
IRSHAD SYED
abhv88@r.postjobfree.com
Oracle
Database Administrator
Note: Available Immediately *** ONLY FOR A CONTRACT
POSITION ***
[pic]
SUMMARY:
. Enterprise DBA support utilising around 8+ years of Experience in Oracle
Database Administrator, providing 24X7 production and development support
11g/10g/9i/8i databases on different platforms like HP-UX, SUN SOLARIS,
AIX, Red Hat Linux and Windows.
. Best practices for Oracle Database Infrastructure, Standards and
Implementation.
. Implementation of best case scenarios for enterprise wide Database
backup/recovery solution analyzing the specific business needs and
optimizing the use of existing infrastructure
. Implementation of Enterprise wide Database Monitoring enabling Oracle 11g
Enterprise Manager Grid Control. One stop solution for monitoring every
single Oracle Database within the global enterprise
. Implement enterprise wide Database Development standards to eliminate
time on Database tuning.
. Database Installation and maintenance.
. Installation of Oracle Databases 8i/9i/10g RAC/11g RAC.
. Data Guard setup with Primary and Standby Databases.
. Strong Oracle RAC Installation, Configuration and Tuning Skills on Red-
Hat Linux and Sun Solaris.
. Implementation of Grid Control.
. Database Backup and Recovery using RMAN including duplicating/cloning
Databases across with point-in-time recovery option.
. Configuration of RMAN Backup using VERITAS Net backup.
. Scheduling backup Jobs using Cron (UNIX) and Schedule Task (Windows).
. Monitor nightly Database backup Jobs and necessary actions for failed
backup jobs including script corrections, disk space monitoring and
Database availability.
. Physical database design, Logical database desin, normalization, de-
normalization
. Capacity planning and bench marking
. Database security and auditing
. Setup procedure for Database statistics gathering - Frequency, Best Time
of the day to execute stats gathering jobs, correct level of gathering
statistics.
. Collections of performance data for specific time range using STATSPACK,
AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN, SQL Trace.
. Analysis of Database Wait Events.
. Troubleshooting for slow performing SQL by enabling Database tracing
including session specific tracing. Performed SQL Tuning using Explain
Plan.
. Plan optimization applying corrective measures including code
restructuring, identifying potential index issues and effective
implementation of uniform coding structure to avoid optimizer re-parsing.
. Setting up Enterprise Manager notification procedures, who gets what
notification, monitoring frequency, threshold limits for process memory,
disk usages etc.
. Database trigger, stored procedure & packages PL/SQL coding.
. Multiple upgrades of Sun Solaris and Linux servers from 8i,9i to Oracle
10g, Oracle 10g to Oracle 11g.
. Excellent problem solving skills.
. Excellent written and verbal communication skills.
. Result oriented, Self motivated, Team Player, Ability to work
independently.
TECHNICAL SKILLS:
Databases : Oracle 11g RAC, 10g RAC, 9i, 8i, 7.x, MS SQL
Server 2005/2008.
DBA : Oracle 11g, 10g, Oracle Enterprise Manager,
TOAD
System Administration : Red hat Linux, HP-UX, Sun-Solaris,
IBM-AIX
Windows 95/98/ME/NT/2003/XP
Backend Scripting : SQL*Plus, PL/Sql, UNIX Shell Script, Perl
Scripting.
Network and Connectivity : Windows TCP/IP, VPN
Connectivity, Oracle TNS
Listener
Development Tool : Visual Studio, Visual C++, Windows/SDK, Visual
Basic.
Oracle Tools : RMAN, OEM/Grid Control, SQL*Loader, SQL
Server,
Oracle Warehouse Builder,SQL*Plus, DBCA,
Import/Export,
Data Pump, Streams, GoldenGate
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR,
ADDM.
EDUCATION: Bachelor of Engineering in Computer Science & Information
Technology.
PROFESSIONAL EXPERIENCE:
Contact this candidate