Sql Dba

Job Description 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 Requirements SQL DBA