Pavan DBA's Blog

The DBA Knowledge Store

Does Specialized skill help Freshers in getting a job?

Posted by Pavan DBA on December 4, 2014

Does Specialized skill help Freshers in getting a job?

Opinions have always been divided when it comes to deciding whether or not to pursue a specialized course for advancing your career in the right path. Most young graduates face this dilemma of choosing the right way ahead that makes all the difference. Is it necessary to pursue specialized courses or skills like Java, PHP, SAP, SAS, HR, Digital Marketing, or Communication after graduation or post-graduation to secure a great job?


The process of making an intelligent and informed career decision is vital. Breaking into one’s chosen industry with or without a specialized degree or skills often works a morale booster. It encourages the individual to persevere, learn, and grow along with the organization. If you have graduated recently and have been looking for a job, this is a great time to start evaluating your skills and credentials to get a job in near future.

Increase your prospects with specialized skills

There are multiple advantages of opting for a specialized course in your preferred industry. The simple days of hiring a generalist are long gone. With increasing competition across all industries, an additional skill or degree definitely offers you a much-needed edge over your rivals.

  • If you possess particular skills – technical, analytical, or otherwise – a specific skill set honed for a particular industry will always help you stay ahead of competition and the crowd
  • The best part about specialized skills is they help you anticipate the tricky interview questions pertaining to the sector or organization and help you prepare accordingly
  • Specialized skills are often relevant to several industries like Information Technology, Engineering, Management, and so on. If you are planning to explore an opportunity in that decided field, a specialized skill will stand you in good stead

However, choosing a random course from any unheard of institute, solely for the sake ‘specializing’, is sheer waste of time, effort, and money. There are certain courses which often turn out to be eyewash that leave no discernible difference in your merit or educational capabilities. Do not buckle under peer pressure when you see most of your friends are enrolling for higher studies. Do not settle for anything substandard just for the sake of earning a degree.

You can always choose to specialize in ‘transferable skills’ that include capacities for teamwork, interpersonal communication, organizational skills that go beyond a university degree and supplement your existing qualifications. Enthusiasm, adaptability, and penchant for success are skills that every employer looks for in a potential employee. And these can be learned beyond the four walls of a classroom.

If you are looking for a job, using the omnipresent digital media is crucial. In this day and age, jobs are made and offered on the virtual world. Create a compelling and professional profile, even if you are a fresher. Your profile must demonstrate your accomplishments and strength areas. Enrolling in job sites, like with a focus on jobs targeted at fresh graduate and post-graduates will help you find a job easily. Start searching and applying for jobs for freshers to find the best match for your skills!


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

SQL SERVER DBA opening in Hyderabad [4+ yrs]

Posted by Pavan DBA on November 1, 2014

Skill Set: SQL DBA with Clustering

Work Location: Hyderabad

Experience: 4+ years of relevant experience in SQL DBA. Candidates should be willing to work I shifts and preference would be given to resources with 4+ years of experience. The detailed JD is given below.


  • Install and configure new SQL Servers
  • Strong knowledge on performance tuning, CDC, clustering  and replication.
  • Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
  • Configure SQL Server monitoring utilities to minimize false alarms
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Failover clustering, SAN replication, and other high availability technologies
  • SQL Server merge, peer to peer, or transactional replication
  • Service Broker
  • Administration of Analysis Services, Integration Services, or Reporting Services
  • Design indexes for existing applications, choosing when to add or remove indexes
  • Experience  log shipping, mirroring, Windows Azure, or other technologies
  • Strong problem solving ability
  • Strong grasp of SQL queries and ability to understand and debug complex stored procedures
  • Good communication and presentation skills.
  • Experience in 24×7 and environment and flexibility to work in shifts

Send ur cv’s to with subject “SQL SERVER DBA position” (plz note any mails without this subject line will be ignored)

Posted in Jobs | Leave a Comment »

New classroom Oracle DBA batch in DBATALENT

Posted by Pavan DBA on October 24, 2014


ORACLE DBA 11g/12c NEW BATCH For Offline !!!
Brought you by DBATALENT by Kanna Technologies

Training Details:
– Mode: Class Room Training
– Starting Date: 3rd NOV 2014
– Duration: 30days
– Timings: 7:30am – 9:00am IST

Other Details:
– Fees: Rs 12,000
– Training material provided

Early bird registrations will get Rs 2000 discount!
Attend 100% free demo on 1st NOV 2014 from 7:00 am

For more details
Write to:
Contact Us: 040-40036087

Posted in Training | 4 Comments »

New Oracle 11g RAC batch in DBATALENT

Posted by Pavan DBA on October 18, 2014

RAC batch



Attend First 2 days as a demo by the Trainer Vishnu Pavan (Oracle RAC certified Expert)

Meeting link :

Training Details:
– Start Date: 20th Oct 2014
– Duration: 20 days
– Timings: 7am – 8:30am IST
– Mode: Online Training

Other Details:
– Fees: Rs 15,000
– Training material provided

For more details, write to:
Contact Us: 040-40036087

Posted in Training | Leave a Comment »

How to resolve ORA-01400 during import(imp) in 11g database

Posted by Pavan DBA on July 12, 2014

Posting after long time…

Recently I am performing a refresh activity using export/import. Donno the reason, but DBA who handled this database in the past configured traditional export (exp) backup on database.

I got a request to import that dump into UAT database which I started performing using imp utility.

For some of the tables, i received ORA-01400 error and detailed message will be as below

. . importing table “TEST”
IMP-00019: row rejected due to ORACLE error 1400
IMP-00003: ORACLE error 1400 encountered
ORA-01400: cannot insert NULL into (“ABC”.”TEST”.”C1″)
Column : 1
Column :

Note that schema, table and column names are changed for security reasons.

Immediately I verified the column C1 in TEST table and observed that it is defined as NOT NULL. Intially, I thought this might be the reason for the error that Oracle is trying to insert NULL value. I checked in the production database and found that there is no NULL values at all in C1 column which means the table structure, data everything is perfect.

After referring to MOS doc 826746.1, got to know that this is a known issue when you take export with exp command from 11gR1 onwards using DIRECT=Y option.

This is because there is behaviour change in exp utility. Prior to 11gR1 when you take export (exp) with DIRECT=Y, if a NULL value is there in column, Oracle used to replace that with default value what it will have in COL$ table. But, from 11gR1 onwards, the value is not replaced by its default but the NULL values is stored in export dump. This will produce ORA-1400 during import.

The solution for this problem is simple…. take the export in conventinal path only i.e don’t use DIRECT=Y or use datapump for your activity.

Even though it seems to be a problem, Oracle has not opened any bug on this because exp utility is desupported from 11g onwards and Oracle recommends to use datapump only.

Finally, i temporarily fixed the issue by taking TEST table export in expdp. Also, changed the daily export backup method from exp to expdp in the production database.

Hope this helps for some people….

Posted in export/import/Datapump | Tagged: , , , , , , , , , , | 2 Comments »


Get every new post delivered to your Inbox.

Join 2,882 other followers

%d bloggers like this: