Pavan DBA's Blog

The DBA Knowledge Store

Archive for the ‘General’ Category

proactive Vs reactive tuning

Posted by Pavan DBA on August 23, 2010

Long back i posted a poll asking my friends, which type of tuning they will prefer…and to my expectation, almost 90% said Proactive tuning…

I doubt (or atleast not sure) if working DBA’s who polled for “proactive tuning” really follow the same in their work because Tuning is one area which DBA’s are afraid off (but ofcourse some people enjoy it 🙂 )

The answer for the poll is reactive tuning on major, but yes sometimes we do proactive tuning

Now, each kind of tuning is having its own advantages and disadvantages. In proactive tuning DBA need to concentrate or predict on future database problems which is very tough where as in reactive tuning, DBA should have good troubleshooting skills and should be a fast decision taker as sometimes PT problems dependent on client business.

So friends, conclusion is….DON’T TRY TO CHANGE WHICH IS ALREADY WORKING FINE by doing proactive tuning and DON’T BE SLOW when doing reactive tuning.

More articles are in pipeline on tuning methodologies….continue to watch this space….

Posted in General | Leave a Comment »

walkin in TCS, Hyd for various technologies

Posted by Pavan DBA on July 16, 2010


Java J2EE (3-7 years of experience)
Struts JSP Servlets, Hibernate, Core Java

IBM Mainframe (MF)
Mainframe (3-7 years of experience)
Knowledge of IMS, JCL, COBOL, DB2

Linux/ Solaris System Admim (Experience 4 years)
Solaris System administration and engineering experience with RedHat Linux ES 3, 4, and 5. Solaris 8 and Solaris 10
Working knowledge of complex web hosting configuration components, including firewalls, load balancers, web and database servers
Good understanding of Unix tools, DNS, Sendmail, and BIND fundamentals, including diagnostics
Well versed in Apache web server, PHP, MySQL and VMWare a plus.
The ability to deploy, support, and diagnose issues for a production environment running critical Oracle/SQL database applications

Service Capacity Analyst (Experience 4 years)
Unix(various utilization(CPU, memory) concepts), Oracle, Java – E1

Windows Admin (Experience 3-7 years)
IIS& Clustering & Load balancing Technologies
Windows Admin with IIS / Clustering / Load Balancing Technologies required

Windows Admin (Experience 3-7 years)
Directory skills , Server Admin
Windows Admin with strong AD skills required

Windows Admin (Experience 3-7 years)
Windows Admin with SQL/IIS/SCOM

Windows Admin (Experience 3-7 years)
Server Admin – 2K, 2K3 & 2K8

Network Admin (Experience 3-6 years)
Switching & Routing
Network Admin with Lan / Wan /Firewall /Security

Unix Admin (Experience 3-6 years)
Solaris, HP Unix, Linux & AIX ( 3-6yrs)
Unix Admin with Solaris, HP Unix, Linux & AIX

Storage Admin & Architect (Experience 3-6 years)
EMC, Hitachi
Storage Admin with exp in EMC & Hitachi

Service Desk (Experience 3-5 years)
Service Desk for L1 Support
Good Accent neutralized candidate, Having troubleshooting skills in Desktop, Basic LAN issues, Outlook Mail client issues.

Application Packaging (Experience 3-5 years)
WISE Packaging Tool Experience
MS Technologies

Moss/ Sharepoint ( Experience 3-8 years)
Minimum of 3 yrs experience in .Net or Microsoft technologies of which at least 2 yrs of relevant experience in MOSS

SDET ( Experience 3-8 years)
Strong programming skill in C# .Good debugging AND testing knowledge,Ability to write automation system Ability to author test plan and cases, conduct security, stress test and debugging at source level after identify, investigating and priorities bugs

SAP SD Experience with at least 1 full SAP SD Project implementation of significant size, scope and complexity and 2 support project experience. Experience in O2C process and knowledge on interfacing modules like MM and FICO.

Siebel Config ( Experience 4-8 years)
Minimum of 4 yrs experience in Siebel Configuration with experience in implementation of Sales and Marketing Modules in Siebel
1. Full Time Graduates / Post Graduates in:
BE / BTech / ME / MTech / MSc / MCA / MCM / MS
PGDIT (2 years full time & approved by AICTE)
Special consideration will be given to B.Sc. / BCA / Diploma holders with 3 years of relevant functional / technical experience, subject to minimum reduction in experience, as per current TCS policy.
2. Consistent academic records from Class X onwards (Minimum 50%)
3. Candidates interviewed by us in the last 6 months are not eligible
4. Candidates with more than 2 years break in their academic / professional career will not be considered

A hardcopy of their CV
One passport size photograph
A photocopy of the last increment letter/offer letter, whichever is latest
The last drawn pay-slip

Tata Consultancy Services Ltd.,
Kohinoor Park,
Plot No.1, Jubilee Gardens, Cyberabad,
Hyderabad 500 081

Registration Time: 09:30 AM to 12:30 PM
Date: 24th July, 2010 (Saturday)

i am not having referal name…anyone can provide it through comments

Posted in General | Tagged: , , , , , , , , | Leave a Comment »

Votes went wrong & role of DBA in future

Posted by Pavan DBA on June 11, 2010

Hi Friends,

Long back i posted a voting query in my blog and thanks a ton for the response you had given.
But, unfortunately, max votes are posted for incorrect answer.

Let me present the same question with options here…

Which of the following DBA should have?
1) Responsibility of task
2) supporting application team while handling issues
3) provide solutions in cost effective way

I got Max votes for option 2 and to be frank, all are the answers for the question. But i posted this query to you to know out of these 3 which you feel the most important.

In my view, option 3 is the perfect answer…not accepting 😦 … oh! let me give you description.

We know in every version Oracle is brining automized features in database administraion. Many DBA’s asked me a simple question “what is the role of DBA in future if everything is automated?” or “whether DBA’s will have work or job to do if all are automated?

Now my only answer to this is….We need to grow from being a regular DBA to DBA who can be a Data Architect. Apart from this, there are many roles to play right from apps to fusion middleware.

The below two links from the great Don Burleson and Tom Kyte will explain in detail…

Hope this cleared some of your queries and if you still have, please post them through commenting… eagerly waiting to reply them 🙂

Posted in General | Tagged: | Leave a Comment »

Sachin’s Appraisal

Posted by Pavan DBA on March 5, 2010

Posted in General | Leave a Comment »

Now that’s apt………..just read these 5 liners :-)……………………………

Posted by Pavan DBA on March 5, 2010

1. Once, all villagers decided to pray for rain. On the day of prayer all the People gathered, but only one boy came with an umbrella…  


2. When you throw a baby in the air, she laughs because she knows you will  catch her…


3.Every night we go to bed, without any assurance  of being alive the next Morning. But still we set the alarm to wake us up…


4. We plan big things for tomorrow in spite of  zero knowledge of the future, or having any  certainty of uncertainties. ..


5. We see the world suffering. We know there is a possibility of same or similar things  happening to us. But still we get married!!!!!!……………….

Posted in General | Leave a Comment »

%d bloggers like this: