Rolesand Responsibilities:
Expertise in RDBMS S/W installation, database server builds, applying patches, upgrading, configuring, trouble shooting ofSQL SERVER 2008R2/2012/2014/2016
Expertise in Disaster Recovery plans by configuring Always On, Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
Implementing High Availability in SQL 2012/2016 by configuring Always On Availability groupsacross Windows Server Failover Clustering.
Expertise knowledge in database encryption
Expertise in database Back Up, Restore,Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
Monitoring Instances, Configuring and Enabling alerts using Quest Foglight/App Dynamics or anyother 3rd part tool.
Experience in queryoptimization and performance tuning. Experience in using SQL Profiler,Execution Plan, Performance Monitor and DBCC Commands.
Experience in Power Shell or SSIS to automate the day to day activities and troubleshoot/enhance the existing scripts.
Monitoring/Troubleshooting Log shipping /DB Replication/Always ON.
Respond and Troubleshoot database related problems reported by customers.
Automate the routine tasks.
Preparing Knowledgearticles and sharing with the team on day to day activities.
Preparing Knowledgearticles and sharing with the team on day to day activities.
Preferred:
Providing24X7 Support and maintenance to all the Database Instances of OLTP/OLAP.
Additional Skills:
Solid Communication & Management skillsand, expertise in Onsite/offshore and Client coordination.
Excellentcustomer interfacing skills.
Strongattention to detail and outstanding analytical and Problem-solving skills
J-18808-Ljbffr