Pavan DBA's Blog

The DBA Knowledge Store

Archive for the ‘General’ Category

Innovation Manager opening in Cognizant [5 yrs]

Posted by Pavan DBA on July 15, 2016

Role : Innovation/ Program Manager who can bring about Innovative ideas and drive/ enable an Innovation engine
Exp : 5+ yrs
job location : chennai

Roles as an Innovation Manager for Customer Accounts
· Nurture key stakeholder relationships at a practice / account level
· Co-create Innovation Strategy and keep track of innovation objectives and outcomes, periodically at account level
· Prepare & present the status of Innovation for leadership review – Insights, Metrics, Best Practices and share to different stakeholders
We are looking for Program Manager who can bring about Innovative ideas and drive/ enable an Innovation engine.
Build innovation related capability and with a design thinking.
Good to Know: Capable of brain storming, brain writing and an avid blog writer who has an own blog.
Most importantly articulate innovative ideas with Marketing, branding, social (active in Facebook, twitter and other social groups) & coaching skills.
Good to have LS/ Pharma/ Health care Knowledge (not a mandate).
Diagnose & cure
· Understand and Analyze Innovation Metrics based on the needs of the different stakeholders (Account – Onsite and Offshore, Client, BU, Innovation Group)
· Indicate areas leading, lagging and on track
· Seek and Recommend solutions to bring lagging areas on par
Bring account ‘Inside-Out’ knowledge to further Account / Practice goals
· Study & analyze account profiles
· Customize campaigns, jointly with account leadership
· Propose and spearhead practice level events
· Cross-pollinate best practices and effectively work with cross-functional teams
· Bring in newer capability techniques like Lean startup, Design Thinking, JTBD, etc.,
· Design, develop and improve our Innovation service offerings
Spotlight & Evangelize
· Write Innovation case studies
· Publish innovation newsletters
· Evangelize – Blog, share, narrate, disseminate using multiple channels
· Facilitate capability building programs
What we look for in an candidate:
· Excellent written and spoken communication skills
· Ability to interact with senior leadership and clients
· Work in changing requirements and dynamic cross functional teams
· Ability to ideate and creative problem solving skills
· Plan and manage simple and complex programmes
· Ability to switch from mundane tasks to intellectual tasks with ease
· Have the ability to take risks, experiment and explore new things
· Flexibility in travelling on short term and long terms for client requirements
· Being a collaborator, acting as a connector of different perspectives
· Ability to be a team player, interact, and maintain trustworthy relationships
Good to have:
· Thought leadership in any business, domain or technology
· Certification on domain expertise
· Certifications on creativity and innovation
· Certification on process and quality
· Sales and marketing background
· Visual thinking and Design thinking skills
· Gamification and social media community management

Technical Skills:
· Presentation skills using MS PowerPoint, and other open source presentation formats
· Documentation skills with word processors like MS Word, Notes
Knowledge to work on MS Excel, good to have knowledge on Macros


Job-related Skills
(Technical and professional skills that the person must have to be effective)

· Project/Program Management Skills
· Facilitation or Coaching Skills
· Microsoft Office Practitioner to Specialist level Skills
· Analytical Skills
· Marketing, Branding Skills
· Innovation Management
· Consulting
· Creativity Skills
· Social skills
Personal Skills
(Non-technical and managerial skills that the person needs to have)
· People Management Skills
· Communication Skills
· Decision Making
· Operations Management
Candidate Checklist : (Candidate must carry the following documents for the interview)
* Passport size photograph
* Last 3 months pay slip
* Offer letter and last increment letter from your current / last organization
* Photocopies of X, XII, graduation and post-graduation Certificates and Mark sheets (all semesters)
* Photocopies of Offer Letter or Experience Letters of ALL previous employments (mandatory)
* Photocopy of any one of the following ID Proofs is a MUST: Passport, Ration Card & Election ID card

Interested candidates send your resume to with Subject “Application for Innovation manager in Cognizant”. Please note mails sent without this subject will not be considered.

Posted in General | Leave a Comment »

HAPPY NEW YEAR 2015 to all

Posted by Pavan DBA on January 1, 2015


Posted in General | 1 Comment »

Golden chance to listen to Oracle Experts in Dubai and UAE

Posted by Pavan DBA on May 21, 2014

Friends, a golden chance to people to listen to so many interesting sessions from Oracle Industry Experts like Oracle ACE, ACE Directors etc. It’s a Great opportunity to meet the Oracle experts, Meet Top Executives, Network with Other Senior DBAs, Database Managers in Dubai..

Event organized across UAE. You can attend physically or virtually by registering at

For Dubai location see here –


Posted in General | Leave a Comment »

Wishing all my blog friends a very HAPPY NEW YEAR 2014

Posted by Pavan DBA on January 1, 2014


Posted in General | 3 Comments »

Finding the location of a row in the database

Posted by Pavan DBA on March 27, 2012

Friends, nice to write an article after really long time….

Earlier I posted an article on how to “How to identify in which datafile (of same tablespace) object is existing”. see that article here  –

But in this article we will learn on how to check in which datafile (irrespective of any tablespace in the database) a row is existing i.e we are finding the location of a row in the database.

This is possible through DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO package and ROWID of a row. We all already know that ROWID is a unique identifier assigned by oracle to each and every row in the database and it is a hidden column in a table i.e every table will have a psuedo column called ROWID, but it will not be shown when we describe a table.

Let’s take a quick example

SQL> conn scott/tiger

SQL> select rowid, DEPTNO, DNAME, LOC from dept;
ROWID                  DEPTNO DNAME          LOC
—————— ———- ————– ————-
SQL> SELECT dbms_rowid.rowid_to_absolute_fno(‘AAAR3qAAEAAAACHAAD’, ‘SCOTT’, ‘DEPT’) FILEID FROM DUAL;

SQL> disc
SQL> conn / as sysdba



So, isn’t easy guys to find in which tablespace a row is existing 🙂

Hope this helps…. HAPPY LEARNING

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

%d bloggers like this: