id: MTAwMDAwMDAxNTYyMDg0MiA0MQ

reference: 1000000015620842

documentId: 1000000015620842

connectionPointId: 41

lastModificationDate: 1559025165000

Názov práce: Dizajnéri a správcovia databáz

Popis práce:
    Installation, Administration and Maintenance of SQL Server Instances.
    Setup Test, Dev, Staging and Production Environments.
    Create Users and assign permissions based on the level of database access the user would need.
    Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc.
    Design database Backup and Restoration Strategy.
    Once created the database Backups, monitor those backups are being performed regularly.
    From time to time recover the databases to a specific point of time, as per the requests.
    Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication)
    Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured))
    Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc)
    Documenting major changes to the SQL Servers.
    Apply Service Packs & patches.
    Database security administration.
    Writing SQL queries,procedure,packages,trigger and understanding of PL/SQL code.
    Tunning SQL queries
    Designing DB objects ie. tables/indexes/views etc and constraints designing & deployment.

numberOfPosts: 1

jobCategoriesCodes_0: http://data.europa.eu/esco/isco/C2521

abstractJV_contact_0:
dominika.tothova (at) tcs.com, dominika.tothova (at) tcs.com, Bc. Dominika Tothová

requiredEducationLevelCode: 7

positionTypeCode: temporary

Minimálny plat: 1800

Maximálna plat: 0

salary_payingIntervalCode: Month

Meno zamestnanca:
Tata Consultancy Services Limited - organizačná zložka

employer_website: https://www.tcs.com/

source: ISSZ