Sql Server Administrator
Resume:
Deepali Bhole
*** *** *** ****** *-mail: *******@*******.***
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: *******@*******.***
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: *******@*******.***
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: *******@*******.***
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: *******@*******.***
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: *******@*******.***
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: *******@*******.***
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