Support x Project in DBA from Jack prabha's blog

For example, you need to install a new (or reinstall the old) database. This is a project or deployment. Once this service is done, it is then handed over to support, whose mission is to support this approved environment. However, if you need to create a new base in your bank, or even create a replication, this is another project and will not be attended to by support, most of the time.


This is an important distinction and avoids many confusions. Organized in this way, the provision of services can make recommendations for improving the environment and separate exactly what is the responsibility of each one. This gives transparency and reliability to the entire process.


Passive and active monitoring

Passive monitoring is that performed by robots or software that will generate alerts informing if something is out of compliance. Active is performed by people who will analyze the performance, integrity, safety data and propose changes to improve the environment in general. Among the items to be monitored both passively and actively we recommend:


Sessions (time), Lock, Logs, Backup (both if done, and integrity), tempdb, archieve, bank size, processing usage, machine ram, size and disk IO.


Checking the physical and logical structures of the database

Active checking of logs, tables and general integrity of the database construction.


Checking and auditing for access security

Who has access to the database, what are the permissions, how many times it has been accessed. Attackers can impersonate legitimate users, or use credentials from real users to create their own. Periodic checking helps prevent this.


Performance analysis and preventive tunning

Analyze, check and, if necessary, repair problems that may arise in the database and are affecting its performance, such as, but not limited to, identification of the most expensive queries.


Service hour cost

Most DBA service providers work on an hourly hire basis, but what looks cheap can be very expensive. In addition to the hourly rate, it is necessary to analyze the time for answering calls and the cost of these hours outside this period. Some companies offer contracts 24x7, that is, 24 hours a day, 7 days a week, but you need to assess whether it is worth it for you. For industries with 3 shifts this can be a differentiator, for service companies or businesses that work from Monday to Friday, it may be an exaggeration.


The Computer Systems Analyst will collaborate with personnel and management staff to clarify, prioritize and design alternatives. The analysts will coordinate and link the computer systems within the organization to share the information and increase compatibility.


Previous post     
     Next post
     Blog home

The Wall

No comments
You need to sign in to comment