JOB DESCRIPTION ABOUT DBA

DBA is responsible for the performance, integrity and security of a database. Additional role requirements are planning, development and troubleshooting.The database approach incorporates the following principles:

• data remains consistent across the database;
• data is clearly defined;
• users access data concurrently, in a form that suits their needs;
• there is provision for data security and recovery control (all data is retrievable in an emergency).

DBA roles are increasingly identified by the databases and processes they administer and the capabilities of the database management system (DBMS) in use.

job decription

Typical work activities

The work of a database administrator (DBA) varies according to the nature of the employing organisation and the level of responsibility associated with the post. The work may be pure maintenance or it may also involve specialising in database development.
Typical responsibilities include some or all of the following:

• establishing the needs of users and monitoring user access and security;
• monitoring performance and managing parameters to provide fast query responses to front-end users;
• mapping out the conceptual design for a planned database in outline;
• considering both back-end organisation of data and front-end accessibility for end-users;
• refining the logical design so that it can be translated into a specific data model;
• further refining the physical design to meet system storage requirements;
• installing and testing new versions of the database management system (DBMS);
• maintaining data standards, including adherence to the Data Protection Act;
• writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata);
• controlling access permissions and privileges;
• developing, managing and testing back-up and recovery plans;
• ensuring that storage, archiving, back-up and recovery procedures are functioning correctly;
• capacity planning;
• working closely with IT project managers, database programmers and web developers;
• communicating regularly with technical, applications and operational staff to ensure database integrity and security;
• commissioning and installing new applications and customising existing applications in order to make them fit for purpose.

Because of the increasing levels of hacking and the sensitive nature of data stored, security and disaster recovery have become increasingly important aspects of the work.


provided link its :
http://jobsearchtech.about.com/od/careersintechnology/p/DBA_Profile.htm
http://www.prospects.ac.uk/database_administrator_job_description.htm


here its the $$$$ report for UK so can take it as reference^^

http://www.prospects.ac.uk/database_administrator_salary.htm

SOLUTION

in my opinion

     Learn o master these few skills:

      in order to become a database expert...with all the skills u had u should not worry about your work...but still u need ur social skills to make u easily communicate with ur boss, workers, friends...

-        C, C#, C++

-        Cisco

-        Java, J2EE

-        Linux

-        .NET

-        Oracle

-        PHP

-        SAP

-        Solaris

-        SQL, SQL Server




Paul S. Randal

TO BECOME A SQL EXPERT
now this link is from SQL let see what they said:
http://technet.microsoft.com/en-us/magazine/gg299551.aspx


HERE ITS THE BIODATA FOR PAUL S.RANDAL
http://sqlskills.com/AboutPaulSRandal.asp

Where can we apply our skills as database expert here its the link will lead you to :
http://www.linkedin.com/jobs/jobs-Data-Quality-Engineer-2120425

http://www.ibm.com/developerworks/data/library/techarticle/dm-0401gupta/

 

Microsoft Access 2007 Tutorial

here is the guidelines to use microsoft access 2007 hope it help u 

http://www.baycongroup.com/access2007/index.html

HOW TO BECOME A DATABASE EXPERT???

Here its the summary of skills & certificates being a database expert:

• Oracle Certified Professional Database Administrator – 9i & 10g
• Oracle Certified Professional 6i Application Developer (Oracle forms)
• Strong SQL and PL/SQL skills
• Strong Understanding of Oracle RAC
• Database Security
• Backup and Recovery, RMAN
• Oracle Forms and Reports
• TOAD - Tool for Oracle Application Developers
• Strong virtual machine skills
• Comptia A+ Certification
• Web design skills including HTML, ASP, PHP,Javascript, CSS and image editing
• Office Software including Microsoft Word, Access,Excel, Outlook, Powerpoint and Macros
• Employee management, training and support
• Human resources development, including hiringpractices, company policies and maintaining a highlevel of employee morale
• Outstanding oral and written communication skills
 
 
 
 
here its an example of an database working exp and skill&cers
 
http://www.database-expert.com/Edward_Stoever_resume_09-2009.pdf

 

 

Database tutorial part1

V1 - Oracle Database Concepts - Part 1

V2 - Oracle Database Concepts - Part 2

V3 - Oracle SQL Tutorial - Creating a table (Theory) 

Now v lookin into job propects

I noe i noe many ppl tink tat computing career can facin jobless chances compare to others job is "a bit higher"

As u can see the percentage of unemployed computer science is the highest compare to others.

http://educationmalaysia.blogspot.com/2006/07/70-public-university-graduates-jobless.html



-tis one is from m'sia education  one so i tink it's ok to take the result for us to refer^^

here is the full unemployment rate for 2009 graduates in different professions.

Computer science 17%
Communications 14%
Architecture 13%
Engineering 13%
Creative arts 13%
Business studies 11%
Maths 10%
Languages 9%
Biological science 9%
Law 6%
Education 5%
Medicine 0%

our deputy minister said:

Our Deputy Prime Minister also argued that a "mismatch" of skills in the workforce had "contributed to the unemploymnent of more than 60,000 local graduates". I've discussed this topic here earlier. Skills "mismatch", if at all relevant, contributes only to a small portion of the unemployment issue. A survey conducted earlier has indicated that as many as 30% of the umemployed local graduates are computer science and information technology degree holders. These skills are in obvious demand in the country - it is not a mismatch. The clearcut issue in this case is that many of the local institutions of higher learning, both public and private have failed to offer a sufficiently rigourous education to produce the necessary quality in the workforce which the industry requires.

deputy minister 2006

when time moving forward all the company want its computing expert...here is the link
http://www.allyhunt.com/cms/updates/top-paying-hot-jobs-in-malaysia

-at US the best job goes to>>>>
http://money.cnn.com/magazines/moneymag/moneymag_archive/2006/05/01/8375749/index.htm

TiredX...

so tired doin al tis kind of thing><

TIS project part 2 ^^

now Let's talk bout the advantages and disadvantages
what do u think about having IT as ur career??

nEGATIVE PERCEPTIONS ON cOMPUTING CAREERS

-    -Highly monotonous >>

-    -High level of stress >>

-    -Requires long hours of works and commitments >>

-    -Competition >>

-    -Need updated time by time >>

 Why Information Technology is a great choice of career

Advantages

Constant demand

-The number of new recruits in IT has been in decline for some years and there is no indication this year will be any different. But in the UK, one in 20 people work in IT and unemployment for IT staff has now dropped to 3.1%, compared to 8.3% for the overall workforce. Four out of five jobs require IT skills. Unemployment is rising and yet there is still an IT skills shortage, says Gordon Frazer, UK managing director of Microsoft.

"Four out of five jobs require IT skills. Unemployment is rising and yet there is still an IT skills shortage," he says. (FRAZER UK managing director at Microsoft)

                                           (FRAZER UK managing director at Microsoft)

Job satisfastion

- bonuses will be given based on performance(many of company)

 

TIS PROJECT: Intro

What is database?

-collection of information that can let u easily manage, accessed, updated.
http://searchsqlserver.techtarget.com/definition/database



wanna know more about database????

CHECK TIS OUT!!

1. What is Oracle? - Definition from Whatis.com
2. What is SQL Server? - Definition from Whatis.com
3. What is database management system (DBMS)? - Definition from Whatis.com
4. What is object-oriented programming (OOP)? - Definition from Whatis.com
5. What is relational database? - Definition from Whatis.com 


Feel boring about reading the article??

Here it's the video clip from Standford University that introducing this courses.. Hope u people enjoy the clip
http://youtu.be/ShjrtAQmIVg


another link u should go n explore urself it's this...
-it describe what database administrator and system analysts do

http://www.studymalaysia.com/education/art_career.php?id=26

IN next post i will try to find the advantages & disadvantages of IT career