Location : Johor Baru to service operations. Installation, configuration and maintenance of MSSQL Data Base Servers2008 / 2008R2 / 2012 / 2014 and Azure cloud database.
Creation and maintenance of SQL Databases. Basic knowledge on DDL, DML and DCL commands. Experience in Database Backups and Restoration.
Experience in Database Migration and Cloud Migration. Create Logins, Users, and assigning roles ,granting permissions. Knowledge in Amazon cloud RDs .
Knowledge in Azure cloud Database. Configure Maintenance Jobs and troubleshoot the failed jobs. Experience in Installing of Lite Speed tool .
Proven ability to handle Database of more than 1 TB in size . Knowledge in installing of RedIS servers . Expertise in SQL Server log shipping Configuration and troubleshooting issues and SQL Mail Expertise in SQL Server Database Mirroring and troubleshooting.
Monitor and maintain disk drive, log file and Tempdb Spaces. Checking the fragmentation levels of indexes, Rebuilding and Re-organize the indexes at regular intervals for better performance.
Good experience in resolve blocking issues by using SQL commands. Involve and troubleshooting log running queries, high CPU utilization issues etc.
Work with DBCC commands, DMV and DMFs to improve the performance of the Data Base. Expertise in Transactional Replication and troubleshooting issues, Able to configure different types of replications.
Experience in Clustering. Experience in configuration of AlwaysOn. Deployments of SQL Scripts, Deployment plan walkthroughs, DR activities.
Involve in SQL server and SQL database Upgrade processes. Service packs and Patch management. Experience in supporting Production Servers, Dev, QA and UAT.
Support Production Servers as DBA 24x7 rotational shifts