Frequently Asked Questions

I've compiled a list of the questions that I get asked most frequently.  If you have a question that I haven't answered or you need a more detailed answer,  you can comment on www.dba-db2.com or contact me. Please read through to see if I've answered it already.  FAQs were lasted updated on 9th July 2012

What is your current job situation?

I am a Senior DBA in a large financial institution.  I've been in this role full time for 3 years.

What are your responsibilities in this role?

I manage over 200 database servers and a team of DBAs onshore and offshore.

The database servers support a) SQL Server and DB2 b) Datawarehouse, Transaction and Modelling database servers.

My main responsibilities are Database Architecture and Performance. I manage Tuning, Database Server Optimisation, SQL Programming, database design of very large databases and the full range of database management procedures.

Do you have an up to date CV?

Yes and read my articles on sqlserver-dba.com  and  dba-db2.com

Would you like to keep receiving job vacancies information?

Yes, for high-end SQL Server and DB2 Senior DBA\Database Architect vacancies.

Do you write product reviews?

Yes, but only if I use the product or have tested thoroughly

We’d like to optimize a database (server) to respond faster , can you help?

Yes. Onsite and Offsite , contact me for details . If you're experiencing a problem , read How to report a DB2 performance problem . This offers a guide on how to document the DB2 Performance problem .  Detailed documentation assists in fixing the problem quicker

I’d like to submit a Guest Blog Post to www.sqlserver-dba.com or www.dba-db2.com, how can I submit a request? What are the guidelines?

Guest Blog post requests are welcome for Database Server related topics. The guidelines are:

a)       Contact me and submit a topic. I’ll reply to confirm  it’s OK

b)       Submit Unique content only.

c)       The article must be 500 – 800 words.

d)       One image supporting the text is OK. I may need to resize.

e)       Include a short biography – focus on technical skills and what make yo an authority on the topic . I’ll include the biography at the top of the post.

f)        I’ll include an external link . The external link must  not be to an unrelated site. For example , it can be to the authors technical blog or to a page offering more information about the topic. I won’t include spam like links.