Sr Oracle DBA
Resume:
AMIR MAJEED
*** ******** ******, **********, ** *7601
*******@*****.***
OBJECTIVE
• Looking for a professional position in a reputable, dynamic and growing organization where my technical and analytical skills will be fully utilized in the field of Database administration.
SUMMARY
• 7+ years experienced in Oracle 8i, 9i, 10g and 11g database administration with Real Application Clusters (RAC), RMAN, EM Grid Control, Data Guard, and ASM, DBA on-call support 24/7 production & development environment.
• 2+ years experienced in SQL-Server versions 2005, 2000, and 7 in a 24/7 production & development environment.
SKILLS SUMMARY
• Real Application Clusters (RAC)
• Performance Tuning
• Disaster Recovery Solutions • Recovery Manager (RMAN)
• Standby Database Solutions
• Oracle Data Guard.
TECHNICAL SKILLS INVENTORY
ORACLE • 8i, 9i, 10g and 11g R1, RAC, Real Application Clusters (RAC), RMAN, EM Grid Control, Data Guard, ASM, SQL, PLSQL, SQL* Plus, TOAD, SQL Net, Net8, Imp/Exp., Export data pump/ Import data pump, DBMS Packages, DBCA and DB Artisan.
SQL SERVER • 2005, 2000, 7, T-SQL, Imp. / Exp. utilities, Network Utility, Query Analyzer, DTS Packages, server mail agent and etc.
LINUX • RH 3.0, SLES-9, Linux-7
UNIX • AIX-4.x (Oracle 8i), Solaris 8 (Oracle 9i), AIX 5.3, SunOS 5.9
WEB TOOL’S • HTML, XML, VB Script, Visual Interdev
DATA MODELING • Erwin 3.1, Visio 2000 / Professional / Technical, Designer 2K
OS • Win 2003 / 2000 / XP/ 98 / NT, AIX -4.X, AIX 5.3, SunOS 5.9
EDUACTION
• (BE) Bachelor’s Degree (4 yrs) in Computer System Engineering
TRAINING / COURSES
• Oracle Database 11gR1: RAC Administration
• Oracle Database 10g: Backup and Recovery
• Oracle Database 10g: Data Guard Administration R2 (Database and Grids)
• Oracle Database 9i: Database Administration
• SQL Server 2000: Database Administration & Implementation
EMPLOYMENT HISTORY
AUTOMATIC DATA PROCESSING (ADP), ROSELAND, NJ
LEAD DATABASE ADMINISTRATOR
01/09-PRESENT
ENVIRONMENT
• Oracle 11g, RAC 10g R2 on Linux, Data Guard, 9i, TOAD, RMAN, SQL Tuning Advisor, SQL Access Advisor, SQL Server 2005 Enterprise Editions, Erwin 3.1, Visio 2000, Win 2003/ 2000/ XP, UNIX (8, SunOS 5.9), AIX (4.x,5.3), LINUX (RH 3.0, SLES-9), X-Win.
RESPONSIBITIES
• Installed, loading, monitoring and troubleshoot development, qa, staging & production oracle databases.
• Supporting databases were on Linux and Solaris. Plan, implement and test staging & production disaster recovery strategy using RMAN and custom written shell scripts.
• Database monitoring and tuning, application and queries, using EXPLAIN PLAN, TKPROF, OEM, STATSPACK, ANALYZE, DBMS_STAT and custom scripts.
• I installing Oracle Database 11g R1 on SUSE Linux Enterprise Server 9 (SLES-9) and created database home and database and ASM instance.
• I installed the necessary software and created 3 node RAC 10g R2 system on RH EL 3.0 and currently we upgraded from 3 nodes to 8 nodes. I created Linux RAC 10.2.0.4 database home & database from scratch also I created ASM instance & ASM disk group.
• Wrote several shell scripts and pl/sql packages to resolve business problems of various natures.
• Involved in staging & production support on call 24/7 and database system infrastructure development.
• Created and maintaining Oracle Data-Guard configuration (primary and standby databases) using Data Guard broker interfaces, including a command-line interface (DGMGRL) and a graphical user interface that is integrated in Oracle Enterprise Manager.
• Create standby logical & physical databases for data protection and disaster recovery before our data center moved from bridge water to DC.
• Designed and implemented Row level Security using VPD for several Integrated Products.
• Reduced the cost of hardware by 30% by reducing the processing time of the whole production cycle by 50% using advance tuning methodology on the existing code and by breaking up the code in smaller pieces to take the advantage of parallel processing.
BLUE WOLF GROUP, NYC, NY
REMOTE ORACLE & SQL SERVER DATABASE ADMINISTRATOR
07/05-12/08
ENVIRONMENT
• Oracle 10g R1 & R2, 9i, 8i, TOAD, RMAN, SQL Server 2000, 2005 Enterprise Editions, Erwin 3.1, Visio 2000, Win 2003/ 2000/ XP, UNIX, AIX, LINUX, X-Client.
RESPONSIBITIES
• Used migration workbench for SQL Server to migrate SQL Server database to Oracle.
• Upgraded oracle database server from previous version 9.2.0.5 to 10.2.0.4.
• Installed, loaded, monitored and troubleshoot different clients company’s Oracle 8i, 9i and 10g databases. Databases are on Windows, Linux & UNIX.
• Plan, implement and test disaster recovery strategy using RMAN 9i without catalog & catalog.
• Refreshed and duplicated database through RMAN.
• Plan and implement oracle data pump (export data pump & import data pump) via OEM and customs scripts.
• Database monitoring and tuning from instance to query level by OEM, EXPLAIN-PLAN, STATSPACK, ANALYZE, DBMS_STAT, TKPROF and so on.
• In order to avoid index rebuilds & BLOB in reporting database structure used Oracle’s transportable tablespace (TTS) feature one of client Auto One insurance. The down time for the final cutover decreased from 48 hours to 22 hours from 32 bit to 64 bit.
• Designed, developed and implemented heterogeneous real-time replication using IBM Web Sphere Replicator (Informix to Oracle and SQL to Oracle)
• Upgraded from previous version SQL Server 2000 to SQL Server 2005.
• Created databases & transaction logs.
• Plan, implement and test disaster recover strategy using VERITAS.
• Created DTS packages for import/export wizard also used Transfer data task and Bulk insert task.
• Run DBCC Consistency checks and fixed data corruption in user database.
• Involved in security administration (created users and assigned roles & privileges).
PRIMARY DBA FOR BLUE WOLF CLIENT’S
ORACLE SQL SERVER
• Armani – New York, NY
• Heineken – White Plains, NY
• PDI Inc. – NJ/PA/IL
• Russ Barrie – UK/USA/AUS/CAD • Auto One Insurance – Melville, NY
• PDI Inc. – NJ/PA/IL
• Cooper health hospital – South Jersey
• Access Group – CA
UCA COMPUTER SYSTEM INC., DENVILLE, NJ
REMOTE ORACLE & SQL SERVER DATABASE ADMINISTRATOR
05/04-06/05
ENVIRONMENT
• Oracle 10g, 9i, 8i, TOAD, RMAN, SQL Server 2000 , Erwin 3.1, Visio 2000, Win 2003/ 2000/ XP.
RESPONSIBITIES
• Performed disaster planning, enrolls new users, maintain space within the database, suggest and implement backup strategy to maximize security and safety.
• Provided technical assistance to developers in all matters concerning performance, including optimizing and rewriting SQL statements in applications.
• Installed and configured ORACLE software on UNIX (HP and SUN) and Windows environments.
• Responsible for logical and physical modeling of database objects using ER-Win.
• Responsible for uploading data from text files to Oracle and SQL Server databases using utilities like SQL*Loader and DTS.
• Responsible for the migration of SQL Server database to Oracle database.
• Plan, implement and test disaster recovery strategy using RMAN 9i without catalog & catalog.
• Refreshed and duplicated database through RMAN.
• Plan and implement oracle data pump (export data pump & import data pump) via OEM and customs scripts.
• Monitored and tune data buffer pools, data block caching in the SGA, data buffer metrics and PGA managements, used STSTSPACK for buffer pool statistics SGA reconfiguration and trend based Oracle reconfiguration.
VERIZON, NYC, NY
ORACLE 9i & SQL SERVER ADMIN (Contract)
10/02-04/04
ENVIRONMENT
• Oracle 9i /8i, SQL Server 2000/ 7,Forms 9i/6i, Reports 9i/6i, Web-DB, 9iAS, IBM AIX-4.X, Erwin 3.1, Visio 2000, Win 2003/ 2000/ NT.
RESPONSIBITIES
• Loaded data from .txt (data files), made .ctl (control file), created .sh (executable file), created, drop and altered new and existing tables and constraints in IBM AIX4.X (Oracle database).
• Monitored and managed the utilization of the system against the database initialization parameters (INIT.ORA) for such events as lock limits, data file limits, process limits, user limits, and other database variables.
• Managed schema objects and database performance problem and security management within the database, created new objects, privileges granted to objects, managed space used for each schema object, created database links when needed. Assigned roles, profiles and system and the OS security interact with Oracle.
• Created Packages, stored procedures, Cursors, Stored functions, Triggers and Parameters.
• Developed interfaces and data conversion packages using PL/SQL, SQL* Loader and Oracle warehouse builder.
• Upgraded and set 9i single instance database and profile. Checked Oracle PWD file and initialization files.
• Created Indexes and materialized views on the standby to speedup reporting.
• Converted Redo Log Files into SQL Statement for reapplication to a standby concurrently on the standby database with logical log application.
• Scheduled Backups and Restoration Plans and Point in Time Recovery.
IMAGE-X ENTERPRISE INC., SANTA BARBARA, CA
ORACLE DATABASE ADMIN & Developer (Contract)
07/01-09/02
ENVIRONMENT
• Oracle 9i / 8i/ 8, Developer 6i/ 5 (Forms & Reports), Oracle Web-DB, SQL Server2000, PLSQL, SQL Plus, T-SQL, LINUX (PostgreSQL-7.1 database), Erwin 3.1, Win XP/ 2000/ NT/ 98.
RESPONSIBITIES
• Managed and created new and existing database users, alter and drop user profiles, grant and revoke user privileges, created, modified and assigned roles, controlling usage of resources and availability of roles, grant and revoke systems and object privileges and password files authentication.
• Data migration from SQL-Server to Oracle and PostgreSQL-7.1 (LINUX) database.
• Managed table indexes and data integrity. Created indexes, stored Procedures, functions, packages and views for faster and efficient retrieval of data, smooth running of all server processes in development & production environment.
• Designed, developed and trained users for processing the ideas through different ideas cycles steps like idea entry, idea booking, idea Scheduling, Confirm, and Receiving Interfaces.
• Involve in designing, normalizing and analysis of database like
Normalized and de-normalized database up to 3 levels.
Designed logical and physical data modeling, data flow (DFD), Control flow (CFD), Entity relationship
(ERD), data structure and data stored.
REFERENCES
• Available upon request
Contact this candidate