Oracle Sql Server
Resume:
MANSOOR TAJ
*************@*****.***
Summary:
Hands-on, business oriented, professional Oracle Database Administrator/Architect having extensive
years of experience in OLTP & Data Warehouse Environments using ORACLE 11g,10g, 9i, 8i, 8.x, and
7.x on multiple OS platforms. As a Professional DBA, have extensive experience setting up Maximum
Availability Architectures and Capacity on Demand Architectures using various products, protocols and
methodologies from Oracle including 10g Real Application Cluster (RAC), Data Guard, Grid Control,
Automatic Storage Management (ASM), Automatic Database Diagnostic Management (ADDM), RMAN,
Streams, Replication. Excellent Leadership skills, communication skills and the ability to influence cross-
functional teams through coaching and mentoring.
Extensive exposure in diverse and complex environments, using multiple database platforms like Oracle,
Microsoft SQL Server and Sybase. Perform heavy refreshes, implementation of high available solutions
like Replication, Mirroring, Log Shipping and Clustering in Microsoft SQL Server. Also perform and
implement Sybase Replication.
MAJOR TASKS PERFORMED:
Implemented Real Application Cluster and Data Guard.
Installed and Configured 10g Grid Control.
RMAN setup, implementations and strategies.
Disaster Recovery site setup.
Oracle Streams Configuration.
Database upgrades from 8i to 9i and 9i to 10g.
Application Tuning, Data Modeling.
Written shell scripts and Windows batch scripts.
SQL Server Mirroring setup.
Implementation of Log shipping and Replication.
Sybase Replication configuration and maintenance.
CERTIFICATIONS:
OCP - Oracle Certified Professional in Oracle 11g.
MCDBA - Microsoft Certified Database Administrator.
CCNA - Cisco Certified Network Associate.
MCSE - Microsoft Certified System Engineer.
Professional Experience:
Saks Fifth Avenue
Database Administrator
May 2010 - Present
Environment: oracle 11g/10g/9i, pl/sql, unix, sun solaris, linux enterprise,microsoft sql sever 2000/2005,
emc replication manager,toad,blue martini,endeca and channel net.
Project: Providing production database support to multiple environments including ecommerce website.
Responsible for:
• Design and implementation of four node oracle RAC on linux enterprise 5 and providing application
scalability and availability by implementing transparent application failover (TAF).
• Impelmentation of oracle10g RAC on windows environment..
• Troubleshooting all outstanding issues in oracle RAC and RMAN.
• Involved in the process of heavy data load and database refreshes.
• Fine-tune the heavy code to improve the response time and identify the performance bottlenecks in
data warehouse.
• Build up QA and UAT environments, using oracle cloning techniques through RMAN. Shell scripts are
designed to automate RMAN and expdp / impdp processes to refresh and build new environments..
• Extending the support for the existing projects and support for backend database clarify Tickets.
• Identifying heavy fragmentation in both tables and indexes and rebuilding them for optimum
performance.
• Supporting integration testing, system testing, and regression testing of various releases.
• Managing and administering ASM diskgroups. Adding new disks and removing and migrating files
across ASM diskgroups and filesystems.
• Building new oracle servers from scratch and applying bug patches and security patches for PCI
compliance.
• Extensive support of blue martini application and providing all kind of database support to fix and
upgrade the blue martini process.
• Administration and management of the microsoft sql database servers.
Cognizant Technology Solutions
JPMorgan Chase Bank
Sr Oracle/Sybase/Microsoft SQL DBA
Nov 2008 – May 2010
Environment: oracle 10g/9i/8i, pl/sql, unix, sun solaris, microsoft sql sever 2000/2005, sybase, toad and
dbartisan
Project: Providing database support to the multiple, financial, and trading applications on 24/7 basis.
Responsible for:
• Design and implementation of two node oracle RAC on sun solaris platform.
• Patching and Rolling Upgrades to oracle RAC, ensuring its 24/7 availability
• Resolving and addressing all issues related to RAC, Clusterware, ASM, Standby databases and
Backup and Recovery procedures using RMAN.
• Keeping an eye on the heavy batch jobs over night and refreshing QA and UAT environments with
replication and different data migration techniques like logical backups and RMAN backups.
• Fine-tune the heavy code to improve the response time and identify performance bottlenecks.
• Build up QA and UAT environments, using oracle cloning techniques through RMAN. Heavy refreshes
from prod environments are done through RMAN on remote servers.
• Promoting heavy code in all environments using yart packages and also with command base
procedures.
• Analysis of the pl/sql code and discussing the explain plan with developers and providing them
suggestions to improve the response time of slow performing queries.
• Upgradation of oracle environment from oracle 9i to oracle 10g and load testing and analyzing the
performance and behaviour of database with applications.
• Sybase replication was used to consolidate the data in this heterogeneous environments. Involve in
the troubleshooting and fixing of the replication errors and bottlenecks.
• Extending technical help and guiding the Junior Developers and assisting them in their database
related issues.
• Administration and management of the microsoft sql database servers.
• Technical support on ongoing projects in microsoft sql server 2000/2005. Involved in heavy refreshes,
backup and restore procedures and providing support in addressing and troubleshooting issues.
MISI Company
Genzyme Genetics
Oracle DBA Administrator
Jan 2007 – Nov 2008
Environment: oracle 10g/8i/7, pl/sql, unix, HP, microsoft sever 2005, microsoft net, web methods and
toad
Project: SMA, 6 color flow, molecular iSCOPE and AJ
genzyme genetics provides complicated testing services for hospitals, doctors and clinics. Everyday the
labs in various location receives thousands of blood, tissue, biopsy samples, this phase is accessioning.
The next stage is testing where the samples are subjected to various testing procedures and process as
per the client’s requests. The test results are sent to the customer either via mail or customers have a
facility to download from the web site.
Various systems are developed to support different test type. SMA project is for spinal muscular atrophy, 6
color flow is for testing the protein markers for cancer patients, UHC project is to upload the data to the
insurance company called united health care.
Responsible for:
• As an only database administrator on the Manhattan site, developed, designed and implemented the
database servers, objects and heavy data migration.
• Involved in the designing, implementation and maintenance of two node Oracle RAC on HP unix
environment.
• Implementation of oracle cluster software, oracle ASM, CRS, OCR and Voting Disk.
• Effective use of command line oracle utilities like EXPDP, IMPDP, CRSCTL, CLUVFY, SRVCTL and
NID.
• Company was practicing user managed backup and recovery procedures, involved in the conversion
of user-managed backup to oracle-managed backup using RMAN.
• Implementation of oracle data guard, by creating physical standby database in maximum
performance mode..
• Analysing performance issues, using statspack reports and explain plan chart.
• Oracle streams was used to consolidate the data in this heterogeneous environment. Involve in the
troubleshooting and fixing of the Stream errors and bottlenecks.
• Extending technical help and guiding to devlopers in addressing their issues like database locks and
blocking sessions.
• Promoting bill promotions, creating new objects, backup and recovery of database operations in
microsoft sql server 2005.
HD-Dimension
Hudson Valley Bank
Oracle DBA Administrator
Jan 2006 – Dec 2006
Environment: Oracle 10g/9.2, pl/sql, unix, linux, java, toad
Project: Credit decisioning system
From deposits and financing to investments and leasing, hudson valley bank has the products, services
and resources to help individuals and businesses achieve their financial goals. This system took care of
credit decisions pertaining to loan account.
Responsible for:
• Supporting production database developed in Oracle 9i & 10g
• Designing and planning migration of databases from oracle 9i to oracle 10g.
• Oracle patching and cloning oracle instances and applications.
• Responsible for all software release installs to test, training and production databases.
• Understanding technical requirement and approvals.
• Troubleshooting application errors and performance issues, including process simulation, to isolate
and identify issues; implement solutions to both short and long term issues; continued refinement of
issues.
• Gathering of both database and operating system metrics relevant to performance monitoring and
tuning.
• Supporting integration Testing, system testing, and regression testing of various releases.
• Resolving defects generated during various test phases
• Designing and developing pl/sql functions/ stored procedures/cursors/packages/triggers
• Tracing user sessions by enabling trace and determining wait events and poor application code.
• Implementation of oracle grid control for effectively administering and monitoring database instances
through html based integrated interface.
• Implementation of physical standby database as a disaster recovery solution.
East West Mortgage
Oracle DBA Administrator
Apr 2004 – Dec 2005
Environment: Oracle 9.2, unix, and windows
Project: CDS credit decisioning system
This project was developed, as a decision-making system. East West Mortgage has many loan products
for corporations, sole proprietor ownership organizations and for people with real estate. The system is
divided into two parts. The first part involves collection of data using the system developed in power
builder .The second part is known as CDS server side pl/sql engine for loan underwriting
Responsible for:
• Design and develop oracle databases
• SQL tuning and increasing the performance of queries.
• Support and maintenance of backend oracle packages.
• Tasked with replication of production oracle databases to create new test environments.
• Monitor oracle database storage usage and warn of impending issues.
• Tracing sessions and running tkprof to get statistics to improve performance of applications and
identify bottlenecks.
• Involved in designing the logical and physical model of database objects using erwin.
• Normalization of the data models for the applications
• Involved in migration of databases from one version to another version
• Worked with toad for ddl extraction and session monitoring.
• Designed and developed stored procedures/packages/triggers
• Involved in performance fine-tuning of the queries/report using pl/sql.
• Involved in writing complex queries to generate ad-hoc reports as per client request as a part of
production support
• Conducted requirements gathering meetings to determine how to integrate the operational data store
feeds into the data warehouse
• Assisted in the design and creation of data architecture, data modeling requirements and reporting
criteria for the data warehouse
Education:
• Master of information technology from american intercontinental university (AIU online) Illinois
• WAN Diploma - computer career school, garden city, new york
Training Attended:
• Proposal writing: 2 day training program conducted by hd-dimension.
• Software project planning: Attended a 1-week training program.
• RAC Training: Attended 5 days training program on orace RAC – Real Application Cluster
• Oracle APPs 11i Training: Attended two weeks training online from India
Contact this candidate