Manager Oracle
Resume:
Sapna R. Desai ***********@*****.***
Residence: 732-***-****
Parlin,
NJ 08859
PROFESSIONAL SUMMARY
Around ten years of experience as an Oracle Certified DBA.
Good experience in data analysis/modeling, database design vis à vis development and subsequent
implementation to support multipurpose business applications for various companies.
Performed various rigorous Data modeling, resolving the complicated Architecture Design, and thereby
mounting the most efficient Oracle Database system.
Extensive experience in setting up a High Availability Architecture using various aspects of Oracle database
administration protocols including 11g RAC, Data Guard including performance tuning,
backup/recovery (RMAN), Streams Replication.
Good interpersonal Communication Skills and a good Team player with activities and timelines.
Ability to manage and execute multiple projects in high pressure, dynamic environment with critical time
lines.
Good experience in System analysis and design and managing multiple projects in a fast paced environment.
Good experience in Sizing of Databases and reviewing estimates.
Strong leadership qualities with ability to define individual and shared goals for teams and growth path for
individuals.
Excellent business writing, oral communication and presentation skills.
CERTIFICATION
Exams Passed Month & Year
Of Passing
Oracle 9i OCP Certification April to Jan 2005
Oracle 10g OCP Certification Dec 2007
Oracle 11g OCP Certification Feb 2010
EDUCATION
• Bachelor Of Computer Application
TECHNICAL PROFICIENCY
LANGUAGES C, C++, Java 2.0, UNIX, RED Hat Linux 6.2(Santiago)
RDBMS Oracle 10g, 11g
BACK END TOOLS Oracle 10g, Oracle 11g, MS Access
FRONT END TOOLS Visual Basic, Java
WEB TECHNOLOGIES HTML 4.0, JavaScript 1.2, ASP 3.0, PhotoShop, Flash
REPORTING TOOLS Seagate Crystal Reports 8.0, Data Reports, Active Reports
DATABASE TECHNOLOGIES Streams, Recovery Manager, Advanced Replication.
ORACLE TOOLS/UTILITIES SQL*Plus, DBCA, OEM, ORADIM, ORAPWD, ANALYZE, DBVERIFY,
LogMiner, RMAN, Exp/Imp, UTLBSTAT, UTLESTAT, SQL Trace, TKPROF,
Oracle Net Manager, SQL*Loader, TOAD, Oracle Performance
Manager, Oracle Management Server
PROJECT DETAILS
Marketaxess (Midtown NY) Mar 2008 till date
Senior DBA
Environment: Linux, Oracle 11203 (SQL*Plus, EXPDP/IMPDP, OEM 11g and 12c)
• Providing 24/7 support as a production DBA and performing various maintenance activities over the
weekends and off hours.
• Worked on several database upgrades from 10g to 11gR2.
• Worked extensively on 11.2.0.3 RAC databases.
• Upgraded OEM from 11g to 12c recently.
• Configured and setup Oracle Streams and handled Streams related issues several times.
• Performance tuning the databases, Memory & I/O. Using AWR, ASH and ADDM to extensively diagnose
database related issues.
• Doing day to day monitoring of the databases like space issues, backup issues.
• Worked extensively on Oracle Streams, resolved Streams related issues/errors.
• Providing SQL Server DBA support whenever required.
• Worked on building replication from SQL server to Oracle several times.
• Performed several RAC installations from scratch by allocating/managing LUNS on the storage level.
• Applying latest PSU patches semiannually in all the environments.
• Working continuously with the developers in order to tune various slow running queries in the database and
also helping them out with any kind of issues. Using sql tuning advisors and sql profiles in order to get the
best explain plan.
• Working on Golden Gate implementation at this moment.
Citigroup (Long Island City NY) Jan 2007 till Feb 2008
DBA
Environment: Unix, Oracle 11g/10g/9i/8i (SQL*Plus, SQL*Loader, EXP/IMP, SQL*Net, Net*8, ODBC, OEM),
TOAD 8.6
Performing ISA activities on several databases.
•
Performing several releases. Generated scripts in order to automate the backup process.
•
Maintaining auditing and security in the databases. Monitoring failed login attempts on daily basis
•
Generating User Entitlement Reports and forwarding them to the Business people to review.
•
Monitoring the database activities, structural changes in database and resolving space issues.
•
Applying patches on databases.
•
Installing 10g database and applying patch set on it in order to upgrade to 10.2.0.3 version.
•
Taking care of upgrading and migrating the databases.
•
Performance monitoring and tuning of Database, Memory & I/O. Extensively used tools such as Oracle
•
Enterprise Manager, SQL*Lab, STATSPACK, EXPLAIN PLAN and SQL TRACE, TKPROF.
Database Migration from 9i to 10g and 10g to 11g.
•
IBM Jun 2006 till Dec 2006
(End Client: Sanofi Aventis Pharmaceutical Company)
DBA
Environment: Windows 2K, Unix, Oracle 10g/9i/8i(RMAN, SQL*Plus, SQL*Loader, EXP/IMP, SQL*Net,
Net*8, ODBC, OEM), TOAD 8.0
Building procedures in PL/SQL in order to smooth flow of data in tables. Created a procedure to normalize a
•
table.
Working on software called Remedy and Manage Now
•
Handling database issues
•
Taking backups through RMAN
•
Performance and Tuning of Databases.
•
RMAN setup. Database Migration from 8i to 9i and 9i to 10g.
•
Backup and Recovery procedure implementation
•
Resolving space monitoring issues
•
Worked on Server Consolidation Project wherein several servers were consolidated to fewer servers in order
•
to perform cost savings. Here lots of databases were migrated to new Linux Boxes configured in order to get
rid of problematic servers. Maintained a Server Mapping sheet wherein all information related to Servers,
databases and application information was present.
Worked on SOX complaint databases. Prepared documentation on procedures, scripts and reports run on all
•
SOX servers.
Extensive use of SQL* Loader
•
Applitech Solutions Pvt. Ltd. Jan 2005 to Sept 2005
(International Software Developing Company)
DBA (Oracle 9i)
Environment: Windows 2K, NT, Oracle 9i/8i(RMAN, SQL*Plus, SQL*Loader, EXP/IMP, SQL*Net, Net*8,
ODBC, OEM), TOAD 8.0
Responsibilities:
Installation and configuration of Oracle 9i database in all environments, which includes development,
•
Testing and Production.
Migration from 8i to 9i database server.
•
Disaster Recovery site setup including installation, configuration and maintenance using Physical Standby.
•
Maintenance of Database (Production, Test and Development) using event, job scheduling through OEM.
•
Performance monitoring and tuning of Database, Memory & I/O. Extensively used tools such as Oracle
•
Enterprise Manager, SQL*Lab, STATSPACK, EXPLAIN PLAN and SQL TRACE, TKPROF.
Implemented an Effective Backup and Recovery strategy for hot backups, cold backups and logical backups.
•
Extensively used RMAN (Oracle Recovery Manager) for Backup and Recovery.
GAD
(Government Office)
DBA (Oracle 9i and Oracle 10g)
Environment: Windows 2K, NT, Oracle 10g/9i/8i(RMAN, SQL*Plus, SQL*Loader, EXP/IMP, SQL*Net, Net*8,
ODBC, OEM), TOAD 8.0
Responsibilities:
Performed Daily tasks like running scripts to prevent row chaining, dropping unused indexes, computed
•
statistics of tables as well as indexes.
Extensively used STATSPACK report in order to gain knowledge of database performance and according tune
•
the database
Oracle Streams Configuration and implementation amongst live databases at different servers.
•
Regularly took backup of databases through RMAN as well as through export/import utility
•
Replication Server on multiple environments.
•
RMAN setup.
•
Backup and Recovery procedure implementation, Resource and space monitoring.
•
Indoswiss Infotech Pvt. Ltd Feb 2002 to Dec 2004
Responsibilities as a DBA:
Installation of Oracle software on Windows server.
•
Database Creation, Parameter Assignment in init file or session level assignment; database startup and
•
shutdown process. Database configuration on parameter file and operating system file.
Database User Creation with limited rights as per specific module under specific client. Creating roles and
•
profiles as per system study and assign to users.
Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc.,
•
configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and
effective management of Oracle networking. Configured listener for external procedure calls.
Database backup & Recovery with export and import for non archive database.
•
Creation of database objects like Tables, Indexes, Views, Users, etc.
•
Oracle SQL*LOADER, Oracle Export/Import Tools and utilities.
•
Established Oracle database connection for Java Based application using ODBC Drivers & Net8 based on
•
TCP/IP.
Provided guidance for developers in writing and tuning PL*SQL stored procedures and SQL queries.
•
Developed PL*SQL stored procedures, Indexes, cursors and database triggers to implement business rules.
•
Managing table spaces, user profiles, indexes, storage parameter’s.
•
Project:
OIL MILLS ERP
Work: VB Programmer Cum DBA
Environment: Windows 2K, NT, Oracle 9i/8i(RMAN, SQL*Plus, SQL*Loader, EXP/IMP, SQL*Net, Net*8,
ODBC, OEM), TOAD 8.0
Responsibilities:
Performed Daily tasks like running scripts to prevent row chaining, dropping unused indexes, and computing
•
statistics of tables as well as indexes.
Took Backup of the Database at regular intervals through RMAN (Recovery Manager)
•
Did performance and tuning of the database
•
Disaster Recovery site setup including installation, configuration and maintenance using Data Guard.
•
Database Migration from 8i to 9i and 9i to 10g.
•
Setup and configured Oracle Streams on 10g.
•
Project Description:
• The software created included Master forms such as Accounts, Assets, Bill of materials, Inward Weigh Bridge
Entries, Outward Weigh Bridge Entries, Item Master, Item Opening Balance, Account Opening Balance, Posting
in Ledgers, Cash and Bank Entries, Stock Opening Balance, Stores Masters and stuff like that wherein the
User needs to enter details.
• Lots of parameter forms like Currency, Port, Ledger, ABC code, Discount, Packing Master, Rate Master as well as
utility which created which were useful for the front end users.
• Import and Export was also taken into consideration and apart from all of it maintenance of the project was also
done.
• Reports were created in Seagate, which were very accurate and varied according to the data.
Project:
FINANCIAL MANAGEMENT SYSTEM
Work: VB Programmer Come DBA
Environment: Windows 2K, NT, Oracle 9i/8i(RMAN, SQL*Plus, SQL*Loader, EXP/IMP, SQL*Net, Net*8,
ODBC, OEM), TOAD 8.0
Responsibilities:
Taken Care of Oracle Net connections present in environment using net manager.
•
Took dumps through Export/Import utility on daily basis
•
Made necessary triggers using TOAD which were used in the application
•
Read only Database Setup for International users.
•
Improved the structure of database by applying referential integrity constraints.
•
Project Details:
It included master forms like Commodity Master, Contract Master etc. Normal transactional forms as well as
Utilities, which provided Back Up and Recovery, Data transfer from an old to a new year. The project was translated into
Gujarati as per the requirement of staff..
Project:
HOSPITAL MANAGEMENT SYSTEM
Work: VB Programmer Cume DBA
(Lead Role Performer of Project)
Environment: Windows 2K, NT, Oracle 9i/8i(RMAN, SQL*Plus, SQL*Loader, EXP/IMP, SQL*Net, Net*8,
ODBC, OEM), TOAD 8.0
Responsibilities:
Used Oracle Enterprise Manager and other tools to create referential as well as other integrity constraints.
•
Created views, which were useful to increase efficiency of user made queries.
•
Took cold as well as hot backups of the database
•
Upgraded different environments to Oracle 9.2.0.4/5/6
•
Made necessary triggers using TOAD which were used in the application
•
Project Details:
This project includes the requirement of a Hospital. All details required for smooth functioning of a hospital are provided.
Forms, which include Doctor as well as patient details, are designed and developed. Appropriate help files are also provided
where necessary. Seagate crystal reports that include personal details of patients and doctors are designed and formatted
which gets updated by an entry of each newly admitted patient.
Project: Law & Order
Work: VB Programmer
(Front End: VB 6.0 and Back End: MS Access)
A live project handled at company named Indo Swiss InfoTech. It was prepared using Visual Basic as front end and
access as back end. It was a full time project for 3 months.
• The system prepared, handles various types of cases in an organization.
• It stores data in an efficient manner and answers the requested queries.
• Reports are prepared which give significant information periodically.
STATUS: Green Card Holder
Contact this candidate