Pratik Rane

Background

About Pratik Rane

Configuring the SQL db server for High availability of the servers in (Production,Prod like,Disastor Recovery,Devtest environment ) • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. • SQL Server upgrade 2008,2008r2,2012,2012r2,2014 • Knowledge of SQL server migration in production environment • Applying cumulative and SP updates in production environment. • Implementing and Rebuilding/Restoring the indexes after Fragmentation • Conducting the Performance Monitoring on SQL servers. • Knowledge of SQL Server 2012 likes Querying, Stored Procedure, Jobs, Backups, Log shipping, Mirroring etc. • Implemented always on availability in node clustered environment. • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions. • Having hands on experience in DR processes including Log Shipping and Database Mirroring. • Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark. • Having Experience on Data center servers and handling 2 TB databases. • Creating PowerShell scripts to automate various daily activities.