Deepali Bhole

*** *** *** ****** *-mail: acsxud@r.postjobfree.com

Markham, On L6C 2S7 Phone: 905-***-****

Senior SQL Server Database Administrator

Expertise in MS SQL Server 6.5 / 7.0 / 2000 / 2005/2008/2012 databases which includes capacity planning, database designing, database and objects creation, configuration, development, security, backup/recovery, tuning, data consistency, data integrity, data loading, job scheduling, and replication

Database development and administration experience which includes creating databases, tables, views, stored procedures, functions, triggers, complex queries and packages

Performance Tuning and Monitoring using SQL profiler, third party tools such as Quest Foglight for SQL server

Designing and implementing large databases for Online Transaction Processing Systems (OLTP) and Online Analytical Processing (OLAP) systems

Establishing standards and schedules for database backup

Work well in a fast-paced dynamic environment, collaboratively and under critical deadlines

Passion for learning and able to get up to speed and productive quickly

TECHNICAL SKILLS

Operating Systems

Windows 2000 Server, Windows NT, Windows Me/XP/2000Pro/98/95/3.x, Linux (RedHat), Unix

Databases

SQL Server 2012/2008/2005/2000 / 7.0 / 6.5, SQL Server Analysis Services, MS Access, DB2

Languages

SQL, Transact-SQL, Visual Basic, C++

Reporting Tools

SQL Server Reporting Services

Tools Used

SQL Server Profiler, Performance Monitor, DTA, Foglight (third party tool for SQL monitoring), Litespeed for Backup etc.

Applications

Microsoft Share point, Microsoft Office, FrontPage, Microsoft Navision, Microsoft CRM

PROFESSIONAL EXPERIENCE

Mevotech LP

Present

SQL Database Administrator

As a MS SQL Database Administrator my job duties include but not limited to:

Automation of tasks using SQL Agent service and SSIS

Performing all database maintenance tasks such as backup, re-indexing, DBCC commands etc.

Analyzing business data for its integrity as it relates to the business

Deepali Bhole

455 Bur Oak Avenue E-mail: acsxud@r.postjobfree.com

Markham, On L6C 2S7 Phone: 905-***-****

Senior SQL Server Database Administrator

Optimizing database workloads using Profiler/Extended Events/DMV’s etc.

Install and Configure new SQL Server versions

Creating reports using SSRS and SSAS

Technical Environment: SQL Server 288R2/2012, Windows 2008/2012, SSRS, SSIS

June 2014 – April 2015 – On Maternity Leave

CGI

Dec. 2013 - June 2014

SQL Database Administrator

Worked with tech team for one of the government client. Did deployments and troubleshooting in System Integration testing and Business Acceptance Testing and preprod environments.

Was responsible for security at instance and database level. Supported log shipping for database availability. Worked on automation using SQL agent service and windows task scheduler.

Technical Environment: SQL Server 2008 R2, Windows 7, Windows server 2008.

KUBRA

May 2011 – March 2013

Senior Database Administrator

Supported development, test, prep, and production environments and tool chains including software and services selection. Collaborated with development team to define and implement software tools using scripts and code for automated builds, database

management / import / export . Managed batch data import and export processes writing scripts and code as necessary to do basic flat file parsing and database mapping. Worked closely with IT project managers, database programmers and web developers.

Managed Database availability using ‘DoubleTake’ third party tool.

Deepali Bhole

455 Bur Oak Avenue E-mail: acsxud@r.postjobfree.com

Markham, On L6C 2S7 Phone: 905-***-****

Senior SQL Server Database Administrator

In addition to above I was responsible for the following tasks in Kubra:

Managed SQL instance and database availability using clustering, Database mirroring and Log shipping

Migration of databases from development environment to test, test to Pre-Production and from pre-production to production.

Installation, configuration and upgrading of Microsoft SQL Server 2005 to 2008 R2.

Establishment and maintenance of sound backup and recovery policies and procedures.

Establishing the needs of users and monitoring user access and security.

Monitoring performance and managing parameters to provide fast query responses to users.

Writing database documentation, including data standards, procedures and definitions for the data dictionary.

Performance and monitoring health of all production servers using third party tool such as Quest – Foglight for SQL Server

Technical Environment: SQL Server 2000,2005,2008, Windows 7, Windows server 2008.

Commport Communications International Inc.

April 2010 – September 2010

Senior Database Administrator/Developer

As a database developer and administrator, my responsibility here included were but not limited to database design and development of database objects such as development of Stored Procedures, triggers, UDF using TSQL, performance tuning, optimization of TSQL queries, monitoring using SQL profiler, designing and implementing backup and restore strategy. Provided database availability using log shipping, replicationand maintaining security and monitoring around 5 SQL servers 24/7. I was responsible for developing DTS/SSIS packages. Implementation of security with DDL triggers.

Commport Communications has been offering Electronic Data Interchange (EDI) and Electronic Commerce (EC) solutions. So Servers are busy 24/7. I was responsible to

Deepali Bhole

455 Bur Oak Avenue E-mail: acsxud@r.postjobfree.com

Markham, On L6C 2S7 Phone: 905-***-****

Senior SQL Server Database Administrator

manage, maintain SQL databases. Such as monitoring transaction log, database size, replication agents and status of replication. Creation of SQL scripts to run at night etc.

Monitor SQL servers using third party tool such as ‘Idera Diagnostic Manager’.

