Covering letter

To,

Recruitment team,

Reference : Database Administrator / Project manager / Tech lead

Dear Madam / Sir,

As an experienced DBA in Oracle, Unix System Administrator & a Project

Manager, for almost 10 years in IT industry, the opening in your

organization intrigued me. After reading your advertisement closely & with

a little background research through your website, I believe I have a clear

understanding of your needs. I believe you would agree my CV warrants

closer examination for the following reasons :

. Energetic, proactive, effective communicator, calm disposition,

willing to learn. Certified in ITIL Foundation (service management).

Trained in ArcGIS Database Administration. Familiarity with Code of

Federal Regulations (21 CFR), Part 11, GCP guidelines. Oracle

Certified Professional DBA (OCP 9i and 8i) - 9.2 years of overall DBA

experience (with 5 years of 10g & 11g RAC). Worked as a Unix system

administrator also, for 2 years (Jan 2001- Jan 2003).

. 9.2 years in providing & overseeing technical and managerial support

in a CMMI level 5 environment. Extensive knowledge of infrastructure,

technical and multi-domain environments. Sound knowledge and

experience in providing service and support to end-users. Strong

passion to lead DBA teams. Aware of Data Quality assessment.

. Proven ability in managing, developing & leading individuals and cross-

disciplinary teams. Ability to understand and to clearly relate to

people in all levels of the organization.

. Worked as a senior DBA, Release, Change & Problem manager in high-

growth, critical production environments and with large-scale data

warehousing applications on various flavors of Unix (Solaris, HP-UX,

IBM-AIX, Linux, SGI-IRIX) & Windows, for the past 9.2 years. Thus, I

am fully aware of the demands, this places on the development of

Business Intelligence Applications & Database Administration.

. Varied experience with Oracle Database & Oracle Apps (Oracle

Applications 10 / 11i / R12) administration & Unix administration,

database replication, disaster recovery, RAC (Real Application

Cluster) implementation, partitioning, analyzing ADDM's AWR reports,

migration, upgrade, process automation, monitoring through shell

scripts, standardizing processes, assessing quality standards,

planning for process & service improvements. Worked with Oracle Apps

10 / 11i / R12, DBA studio, RMAN, OEM & Toad. Aware of data storage

technologies & failover.

. Worked as database security analyst, database architect, capacity

planner, backup & recovery strategist, performance tuning consultant,

on-call DBA, replication admin, developer of DB monitoring ideas &

shell scripts for high-availability 24x7 OLTP, DSS & Data warehouse

environments (Production, Testing, Development), SAP basis

administration. Closely familiar with SDLC (Software development Life

Cycle) & Agile / Scrum development methodologies.

. Extensive experience with database security analysis, capturing &

directing metrics to specific servers for generating security reports

for SOX compliance, and recommending auditing levels.

. Worked closely with clients, users, customers, external vendors, and

as part of cross-functional teams, under strict SLA's & deadlines,

also provided on-call support during off hours. I'm at ease with

interacting with higher management & customers when needed; currently

leading a DBA team responsible for database administration for

production and operational support.

The position at your organization would be a valuable exposure and a

definite career progression for me. I would welcome the chance of

discussing this opportunity with you.

--Sincerely, Anshu Singare

Resume

CAREER SUMMARY

Name : Anshu Singare

Contact : e-mail : abmqzh@r.postjobfree.com,

Phone : +1-720-***-****, Fax :

+1-607-***-****, Current location :

Colorado Springs, CO, US

Current occupation : Senior Database administrator,

Database Transition & support lead, at

Verizon Business.

Educational background : Bachelor of Engineering (Computer

Science & Engineering) - June 2000

Oracle Certified Professional Database

Administrator. (Oracle9i)- October,

2003

Oracle Certified Professional Database

Administrator. (Oracle8i)- March, 2003

ArcGIS / ArcSDE DBA trained at ESRI,

California - Aug, 2008

ITIL Foundation (IT Infrastructure

Library) certified in Service

Management - March,2007.

SUN Solaris System Administrator

(Solaris 8/9)

Brainbench Certified Oracle 8i

Database Administrator - July 2004

Systems worked on : Unix servers (Sun Solaris, HP-UX,

IBM-AIX, Linux, SGI-IRIX), Windows 2K

