SAURABH DUBAL

Address:

Plot No:***, sec-**, Sanpada,Navi Mumbai-400705

E-Mail ID: admcoi@r.postjobfree.com

Mobile no: 982*******

Career Objective:

Seeking a challenging career and growth oriented position in Microsoft SQL server Database administrator Environment where knowledge can be shared & enriched logically.

Summary of experience

●4.8 years of experience as a MS SQL Database Administrator

• Expert in installation, upgrade and configuration of MS SQL Server 2005, 2008 and 2012.

• Sound knowledge in Database Backup, Restore, Attach-Detach.

• Developed backup and recovery strategies for production environment.

• Handling all the blocking issues which affect the performance.

• Experience in scheduling monitoring of Jobs.

• Creating and Maintaining of Maintenance Plan.

• Implementing MS SQL Server Security and Database permissions.

• hand’s on experience in Log Shipping, always on and Mirroring of databases between the

servers.

●Basic knowledge of replication and clustering.

• Basic knowledge Performance Tuning (Performance Monitor, SQL Profiler).

• Create and maintaining the linked servers.

• Create and maintaining and Database mail.

• Create indexes, maintaining indexes and rebuilds and reorganizes.

●Sound knowledge of IIS

●Data import/export (data Migration/Data Dump)

●24 x 7 Production Database Remote and On-Call Support.

●Experience in SSRS,SSIS,Powershel script

●Managing Incident call provide RCA.

Certification

●Successfully Completed Diploma in Software Programming (IDEMI INSTITUTE).

●Oracle 12c sql/plsql certification

Technical Skills:

Operating Systems

WINDOWS XP/7,10,WINDOWS SERVER 2003,2008,2012

RDBMS

MS SQL SERVER 2005/2008,2012,Oracle 12c

Web Technologies

Html, .Net, IIS

4.Netmagic NTT solution (2Jan 2020 to till date )

Role: DBA

Team size : 12

Description:

Netmagic is a currently largest datacenter provider in india.we provide support almost all the aspect.

We currently support 600 DB server with 350 Client that is 24/7 support.

Responsibilities:

Installation & Configuration of SQL Server 2016/2017.

SQL Cluster installation fixed the issue.

Monitoring and maintenance 350+server with there database.

Applied patching on stand-alone server or cluster server.

Create poa before any plan activity and eliminate the same.

We are working on tikect basic so we closed incendent in 10min buffer time or response the same.

Corrdinate with customers if any issues, escalation happened.

3.Company name: TeleperfomancePvt Ltd, Mumbai from (1st Aug 2018 to 23rd Dec 2020)

Project Title : Domino's

Client : Domino's

Role : Database Administrator.

Environment : SQL Server 2008R2/2012 & 2014 on Win Server 2008/2012

Duration : 1st Aug2018to Till Date

Description:

Domino's Pizza Inc. is an American pizza restaurant chain. The corporation is headquartered at the Domino Farms Office Park Ann Arbor Charter Township, Michigan, United States, near Ann Arbor, Michigan. Founded in the United States in 1960, Domino's is in 82 countries, making it the second-largest franchised pizza chain after Pizza Hut. In March 2017, Domino's announced a pilot project in Dutch and German cities using ground drones to deliver food within a one-mile radius of stores in partnership with Starship Technologies. The scope of the project is to monitor and maintenance of all SQL databases servers.

Responsibilities:

Installation & Configuration of SQL Server 2008\2008R2\2012 & 2014 .

Involved in the process of Up gradation/Migration SQL Server 2005,2008 & 2008R2 to 2014.

Performing Index Rebuild Activity Manually on frequent basis.

Hands on Experience in Configuring Log shipping and troubleshooting the issues.

Proactively monitored the DR Server and prevented crash due to space issue.

Used DBCC commands to troubleshoot issues related to database consistency.

Hands on Experience in Creating Linked Servers from SQL to SQL for distributed query purpose.

