Jivanrao Sabbani

982******* ac265z@r.postjobfree.com

Holding H1B visa.

Sr. SQL SERVER DBA

PROFESSIONAL SUMMARY

17+ years of IT experience with 6 years as Visual FoxPro developer, 9 years as Database Administration and development with MS SQL Server technology 2014/2012/2008 R2/2005/2000 and 2 years as transition lead for SQL projects.

Extensive experience on database administration, advanced data recovery, data corruption, extended SQL Server internals and SQL Server Memory concepts

Extensive experience in installation, Upgrades (In place Upgrade and side-by-side) and configuration of MS SQL Server 2012, 2008 R2, 2005, and 2000 versions on both Standalone and Cluster Environments.

Experienced in investigating and applying necessary SQL Server database Service packs, hot fixes and Security Patches.

Experience in Database Backup, Recovery and Disaster Recovery procedures (Log shipping, Mirroring, Clustering and Replication).

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.

Experience in extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS Packages from SQL Server.

Good technical and analytical skills with sound understanding. Skill of creating new software & systems, designing, analysis, testing, database development and coding for modules while structuring customized solutions.

Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the databases.

Experience in troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics, and Index tuning Wizard.

Actively involved in monitoring system performance by using SQL Profiler, Database Engine Tuning Advisor, and Windows performance monitor, Event Viewer, DMVS, and Resource Governor to achieve better performance, Resolve Dead Locks/Long Running Queries, accessibility and efficiency.

Using Performance Monitor/Profiler to solve Blocking, Dead Locks/Long running queries.

Experience with the Incident Tickets, Change Requests and Knowledge management

Worked closely with management, applications development staff, and users on database solutions to business problems.

Defined and administered database standards, controls, procedures and documented the same

Provided after hours and 24/7 Database Maintenance and Production Support.

TECHNICAL SKILLS

RDBMS

MS SQL SERVER 7.0/2000/2005/2008/2008R2/2012,2014

MS Access 2000/2005.

SQL Server Management Studio, SQL Server Business Intelligence

Development Studio (BIDS), Database Engine Tuning Advisor(DTA),

Databases Tools

Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation

Services, Upgrade Wizard, Replication, Jobs and task creating and

scheduling, MS Visio, Crystal Reports 10.0, SQL reporting, SSIS,

TFS, Visual Studio 2012

Programming Languages:

SQL, TSQL, XML, VB 6.0, Perl, HTML.

Web Tools:

MS-Front Page, Internet Information Server(IIS)

Operating Systems:

Windows 2000/2003/2008/XP/NT 4.0, Linux, MS-DOS.

Utility Tools:

MS Office, MS Project, Visual Source Safe 6.0, SCCM,SCOM

ETL Tools:

SSIS(SQL Server Integration Services), DTS(Data Transformation Services),

Import Export Data, Bulk Copy Program (BCP)

Larsen & Toubro Infotech (LTI) Dec2009 – Present

SCANIA INFOMATE, Europe (LTI Client) Feb2012 – Present

Sr. SQL Server DBA

Description: Scania AB, formerly AB Scania-Vabis, is a major Swedish automotive industry manufacturer of commercial vehicles – specifically heavy trucks and buses. It also manufactures diesel engines for heavy vehicles as well as marine and general industrial applications.

Responsibilities:

Day-to-day DBA responsibilities for backups, server uptime, performance tuning & optimization of code developed by developers.

Monitoring SQL Servers through SpotLight for SQL Servers and resolving various alerts generated by systems.

Cluster setup and issues handling.

Handling mirroring issues.

Deploying various scripts in UAT & PROD as per business requirements.

Deploying Service Packs and hotfixes for SQL Server as per deployment schedule.

Troubleshooting on SQL related issues addressed through Service Desk portal.

Performance tuning of slow running queries and providing timely advice on Indexes and query logic.

Implementation and Support of AlwaysOn High Availability Group.

Ensure the compatibility level changes and perform database checkup routines to ensure consistency and integrity is preserved

Capture performance baselines for old and new environments using Perfmon.

Daily periodically monitored performance using both System Monitor and Profiler.

Proficiency in developing Maintenance plans, backup, recovery strategies and Rebuild/Reorganize strategies

Reviewing and verifying Database backup details, Database user privileges, Inactive user accounts.

Monitoring CPU resource usage and SQL Server disk management

Oncall duty support

Environment: SQL Server 2000, 2005, 2008,2008R2, 2012,2014, Clustering, SSRS, SSIS, BMC Remedy, Litespeed Backup tool, SQL Agent, SQL Profiler.

Ingram Micro, UK (LTI Client) Feb2012 – July2012

Sr. SQL Server DBA (Deputed at Onsite, UK)

Description: Ingram Micro is a wholesaler of IT products and services. It is the world's largest wholesaler in technology products and services. It sells products and services only to IT resellers, from manufacturers such as Acer Inc., Apple, Cisco, Brocade Communications Systems, Ruckus Wireless, Veeam Software, Google, Hewlett-Packard ("HP"), IBM, Lenovo, Microsoft, Samsung.

Responsibilities:

Day-to-day DBA responsibilities for backups, uptime, performance & optimization of code developed by previous developers.

Installation and Maintenance of SQL Clustering in Production, Development, and Test servers.

Installed, upgraded and configured 2008R2 for several applications with latest service packs

Administrated and managed SQL Server 2012/2008R2/2008/2005 databases in production, Staging, QA and development environments.

Managing, migrating and Performance analysis of very large databases

Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.