As an administrator, I was responsible for creating DDL triggers for auditing, optimization of queries using SQL profiler and Database Tuning Advisor, creation of database objects such

as stored procedure, triggers etc. Did change .net application to SQL server stored

procedure using CTE (Common Table Expression)

Also was responsible for change management i.e. creation of documents related to change management, compared SQL scripts between two releases. Checked dependency of objects etc.

Technical Environment: SQL Server 2000,2005, Windows 7.

March 2009 – Jan 2010

Achieved Microsoft Office Sharpoint Server-2007 Configuration, SQL Server 2008 – MCTS - Business Intelligence, SQL server 2008 – MCTS – Implementation and Maintenance certifications

CIBC

April 2008 – March 2009

Senior Application Developer

Worked as an administrator/developer for SQL server 2000. Our team was responsible for data cleansing using DTS/SSIS packages. Developed vb scripts for DTS packages. Developed data flow diagrams for DTS/SSIS packages. Imported and exported data from different data sources such as excel, text files and XML. Developed and optimized stored procedures.

Met with client group (National Contact Centre Operations) to gather and convert specifications about business requirements into programming instructions and designed and coded programs

Reviewed, analyzed and modified programming systems to enhance the security

Monitored operating efficiency of existing application systems

Optimized stored procedures and queries by reducing execution time from few minutes to few seconds.

Deepali Bhole

455 Bur Oak Avenue E-mail: acsxud@r.postjobfree.com

Markham, On L6C 2S7 Phone: 905-***-****

Senior SQL Server Database Administrator

Designed SQL Server database from MS Access database

In order to implement security policy, converted data source location from FTP to NAS using DTS packages

Provided detail documentation to clients

Presented implementation package to client group

All projects completed within budget and time; performance rated as exceeding expectations

Technical Environment: SQL Server 2000, Windows XP

HITECH NETWORK, Inc.

May 2004 – March 2008

SQL Server Administrator and Share point Administrator

Designed, developed and implemented SQL Server databases. Did capacity planning for SQL databases. Upgraded SQL server 2000 to 2005. Backed up SQL databases as per schedule. Utilized different SQL performance monitoring tools such as SQL profiler, System monitor etc. for routine maintenance tasks. Provided SQL server availability using log shipping.

Used OLAP (BI) tools such as SSAS for creating cubes and dimensions and SSRS for creating reports for finance and sales departments.

Administered Share point server 2003 and MOSS 2007. Configured share point server. Upgraded

Share point server 2003 to MOSS 2007. Scheduled routine backup for share point server and

webparts.

Successfully administered three production servers for CRM, MS Navision and Share Point server

Provided ongoing SQL Server support to Navision and Axapta consultants

Quickly learned new technology such as share point server and worked as an administrator of share point server along with SQL Server

Created reports for finance and sales department using SQL server reporting services

Deepali Bhole

455 Bur Oak Avenue E-mail: acsxud@r.postjobfree.com

Markham, On L6C 2S7 Phone: 905-***-****

Senior SQL Server Database Administrator

Presented reports to sales and finance executives on client side

Optimized queries and reduced execution time of SQL queries and store procedures

Performed performance tuning on production servers

Installed Share point server 2003

Upgraded share point server 2003 to MOSS 2007

Secured SQL server and share point server at different levels

Technical Environment: SQL Server 2000,SQL Server 2005, Share point Server 2003, MOSS 2007

Windows XP, Windows Server 2003

Central net Computers

February 2002 - May 2004

Database Designer / Developer /Administrator

Designed SQL server database for handheld devices. Used VB Appforge as a front end and SQL server 2000 as a back end. Used different SQL server tools such as Query analyzer, Event Viewer, SQL profiler for performance monitoring and tuning. Imported data from MS Access to SQL Server.

Designed logical and physical design of database for handheld devices applications

Imported several GB of legacy data into newly created SQL Server databases using Data Transformation Services packages, BCP and Bulk Inserts

Solved performance problems using various tools including SQL Query Analyzer, SQL Server profiler, Windows Performance Monitor, Event Viewer, Network Monitor and various third party tools

Developed SQL scripts and established replication to effectively exchange information between business partners

Programmed handheld devices in VB Appforge

Technical Environment: SQL Server 2000,MS Access, Appforge VB, Windows XP

Deepali Bhole

455 Bur Oak Avenue E-mail: acsxud@r.postjobfree.com

Markham, On L6C 2S7 Phone: 905-***-****

Senior SQL Server Database Administrator

NIIT (India)

October 1999 – April 2000

Database Developer / Administrator

Designed SQL server 7.0 database for training organization

Programmed in Visual Basic 6.0 with SQL Server as a back end

EDUCATION

Diploma in Computer Centered Networking from National Institute of Information Technology, Pune (India)

Diploma in Civil Engineering from Maharashtra State Board of Technical Education, Pune (India)

PROFESSIONAL CERTIFICATIONS

Microsoft Certified Solutions Associate (MCSA) Part I: Microsoft SQL Server 2012

Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance

Microsoft Certified Technology Specialist(MCTS): Microsoft Office SharePoint Server 2007 – Configuration

Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2005, Implementation and Maintenance

IBM DB2 system administrator certification

MCP in SQL Server 6.5, 7.0, 2000 Design and Administration

MCSD in Visual Studio

Contact this candidate