Manager Oracle
Resume:
Title:Information Systems Specialist
****@******.***
Document
Source below
NAME: Appa Chaudhari
ADDRESS: **** **** ********,#***
CITY: Hayward
STATE/PROVINCE: CA
ZIP/POSTAL CODE:
COUNTRY: USA
EMAIL: ****@******.***
PHONE: 510-***-****
CANDIDATE ID: 113119
CITIZENSHIP: Permit
EDUCATION: Bachelor Degree
EXPERIENCE: 0
WILL RELOCATE: Yes
RELOCATION INFO:
JOB WANTED: Any
RATE NEEDED:
HOMEPAGE:
COMMENTS: Dear Sir/Madam:
My background includes Bachelor's Degree in Computer Science & Engineering,
coupled with over eleven years experience in IT industry as Oracle Database
Administrator (8i/8.x/7.x), Data Modeler and Developer. I have done OCP
certifications in Oracle 8i DBA. My proven track record makes me an ideal
candidate for the job. My resume is attached for your review. You will find
that my qualifications and experience perfectly meet your requirements.
I am available for telephone interview or an in person meeting at your
convenience. I look forward to hearing from you and thank you for your
consideration.
Sincerely,
Appa Chaudhari
HOTSKILLS: Oracle DBA/Application DBA/Data Warehousing
ESUME
APPA CHAUDHARI
Oracle 8i Certified Professional Database Administrator
2416 West Tennyson Road, # 301,
Hayward,CA,94545
****@******.***
PROFESSIONAL SUMMARY:
-Over 11 years solid experience including 9+ years current experience as Oracle
Database Administrator (Oracle 8i/8.0.5/7.x) on Unix (Sun Solaris, HP UX, AIX,
Linux, SCO) and Windows NT platform. Solid understanding of core DBA functions.
-Experience in Oracle 11i Applications installation, configuration, system
administration, implementation and support. Understanding of ERP systems.
-Experience in Data Modeling, Data Warehousing, Application Development and
Support.
-Experience in providing 99.99% availability of the system using High
Availability cluster hardware, software and Oracle Parallel Server.
Successfully maintained multiple, very large size databases.
-Experience in Replicating Oracle Databases. Created and maintained standby
databases.
-Expert in backup and disaster recovery. Implemented RMAN (Recovery Manager).
-Solid experience in performance tuning (initialization parameters, SQL
Statements, I/O).
-Expert in shell scripting.
-Migrated Oracle Databases from Oracle 7.3.2 to 7.3.4, Oracle 7.3.4 to 8.0.5,
Oracle 8.0.5 to 8.1.7.
-Experience in installation and configuration of apache web server.
-Experience in Unix System Administration.
SKILLS:-
RDBMS:-Oracle 9i/8i(8.1.7)/8.1.6/8.x/7.x, MS SQL Server 2000,MY SQL.
APPLICATIONS:-Oracle Applications 11i/ 11.0.3/10.7 SC, Oracle Web Server
OPERATING SYSTEMS:-Solaris 8, HP UX 11.0(64 bit), Red Hat Linux 7.0, SCO Unix
5, IBM AIX 4.X, Windows 2000/NT 4.0, MS-Windows for Workgroup3.11, Novell
NetWare 2.0
LANGUAGES:-SQL*Plus, PL/SQL, Shell Script, Perl, C++, C, Java, Fortran, Pascal,
Visual Basic, Cobol.
SOFTWARE:-Oracle Enterprise Manager, HP Open View, Recovery Manager, EBU,
Veritas Netbackup, Legato backup, Omniback, Advanced Replication, Oracle
Parallel Server, PVCS, Forms 6i, Developer 2000, SQL*Forms, SQL*Menu,
SQL*ReportWriter, Export/Import, SQL*Graphics, ODBC, XWindows, Portal (WebDB),
Crystal Reports, SQL*NET, Broad vision, Spot Light, I/Watch, MC Service Guard,
HTTP Server, Apache Server, SQL Windows 5.0, SQL*Loader, MS Access, TCP/IP
(Telnet, FTP) & X.25.
DATA WAREHOUSE/ DATA MODELING:-Informatica, ERwin, Designer 2000, Visio,
Process Modeler, ER Diagrams, Data Flow Diagrams.
HARDWARE:-HP 9000(64 bit), Sun Netra t1, t1125, t1405, Ultra E250 / E450,
E3500, E4500, FC-60 disk array, HP Net server LX Pro, Dell power edge XE 590-2
Server, Dell PC, Compaq PC, Ethernet LAN, VSAT.
EDUCATION AND TRAINING: -
Bachelors Degree
in Computer Science & Engineering, August 1990.
Oracle8i Server Database Administration, Backup and Recovery, Network
administration, Performance tuning, high availability clustering solution
MC/Service Guard Implementation, I/Watch.
PROFESSIONAL CERTIFICATION: -
Oracle 8i Certified Professional Database Administrator OCP, January 21,
2001. ORACLE CORPORATION and SYLVAN Prometric Testing.
Experience: -
Visfinity, San Carlos, CA
Senior Oracle Database Administrator
February 2001 Till Now
-Replicated Oracle databases in production machine.
-Actively involved in maintaining the production system as well as
troubleshooting production related problems.
-Tuned application using SQL_TRACE, TKPROF and EXPLAIN PLAN. Incorporated
hints, rewritten queries, analyzed statistics so as to avail COST based
optimization.
-Wrote shell scripts for automatic logical backup, hot backup, cold backup,
disk space & table space monitoring, database availability, generate
statistics, automatic startup & shutdown of database.
-Implemented recovery manager (RMAN). Created recovery catalog. Written RMAN
scripts to perform automatic full and incremental backup. Tuned backup for
performance by parallel zing channel allocation. Performed complete and
incomplete recovery using RMAN.
-Configured & created hot stand by database for production environment.
-Responsible for database security including design, access control and
maintenance.
-Performed database tuning for better performance on server including SGA
allocation, I/O distribution. Removed fragmentation, chained and migrated rows.
-Designed logical and physical databases (OFA Compliance). Reviewed description
of changes to existing database design to understand how changes will affect
physical database (how data is stored in terms of physical characteristics such
as location, amount of space, and access method).
-Configured Intelligent Agent and Oracle Enterprise Manager on a Unix box to
monitor all databases and performed advanced diagnostics and tuning.
-Performed Capacity Planning. Monitored space used in the database, and planned
future growth.
-Installed Broad Vision. Created database repository schema for Broad Vision.
-Written triggers, functions, procedures and packages using pl/sql and dynamic
sql for system business rules and system security.
-Installed Oracle 8.1.7 on Sun Solaris UNIX servers. Configured apache web
server.
ENVIRONMENT: Sun Solaris 8, Oracle 8.1.7, Oracle Apps 11i,Windows 2000,
Legato backup, PL/SQL, Java, Oracle Enterprise Manager 2.2, Recovery Manager,
Shell Script, Broad Vision, I/Watch, Sun E250 / E450.
COMPANY:- INTELIANT CORPORATION, Cupertino, CA
CLIENT: -
WHITE PJ Inc
., Hayward, CA
Senior Oracle Database Administrator
May 2000January 2001
-Installed and tuned Oracle apps 11i (11.5.x). Complete understanding of Apps
schema. Helped developers in interfacing to Apps from the local applications.
-Performed System Administration of Oracle Applications. This included creating
users, Registering printers, and Monitoring Concurrent Managers. Applied
patches.
-Configured & created database on fail over clustered hardware using MCI
Service Guard. Tested and implemented high availability solution using HP MC
Service Guard, Oracle Parallel Server.
-Integrated and configured RMAN (recovery manager) with HP Open View Omniback
II. Created recovery catalog. Taken backup of recovery catalog. Written scripts
for automatic backup and recovery using RMAN. Tested database, tablespace and
datafile recovery using RMAN.
-Identified the requirements from Engineering team, put into logical data model
in Erwin, converted into physical model by introducing physical objects, and
defined the volumetric for Call Center, Contact Management, FAQ, Self Services
and CRM application. Also, defined the data models for WPJ information systems
like Billing, Provisioning, Subscription, Collection, and Customer Management.
-Configured and monitored database using HP Openview.
-Configured Disk Array for Oracle Database. Planned for future storage
requirements.
-Wrote shell scripts for automatic backup, disk space & tablespace monitoring,
database availability, generate statistics, startup & shutdown of database.
-Performed database tuning for better performance on Server including SGA
allocation, I/O distribution, Fragmentation, Row Chaining.
-Application Tuning using SQL_TRACE, TKPROF and EXPLAIN PLAN.
-Managing Schema Objects - Tables, Views, Sequences, Synonyms, Indexes, and
Clusters.
-Contacted Oracle Corporation for technical support. Applied Oracle 8.1.6.2
patch.
-Designed and Developed Database Triggers, Packages, Procedures and Functions
using PL/SQL.
ENVIRONMENT: HP UX 11.0, HP 9000 Series (64 bit), FC-60 Disk Array, Oracle
Apps 11i,Oracle 8i(8.1.6), HP Open View, Omni back II, Windows NT/2000, Forms
6i, PL/SQL, Shell Scripts, Oracle Enterprise Manager, Recovery Manager,
Export/Import, SQL * Net.
CLIENT: -
Northpoint Communications, Emeryville, CA
Oracle Database Administrator
January 2000 - May 2000
-Replicated databases using shareplex and shell scripts.
-Involved in designing and implementing table partitions. Largest table
contained over 100 million rows.
-Implemented recovery manager for backup and recovery. Disaster recovery
planning. Drawing disaster recovery plans and tested backups periodically on
test server. Ensured proper recovery of database in case of a problem.
-Designed and created data warehouse (star schema) for reporting module of
application and transactional schema. Used Informatica ETL tool for migrating
customers data into data warehouse.
-Performed tuning of Application SQL queries using explain plans and trace
files. Worked closely with developers to help address any application
performance issues.
-Proactively run bstat and estat scripts for capturing a snapshot of system
wide database performance statistics and analyzed the output file report.txt
that is generated and adjusted init.ora parameters.
-Written shell script, which monitors alert log file and free space for
archived log files in file system. Monitored and tuned rollback segments, redo
log files.
-Extensively used Export/Import utilities for selective backup transferring
tables between Oracle instances, and also for de-fragmentation.
-Wrote shell scripts for automatic logical backup, hot backup, cold backup,
startup & shutdown of databases.
-Enrolled users and maintained system security. Managed user privileges, roles
and profiles.
ENVIRONMENT:-Solaris 2.6,Oracle 8.1.5/8.0.5, Windows NT 4.0, EMC Disk Array,
Perl, Veritas Netbackup, PL/SQL, Oracle Enterprise Manager, Recovery Manager,
Siebel, Shareplex, Export/Import.
COMPANY: -NATIONAL INFORMATICS CENTRE, MUMBAI, INDIA
CLIENT: -TRADE MARKS REGISTRY, MUMBAI, INDIA
Senior Oracle Database Administrator
April 1996 - December 1999
-Complete understanding of Oracle Apps schema. Helped developers in interfacing
to Apps from the local applications.
-Performed System Administration of Oracle Applications. This included creating
users, Registering printers, and Monitoring concurrent Managers. Applied
patches through ad-patch utility.
-Set up and managed development, integrated test, and production environments
to support a full life-cycle development methodology with configuration
controls.
-Migrated from Oracle Apps 9.4 to 10.7SC.
-Replicated databases using snapshots, shell scripts, import & export.
-Actively involved in the Development of Data Warehousing Project, based
on Star Schema Dimensional Model and used Data Modeling Tools Designer 2000.
-Evaluated options for getting data from extract program to Data Warehouse.
-Migrated of oracle database and application from DELL Power Edge to HP LX
Server.
-Carried out successful upgrade of Oracle from 7.3.2 to 7.3.4 and 7.3.4 to 8.0
for the production database.
-Configured Parallel Query Option to check the response of application.
-Changed the init files parameters & configured Instances to optimize response
time.
-Performed configuration and tuning of database storage parameter for
tablespaces and related tables. Done table & index partitioning.
-Allocated system storage and planned future storage requirements.
-Written shell scripts for backup of database.
-Worked with the developers & did PL/SQL optimization. Used EXPLAIN PLAN.
-Extensively used Export/Import utilities for selective backup, transferred
tables between oracle instances and to remove defragmentation.
-Administration of oracle database and supervision of DBA activities at various
office locations.
-Co-ordinated with departmental heads and software developers to provide
necessary specifications and testing of the modules. Created ERD and DFD
diagrams for the revised system.
-Enrolling users and maintain system security. Managing user privileges, roles
and profiles.
-Tested modifications of application on test database and then ported onto the
production server.
-Performed maintenance related to creation /alteration of tables, indexes,
users, tablespaces and data files.
-Configured disk array for RAID level 5. Installed Oracle, Unix and application
packages.
ENVIRONMENT: SOLARIS 2.5, WINDOWS NT 4.0,Oracle Apps 10.7,ORACLE 8/7.3.4,
PL/SQL, SQL Windows 5.0.1 (Centura), Pro*C, Visual Basic, Forms 4.5,TCP/IP,
Export/ Import.
COMPANY: -
TECHNICAL AND HIGHER EDUCATION, MUMBAI, INDIA
Oracle Database Administrator
October 1995March 1996
-Performed Installation, Maintenance, Tuning, Security, Backup and Recovery on
all QA and Development Servers.
-Created databases, tablespace, users & allocated resources to users.
-Monitored system health, data base health.
-Translated logical data model and likely queries into a physical design.
-Designed of SQL*Loader control files. Written stored procedure. Designed
format of data entry records for contractors.
-Analyzed, designed and developed systems such as Library Management, Hostel
Management, Payroll, Stores Management, Student & Staff track record, Result
Analysis and Admission Processing.
-Developed PL/SQL script for generating error report and populating error free
data into various tables of database.
ENVIRONMENT: Oracle7.0, SOLARIS 2.5, SQL*Net, PL/SQL, FORMS 4.5, C, C++, Visual
Basic
COMPANY: - AMRUT ENGINEERING, INDIA
Oracle Database Administrator /Data Modeler/Developer
August 1990 -
September 1995
-Performed data replication using triggers and snapshots.
-Created user accounts and monitored system security. Wrote Unix scripts for
hot backup, logical backup and cold backup.
-Developed tools in C for Normalization of database. Developed packages,
procedures, and triggers.
-Designed and developed Order Processing & Inventory Control System, Payroll
and Attendance Recording System, Image Management System.
-Constructed and documented data decomposition diagrams and data flow diagrams.
-Resolved database capacity issues.
-Performed Data loading, Migration, Performance tuning of Application, SGA &
I/O.
-Performed configuration of Unix kernel parameters for Oracle.
-Configured tnsnames.ora and listener.ora, ODBC for database connectivity.
-Installed Unix, Created Unix Users. Installed and upgraded the Oracle 7.x
server.
ENVIRONMENT:- Oracle 6.0/7.0, FORMS 4/4.5,SQL*PLUS, PL/SQL, SQL DBA, UNIX, C,
C++, PASCAL, FORTRAN, VISUAL BASIC, COBOL.
References: Available upon request.
Contact this candidate