/ XP / NT

Databases worked on : Oracle 11g/10g/9.x/8.x/7.x, Oracle

Apps 10 / 11i / R12, MS SQL server, MS

Access, Sybase, DB2, Informix

Strengths : (Soft skills) Project & team

Management, Communication, Client /

customer interfacing, Problem solving,

Change & release management, Corporate

etiquette, Business analysis.

(Technical) Oracle Database & Oracle

Applications 10 / 11i / R12 (Oracle

Apps) admin, 10g RAC, statspack,

tuning, RMAN, Streams, ArcSDE, Unix

system admin, SAP basis admin.

Overall experience : 9.5 years in IT (9 yrs in Oracle

Database Administration with 6 years

of project leadership & management) in

the domains of Network &

Telecommunications, Healthcare,

Retail, Banking & Finance, Insurance.

US experience summary : Senior DBA, DBA team mentor, leading

technical innovation, for Verizon

Business, at Colorado Springs, CO, US

for 1 year & 1 month (till date).

Onsite DBA Lead, DBA team mentor,

Database release & coordination

manager, for Level3, at Broomfield, CO

(USA), for 1 year.

Onsite Database transition & support

manager and Senior DBA cum mentor for

Pfizer, at New York City, NY (USA),

for 3 years.

Onsite Senior DBA for IKON, at

Malvern, PA (USA), for 5 months.

SKILLS

Technology NUMBER OF LAST PROFICIENCY

YEARS USED USED LEVEL

Oracle DBA (7.x-11.x), DB security & 9.2 2008 Expert

SOX compliance

Oracle 9i, Oracle 10g, 11g RAC / Data 8.7 2008 Expert

Warehouse

Oracle performance tuning, capacity 9.2 2008 Expert

planning

RMAN, backup and recovery 9.2 2008 Expert

Migration, upgrade of Oracle 9.2 2008 Expert

databases

Project management, change & release 6.2 2008 Expert

management, ITIL

Oracle Streams, SAP Basis 1 2008 Proficient

administration

Informix 9 DBA 2 2008 Proficient

Windows / Unix (Solaris, IBM-AIX, 9.2 2008 Expert

HP-UX, Linux), shell scripting

Oracle Applications 10 / 11i / R12 3 2008 Proficient

DBA

Data modelling & design 8.5 2008 Proficient

EMC BCV technology 5.5 2008 Proficient

Enterprise tools : OEM (Oracle 9.2 2008 Proficient

Enterprise Manager), Quest Toad, BMC

Patrol, DBartisan, Putty, Exceed,

Reflection, Primavera, Remedy,

Unicenter TNG, Peregrine

Oracle Spatial / data types / ArcGIS 2 2008 Proficient

/ ArcSDE 9.2 & 9.3 / ESRI

architecture

Oracle gateways 3 2008 Proficient

ETL Concepts, SDLC 8 2008 Proficient

Oracle dataguard / standby 6 2008 Proficient

C/C++, VB, VC, Pascal, Prolog, Cobol, 2 2003 Basic

perl,

Siebel CRM technology - Siebel tools, 0.5 2010 Basic

client & DB

Data quality assessment 0.2 2010 Basic

SIGNIFICANT ACHIEVEMENTS

1) Proudly devised techniques for exponentially speeding up data

transfers between servers, at Verizon Business, that would save about

80% of DBA effort & time taken in attempting to transfer data over

numerous hours, sometimes days.

2) Successfully developed a DBA transition toolkit to help structure any

DBA transition with comprehensive coverage of all possible topics of

importance. This would save almost 80-90% of time & effort spent in

planning of a DBA transition -Oct 2008.

3) Vigorously led a 41 people strong DBA team, as the DBA lead,

transition lead, DBA release manager & mentor, at Level3. We

transitioned about 5000 databases (70% Oracle, 10% Sybase, 20% MSSQL

server) from existing DBA's. I received numerous appreciations during

this period. Transition helped the company save about 300 million USD

annually - May 2008 to Nov 2008.

4) Got trained from ESRI in ArcGIS / ArcSDE Geodatabase administration &

then trained others - Aug 2008.

