Sql Server Management

SUYOG S. PAGARE

***, ***** **** ***, **** Rto, Kalyan (W)

Contact: +91-996*******; Email: *****.********@*****.***

SQL DATABASE ADMINISTRATOR

Seeking a position in an organization that provides ample opportunity to explore & excel while carving out the niche for personal, professional as well as organizational goals

PROFILE

Competent and diligent professional with an experience of over 9+ Years in Installation, Configuration, troubleshooting and Recovery for databases; currently spearheading as SQL DBA Tier 3 with Datavail Infotech.

Proficient in SQL Database Administration encompassing Planning/ Implementing, Memory Management, back up & restore, login & user creation, database health check up, SQL Mails, Alerts Monitoring, Database Migration, Performance Tuning, creation and configuration of Database on SQL Server 2000, 2005, 2008 and SQL Server 2008R2, 2012, 2014.

Experience in SQL Server installation, Data checking, uploading and downloading, Maintenance, log shipping, replication, database mirroring, SQL cluster, Always On, Troubleshooting technical problems and Coordinating with the DBAs to solve technical difficulties.

Focused and hardworking individual equipped with thorough knowledge and technical understanding coupled with an analytic bent of mind and confident to take challenging assignments.

Technical Skills

Languages

TSQL.

Database

MS SQL 2000, 2005, 2008, 2008 R2, 2012, 2014, Oracle 9i, Oracle 10g.

Database Tools

SQL Enterprise Manager, SSMS, SQL Profiler, SSIS, SSRS Performance Dashboard, MBSA, RMAN for Oracle.

Trainings

AMAZON AWS Solution Architect Associate

AMAZON AWS Solution Architect Professional

Attend Training on Big Data Hadoop Administration

Attended training on OCP and OCA course.

ITIL V3 Certified

PROFESSIONAL EXPERIENCE

Datavail Infotech Since November 2014.

SQL DBA Tier -3

Working on all USA based clients including clients from Healtchcare, Entertainment and banking domain.

• Providing level 3 DBA support with experience of handling team over 17 DBA’s.

• Attending CAB meetings with stake holders and higher management.

• Following up ITIL process for any kind of Change, problem Management issues.

• Working on DR strategies, Security Management, Hardening of server’s.

• Participated in Database Audits: Implemented security best practices and recommendations given by the audit team for SQL environment.

• Base lined Query performance by storing the execution plans of critical/ Daily reports for future reference.

• Base lining and capacity planning of Database servers using Perfmon, DMV and Data collector in SQL 2008.

• Partitioning of large tables and analyzing the query performance improvement.

• Implementing SQL Server 2012 HADR Availability Groups on base Windows clusters.

• Worked on POC for SQL2014 installation and Always on configuration.

• Customized event notification to capture blocking queries & troubleshooting blocking queries using Read uncommitted isolation level & Snapshot isolation levels.

Mphasis an HP Company Jan 2013 – July 2014

SME SQL DBA

Working on all USA based clients including clients from Banking domain for eg. Butterfield bank, Deutsche Bank etc.

• Providing SQL Server DBA support for production changes (RFC) following the Change management process.

• Building and Managing 2005, 2008, 2008 R2, 2012 SQL Failover Clustered Instances on Windows Clusters.

• Building and Managing SQL Server 2000, 2005, 2008, 2008 R2 & 2012 standalone instances.

• Migrations of SQL Server 2000 to 2005/2008, 2005 to 2008, 2000 to 2012 etc.

• Implementing SQL Server 2012 HADR Availability Groups on base Windows clusters.

• Configuration and troubleshooting of SQL Server High Availability solutions like Failover SQL clusters, HADR (Availability groups), Log shipping, Database mirroring, and Replication ( mainly snapshot & transactional ) etc.

• Managing HP Polyserve SQL Instances.

• Resolving all DB related external/internal production & non-production incidents within SLA.

• Handling routine day to day DB related requests like backup/restore/refresh, user/login management, Data transfer, DB changes deployment, linked server creation etc.

• Planning & carrying out Disaster Recovery solutions for SQL Servers across different applications using various methods.

• Patching SQL Server 2008R2/2008/2005/2000 Standalone & Clustered instances with Hot-fixes, service packs etc regularly.

Datavail Infotech July 2010 – Jan 2013

Team Lead MS SQL DBA

Responsible for 24*7 support for USA clients & working on Failover Clustering, Replication, log shipping, mirroring, performance tuning.

Proactively monitor the database systems and provide database administrative support to ensure secure services with minimum downtime (SQL Server).

Responsible for installation, configuration and troubleshooting of SQL Server 2000, 2005, 2008 and SQL Server 2008R2.

Involved in handling database backup and recovery procedures and scheduling them for execution.

Handling installation, creating new database using prescribed specifications as per the requirement from the client.

Managing database security, creating and assigning appropriate roles and privileges to users depending on the user activity.

Handling performance using profiler & performance monitor and documenting the status reports

Responsible for Server installation and involved in Data checking, uploading and downloading.

Implementing and monitoring of log shipping for multiple servers.

Troubleshooting technical problems related to database performance or I/O hardware performance issue and coordinating with the DBAs to solve technical difficulties ensuring all jobs run successfully.

Creating and configuring the linked server and Monitoring SQL server, Application logs and analyzing the logs.

Accountable for performing Database Migration Test environment to PROD environment..

Installing SQL Server service packs based on the errors and flaws that are found in the application.

Implementing SSRS Reports for monitoring Database activity including current or historical report.

Automate and setup internal processing tasks, backup tasks and setting up alerts using SQL Agent to monitor the server and database health.

As a ORACLE DBA support my responsibilities are:

Healthcheck of ORACLE database.

Backup and recovery of databases using RMAN.

User creation, table space management.

Installation of Oracle software and database creation.

Also worked on MYSQL databases and my responsibilities are:

Monitoring session.

Backup and restore of MYSQL databases.

Database, Logins creation.

Clover Infotech Ltd April 09 - July 2010

MS SQL DBA

Handled different clients like Euronet, Deloite, HSBC Security, Cipla, DBS bank, DCB, CRISIL, Birla Sun Life, Peninsula, Future Money & Great Ship.

Successfully Installed and configured MS SQL Server Service Packs applicable. Implemented and monitored Log

shipping, Database mirroring & replication

Provided consultation on SQL Server to client’s development teams.

Upgraded and upsized databases from earlier versions to the latest versions. Initiated performance Tuning using performance monitor and profiler. Designed and implemented strong backup policy, security policy.

Provided 24 X 7 production support, Monitored Error Log, system log & database performance.

Responsible for Migration of SQL Server from 2000 to 2005, Recovering production databases with minimum data loss & Performing monthly drill to verify backups contingency.

Recovery of SQL Server databases : Whenever there is major database crash (like a disk crash) recovery of database from production backup or standby is carried out.

Scheduling Backups for Database: Daily Full backup Differential & T-Log backups are carried out of all production databases, as per the business requirement.

Handled Creating Logins and to assign Particular database Role to them, Installing MS- SQL Server (2000)/(2005) client & Server.

Dexterity in creating DTS Packages, Maintenance Plans to Backup Databases, databases as per available Space, Linked Server, Batch Files to Copy database backups & SSIS Packages to Transfer data from SQL database to Oracle database.

As a ORACLE DBA support my responsibilities are:

Monitoring session and session management for ORACLE databases.

DR check.

RSIMC October 2008 – April 2009

SQL DBA

Handled clients like Reliance, Birla Sun Life & Implemented client-server network.

Installed and configured MS SQL Server Service Packs applicable & monitored the network 24 X 7. Also initiated Configuration of Server.

EDUCATIONAL CREDENTIALS

B.E in Electronics & Telecommunication, 2008, R.A.I.T

MBA (IT), from UBI, Belgium.

Certification

MCTS 2008, MCITP SQL 2008, ITIL V3. AWS SA-Associate.

Extra Curricular Accolades

Worked on the configuration of Robotics Level1 and represented in IEEE Techfest, 2006.

Finalist in Robotics Level 1 Technovanza a national level event held in VJTI.

Date of Birth: 10th Aug 1986

Languages known: English, Marathi, Hindi.

Contact this candidate