Sql Server Windows
Resume:
Sandeep Sawant
*****************@*****.***
Total 15+ years of experience with 10 years of experience as SQL Server DBA, 4 years as SQL Server Developer, 1 year as Azure SQL and 2 years as an ORACLE 8i DBA.
Installed SQL Server 2016, 2014, 2012, 2008R2, 2008 and 2005 in Distributed Cluster and Standalone Server environments.
Managed SQL Server Database Design, Development and Administration in Production, Stage and Development, Distributed Cluster Environments.
Handled Migration of:
-On-Premise Database to Azure SQL Server
-SQL Server 2008R2 to SQL Server 2016
-SQL Server 2008R2 to SQL Server 2012
-SQL Server 2005 to SQL Server 2008R2
-SQL Server 2005 to SQL Server 2012
Created and Managed Azure SQL Server Databases.
Handled the Setup of Azure SQL Server Databases and Connection Strings from SQL Server Management Studio (SSMS) for Developers.
Proficient in DBA activities, such as:
-Project planning,
-Capacity planning,
-Disaster Recovery,
-Query Optimization,
-Scaling up and Scaling out,
-Database Architecture Designing,
-Data Modeling,
-Performance Monitoring and Tuning
Managed Physical Servers and VMWARE servers in Distributed Cluster Server environment, as DBA
Used PowerShell and T-SQL script to automate the Backup, SQL Server Audit and Security tasks of Database Servers.
Implemented Log Shipping, Replication, Mirroring and Microsoft Always On Availability Group as Hardware Availability (HA) and Disaster Recovery (DR) solutions.
Implemented ALWAYS ON WSFC with Load Balancing Feature.
Proficient in creating SQL Objects like Tables, synonyms, stored procedures, views, indexes, triggers, rules, defaults, user defined data types and functions.
Installed and Configured Reporting Services on Clustered Server Environment
Applied Pro tools like Litespeed, Foglight, Spotlight, Netback backup VERITAS, BMC remedy, CA Service desk for optimizing Distributed Clustered Database as DBA
In-depth experience in Interacting with Clients and End-Users, understanding their requirements and providing the right solutions.
Presented Training, on topics “DBA - Service Innovations” and “Your Data Center in Doomed – Disaster Recovery”
Certified Infrastructure Technology Information Specialist (ITIL) V3, with hand-on experience in ITIL processes
Certified Microsoft Certified Technology Specialist (MCTS)
TECHNICAL SKILL SET:
Database Administrator (DBA)
SQL Server 2016, 2014, 2012, 2008R2, 2005, 2000, Oracle, Azure SQL Server
Programming Languages
PowerShell, T-SQL, Visual Basic, PL SQL
Operating System
Windows Server 2012,2008,2003,2000,Unix
Ticketing and Monitoring Tools
Citrix, BMC Remedy, Litespeed, Foglight, Spotlight, SCOM, VERITAS and Visual source safe.
ETL Tool
SQL Server Integration Services (SSIS), Data transformation services (DTS),BCP Utility
Database Tool
SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Enterprise Manager, SQL Server Management Studio.
Domain
Healthcare, Logistics, Insurance, Retail, Banking and Finance
PROFESSIONAL EXPERIENCES:
1. UPS Supply Chain Solution (US) August 2017 – Till Date
Location: Alpharetta (GA, USA)
Domain: Healthcare and Logistics
Employer: Stream IT Technologies
Role: Senior SQL Server DBA
Brief description of the project:
UPS is committed to the healthcare industry and is continually investing in its people, resources, network and solutions to meet healthcare companies’ unique logistics needs. UPS has more than 4000 servers is their Distributed Environments. Each team is responsible to manage servers and provide efficient solution to improve business need.
Responsibilities:
Managing SQL Server SQL Server 2016, 2014, 2012, 2008R2 in Production\Development\UAT\TEST servers in UPS environment.
Implemented and documented Always ON WSFC with new Load Balancing features in SQL Server 2016.
Assist to application team for code review, performance analysis and for deployment.
Handling real time server/databases performance issue with different team within UPS.
Implemented Partition of tables on high volume tables for critical databases.
Managing disaster recovery such as log shipping, replication and mirroring databases.
Monitoring alerts and troubleshooting on technical issues.
Installed and configured SQL Server 2016 Standalone and Cluster server on Physical and Virtual Machine.
Provide ON CALL Support on rotational basis.
Co-ordinate with offshore team for project work.
Technologies:
-SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005 with clustering, replication and mirroring
-Always ON availability group with Load Balancing Feature
-Windows Server 2012, 2008, 2003,2000 in 32 and 64 bit environments
-Foglight tool for Monitoring and Performance Tuning
-PowerShell and T-SQL
2. Neustar (US) July 2017 – Till August 2017
Location: San Diego (CA, USA)
Domain: Telecommunication
Employer: Stream IT Technologies
Role: Senior SQL Server DBA
Brief description of the project:
This project is basically migration of Neustar SQL Server databases from SQL Server 2008R2 to SQL Server 2016. The project involves initial assessment, SQL Server installation and configuration, application testing, migration of databases and implementation of disaster recovery strategy of databases.
Responsibilities:
Initial assessment and due diligence of initial system.
Installed and configured SQL server 2016 in cluster environment on Production and QA servers.
Engaged with application team for application testing on QA servers.
Migrated databases from SQL server 2008R2 to SQL Server 2016
Implemented Always ON WSFC for reporting and disaster recovery of databases.
Technologies Used:
-SQL Server 2016, 2008R2 with clustering, Always ON and mirroring.
3. Marsh & McLennan Companies (US) November 2013 – March 2017
Location: Mumbai (India), Hoboken (NJ, USA)
Domain: Insurance
Employer: L&T InfoTech
Role: Senior SQL Server DBA, Azure SQL Cloud Architect & Team Lead
Brief description of the project:
Marsh & McLennan Companies has 250 SQL servers and more than 3000 SQL Databases in Production, Stage and Development environments. The DBA project consisted of installation, migration, up-gradation of SQL Servers, along with code deployments, security administration and access control management.
Responsibilities:
Managed and Administered SQL Server 2016, 2014, 2012, 2008R2, 2005 in Production and Non-production environments.
Administered SQL Databases larger than 1 TB size in Distributed Clustered Server environments.
Upgraded SQL Server 2005, 2008 R2 using in-place and side-by-side upgrade, to SQL server 2012, 2016.
Installed SQL Server and service packs on versions 2005, 2008R2, 2012, 2014 on Distributed Cluster and Standalone Server environments.
Created Databases on Azure SQL Server
Migrated On-Premise databases to Azure SQL Server
Configured Azure SQL Server Firewall for Performance Tuning
Recovered system and user databases from suspect mode
Implemented Log Shipping, Replication and Mirroring.
Implemented Always ON Availability Group as a HA and DR solution.
Installed and Configured Integration Services on Clustered Environment
Deployed and Scheduled DTS SSIS Packages
Installed and Configured Reporting Services.
Managed and worked on daily DBA tasks like handling user’s permissions and space issues, Database Backup and Restore in all environments.
Handled month-end outages like Shutting down the servers and applying upgrade Patches.
Used Power Shell and T-SQL script to automate Backup, SQL Server audit and other DBA tasks.
Worked closely with development team for Query optimization and Performance Tuning.
Managed DBA project’s audits.
Technologies Used:
-SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005 with clustering, replication and mirroring
-Azure SQL Server
-Always ON availability group
-Windows Server 2012, 2008, 2003,2000 in 32 and 64 bit environments
-Foglight tool Monitoring and Performance Tuning
-PowerShell and T-SQL
4. Ingram Micro (US) November 2011 - October 2013
Location: Mumbai (India), Irvine (CA, USA)
Domain: Retail and Supply Chain Management
Employer: L&T InfoTech
Role: Senior SQL Server DBA & Team Lead
Brief description of the project:
Ingram Micro’s wholesale retail business in IT Products and services required the creation and administration of Distributed Clustered SQL Server environments. The project also included critical support during migration of SQL Servers, plus 24/7 Global DBA support.
Responsibilities:
Applied Patches and Service packs to update of MS SQL Server 2012, 2008R2, 2008 and 2005 in Clustered and Standalone Environments.
Migrated SQL databases from SQL Server 2000, 2005 to SQL Server 2008R2, 2012 and documented the process with Pre-Migration and Post-Migration steps.
Configured Database mail in SQL Server 2005, 2008R2.
Used Spotlight tools for monitoring Blocking, Deadlocks, Long running jobs, Space issues and Performance Tuning
Implemented Log Shipping, Replication and Mirroring.
Used Litespeed tool for backup and restore of SQL Servers
Worked on Logins copy, Databases movers, job mover, job editor, server Configuration, database configuration, linked server creation.
Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies
Recovered damaged database in Distributed Clustered Server environment
Extensively worked on migrating DTS to SSIS Packages.
Managed and worked on daily DBA tasks like handling user’s permissions and space issues, Database Backup and Restore in all environments.
Worked on month-end outages like Shutting down the servers and applying Windows Patches.
Managed DBA project’s audits.
Technologies:
-SQL Server 2012, 2008R2, 2008, 2005, 2000 with clustering, replication and mirroring
-Windows Server 2012, 2008, 2003,2000 in 32 and 64 bit environments
-Spotlight for Monitoring and Performance Tuning
-Lite speed for SQL Server Backup and Restore
5. MetLife (US) January 2011- October 2011
Location: Mumbai (India)
Domain: Insurance
Employer: iGATE Patni
Role: Senior SQL Server DBA
Brief description of the project:
The primary project target was to create Distributed cluster environment and disaster recovery strategy to enable 24/7 SQL database availability. The Project consisted of log shipping, replication and database mirroring as part of Disaster Recovery (DR) plan.
Responsibilities:
Managed and Administered MS SQL Server 2008R2, 2005, 2000 in Clustered and Standalone Environments.
Handled memory configurations for MS SQL Server 2000, 2005 and 2008R2.
Implemented data partitioning, replication, log shipping, database mirroring.
Migrated DTS packages to SSIS packages.
Designed and developed SSIS packages.
Used SCOM tool to Monitor SQL Server health
Used Litespeed tool for backup and restore of SQL Servers
Diagnosed database health with DBCC and DMV.
Monitored SQL Server performance with execution plans and Index tuning.
Recovered system and user databases from suspect mode.
Extensively worked on troubleshooting and fine-tuning of SQL databases for Performance Tuning.
Designed and implemented comprehensive backup and restore plan.
Technologies:
-SQL Server 2008R2, 2008, 2005, 2000 with clustering, replication and mirroring
-Windows Server 2008, 2003, 2000 in 32 and 64 bit environments
-SCOM for Monitoring and Performance Tuning
6. Saville & Holdsworth (SHL - UK) December 2007 to November 2010
Location: Mumbai (India),London (UK)
Domain: Healthcare
Employer: Capgemini India Pvt Ltd
Role: SQL Server DBA
Brief description of the project:
SHL Talent Measurement Solutions project included migration of Data center location, SQL Server up-gradation, and configuring the security profile of SQL Database servers.
Responsibilities:
Administered and maintained Production MS SQL servers with more than 1TB of database size with distributed clusters
Migrated SQL Server 2000 databases to SQL Server 2008R2 and 2005.
Installed and updated patches on SQL Server 2005, 2008R2 on distributed cluster and standalone servers.
Implemented Log Shipping, Replication and Mirroring.
Identified database performance issues with DMV, SQL using profiler.
Worked on daily routine DBA tasks like ticket handling, user permissions, space issues, backup and restore etc. on production and non-production servers.
Used Litespeed tool for backup and restore of SQL Servers
Configured log shipping, database mirroring, database snapshot, online indexing, maintenance job on all SQL servers.
Implemented security policies on Production and Non-production servers.
Worked on update statistics, rebuilding the indexes at regular intervals to get better performance.
Automated DBA task such as daily backup, disk space and file space report with T-SQL scripting.
Extensively worked on extraction, transformation and loading of data with DTS, SSIS and BCP utilities.
Server.
Designed and implemented SSIS packages.
Worked closely with development team to provide assistance for fine tuning queries and procedures.
Provided daily, weekly and monthly project reports to management for analysis.
Managed team queries and mentored teammates.
Technologies:
-SQL Server 2008R2, 2008, 2005, 2000 with clustering, replication and mirroring
-Windows Server 2008, 2003,2000 in 32 and 64 bit environments
-Litespeed for SQL Server Backup and Restore
7. Countrywide Financial (US) December 2005- December 2007
Location: Mumbai (India), Simi Valley (CA, USA)
Domain: Finance
Employer: Countrywide Financial India Pvt Ltd.
Role: SQL Server Developer
Brief description of the project:
The Project’s primary focus was to build database support from India for multiple Global regions. The Project consisted of MS SQL server setup, administration and 24/7 support.
Responsibilities:
Created SQL Database model, using Erwin tool and configured for normalization and creation of SQL databases.
Created SQL Server stored procedures, functions, triggers, views and complex SQL queries.
Enforced constraints, referential integrity to keep database consistent.
Prepared detailed statistical reports in MS Access and MS Excel to track progress of weekly, monthly and quarterly for bug identification, resolved and pending issues.
Optimized existing procedures, views and queries.
Defined best practices and provided guidelines to team to improve database performance.
Diagnosed issues and taken corrective actions within development team.
Created and managed regular maintenance jobs.
Implemented SQL Logins, user permission, managed roles and authentication modes as a part of Security Policies for development servers.
Rebuilt the Indexes at regular intervals for Performance tuning
Technologies:
-SQL Server 2005, 2000
-Windows Server2003,2000 in 32 and 64 bit environments
-Erwin tool for database modeling
8. IKEA June 2005- November 2005
Location: Mumbai (India)
Domain: Retail and Supply Chain Management
Employer: ETP International,
Role: SQL Server Developer
Brief description of the project:
The project’s primary goal was to support IKEA - Dubai and managing 20+ SQL servers.
Responsibilities:
Implemented SQL logins, Roles and Authentication Modes as part of Security Policies for multiple user roles.
Implemented Stored Procedures, Indexed views, User Defined Functions (UDL), Distributed Queries and Common Table Expressions.
Created User Defined Data Types, Procedures, Triggers and Functions rebuilding the indexes at regular intervals for better performance.
Designed and implemented comprehensive Backup plan and Disaster Recovery strategies.
Monitored/troubleshoot the existing DTS packages.
Involved in trouble shooting and fine-tuning of databases for better performance and concurrency.
Technologies:
-SQL Server 2005, 2000
-Windows Server 2003, 2000 in 32 and 64 bit environments
9. ICICI Bank December 2004- May 2005
Location: Mumbai (India)
Domain: Banking
Employer: 3i InfoTech
Role: SQL Server Developer/ DBA
Brief description of the project:
ICICI bank needed support for major banking and financial applications which are based on SQL servers. Project consisted of SQL Server enhancements, deployments and maintenance.
Responsibilities:
Reviewed existing business procedures and recommended changes.
Maintained Windows 2003 Server for Secure currency transaction business.
Diagnosed issues and implemented corrective actions within development team.
Conducted Consistency Checks on the database and analyzed the fragmentation on the indexes.
Implemented Maintenance Plan tasks such as, History Clean Up and Rebuilding indexes.
Assigned user permission and roles to maintain secured SQL databases.
Technologies:
-SQL Server 2005, 2000
-Windows Server 2003,2000 in 32 and 64 bit environments
10. Patni Internal June 2003-November 2004
Location: Mumbai (India)
Employer: Patni Computers
Role: SQL Server Developer
Brief description of the project:
The Enterprise Management project was to migrate Patni Group’s Sybase database to SQL Server 2000.
Responsibilities:
Worked on various database schemas and entity relationship diagram for all SQL and Sybase environment.
Created and modified stored procedure and views.
Worked on data analysis and reported to management with timely and accurate information.
Major role played in migration of database from Sybase to SQL server in EPMS.
Involved in scripting and automation of DBA daily health check task.
Created disaster recovery plans.
Created DTS to transfer data between SQL and SYBASE.
Optimized queries and stored procedure.
Configured transaction replication in SQL 2000.
Worked on performance tuning of SQL databases.
Technologies:
-SQL Server 2000
-Windows Server 2003,2000 in 32 and 64 bit environments
11. New India Assurance November 2000-August 2002
Location: Mumbai (India)
Domain: Insurance
Employer: CMC Ltd
Role: Oracle DBA
Brief description of the project:
The General Insurance System Software (GENISYS) was created to assist end users in preparing new policies, create claims, manage renewals, access account details and review MIS reports.
Responsible for but not limited to:
Created and updated SQL, PL/SQL blocks as per the customer requirements.
Handled Workgroup setup and optimization for GENISYS Insurance Software.
Provided software training to company users.
Implemented Backup and restore of databases in production environment.
Worked on Performance Tuning and Autonomous monitoring
Technologies:
-Oracle 8i and Developer 2000
-Windows Server 2000 and UNIX
EDUCATIONAL QUALIFICATIONS:
Bachelor of Science, Mumbai University, India
Higher Diploma in Software Engineering from Aptech Ltd.
PROFESSIONAL CERTIFICATIONS:
Microsoft Certified Technology Specialist (MCTS - 2005 and 2008).
Infrastructure Technology Information Specialist (ITIL) V3 certified.
Completed Journeyman Leadership Program from L&T InfoTech.
Contact this candidate