5) Assertively led the L2 team of DBA's, as the lead Application DBA

responsible for about 600 application databases, at Pfizer, New York.

This project involved coordination between L2 DBA's and the customer

side managers, Application development & maintenance teams,

engineering team - Mar 2007 to May 2008.

6) Proudly led the L3 team of DBA's while working with them & providing

guidance at every step, for performance issues & problem management

May 2005 to Mar 2007.

7) Successfully led the DST (Daylight Savings Time) patching project for

almost 500 Oracle databases spread over 150 servers (95% Unix, 5%

Windows) at Pfizer, and achieved the target on time. This project

saved the company about 50,000 USD - Jan 2006 - Feb 2006.

8) Aggressively Headed and completed transition, knowledge base creation,

support and transition of more than 250 Oracle Database setups & 150

Applications against tight deadlines for Pfizer, at New York (USA).

This helped the company save about 400,000 USD a month - Aug 2005 to

Mar 2006.

9) Proposed, designed, base-lined the SOP's (Statement of Procedure) for

DBA team's activities and qualification documents for Oracle 10GR2

installation, operation and performance. This now helps save the

company about 5000 USD a month - Aug 2006 to Nov 2006.

10) Continued to successfully lead Application & Oracle database

transition teams at Pfizer, to achieve targets in time, ensuring

business continuity as well. This helps the company save an average of

25000 USD per Application.

11) Successfully completed ITIL Foundation certification, with 97% score

(one of the highest scores yet). With this knowledge, I add value by

aligning the team's operations closer to the ITIL directives - Dec

2006. Got trained on awareness & applications of Code of Federal

Regulations (21 CFR), Part 11, GCP guidelines - June 2005

12) Headed "SOX compliance" project, for IKON, at Malvern PA (USA). This

helped the company get rid of many database security issues uncovered

during the process - Jan 2005.

13) Extensively researched usage & applications of Oracle's RMAN (Recovery

Manager), contributed research documents, held KT sessions for team

members, and established backup plan for databases. This helped the

company save about 2500 USD a month - Jan 2007.

14) Successfully handled Oracle Parallel Server setup migration from

Oracle 8.1.7.2 to 8.1.7.4 for IKON and devised process improvements.

This saved the company from a loss of about 60,000 USD overall - Dec

2004.

15) Publications on Knowledge shop : Oracle database tuning through

partitioning & indexes, Oracle database migration, Understanding RMAN,

setup for Oracle, Understanding Oracle Applications (writing). My

publications help many other projects save about 40 hours of research

per month.

16) Administered a 5 months long migration & upgrade of Oracle databases,

Oracle applications 10 / 11i / R12, Oracle web servers, EDI adapters

(Oracle Application Interconnect) for the project IKON. - Jan-Apr

2004.

17) Successfully completed 2nd project of Competent Toastmaster track, in

Toastmasters' Club, Bangalore, India. This helped me improve my

communication skills to a great extent - Dec 2003.

18) Conducted internal audit in my company for adherence to ISO 14001

(International Standards for Environmental Policy) & delivered

seminars, to fellow Infoscions. This helped spread awareness about

importance of this certification - Apr 2004.

19) Successfully handled the position of Technical Seminars Manager along

with the job of Lecturer in Computer Science department, at RKDF

Engineering College, Bhopal (M.P.), India.

20) Received appreciation from the IKON, Pfizer, Level3 & Verizon managers

& colleagues for quality & positive attitude towards work.

21) Got certified in auditing for BS 14001, Environmental policy

enforcement - May 2004.

DETAILS OF THE PROJECTS WORKED ON

01 Project / Verizon Business, Colorado Springs, March 2009 to

Client Colorado, USA Present

Brief description

Database Administration services for a large setup of databases -

production, testing, & development databases on Unix (Sun Solaris,

IBM AIX, Linux) & Windows (5%). Size of environment : 1000 Databases

of about 400 GB - 4 TB each. All DB's are on hardware clusters, & all

PROD DB's have standby configured. There are about 12 RAC clusters

for data warehouses. 12 onsite DBA's. My responsibilities include

Reviewing overall physical database structures for data integrity,

performance quality, recoverability, maintenance, and space

requirement considerations including capacity planning & trending.

