Security, Integrity, and Availability
Your company’s data is a vital and extremely valuable asset.  Is it secure, valid, accurate, and available when needed - as needed?  Does it conform to your business rules?  Ensuring that your data is all of these is the main responsibility and role of the Database Administrator (DBA).  If you need assistance in bringing your data and processes up to acceptable levels, PCS’ senior level technical staff is available to provide you with whatever necessary DBA support solution that may be required.

Specific DBA responsibilities vary by the technology of the database management system (DBMS) used and the organizational environment of the enterprise itself.  At a minimum, functions that fall within the DBA’s area of responsibility include:

• Security
• Integrity
• Availability
• Recoverability (Backup & Restore)
• Performance
• Testing
• Database Design
• Database Utilization

One critical area sometimes viewed as a lesser responsibility or not fully acknowledged as a responsibility by DBAs is the provision of testing support.  It is essential, however, that testing be successfully conducted and completed as a part of the recovery process to validate that the restoration has been successful.  The DBA function is responsible for recovery, and consequently must ensure that a thorough testing program is in place.  With regard to database design and database utilization responsibilities, DBAs have varying degrees of responsibility and influence that are directly dependent on the company’s organization, IT structure, and staffing environment.  They may have direct responsibility or merely provide direction and guidance.

PCS’ staff has years of experience in all DBA functions and are technically proficient with all major DBMSs: Oracle, MS SQL Server, IBM DB2.  As an adjunct of our normal consulting services and activities, our staff has continual exposure to and experience with the latest releases of DBMS technologies.