Monday 3 June 2013

SQL DBA INTRODUCTION

    SQL DBA
The Data Base Administrator (DBA) is responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities facing the company. It is extremely important to the company that on-line processing database systems offer the highest reliability and performance possible. The DBA is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives. Trains and develops technical support and applications staff to better utilize on-line processing databases environment. Provides and designs tools to assist in the management of the database and transaction processing environment. Works to provide a working model of our transaction processing environment or capacity assessment and planning.
Develops a methodology for the ongoing assessment of database performance and the identification of problem areas. Develops a security scheme for the database environment, as well as assisting in disaster recovery if necessary. Provides leadership during the development and enhancement of production applications including working with applications, technical support and operations during the design, development and implementation of applications. Work with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments. Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process. Work with vendors in evaluating and implementing new technologies.
Microsoft SQL Server Administration (DBA) Services
  • MS SQL Database Designing
  • MS SQL Store Procedure Development 
  • MS SQL Trouble-shooting and Query Optimization 
  • Database Performance Scalability and Indexing 
  • Database Back-up, Monitoring, Memory Check, Administration and Maintenance Services 
  • Database Business Intelligence Services 
  • Database Integration Services 
  • Database Support Services 
  • Database Security and User Management Services 
  • MS SQL DB Tracking 
  • Replication- Data Synchronization among multiple servers 
  • Database QA/Testing Services

No comments:

Post a Comment