Conducting occasional Application transaction analysis & impact on DB

/ network performance.

Communicating complex technical information to Business / Application

owners in a concise and articulate manner. Helping audit teams with

data collection related to database SOX compliance. E.g. User

privileges, profiles, passwords.

Transition plan creation and monitoring for process & technology

transition of more than 500 databases and 300 applications. This

includes J2EE Applications' backend databases also.

Knowledge base development. Proposing, designing, base-lining System

Appreciation Document as Oracle DBA team's reference Bible on various

DBA domains & their business functions. These live documents serve as

operational manuals also. On-call DBA role on a regular schedule.

Actively getting involved with ITIL management areas : Change,

Incident & Release management. SOX compliance.

Regularly meeting Application teams, business owners to discuss their

future requirements, DB capacity forecast & DB design changes.

Role : Senior DBA, Grid & capacity manager, Database

Transition & support lead, at Verizon Business.

Hardware : Sun Solaris 5.9 / 5.10, IBM-AIX, HP-UX servers,

Win2K servers, workstations, SAN (Storage Area

Networks)

Software : Oracle 9i / 8i / 10g Data warehouse on RAC, Oracle

Enterprise Manager (OEM), 10g grid console (grid

control), UNIX, Oracle RMAN, ASM, Oracle DB

configuration & upgrade assistants, Toad, DBA

Studio, SSH, Putty, Telnet, SQLPLUS, Toad, VSS, MS

Project, MS Visio, MS Word, Excel, Powerpoint,

Outlook.

02 Project / Level(3) Communications, Broomfield, April 2008 to Mar

Client Colorado, USA 2009

Brief description

Database Administration services for a large setup of databases (70%

Oracle, 10% Sybase, 15% MSSQL server, 5% Informix) production,

testing, & development databases on Unix (Sun Solaris) & Windows

(5%). Size of environment : 5000 Databases of about 600 GB - 2 TB

each on Solaris 10, Largest : 120 TB 6 node RAC cluster which

supports a Data warehouse, there are 11 separate 3-node RAC clusters

for smaller data warehouses, 30 databases with ArcSDE 9.2

administration.. 6 onsite & 35 offshore DBA's. My responsibilities

include

Database backup monitoring, performance monitoring & tuning. Database

migration, recovery & cloning & specific process-bound refreshes,

Data warehouse performance troubleshooting, coordination with Oracle

support, RAC (10g), dataguard configuration (VLDB Datawarehouse on

RAC implementation - 80 TB), Devising new ideas & implementing Unix

shell scripts, analyzing ADDM's AWR reports, migration, upgrade, some

SQL / PL/SQL scripts for automating database & resource monitoring

tasks & for generating alerts, DB security analysis. User request

troubleshooting, Data modelling & design advice to App teams.

Project planning, scheduling, evaluation, monitoring progress &

presentation to client / customer management. Developing &

implementing project policies & procedures. Leading the Oracle

transition & support project for onsite & offshore teams. DBA release

management & interfacing between Business owners & the DBA's for

major / minor releases. Transition plan creation and monitoring for

process & technology transition of more than 5000 databases and 900

applications. This includes SAP, Siebel, J2EE Applications' backend

databases also.

Knowledge base development. Proposing, designing, base-lining SAD

(System Appreciation Document) as Oracle DBA team's reference Bible

on various DBA domains & their business functions. These live

documents serve as operational manuals also. Mentoring & conducting

weekly knowledge fusion sessions for team aimed at bridging gaps

between onsite and offshore teams. On-call DBA.

Managing enterprise-wide releases, managing problem tickets

(repeating incidents). Actively getting involved with ITIL management

areas : Service level, Availability, Change, Incident, Release &

problem management. SOX compliance.

Role : Database release manager & DBA team lead, Database

Transition & support lead, Team manager & Senior

Oracle DBA

Hardware : Sun Solaris 5.9 / 5.10, HP-UX servers, Windows NT/XP

workstations, servers, SAN (Storage Area Networks)

Software : Oracle 9i / 8i / 10g Data warehouse on RAC, Oracle

Enterprise Manager (OEM), 10g grid console (grid

control), Informix, UNIX, Veritas Netbackup, Oracle