Configuring Database Mail, Managing Operators and alerts.

Monitoring for the failovers of all failover cluster instances running in the environment and move them on to the preferred nodes with the concerned team’s approvals.

Regular monitoring of servers, which includes Backup Jobs, maintenance jobs and troubleshoot incase of failures on day to day basis.

Managing the MS SQL SERVER Security on development, and production environment

2.Company name: Softengerindiapvt.ltd (31july2017-24April2018)

Client: SVC CO-OP Bank Ltd, Mumbai

The SVC CO-OP Bank is a leading Co-Operative Bank in India with 190+ branches in 10+ states across all over India. Bank has its own Core Banking Software (CBS) “GENIUS” that is used by its branches and 40+ Client CO-OP Bank’s with a total strength of 300+ Branches of client banks. Along with CBS, Bank also offers Net Banking, SMS Banking, ATM Services, Demat Services, etc to its customers.

Role: DBA

Responsibilities:

Maintaining the job Schedules and Backup and Restoration of Databases

Executing and maintenance T-sql scripts.

Maintaining Database Backup.

Migrated SQL server 2008/2005 to SQL Server 2012 in Microsoft Windows Server 2008 Enterprise Edition.

Created Backup and Recovery procedures using SSMS.

Analyzed the existing application programs and tuned the SQL Queries using SQL Profiler in Test and Production database.

Creation and Maintenance of SQL Users Security Permissions, Roles and Authentication Modes as a part of Security Policies for various uses.

Handled Daily routine DBA tasks like user backup and restoration requests, Space issues and Maintenance jobs on Production and Test Databases

Created SQL Jobs, Schedules, Alerts using SQL Server Agent and Notifications using Database Mail.

Experience in Creating and Maintaining Database Mirroring and Log Shipping as High Availability Tool.

Responsible for Load and Performance Monitoring of Database Servers.

Rebuilding and monitoring of indexes for better performance.

Monitoring and Scheduling of Daily jobs and debugging of any issues related to failure of Jobs.

Daily inspection of Error logs, monitoring of Tablespaces and Partitioning in Oracle Databases.

Provide 24 x 7 on call support for databases to achieve maximum performance and availability of database in production environment

1.Company name: Accord Fintech Pvt. Ltd. (Aug2014-Aug2016)

Project Name: Ace-MF

Team Size: 4

Role: DBA

Description:

Presenting Ace MF database, a desktop based application, A COMPREHENSIVE & ANALYTICAL APPLICATION FOR MUTUAL FUND INFORMATION. The database is accurate and consistent. The interface is dynamic and flexible; navigation is user friendly. The application is designed in such a manner that with minimal clicks you can achieve the desired output

Responsibilities:

Configure and Maintaining the databases

Allocating Shrinking and Altering the database files

Create and configure the scheduled jobs

Create and Maintenance the indexes and Rebuilding and Reorganizing indexes

Maintaining backup and Restore databases

Database Mail configuration Servers

Daily Maintenance of Sql servers included reviewing Sql server logs, Event Viewer

Create and Maintenance of Maintenance Plans

Monitoring and Troubleshooting of Performance issues

Executing and maintenance T-sql and jobs scripts.

Education Qualification:

●Bsc(IT) Pursing From SIES COLLEGE (NERUL),Mumbai University

●H.S.C From Modern college vashi.

●S.S.C From NMSC Vashi

Personal Profile:

●Date of Birth: 16thsep 1991

●Sex: Male

●Father’s Name: Dinesh Dubal

●Marital status: Single

●Hobby: Pro.Photography,Playing games (TAEKWONDO, KHO-KHO, FOOTBALL, PC Games)

●Permanent address: Plot No:132, sec-10,Sanpada,Navi Mumbai-400705.

●Languages known: English, Hindi, Marathi

Declaration:

I do hereby declare that the above-furnished information is true to the best of my knowledge and belief.

Date:

Place: Navi Mumbai (Saurabh Dubal)

Contact this candidate