SQL Dba

Job Description:

·        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