SHALEEN GARG
(234 Escuela Ave. #34 Mountain View, CA 94040)
Tel: (650) 962-8393 E-mail: shaleen@bigfoot.com
OBJECTIVE
Seeking a
position as Database project manager, DBA Manager/Team Lead in a
challenging environment, where I can provide value addition utilizing my
expertise and problem solving & analytical skills
SUMMARY
7+ years
of experience with 24/7 Oracle database administration. Experience in designing
and administering very large mission critical 24/7OLTP/ Data warehouse
databases (>500GB in size and >100Million transactions). High expertise
in database tuning, administration, migration and backup & recovery.
Experience with Oracle Financials administration. I have in-depth knowledge of
Relational Databases, analysis, design & development of databases for
business applications, Partitioning, Parallel processing, Disaster Recovery and
Replication. Good interpersonal skills, self-motivation and quick learning are
my particular strengths
SKILLS PROFILE
Relational Databases
Oracle
RDBMS 7.x – 9.x
Software
SQL *PLUS,
SQL Loader, Server Manager, Enterprise Backup Utility (EBU), Recovery Manager
(RMAN), Oracle Enterprise Manager (OEM), Quest Production Availability Suite
(I/Watch, Space Manager, Spotlight on Oracle, SQLab Expert), BMC Patrol, SQL
Navigator, Pl/sql Developer, Oracle Financials, SQL *Net 1.x - OracleNet,
Browser, Oracle supplied database packages, Procedure Builder, Oracle Terminal,
Developer /2000 2.1 (Forms 5.0, Reports 3.0), Developer /2000 1.x (Forms 4.5,
Reports 2.5), ADSM/ TSM, ERWIN, Schema Manager, Legato Storage manager, Veritas
Netbackup, Veritas Cluster Server, Veritas Database Edition, Veritas Volume Manager
Programming Languages
PL/SQL,
UNIX shell scripting, JAVA, C, C++, PRO *C, Windows SDK,
Operating Systems
Sun
Solaris 6-8, Digital Unix 4.0x, 3.2, HP UX 11.0, Windows NT
System Analysis, Design and Development
Requirement
Analysis, Process Modeling, Data Modeling, System Design, Development, Client
Server Architecture, Testing
CORPORATE EXPERIENCE
Walmart.com |
Lead DBA |
Aug’01 – Present |
|
Ventro Corporation |
DBA Manager |
Aug’00 – Aug’01 |
|
Apple Computers |
DBA Team Lead |
Mar’00 – Aug’00 |
(Rapidigm Inc.) |
DirecTv Inc. |
Senior Database Administrator |
Aug’98 – Feb’00 |
(Rapidigm Inc.) |
DirecTv Inc. |
Analyst/Programmer & DBA |
Oct’97 – Aug’98 |
(Rapidigm Inc.) |
Tata Consultancy Services |
Analyst/Programmer & DBA |
Aug’95 – Oct’97 |
|
EDUCATION & CERTIFICATION
·
Oracle Certified DBA for Oracle9i & Oracle8i
·
Certificate of achievement Business Management I
·
New Features for DBA’s in Oracle9i Training (5 days)
·
Oracle8 Network Administration Training (2days)
·
Oracle8 Backup & Recovery workshop Training (5 days)
·
Oracle Certification for Developer/2000
·
Certificate Course in Advanced Java Programming (10 days)
·
Bachelor of Engineering, Honors (Computer Science) from
Allahabad University, Motilal Nehru Regional Engineering College Allahabad,
India
WORK EXPERIENCE
DBA Mentoring, Management & Project Management
·
Mentored teams of 5 –7 DBA’s/ Database
developers, performing Resource allocation & Management in several
positions
·
Lead & Implemented many DB projects with great
detail, on time and under budget. Few examples are Oracle9i Migration,
Disaster Recovery implementation, DB Security, Catalog & OMS application
tuning, Performance tuning of all international DB’s etc.
·
Established database policy, standards and strategies
·
Investigation of new technologies and future system
requirements
High Availability & Disaster Recovery
·
Provided true 24x7 operational support for Oracle
instances running on SUN Enterprise (10000,6500,4500), HP (G/H/K Class) and IBM
RS/6000 servers. These were true mission critical databases for Wal-Mart,
Apple, DirecTV & Ventro having serious financial implications for
even the smallest downtime
·
Troubleshooting the
problems/issues at production database
·
Tested, configured, and deployed high availability
solutions utilizing:
o
System management tools -- Quest Availability Suite, BMC
Patrol, Oracle Intelligent Agent, Data Gatherer and Enterprise Manager (OEM)
o
Multi-node fail-over clusters utilizing Veritas Cluster
Server and Veritas Database Edition
o
Proactive monitoring and tuning of database instances
o
Enterprise backup solutions utilizing Oracle Recovery
Manager (RMAN) in conjunction with Legato Networker, Veritas NetBackup, IBM
ADSM and HP OmniBack media management software
·
Designed and implemented disaster recovery site for
Walmart.com. Implemented 8 Oracle Hot Stand-by Databases using oracle9i
Dataguard to replicate 400 GB/ day of redolog over a distance of 2000 miles
with high latency due to lack of dedicated link
·
Evaluated backup and recovery needs and strategies.
Performed online as well as offline backups. Used utilities such as export,
import, recovery manager and Sqlldr. Integrated logical and physical backups
·
Performed complete recovery of production databases
in several scenarios using various techniques including latest flash-back query
Performance Tuning & Enterprise Monitoring
·
Performed extensive database and application/sql tuning.
For example on one occasion increased order-processing capacity by 700%
and on another occasion reduced logical reads done by database from 35 TB/day
to 6 TB/day. Many times increased efficiency of specific functions by more
than 1000%
·
Tuned and optimized databases (Initialization parameters, Latches, Waits,
Locks, Memory/ disk reads), SQL code tuning with utilities such as Explain
Plan, TK*Prof etc
·
Evaluate, recommend, configure and implement enterprise-monitoring
software. Implemented Quest Software database management suite of products:
these include I/Watch, Space Manager, Instance Monitor, and SQLab Xpert, Oracle
Enterprise Manager, BMC Patrol Application Management tools etc.
Security, Administration and Migration
·
Performed enterprise-wide database security implementation
and enforced many checks & balances to improve auditing, security and
password protection
·
Performed capacity planning, space/growth management
and forecasting to ensure smooth operation
·
Installed/upgraded/patched oracle software and databases
·
Planned, tested and successfully performed oracle8i to
oracle9i, oracle8 to oracle8i and oracle7 to oracle8 migration with
minimum downtime
·
Various database administration activities such as the
creation of database, oracle users, roles, privileges, Tablespaces, Rollback
Segments, Redo Logs, database objects and maintenance of the same, Database
Replication/ Refreshing, PL/SQL Store Procedure, Triggers, Shell Script etc.
·
Developed database monitoring scripts (fragmentation
of tables, tablespaces, extents, segments, alert and trace files etc.) using
shell scripts
·
Administered VLDB’s with special attention and
partition & parallel processing.
Modeling, Design & Development
·
Data modeling with Analyst/Programmers using
ERWIN and Schema Manager
·
Analysis of user requirements, software specifications
and dependencies between various modules
·
Planning and completing System testing
·
Design & Develop Forms and
Reports
·
Unit and Integration testing of screens and reports
·
Coding of database procedures, triggers and Batch Programs. Expert
in SQL and PL/SQL programming
·
Performance Tuning & Optimization
References are available on request