Job description for Database Administrator Analyst at PT. Vlink Consulting Indonesia
- Installing SQL Server : Installation, Administration and Maintenance of SQL Server Instances, Setup Test, Dev, Staging, and Production Environments.
- Security : Create Users and Design permissions based on the level of database access the user would need.
- Security and General Administration : Create Linked Servers to SQL Servers and other databases such as Oracle, Access, etc
- Database Backups and SQL Server Agent : Database Backup and Restoring Strategy
- SQL Server Agent : Once created the database Backups, monitor those backups are being performed regularly.
- Database Backups and Recovery : From time to time recover the databases to a specific point of time, as per the requests.
- Failover Clustering, Database Mirroring, Log Shipping and Replication : Setup High-Availability as part disaster recovery strategy for the databases
- Monitoring SQL Server Error Logs and Checking your email alert : Troubleshoot various problems that arise in a day-to-day work and fix the issues
- Creating and maintaining those indexes, not performing database shringking, memory settings, monitoring CPU usage and Disk I/O activity etc : Monitoring and performance Tuning; physical Server level (Database setting options)
Responsibilities:
- Candidate must possess at least a Diploma, Bachelor's Degree, Engineering (Computer/Telecommunication) or equivalent.
- Required skill(s): MS SQL Server, Oracle.
- At least 2 year(s) of working experience in the related field is required for this position.
- Preferably Staff (non-management & non-supervisor)s specializing in IT/Computer - Network/System/Database Admin or equivalent.
- Full-Time position(s) available.
