Send me more jobs like this

Keywords / Skills : MySQL

4 - 7 years
Posted: 2019-07-21

Industry
ITES/BPO
Function
IT
Role
Database Administrator (DBA)
Education
Bachelors
Degree
Posted On
21st Jul 2019
Job Ref code
126052
Job Description
Job Description :

ey Job Description/Responsibilities
• Extensive knowledge as a MS SQL Server DBA with hands-on experience in SQL Server 2008 R2/2012/2014/2016 • Working experience as a production support analyst supporting SQL server 2008R2/2012/2014/2016 instances. • Good knowledge in Installation, database maintenance, replication, backup & recovery, clustering and log shipping. • MS SQL Server installation, configuration and administration of various SQL Server Products like SQL Server Database Server 2008 R2, 2012,2014 & 2016 (Stand alone and Always On Clusters) • Knowledge in Database Creation, Database Configuration, Space management, and User management, Backup and Recovery, Database Maintenance. • Knowledge on deploying SSRS reports, creating data sources, assigning permissions. • Knowledge on deploying and executing the SSIS packages. • Setting up Mirroring, Log shipping and Transactional Replication • Extensive Knowledge on setting up and Implementing MS SQL Always ON. • Good Knowledge on T –sql • Install patch or service pack for SQL 2008 R2 , SQL 2012/2014/2016 • Disk space Planning and Management in all the servers. • Backup and Restoration of Databases to different environments as per the user requirement. • Implement and maintain database security, Knowledge on Database and Server roles and access levels. • Creating Users and assigning right permissions to them. • Having experience on Scheduling Jobs and assign Jobs. • Prepare SQL server for High Availability environment and support for the BCP activities. • Developing successful Backup strategies based on recovery model of the databases. • Configuring the DB mail with the help of SMTP servers. • Good knowledge to update more new techniques by Microsoft and developing the standard of supporting the SQL servers. • Good knowledge on setting up linked servers and assigning access. • Strong Knowledge on DBCC commands. • Running Trace Profiler and knowledge on extended events. • Resolve incident, service call and work order ticket based on SLA. • Effective Knowledge on Monitoring tools like SPOTLIGHT and SCOM. • Knowledge on Service Now too
Key Skill(s)

Similar Jobs
View All Similar Jobs
Walkin for you