Role : MS SQL DB Admin
Experience : 6 - 12 years
Hire : Perm role
Location : Sentral KL
MS SQL DB Admin
Work along with an Onsite / offshore team in SQL track and should be hands on in SQL and certified
Good client engagement skills needed and stake holder management
SQL installations and configuration for SQL server 2008\2008R2\2012\2014\2016\2017, troubleshooting installation issues.
SQL database upgrades/Migrations, backup and restores.
Creation of the SQL logins and users, access provision as per the requirement.
Configuration of database mirroring and troubleshooting mirroring issues.
Configuration of Always on availability groups and troubleshooting AG issues.
Configuration of log shipping and troubleshooting Log shipping issues.
Creation of AG listeners, adding the database to always on and performing the failovers.
Configuration of Transaction replication and trouble shooting for replication issues, knowledge and hands on other replication topologies.
Installation and configuration of SQL server clustering, performing the failovers and troubleshooting the SQL cluster issues.
SQL performance tuning and Query optimization, knowledge on backup tools like TDP and semantic net backup
SQL patching such as applying service packs, security patches and Hotfixes.
Setting up the extended event traces and assisting the application team for trouble shooting the application issues from database standpoint.
Cognizant (Nasdaq-100: CTSH) is one of the world's leading professional services companies, transforming clients' business, operating and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant is ranked 195 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com or follow us @Cognizant.
Functions : IT
Industries : IT/Computers - Software
Skills/Roles I hire for: Java, Dotnet, Business Analyst, Business Intelligence, LIMS, Sap, FICO, Abap, Production Planning
level Hiring For: Mid Level
Simple body text this will replace with orginal content