Database Administration

Database Administration must work closely with key Application Management teams or departments– and in some organizations the functions may be combined or linked under a single management structure. Organizational options include:

• Database administration being performed by each Application Management teams for all the applications under its control
• A dedicated department, which manages all databases, regardless of type or application
• Several departments, each managing one type of database, regardless of what application they are part of.

Database Administration works to ensure the optimal performance, security and functionality of databases that they manage. Database Administrators typically have the following responsibilities:

• Creation and maintenance of database standards and policies
• Initial database design, creation, testing
• Management of the database availability and performance; resilience, sizing, capacity volumetrics etc.
• Resilience may require database replication, which would be the responsibility of Database Administration
• Ongoing administration of database objects: indexes, tables, views, constraints, sequences snapshots and stored procedures; page locks – to achieve optimum utilization
• The definition of triggers that will generate events, which in turn will alert database administrators of potential performance or integrity issues with the database
• Performing database housekeeping – the routine tasks that ensure that the databases are functioning optimally and securely, e.g. tuning, indexing, etc.
• Monitoring of usage; transaction volumes, response times, concurrency levels, etc.
• Generating reports. These could be reports based on the data in the database, or reports related to the performance and integrity of the database
• Identification, reporting and management of database security issues; audit trails and forensics
• Assistance in designing database backup, archiving and storage strategy
• Assistance in designing database alerts and event management
• Provision of third-level support for all database-related incidents.

Date: 2014-12-29; view: 887