Sql Server Oracle
Resume:
AMIR MAJEED
*** ******** ******, **********, ** *7601
*******@*****.***
AMIR. Majeed
Page 1 of 7
• Looking for a professional position in a reputable, dynamic and growing organization where I can
Objective
utilize and increase my skills in the field of Oracle Server and MS-SQL Server administration.
• 6+ years of experience with Oracle databases versions 11gR1 RAC, 10g, 9i, 8i and 7 in a 24/7
Summary
production & development environment.
• 2+ years of experience with SQL-Server versions 2005, 2000, and 7 in a 24/7 production &
development environment.
Skills Inventory
Oracle
• 11gR1 RAC, 10g, 9i, 8i, Data guard, SQL, PLSQL, SQL* Plus, TOAD, SQL Net, Net8,
Imp/Exp., OEM, RMAN, DBMS Packages, Database administration, DBCA and etc.
• 2005, 2000 / 7, PLSQL, T-SQL, Imp. / Exp. utilities, Network Utility, DB Administration,
SQL Server
Query Analyzer, DBMS Packages, Server mail Agent, DTS Packages.
Linux
• Red-Hat Advance server 3 (Oracle enterprise 9.0.1/9.2.4), Linux-7 (PostgreSQL-7)
Unix
• AIX-4.x (Oracle 8i), Solaris 8 (Oracle 9i)
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, IBM AIX -4.X for Oracle 8i Database, Solaris 8 for 9i
Education
(BE) Bachelor’s Degree (4 yrs) in Computer System Engineering
• Oracle Database 11gR1: RAC Administration
Training /
• Oracle Database 10g: Backup and Recovery
Courses
• 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 01/09-Present
Lead Database Administrator
Environment
• Oracle 11gR1 RAC,10g, 9i, SQL, PL/SQL, SQL*Plus, TOAD, RMAN, SQL Server 2005
Enterprise Editions, Erwin 3.1, Visio 2000, Win 2003/ 2000/ XP, UNIX, AIX, LINUX, SUN
X-Client.
Responsibilities
• Currently implemented 3 nodes 11g (release-1) RAC cluster and in the process of implementing
8 nodes RAC cluster.
• Installed, upgrade, configured oracle parameters, listener configuration Oracle 10g databases on
SUN, AIX LINUX & Win environment.
AMIR. Majeed
Page 2 of 7
• Performed & monitored all backups through RMAN on both physical disk & tape drive also
through export & import on both local disk and network drive/disk.
• Performed Oracle high-availability/disaster recovery products such as Data Guard.
• Managed & monitored large centralized or decentralized database systems about terabyte.
• Strong programming skills using T-SQL, PL/SQL and Unix Shell; thorough familiarity with
UNIX/Linux/Sun and Windows operating systems
• Wrote shell script (.ksh & .sh) for database full export, database full import, exports schemas,
import schemas, export tables, import tables and others.
• Configured shell script running through CRONTAB job.
• Created, managed, and used initialization files: PFILE and SPFILE.
• Performed multithreading/ multiprocessing by opening 300 threads at once.
• Performed explain plan, SAR and etc.
• Rebuild online Indexes and Indexes.
• Configured ARCHIVELOG mode & the Flash Recovery Area.
• Configured RMAN Persistent Settings & Backup Optimization.
• Enabled Fast Incremental Backup.
• Created an Oracle-suggested Backup & Duplex Backup Sets.
Blue Wolf Group, NYC, NY 07/05-12/08
Remote Oracle & SQL Server Database Administrator
Environment
• Oracle 10g, 9i, 8i, SQL, PL/SQL, SQL*Plus, TOAD, RMAN, SQL Server 2000, 2005
Enterprise Editions, Erwin 3.1, Visio 2000, Win 2003/ 2000/ XP, UNIX, AIX, LINUX, X-
Client.
Responsibilities as Oracle DBA
• Installed & Configured Oracle database 10g, 9i & 8i on Windows, UNIX, AIX, SUN, LINUX.
• Applied Oracle security patches, Current patches and CPU patches on Oracle databases.
• Wrote Oracle shell script (.ksh & .sh) for archive logs & trace files purged, check database
status, check listener status, check oracle agent status, check max extent fails, check next extent
fails, analyze tables & schemas, rebuild indexes online and others.
• Configured oracle database status alert, table spaces trash holds, listeners’ status alert and others
through Oracle management server (OMS).
• Wrote shell script (.ksh & .sh) for database full export, database full import, exports schemas,
import schemas, export tables, import tables and others.
• Configured shell script running through CRONTAB job.
• Created, managed, and used initialization files: PFILE and SPFILE
• Identified the various states of starting an instance & shutdown an instance
• Monitored Alert and Trace files.
• Used the Database Configuration Assistant to create a database.
• Created a database manually.
• Identified the uses and contents of the data dictionary.
• Used the data dictionary to retrieve information about the database.
• Multiplexed the control file.
• Managed control file with Oracle Managed Files (OMF).
• Maintained online redo log files.
• Managed online redo log files using OMF.
• Multiplexed and maintained online redo log files.
• Archived online redo log files.
• Created and managed table spaces.
• Created a table space & data files when using OMF.
• Maintained storage structures with automatic segment - space management.
• Maintained storage structures manually.
AMIR. Majeed
Page 3 of 7
• Managed automatic undo management and manual undo management.
• Created and Maintained tables using appropriate storage settings.
• Created b-tree and bitmap indexes.
• Maintained Indexes.
• Rebuild online Indexes and Indexes.
• Configured ARCHIVELOG mode & the Flash Recovery Area.
• Configured RMAN Persistent Settings & Backup Optimization.
• Enabled Fast Incremental Backup.
• Created an Oracle-suggested Backup & Duplex Backup Sets.
• Configured Control File Auto-backups.
• Managed Backups.
• Performed Complete Recovery.
• Performed Recovery Using Incrementally Updated Backups.
• Restored and Recovering the Database on a New Host.
• Restored the Server Parameter File.
• Restored the Control File from Auto-backup.
• Created an Initialization Parameter File for the Auxiliary Instance.
• Created a Duplicate Database.
• Used Enterprise Manager to Create a Duplicate Database.
• Performed Basic RMAN Table space Point-in-time Recovery.
• Configured the Recovery Catalog Database.
• Created the Recovery Catalog Owner & Recovery Catalog.
• Registered a Database in the Recovery Catalog.
• Manually Re-synchronized the Recovery Catalog.
Responsibilities as SQL Server DBA
• Installed & configured SQL Server 2005, 2000 & 7 on windows 2000, 2003 & XP and applied
a service pack.
• Upgraded from previous version SQL Server 2000 to SQL Server 2005.
• Created databases & transaction logs.
• Handling dynamic database growth for space management strategies.
• Attached & detached databases and moved databases.
• Used copy Database Wizard to Copy the databases.
• Build simple packages and Imported data from Access & exported a table to Excel.
• Experienced in installing, configuring, managing, monitoring and troubleshooting SQL
Server2005.
• Implemented SQL Server disaster recovery, backup/restore, migration, and upgrade.
• Configured the agent & setting up database mail.
• Created alerts & operators & associated alerts with jobs.
• Used DTS import/export wizard.
• Worked with the component of DTS packages.
• Copied & manipulated data using DTS.
• Used the Transfer data task and Bulk insert task.
• Extensive experienced with SQL Server T-SQL in constructing triggers, stored procedures, user
defined functions, views, indexes, relational database models, data integrity.
• Upgrade/Migration of MS SQL Server 2000 to MS SQL Server 2005 using any suitable
approach.
• Installed Microsoft Analysis Services & Report Services.
• Experienced in developing and monitoring SSIS, SSRS, and SSAS Packages.
• Run DBCC Consistency checks and fixed data corruption in user database.
Involved in Security Administration created users and assigned roles & privileges.
Managed Blue Wolf Client’s as a primary DBA
Oracle SQL Server
AMIR. Majeed
Page 4 of 7
• Armani – New York, NY • Auto One Insurance – Melville, NY
• Heineken – White Plains, NY • PDI Inc. – NJ/PA/IL
• Auto One Insurance – Melville, NY • Cooper health hospital – South Jersey
• PDI Inc. – NJ/PA/IL • Access Group – CA
• Russ Barrie – UK/USA/AUS/CAD
UCA Computer Systems Inc., Denville, NJ 05/04-06/05
Remote Oracle & SQL Server Database Administrator
•Oracle 10g, 9i, 8i, SQL, PL/SQL, SQL*Plus, TOAD, RMAN, SQL Server 2000 Enterprise
Environment
Editions, Erwin 3.1, Visio 2000, Win 2003/ 2000/ XP.
•Business Management Solutions (BMS)
Project
•Inventory Control and Financial Accounting Systems (GL)
Responsibilities as Oracle DBA
• Manage and monitor Archive logs and archive log destination directories.
• Manage and monitor backup directories for hot and cold backups, backup program output,
export output directories, export control cards, SQL*Loader control cards, SQL*Loader output
files, export output files and anything else that is created on a regular basis.
• Review and manage space reports (i.e. free space, extents, mount-points, directories),
performance reports, output from the backup process execution, output from data loads
(SQL*Loader, custom programs), alert log and trace files for errors, output from auditing and
complex administrative activities performed regularly.
• Monitor and configure naming conventions, server, database, table space, rollback segments,
online redo logs, tables, indexes, users, views, clusters, constraints, roles, profiles, outlines,
materialized views, database link, TNS-names alias entries, administrative support directories,
administrative support script output directories, administrative support output and report files
included the execution date.
• Follow OFA naming conventions to distribute I/O among different disk drives and DBA report
cards and their 360-degree review process.
• Monitor 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.
Responsibilities as SQL Server DBA
• Prepare Database Maintenance plans and Backup and restoration plans
• Manage all aspects of database administration, backup, disaster recovery, and security
• Create DTS packages to load data from excel to Production and Exp/ Imp. Used DTS from
Stage to Production
• Create replication terminology and replication plan, Implemented Transactional Replication
on Production server.
• Troubleshoot SQL Server Agent Jobs. Used SQL Server Agent to configured alerts and
operators.
• Worked as team member. Created a productive Development, Staging, and production
environment for application database. Processed new application database requests.
AMIR. Majeed
Page 5 of 7
Managed UCA Client’s as a primary DBA
Oracle SQL Server
• Spencer Gifts – Atlantic City
• AXA – NJC, NJ
• Cendant Group - Phoenix, AZ
• Reuters – NYC, NY
Verizon, NYC, NY 10/02-04/04
Oracle 9i & SQL Server Admin
• Oracle 9i /8i, SQL Server 2000/ 7,Forms 9i/6i, Reports 9i/6i, Web-DB, 9iAS, IBM AIX-4.X,
Environment
Erwin 3.1, Visio 2000, Win 2003/ 2000/ NT.
•
Project
Broadband Database Management System (BDMS) and DSL
Responsibilities as Oracle DBA
•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 like
Used Imp/ Exp utility for Logical backups and RMAN for Incremental physical file
system backups
Physical file system backup: offline backups and online backups.
Image-x Enterprise Inc., Santa Barbara, CA 07/01-09/02
Oracle Database Admin & Developer (Contract)
• Oracle 9i / 8i/ 8, Developer 6i/ 5 (Forms & Reports), Oracle Web-DB, SQL Server2000,
Environment
PLSQL, SQL Plus, T-SQL, LINUX (PostgreSQL-7.1 database), Erwin 3.1, Win XP/ 2000/ NT/
98.
Project
• E-Filing Courthouse System (ECHS). www.e-filing.com.
Responsibilities as Oracle DBA
• 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
AMIR. Majeed
Page 6 of 7
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.
Managed Image-x Enterprise Client’s as a primary DBA
Oracle
• Chelan County Court House – Santa Barbara, CA
• American Airlines – Dallas, TX
•
References Available upon request
AMIR. Majeed
Page 7 of 7
Contact this candidate