User blogs

Basically, the implementation of systems in the cloud is carried out by the cloud provider in conjunction with the IT team of the contracting company and the software vendor.

The cloud provider performs environment provisioning, database installation and configuration, access security, communication tools, among other activities. And softwarehouses are responsible for accessing the environments created by the cloud provider and installing their applications in that environment.

All teams (IT staff, softwarehouse and cloud provider) must follow the approval and start of production to make sure the migration is successful.

Below are some steps that need to be taken for this to happen.

Survey of company needs

Assess what the real business operation needs are, then see which systems should be migrated to the cloud - or which software as a service should be purchased. This is the initial step, and is usually taken with a cloud provider specializing in production environments.

In this format, the IT team must seek to be in line with the operational areas of the business, and the specialist provider must technically analyze the IT assets, the obstacles that can be faced and then outline the migration strategy.

Like all IT projects, this case must also be started in understanding the business and its challenges, since the implementation of new technologies needs to meet the demands and provide more competitiveness to the organization.

Computer Systems Analyst will help the organization to utilize computer technology efficiently and effectively. 

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.