Senior offshore DBA supporting MS SQL Servers

- Build high availability /disaster recovery solutions for databases and instances by implementing Always ON feature.- Build multi node SQL server failover cluster instances.- Replication and Mirroring implementation as per client requirements on multiple occasions. - Troubleshoot issues on AlwaysOn, replication, mirroring and log shipping failures/slowness.- Performance review on servers with slow performances.- Involved in Log shipping disaster recovery drills.- Shared… Show more - Build high availability /disaster recovery solutions for databases and instances by implementing Always ON feature.- Build multi node SQL server failover cluster instances.- Replication and Mirroring implementation as per client requirements on multiple occasions. - Troubleshoot issues on AlwaysOn, replication, mirroring and log shipping failures/slowness.- Performance review on servers with slow performances.- Involved in Log shipping disaster recovery drills.- Shared resource for multiple clients. - Support Audit report activities and daily database activities including backup/recovery, users and roles, incident management.- Driven multiple complex requirements from clients to closure swiftly and diligently.- Documentation and reviews for existing /new processes.- Configure, maintain,troubleshoot as a day today activity for SQL server 2005, 2008, 2008 R2 , 2012 and 2014 versions as 24*7 support professional. Show less

- Senior SQL Server Database administrator for multi tier applications.- Quarterly Audit report of SQL server users and Roles.- Daily maintenance of Database environments includes backup/restore activities, database refresh activities, user roles and permissions.- Documentation of multiple SQL server reports for business review and budget allocations on database infrastructure.- Migration of SQL server from SQL server 2005 to Higher versions. - recovered databases from… Show more - Senior SQL Server Database administrator for multi tier applications.- Quarterly Audit report of SQL server users and Roles.- Daily maintenance of Database environments includes backup/restore activities, database refresh activities, user roles and permissions.- Documentation of multiple SQL server reports for business review and budget allocations on database infrastructure.- Migration of SQL server from SQL server 2005 to Higher versions. - recovered databases from corruption issues.- Performance tuning for entire SQL server instances and specific queries.- Engage with developers and management to come up with solutions for Purging of archival data.- Performance review on SQL server with respect to SQL server instance settings such as MAXDOP, Max memory settings, assess disk performances.- Single point of contact for all database related activities and changes. - Rebuild database servers as emergency operations.- Design SSIS packages to automate basic ETL processes. Show less

- Experience with SQL server installation, configuration and maintenance tasks. - Experience with setup of 2005, 2008, 2008 R2 and 2012 versions of MSSQL Server.- Implementation,audit and review SQL server security policies for SQL server logins and database users.- Configure and troubleshoot SQL DR with SQL server Log shipping.- Implement high availability of instances using FCI for SQL server 2005 , 2008 and 2008 R2 versions.- Applying service packs/hotfixes to SQL server… Show more - Experience with SQL server installation, configuration and maintenance tasks. - Experience with setup of 2005, 2008, 2008 R2 and 2012 versions of MSSQL Server.- Implementation,audit and review SQL server security policies for SQL server logins and database users.- Configure and troubleshoot SQL DR with SQL server Log shipping.- Implement high availability of instances using FCI for SQL server 2005 , 2008 and 2008 R2 versions.- Applying service packs/hotfixes to SQL server when new patches are released by Microsoft.- Design basic SSIS packages for automation of ETL process.- Build Transactional and Snapshot replication for multi site replication topology.- Design, test and implement backup and recovery strategies as per application critical priority.- Configure SQL agent jobs , monitor job failures.- Incident and change management activities. - 24*7 support and On call support for business critical activities. - Discuss solutions with Developers, application support teams to fulfill client requirements. Show less