SQL Server career advice
Home > Ask the SQL Server Experts > Adam Machanic - SQL Server 2005 Questions & Answers > Advice for becoming an expert DBA
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

Advice for becoming an expert DBA

Adam Machanic EXPERT RESPONSE FROM: Adam Machanic

Pose a Question
Other SQL Server Categories
Meet all SQL Server Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 07 January 2006
I want to become an expert DBA, but I'm not sure about the best approach. I have basic knowledge of databases like SQL Server 2000, Oracle8, Access and FoxPro. Can you please provide some ways I can get started on the right foot?

>
EXPERT RESPONSE
This is a broad question, as there are many different kinds of DBAs and everyone has a different definition of what "expert" means. That said, I think I can help with some general guidelines.

First, choose your specialty. The best DBAs I know specialize in some particular area. If you come from a development background, you might choose to specialize in database development, leveraging your previous knowledge of data access and application development methodologies. If you come from an IT background, you might choose to become more of a "systems management" kind of DBA, working on performance, replication, clustering, monitoring, and other high availability issues. Finally, if you come from a business background you might choose to focus on business intelligence, including OLAP and reporting technologies or ETL processes.

Choose an area you're really interested in, because the best DBAs I've met are somewhat obsessed. And the most important quality of a great DBA, in my opinion, is a thirst for knowledge. You should strive to learn everything you can about databases, database development, and especially about your employer's business. Great DBAs own the data that runs the business. If you can't understand the rules behind the data, you're not going to be able to do a very good job.

Finally, work hard and make sure to check your ego at the door. There is no excuse for laziness or rudeness in the workplace. It doesn't matter how much you know or how much you think you know if you don't do your job well or if you alienate your fellow employees. Always remember that interpersonal skills are even more important than technical skill in this field. In the end, your career will be influenced a lot more by the long-term relationships you build than by your expertise, which can render itself outdated in a surprisingly short amount of time.


Sound Off! -   Be the first to post a message to Sound Off!


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Adam Machanic - SQL Server 2005
Stored procedure concurrency problems in SQL Server 2005
SQL vs. T-SQL
Database Snapshots: Creating read-only copies of a database
Upgrading SQL Servers
Determining number of servers needed for large member site
SQL Server 2005 Enterprise Edition vs. Standard Edition
Encryption failures when upgrading to SQL Server 2005
Upgrading to SQL Server 2005 while maintaining .adp access
Modifying a query to show navigation path
Viewing SQL Server 2005 data via Windows Forms

SQL Server overview
How to use rank function in SQL Server 2005
SQL Server memory configurations for procedure cache and buffer cache
Storage area network (SAN) basics every SQL Server DBA must know
Open SSIS packages without validation using these SQL properties
SQL Server PerfMon counters for access methods and buffer manager
SQL and SQL Server Tutorial and Reference Guide
Monitor SQL Server disk I/O with PerfMon counters
Track changes to SQL Server 2000 and 2005 with one simple utility
Tips for scheduling and testing SQL Server backups
SQL Server tempdb best practices increase performance
SQL Server overview Research

SQL Server career advice
Minding the data and databases
What are you worth? IT salary surveys shed some light
TDWI keynote speaker reveals secrets of DBA career success
Automation vs. the DBA
New certifications will become reality in 2006
SQL Server 2005 may call for a smarter DBA
Letters to the Editor: Are DBAs needed anymore?
DBA cites on-the-job training as key
Web services, BI fuel DBA job market
Shun Linux and kiss your job security good-bye, part 1

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
application server  (SearchSQLServer.com)
comma-separated values file  (SearchSQLServer.com)
DDBMS  (SearchSQLServer.com)
entity-relationship model  (SearchSQLServer.com)
full-text database  (SearchSQLServer.com)
intelligent database  (SearchSQLServer.com)
OLE DB  (SearchSQLServer.com)
Quiz: Database Basics  (SearchSQLServer.com)
relational database management system  (SearchSQLServer.com)
SQL Server  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts