analyzes, researches, queries, reviews data with the goal of finding
useful information, insight, trends
importing, cleaning, transforming, validating or modeling data with the
purpose of understanding or making conclusions from the data for
decision making purposes.
presenting data in charts, graphs, tables, designing and developing
relational databases for collecting data and in some organizations it
also includes building or designing data input or data collection
screens.
write Data Definition Language or Data Manipulation Language SQL
commands, be responsible for improving data quality and for designing or
presenting conclusions gained from analyzing data using statistical
tools like Microsoft Excel, SAS, SPSS and others.
Working Hours:
Database analysts usually work a 40-hour week.
Overtime is often part of
the job as deadlines and user requirements must be met.
Database administrators work with database software to find ways to store, organise, and manage data.
They are responsible for the performance, integrity, backup and security of a database.
They identify user needs, set up computer databases, and test systems. They ensure that systems perform as they should and add people to the system as needed.
They also plan security measures.
They also need some additional role requirements that are:
planning
troubleshooting
development
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).
Working Hours:
Working hours typically include regular unsocial hours.
Overnight and weekend work is often necessary as maintenance and development work needs to be undertaken during periods of low usage.
•A database is an organised collection of data for one or more purposes, usually in digital form. •The term "database" may be narrowed to specify particular aspects of organised collection of data and may refer to the logical database, to physical database as data content in computer data storage or to many other database sub-definitions •In computing, databases are sometimes classified according to their organisational approach. The most prevalent approach is the relational database, a tabular database in which data is defined so that it can be reorganised and accessed in a number of different ways. A distributed database is one that can be dispersed or replicated among different points in a network. An object-oriented programming database is one that is congruent with the data defined in object classes and subclasses. •Computer databases typically contain aggregations of data records or files, such as sales transactions, product catalogues and inventories, and customer profiles. •Information from http://searchsqlserver.techtarget.com/definition/database
Computer science majors program computer systems, maintain communications networks and develop the core digital technologies that influence our lives. Computer science can be separate into: ~ Network and Security ~Software Engineering ~Database System ~Bio Information System ~Graphic Design and so on...
