Discussion Locked

Prove that I am a DBA

0 helpful
11 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I managed 17 Access databases at work that reside on a file server. Access is a relational database, with ODBC functions, data integrity is determined by relations, access can be controlled (security), performance, back-ups, etc... How can I convince my team that I too am a Database Administrator? Honest and good feedback is needed to prove my position and career. Any links or information that you can provide would also be great! Thanks!

Regards,
"Needing to prove that I a DBA"

11 replies

by boxfiddler Hot topic

How are you with SQL and Oracle? To name but 2. Access is highly limited in comparison to other DB's - are you familiar with those limitations? The size limitation alone is probably enough to convince many that you will have problems with more powerful and larger DB's.

If the answer to the first question is huh? or not at all, then you need to learn something besides Access in order for your fellow team mates to take you seriously.

Access is often (whether rightly or not) seen as somewhat of a joke.

by olivesuntech

I agree that Access is not the only database to use and believe me I have tried to convince my collegues to seek other options. My problem is that I have all of these Access databases that I manage at work and have either made recommendations to move from Access to other type of databases. I was successful getting them moved to a SQL server but now there is another person managing the back-end. I only have access to the test SQL servers.
Access is seen as a joke but I have stuck based on my current job role. Help me prove that I too am a DBA. Any thoughts?

by rfink

BDO (By definition only). Calling access a database is like calling my sister's recipe file a database.

When I worked with access it didn't have the major functions like rollback, rollforward, checkpoints or log files for that matter. Maybe it does now but I gave up on it.

by olivesuntech

Thanks for your response. By definition only I am an database admin. I know SQL and have move alot of the databases to the back-end of a SQL server. The problem is that I share the responsibiltiy with someone else and he manages SQL end. Despite my effort, how can I prove that Access is Database Administration so I can move on to better things?

by rfink

What DBA training do you have? Since you mentioned SQL servers, do you have your MCDBA for example?

Being a SQL or Oracle DBA is a totally different animal than being an access DBA. Do you know how to do data replication, DTS packages, stored procedures, maintenance jobs, etc? Are you familiar with ERDs, data modeling, data normalization?

Good DBAs are worth their weight in gold.

Just my two cents.

by tony hopkinson

you are trying for parity, same pay as your sql server colleague.

Can't agree just based on the technology, don't ask to be recognised as a DBA, ask to be recognised for the value you add.

What goes better when you do your stuff? How do you, how can you add value to the people who use the data .

Whether it's in DB2, Access or a filing cabinet, shouldn't matter to your employer as long as the data maintainas a good quality and is 'easily' accessible.

You might have outgrown your role, it happens, if they can't or won't provide you with more scope, move on.

by sigman

One way of getting the experience you need to be recognized by other employers as a DBA would be to suggest to your current management that the SQL Server DBA train you as a backup i.e. cross-train to ensure that the job functions can be supplied if someone is out.

They may also wish to offload some routine activities, which is a start. You would probably only get operator access until you proved yourself.

by jdclyde

Sometimes it takes being hired in as the "expert" to get the respect you need in new areas.

Shellbot recently did that. She was unhappy with her job so she got a new job. She then got STUCK playing with ACCESS and Excel instead of "real" database work, and so she pulled that plug and move to a place where she could do what she originally got hired in to do.

Job satisfaction and respect are more important than a lot of people often admit.

I HATE when I have to spend a few days working on spreadsheets, because I am the most knowledgable about them, but at least I don't have to do it often. B-)

by tony hopkinson

you administer databases after all.

However Access is a desktop, while it has it's own particular class of administration tasks , there's a shed load it doesn't have and high end DBMS's do.

I wouldn't just accept that you were capable of managing MySQl, PostGre, Oracle, Sybase, even SQL Server, just on the strength of Access.

It's good at what it does , but it doesn't do anywhere near as much as a full DBMS. What it does do it, does in some very non -standard ways as well.

To be quite honest, if you asked me to manage access databases, I'd propably have to ask you for help though. So it's not a knock as such, it's just when people say DBA, they think of the big boys.

As for how to convince your team, I don't get that at all. Why do you need to?

by olivesuntech

I do not have a MCDBA and nobody has this certification at my company. However, we all have Engineering degrees and education. Without my knowledge and exsperience with MySQL and SQL there would not have been a migration. I am familiar with data modeling and normalization. I report to clinical leadership who is not familair with databases and depend on my expertise in this area. I agree you in regards that Access is not the most robust database (that is way most of them have been moved to a SQL backend). However, by definition of DBA, whether Access, SQL Oracle and work indicated, this is administration.

This discussion is closed to new replies.