RMAN, ASM, Oracle DB configuration & upgrade

assistants, ArcSDE (ESRI's GIS software for handling

geo-spatial data), Toad, DBA Studio, MS SQL 2000

server, Sybase ASE iSQL, SSH, Putty, Telnet,

SQLPLUS, Toad, Clear Case, VSS, Remedy, MS Project,

MS Visio, MS Word, Excel, Powerpoint, Outlook.

03 Project / Intel - SAAS, Santa Clara, April, 2008 to

Client California, USA April 2008 (25

days)

Brief description

Oracle 11g RAC implementation. Goal : setup Production, Testing &

Development environments on Oracle RAC, on dedicated Linux servers.

This setup would support the SAAS delivery services for Intel. Size

of environment : 9 Databases of about 500 GB - 1 TB each on Red Hat

Linux 4.3, PROD / DEV & TEST environments on 3 separate 3-node RAC

cluster each.. 1 onsite (myself) & 3 offshore DBA's. My

responsibilities included

Leading the Oracle 11g RAC (crs) on 10g database implementation,

performance optimization & monitoring. Database backup strategy

setup. On-call DBA.

Proposing, designing, base-lining the SAMD (System Appreciation &

Maintenance Document) as Oracle DBA team's reference Bible on RAC

installation, maintenance & troubleshooting. These live documents

served as operational manuals also for new DBA's.

Role : Database RAC implementation & maintenance lead,

Senior Oracle DBA

Hardware : Redhat Linux 4.3 on Dell enterprise servers

Software : Oracle 10g, 11g RAC, OEM, grid console (grid

control), ASM (Automatic Storage Management), UNIX,

RMAN, DBCA & DB upgrade assistant, Toad, DBA Studio,

SSH, Putty, Telnet, SQLPLUS, Toad, MS Project,

Visio, HP ILO.

04 Project / Pfizer Global Pharmaceuticals, New May, 2005 to

Client York, NY, USA April, 2008

Brief description

Oracle Database Administration services for a large infrastructure of

production, testing, & development databases on Unix & Windows

platforms. Size of environment : 1700 Databases of about 300 GB - 3

TB each, RAC : 2 separate 3 node clusters on Linux & Solaris 9 (30%

were Data warehouse DB's). There were 8 onsite & 22 offshore DBA's.

My responsibilities include

Backup & recovery, RMAN, 10g RAC admin, performance monitoring &

tuning, Database migration, recovery & cloning & specific

process-bound refreshes, devising new Unix shell scripts, SQL /

PL/SQL scripts to monitor databases, system resources & generating

alerts, troubleshooting, analyzing ADDM's AWR reports, migration,

upgrades, Database architect : Data modelling & design advice to App

teams. On-call DBA.

Leading the Oracle support & transition project for onsite & offshore

teams. Transition plan creation and monitoring for process &

technology transition of more than 250 databases and 80 applications.

Project planning, scheduling, monitoring progress. Developing &

implementing project policies & procedures. SOX compliance. This

includes SAP, Siebel, J2EE Applications' backend databases also.

Proposing, designing, base-lining the SOP's (Statement of Procedure)

for Oracle DBA team's activities and qualification documents for

Oracle 10GR2 installation, operation and performance.

ITIL management areas : Service level Management, Availability

management, Configuration management, Incident management. Knowledge

base development & support. Mentoring & conducting knowledge transfer

sessions for team. DB security analysis.

Role : Oracle Database transition & support lead, Senior

DBA & team mentor (95% Oracle, 5% MS SQL server)

Hardware : Sun Solaris 5.6 / 5.7 / 5.8, IBM AIX 5.2 / 4.3,

HP-UX servers, Red Hat Linux,Win NT/XP workstations

Software : Oracle 9i / 8i / 10g, mobile server, workflow

server, Oracle Enterprise Manager (OEM), RAC,

Statspack, AWR, ADDM, Dataguard, Veritas Netbackup,

Streams (replication), 10g grid console, UNIX, RMAN,

DB configuration & upgrade assistants, Toad, DBA

Studio, MS SQL 2000 server, Telnet, SQLPLUS, Toad,

Peregrine, Clear Case, VSS, MS Project, MS Visio, MS

Word, Excel, Powerpoint, Outlook.

05 Project / IKON office solutions, Malvern, PA, Aug, 2003 to May,

Client USA 2005

Brief description

Size of environment : 350 Databases of about 100 GB - 900 GB each

(50% were EDW Data warehouse DB's), OPS (Oracle Parallel Server) : 2

separate 4 node clusters on IBM-AIX. 2 onsite & 4 offshore DBA's.

This includes SAP, Siebel, J2EE Applications' backend databases also.

My responsibilities included :

Project management, planning, scheduling, monitoring progress &

performance. Developing & implementing project policies & procedures.

Oracle database administration, backup monitoring, performance

monitoring, tuning, migration, recovery & cloning. SOX (Sarbanes

Oxley compliance) implementation. Noetix EUL generator setup & view

generation, Database architecture / modelling & design advice to App

teams.

Devising innovative & useful shell scripts, SQL / PL/SQL scripts for

automating database, resource monitoring tasks and for generating

alerts. User request troubleshooting. Mentoring & knowledge transfer

sessions for the new trainees. On-call DBA.

Oracle Apps 10 / 11i / R12 administration, installation, patching,

cloning, migration. OAI support (Oracle application integration).

Oracle Portal Administration. Oracle Discoverer administration.

Role March 2005 -June 2005) Project Leader & Senior DBA

(August 2003 - February 2005) Senior Oracle DBA,

Oracle Web server admin, Oracle Apps DBA (10 / 11i /

R12), OAI (Oracle Applications Interconnect) admin

Hardware : IBM AIX 5.2, 4.3 servers, Win NT/XP workstations

Software : Oracle Apps 10 / 11i / R12, Oracle 9 / 9i / 8 / 8i,

Oracle Parallel Server, UNIX (IBM-AIX), BMC Patrol,

mailx, Telnet, SQLPLUS, Toad, Discoverer, Oracle

Portal, Apache Web server, Noetix EUL generator, MS

Project, MS Visio, MS Word, Excel, Powerpoint,

Outlook, VSS.

06 Project / Coca Cola, Bangalore, India June, 2003 to

Client August, 2003

Brief description

SAP release 4.6c on Oracle 8i DB, all on 6 Tru64 Unix servers.

Overall project tasks include

SAP basis support & administration, vendor interfacing, server

hosting & management, monitoring services (database &

infrastructure). Incident management, Reporting & documentation

Oracle 8i DBA support: SAP system database (oracle) maintenance &

tuning.

Tru64 UNIX administration: User account management, Storage

monitoring & configuration, Performance monitoring, backups.

Role : Project Leader, Technical consultant

Hardware : Compaq Tru64 UNIX servers, NT/2000 workstation

Software : SAP release 4.6c, Oracle 8.1.7, Compaq Insight

Manager (for servers & process monitoring), VNC,

Telnet, Lotus Notes, SQLPLUS, CA Unicenter TNG, MS

Project, MS Visio, MS Word, Excel, Powerpoint,

Outlook.

07 Project / Citigroup (Citibank), Bangalore, April, 2003 to May,

Client India 2003

Brief description

I used Abinitio, a data warehousing tool, to extract data from

flat-files from mainframe-computers, based on a defined format, to

transform data according to user defined requirements, & to load into

an Oracle database (ETL - Extraction-Transformation-Loading). I

formulated the queries, using SQLPLUS, Toad. My responsibilities

included : Design of the solution process, testing & development.

Role : Developer, Tester.

Hardware : Sun Solaris 2.8 server (Sun Fire v480), NT/2000

workstation

Software : Ab-initio (data warehousing tool), Telnet, Oracle

8.1.6, Toad, SQLPLUS, MS Project, MS Visio, MS Word,

Excel, Powerpoint, Outlook, VSS.

08 Project / Infosys In-house projects : SCHLUMBERGER, GOLDMAN

Client SACHS, McKINSEY, REEBOK, CITIBANK, NYLI, Bank of

America, AMEX, YANTRA, EVOLVING SYSTEMS, ACCORD,

NORDSTROM, LUCENT, NORTEL, AXA LIFE INSURANCE, ATLAS,

AETNA, APPLE, LEXISNEXIS, TOSHIBA, TELSTRA, VERIZON,

ERICSSON, Bangalore, India

Duration From : Oct, 2000 To :

March, 2003

Brief description

Size of environment : 400 Databases (Oracle, Informix, Sybase, DB2)

ranging from 2 GB - 400 GB in size on Unix (HP-UX, Sun Solaris,

IBM-AIX, SGI-IRIX, Linux) & Windows (NT & 2000) platforms (20% were

Data warehouse DB's). This includes SAP, Siebel, J2EE Applications'

backend databases also.

Database (Oracle) related :

Design, creation, maintenance & administration of all the Oracle

7.x-9.x databases on 76 Unix servers. Migration, upgrade, cloning of

databases. Database backups, disaster recovery planning. On-call DBA.

Helping users with SQL & PL/SQL query-tuning, database objects'

creation (tables, views, Db-links, procedures, functions, etc.) &

Troubleshooting problems in Oracle databases & Applications, Data

modelling & design advice to App teams.

DB security analysis, tuning databases for memory, I/O, resource

usage, query-efficiency, response-time, throughput.

Unix (Solaris / HP-UX / IBM-AIX / SGI-IRIX) administration related :

Maintenance, administration & monitoring of Unix servers (Sun Solaris

- 2.6 / 2.7 / 2.8, HP-UX - 10.00 / 11.00, IBM-AIX - 4.3, SGI-IRIX)

Devising, verifying the feasibility, testing & implementation of the

backup-strategies for the servers & databases. Performing the

restoration checks. Performing a regular cleanup of the servers.

Preparing monthly system activity documents.

Tuning the memory, I/O, resource usage, disk-space on a Unix server.

Installing / upgrading UNIX applications (or new versions of existing

ones), server patching.

Role : Database Administrator & Unix System Administrator

Hardware : Sun servers (E450, E4500, E3500, etc.), HP-UX

servers (visualize C2000, J9000, etc.), IBM-AIX

servers, SGI-IRIX systems, Windows NT/2000 servers /

workstations

Software : Telnet, Hummingbird neighborhood, Oracle 7.x-8.x,

Toad, Oracle Apps 10 / 11i / R12, Exceed, Informix,

CA Unicenter TNG, MS Project, MS Visio, MS Word,

Excel, Powerpoint, Outlook

09 Project / RKDF Engineering college, Bhopal July, 2000 to

Client (M.P.), India September, 2000

Brief description

Educating the students, in various important subjects in CSE-syllabus

: Artificial Intelligence, Microprocessors, Theory of computation,

LISP, PROLOG.

Conducting technical seminars, paper-presentations, on various

subjects chosen by students, as per their interests, or as per other

students' & staff's demands.

Organizing software-installation workshops for students, along with

vendors when required.

Role : Lecturer

Hardware : Win NT / 95 / 98 workstations

Software : C, C++, Pascal, COBOL, Oracle Standard Edition.

Publications

1) Oracle database tuning through partitioning & indexes

2) Oracle database migration (8i to 9i)

3) Understanding RMAN (for backup & recovery) setup for Oracle

4) Understanding Oracle Applications - writing currently

5) RMAN case studies - Backup to and recovery from remote tapes - full /

partial

6) I maintain an Oracle web log at http://databaseoracle.blogspot.com and

post useful information based on the results of my various mini

research projects.

Other personal information

1) Valid passport & US Visa; authorized to work in India & US.

2) Languages known : English (Fluent), Hindi (Fluent), French

(Intermediate), Mandarin Chinese (Basic), Kannada (Basic).

3) Involved with SOS Children's villages of India to help less privileged

children ; also involved with CUPA for homeless animals. Participated

in 10 mile breast cancer walk in Edison, NJ, organized by YWCA, in

2007 (walk for Hope to cure breast cancer) ; volunteered for helping

elderly people, children's hospital, public library & animal care

facilities ; volunteering for Florissant Fossil Beds national

monument.

4) Enthusiastically performed role of Stalls Manager on Petit Infoscion

Day - Sep 2003.

5) Hobbies : Listening to & playing music, ardent reading, swimming,

walking, trekking, Tennis, spending time with children & animals,

keeping in touch with old friends, learning new languages.

6) References available on request.

Contact this candidate