Job Description: Roles
and Responsibilities:
· Expertise in RDBMS S/W installation, database
server builds, applying patches, upgrading, configuring, trouble shooting of
SQL SERVER 2008R2/2012/2014/2016
· Expertise in Disaster
Recovery plans by configuring AlwaysOn, Clustering, Log -shipping, Mirroring and
Replication (Snapshot and Transactional).
· Implementing High
Availability in SQL 2012/2016 by configuring AlwaysOn Availability groups
across 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 any
other 3rd part tool.
 Experience in query
optimization and performance tuning. Experience in using SQL Profiler,
Execution Plan, Performance Monitor and DBCC Commands.
· Experience in
PowerShell 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 Knowledge
articles and sharing with the team on day to day activities.
· Preparing Knowledge
articles and sharing with the team on day to day activities.
Skills /Competencies:
Preferred:
· Providing
24X7 Support and maintenance to all the Database Instances of OLTP/OLAP.
Additional Skills:
· Strong Communication & Management skills
and, expertise in Onsite/offshore and Client coordination.
· Excellent
customer interfacing skills.
* Strong
attention to detail and outstanding analytical and Problem -solving skills