Reviewing Security Scripts and Maintaining them

Ensured security logins and database access permissions.

Applying service packs for old and new environments according to the Enterprise Architecture standards

SQL Process Documentation

Experience with Incident Change Management and Remedy Tickets

Involved in various stages like system Analysis, design, and development

Environment: SQL Server 2000, 2005, 2008 & 2008R2, 2 node Cluster, 3 node Cluster and 4 node cluster,

SQL Agent, SQL Profiler, Database Tuning Advisor.

SCANIA INFOMATE, Europe (LTI Client) Feb2010 – Jan2012

Sr. SQL Server DBA(Deputed at Onsite, Sweden)

Description: Scania AB, formerly AB Scania-Vabis, is a major Swedish automotive industry manufacturer of commercial vehicles – specifically heavy trucks and buses. It also manufactures diesel engines for heavy vehicles as well as marine and general industrial applications.

Responsibilities:

Installation and Maintenance of SQL Server 2008, SQL Server 2008R2, Clustering & Mirroring.

Migration of SQL server 2005 to SQL 2008 and SQL server 2000 to SQL 2008.

Handling Short request and Regular request.

Handling L2 & L3 Incident tickets.

Responsible for high availability and performance of Instance.

Resolution of Database performance issue, Disk capacity issues, Jobs, Alerts, Warnings etc.

Deployment activity & oncall duty support after office hours.

Setting up and managing High availability techniques like Log shipping, Clustering and Replication.

Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2008 on windows 2008 enterprise edition.

Written and deployed SQL Scripts for low disk management, Rebuilding/Reorganizing index, CPU Resources usage using DMVs.

Backup & restore activity.

Upgraded Light speed from 5.2 to 6 for all Test, Dev & Prod environment

Environment: SQL Server 2000, 2005, 2008 & 2008R2, Clustering, SSRS, SSIS, BMC Remedy, Litespeed Backup tool

Capgemini Feb2009 – Dec2009

SHIRE,USA & UK (Capgemini Client) Feb2009– Dec2009

Sr. SQL Server DBA

Description: Shire is a global biotechnology company focused on serving people with rare diseases and other highly specialized conditions. The company's products are available in more than 100 countries across core therapeutic areas including Hematology, Immunology, Neuroscience, Lysosomal Storage Disorders, Gastrointestinal / Internal Medicine / Endocrine and Hereditary Angioedema; a growing franchise in Oncology; and an emerging, innovative pipeline in Ophthalmics.

Building of project servers.

Performance issues, Clustering issues, Memory issues, Maintenance Jobs issues etc.

Setup of Merge Replication and taking care of issues.

Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.

Handling L1,L2 & L3 Incidents.

Creation and maintaining DBA documentation.

Implemented transactional replication.

Active participation in Change and EARS Management system.

Worked as a team member for 24X7 on call production support.

Environment: MS SQL Server 2000/2005, BMC Remedy, Windows2003/2008 server

Patni Computers Jan2008 – Feb2009

Metlife Insurance, USA (Patni client) Jan 2008 - Feb 2009

Sr Database Administrator

Description: PATNI is an IT services company, headquartered in Bridgewater, New Jersey, United States. The firm operates in North America, Asia, Europe, Japan and Australia, providing technology consultancy and services

Responsibilities:

Handled 140 servers with 42 applications.

Resolving Production/QA/test tickets.

Checking the Jobs, alerts, warnings and resolving if there are any issues.

Resolving the database performance issues, database capacity issues, replication and other distributed data issues.

Configuring Log shipping and taking care of issues.

Map product solution and technical information to customer context.

Creation and administration of all database objects.

Migration of SQL servers from 2000 to 2005.

Environment: SQL Server 2000, 2005, Windows 2003, Microsoft Clusters, Log shipping, Replication, Litespeed.

Wipro Infotech April2005 – Dec2007

Technova Imaging Systems, Mumbai (Wipro client) April 2005 - Dec 2007

Database Administrator and Application Support

Description: TechNova is one of the world’s leading suppliers of Total Imaging Solutions for the Graphic Communications industry. Since 1971, TechNova has introduced several new breakthrough technologies that have transformed the imaging processes in various industries.

Responsibilities:

Database health checks

Backup and restoring through VERITAS Tape drive.

Executions of scripts in Production environment.

Resolving the tickets assigned to DBA (L2 & L3)

Installation of SQL server in DR environment

Installation of Active / Passive cluster server.

Application support.

Modification of application as requested from user.

Creation of weekly and monthly reports.

Environment: SQL Server 2000, Windows 2000, 2003, Red hat Linux & Sun Solaris

PAMAC Finserve PVT Ltd, Mumbai, India April 1999 – March 2005

EDP Manager

Responsibilities:

Development of New software for MNC Bank & Telecommunication (HSBC, HDFC, ANZ Grind lays, Airtel)

Customization and Maintenance of the software.

Understanding the new requirements and explaining the same to team members.

Merging all the centres data in location and one database

Handling the team of 8 people with different technologies.

Implementation of totally new Data centre environment for critical applications, mail domain server and database

Environment: FoxPro for DOS, Visual FoxPro 6.0, Visual Basic 6.0., ASP.Net, VB.Net, SQL Server 2000

Certifications:

ITIL v3 Certified

Certified since 2010

Microsoft Certified Professional

- SQL Server 2000

Certified since 2006

Education:

Masters in Commerce Mumbai University (Passed-April 2002)

Bachelor in Commerce Mumbai University (Passed-April 2000)

Contact this candidate