Sql Server Life Insurance
Resume:
MIHIR Raja PATEL
Senior MS SQL Server DBA
****************@*****.***
SUMMARY:
. Senior MS SQL Server DBA with Extensive knowledge in Managing SQL
Server environment
. Over 8+ years experience in Database Administration, System Analysis
and Administration, Design, Development & Support of MS SQL Server
2012,2008 R2, 2005, 2000, and 7.0 in Production, Development &
Replication Environments.
. Extensive experience in installation, configuration, and maintenance
of MS SQL Server 2012/2008 R2/2008/2005 and 2000
. Good experience in Upgrading and migrating from SQL server 2000 to
SQL server 2008 R2
. Experienced in working with production 24/7 Environment
. Experienced in Database Backup, Recovery and Disaster Recovery
procedures.
. Experience in implementing different types of Replication Models like
Snapshot, Merge and Transactional on basis of business specification.
. Extensive experience in Maintaining High Availability using Failover
Clustering, Database Mirroring and Log shipping capabilities of MS SQL
Server 2000/2005/2008 to provide robust database solutions.
. Experienced in Performance Tuning, Query Optimization, Client/Server
Connectivity, and Database Consistency Checks using DBCC Utilities
. Expert in Table Normalization, Optimization and Tuning, Data
Import/Export, Troubleshooting, Database Objects authorization,,
Objects Creation such as Tables, Views, User created Data Types,
Indexes, Stored Procedures, Cursors, Triggers and more.
. Extensive experience with SQL Server and T-SQL in constructing
triggers, tables, user functions, views, indexes, user profiles,
relational database models and data integrity.
. Experience in Managing Security of SQL Server 2000/05/08 by creating
Database Users, Roles and assigning proper permissions according to
business requirements
. Experience in Extraction Transformations and Loading (ETL) tools like
SQL Server Integration Services(SSIS),Data Transformation Services
(DTS), Bulk Insert, and Bulk Copy ( BCP)
. Experience with Reporting Services (SSRS) and Analysis Services
(SSAS).
. Experienced in implementing log shipping.
. Experienced in implementing database mirroring.
. Expert level skills in Clustering, Replication, Data Modeling
(Physical and Logical), Server Mapping, Installation and
Configuration, up gradation form previous versions.
. Created maintenance plans to perform index defragmentation, re-
indexing and update the index statistics.
. Proficient in troubleshooting database issues.
. Experience in Creating Roles and managing user permissions, Jobs,
Alerts, SQL Mail Agent, and using performance monitor/profiler for
resolving deadlocks.
. Experienced in Design, Development, Testing, Implementation and
production, support SDLC of Client/Server, and Web based applications
. Good experience with SQL Server 2005 Online Database Indexing and
Recovery.
. Have good understanding of C#.NET and ASP.NET
. Team player with Good communication, interpersonal and business
analysis skills.
. Performed Server 2000, 2003 and IIS Systems Administration, and
configuration.
. Good team player with strong analytical skills.
TECHNICAL SKILLS: MS SQL Server 2012/2008 R2/2008/2005/2000, Windows Server
2008 R2/2008/2003/2000, Microsoft SQL Server Integration Services (SSIS),
Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server
Analysis Services (SSAS). Data Modeling, Erwin 4.0/3.5, Star Schema
Modeling, Snow Flake Modeling, MS SQL Server 2008/2005, OLAP Tools, SQL,
Perl, Visual Basic, TOAD, SQL* Loader, IDERA Diagnostic Manager, Apex SQL
Monitoring Tools.
PROFESSIONAL EXPERIENCE:
07/2011- Present WELLPOINT, Richmond, VA
Senior MS SQL Server DBA/Architect
Description: WellPoint, Inc. is the largest managed health care, for-profit
company in the Blue Cross and Blue Shield Association. It was formed when
WellPoint Health Networks, Inc. merged into Anthem, Inc., with the
surviving Anthem adopting the name, WellPoint, Inc.
Responsibilities:
. As a Production and development support DBA responsible for
maintaining 150 SQL Servers out of which 170 servers are production
servers in which 100 were mission critical and 70 were business
critical servers, remaining test and development servers.
. Installed SQL Server 2012/2008 R2 and SQL Server 2005 on windows 2008
R2 and 2003 servers, applied service packs and security fix for all
servers.
. Implemented Failover clustering for Active/Active and Active/Passive
SQL environment
. Managed SQL Servers in a Clustered environments
. Implemented Database Mirroring on SQL Server 2008 environments.
. Configured and maintained Log shipping architecture to provide backup
server solution for 4 environments.
. Implemented transactional replication for data refresh
. Managed all Publisher, Distributor and Subscriber database
environments for the replication
. Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot
problems and queries
. Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
. Created the DTS, SSIS packages to import the data from MS Access and
Oracle server to SQL Servers.
. Created SSIS packages to Extract and Load data from diverse source
(flat file, excel, xml and oracle)
. Created Data Flow's for Aggregate, sort, lookup, merge, union all and
fuzzy lookups.
. Used containers for repetitive control flow tasks
. Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export
control extensively in SSIS
. Performed Multi File Imports, Package configuration, Debugging Tasks
and Scripts in SSIS
. Scheduled package execution in SSIS
. Installing packages on multiple servers in SSIS
. Extensively worked on SSIS for data manipulation and data extraction,
ETL Load
. Created extensive reports using SSRS ( Tabular, Matrix )
. Installed, configured and maintained MS SQL Fail over clustering to
provide server high availability solution for 6 different
environments.
. Involved in tuning SQL Server databases using available tuning methods
like index tuning wizards, profiler and execution plans.
. Created the standard documents for Disaster recovery testing and
implemented them.
. Experienced with database sizing and capacity planning for production
servers.
. Experienced with creating logical and physical database design for
development projects.
. Experienced with improving SQL Server using windows performance
monitor to improve the server performance.
. Created the backup schedule for production, test and development
servers.
. Worked with developers to do the database schema changes and database
restore requests.
. Involved in restore operations to refresh the data from production to
test servers.
. Experienced in troubleshooting production servers and fixed the user
and application issues.
05/2009-04/2011 MASSMUTUAL Life Insurance, Enfield, CT
Senior MS SQL Server DBA/Architect
Description: Founded in 1851, Massachusetts Mutual Life Insurance Company
(MassMutual) is an American mutual life insurance company with 1800 offices
and 13 million clients worldwide. Mass Mutual is one of the largest Life
Insurance companies globally and was ranked 93rd in the Fortune 500 list
(as of 2010). The Company has revenues of about $25 Billion (2010) with
Assets under Management at $448 Billion (2010)..
Responsibilities:
. Upgraded SQL server 2005 to SQL Server 2008 on standalone and
clustered environments and applied service pack.
. Interacted with application team at the time database migration from
SQL Server 2005 to SQL Server 2008.
. Interacted with Developers in troubleshooting application and database
issues.
. Identified, tested and resolved database performance issues to ensure
data optimization.
. Used tools like SQL Server profiler, Performance Monitor to identify
bottlenecks.
. Implementation of system wide security policies and trouble shooting.
. Involved in installing SQL Server 2005/2008 on Development, Production
and WTC (Testing) machines.
. Troubleshooting high availability scenarios involving Clustering,
Database Mirroring, Log Shipping and Replication.
. Involved in migrating SQL Server Databases from LAB Server to
Development Server and from Development to Production Server.
. Experience in Designing, Building the Dimensions, cubes with star
schema using SQL Server Analysis Services (SSAS)
. Documented the results from Upgrade Advisor and resolved all before
and after issues migrating from SQL Server 2005 to SQL Server 2008.
. Involved in troubleshooting all the performance issues for different
database applications.
. Converting existing DTS Packages to Integration Service (SSIS)
Packages using DTS Xchanger tool.
. Extensive use of Import/Export wizard to convert T- SQL Queries, Data
and Reports from different forms like XML file, MS Excel file, TTF
file, PDF file and other formats to SQL data type and Vice versa
. Deployed SSIS packages to MSDB database and file system using manifest
file and the wizard utility in SQL Server 2008.
. Documented all the steps and procedures for future references.
. Interacted with concern application team in fixing the problems when
ever needed.
. Created performance baseline reports using RML tool and documented for
future use.
. Involved in setting up database mirroring for production server
. Configured replication methods like snapshot, transactional and merge
replications.
. Monitoring and scheduled jobs on production and staging environment.
. Responsible in Monitoring and Troubleshooting SQL Server Performance
issues.
. Used the Execution Plan to improve the optimization of the T-SQL code.
. Performance tuning of SQL queries and stored procedures using SQL
Profiler and Index Tuning Wizard.
. Resolving performance related issues to Blocking, Deadlocks and long
running queries
. Provided 24 x 7 Production support for the database and application
issues.
12/2007-04/2009 MERCK, WHITEHOUSE STATION, NJ
Senior MS SQL Server DBA
Description: Merck & Co., Inc. (NYSE: MRK), also known as Merck Sharp &
Dohme or MSD outside the United States and Canada, is one of the largest
pharmaceutical companies in the world. Currently, it is one of the seven
largest pharmaceutical companies in the world both by market capitalization
and revenue.
Responsibilities:
. Upgraded most of SQL Server 2000 to SQL Server 2005
. Involved with upgrade of databases from 2000 to 2005 in a Clustered
environment.
. Worked on SQL Server 2005 with latest Service Packs.
. Involved in Performance Tuning on Production, QA and Staging servers
of the current project.
. Involved in Monitoring Performance of different production servers.
. Implemented Database mirroring for disaster recovery.
. Maintained various databases for Production and Testing using SQL
Server 2005.
. Planning the location of data, index, and Transaction log files on the
disk.
. Performance tuning, and optimization of procedures and queries.
. Worked with SQL server Profiler.
. Created the backup and restore strategy for production and development
environment.
. Created Database Maintenance Planner for the Performance of SQL Server
which covers Database Integrity Checks, Update Database Statistics and
Re-indexing.
. Using SQL Server Integration Services (SSIS) tool of SQL Server to
populate data from various data sources, creating packages for
different data loading operations for application.
. Experience in creating and executing SQL Server Integration Services
(SSIS) packages.
. Managing schema objects such as tables, views, clusters, indexes,
procedures, triggers & maintaining Referential Integrity depending on
user requirements and converting them into technical specifications.
. Administering the MS SQL Server by creating user logins with
appropriate roles, dropping and locking the logins, monitoring the
user accounts, creation of groups, granting the privileges to users
and groups.
. Database and Transaction log backups & restoration, backup strategies,
scheduling the backups. Backing up system & user databases and
restoring them.
. Performing fine Tuning of Database Application. Cleansing and solving
Database troubles.
. Used BCP and Bulk Insert utilities.
. Worked with SQL Server Reporting Services (SSRS).
.
03/2006-10/2007 UTI BANK, INDIA
Junior MS SQL Server DBA
Description: Axis Bank Limited, formerly UTI Bank, (BSE: 532215, LSE: AXBC)
is a financial services firm that had begun operations in 1994, after the
Government of India allowed new private banks to be established. The Bank
was promoted jointly by the Administrator of the Specified Undertaking of
the Unit Trust of India (UTI-I), Life Insurance Corporation of India (LIC),
General Insurance Corporation Ltd., National Insurance Company Ltd
Responsibilities:
. Created Database Maintenance Planner for the Performance of SQL Server
which covers Database Integrity Checks, Update Database Statistics and
Re-indexing.
. Planned the Complete Backing up of Database and restoring the Database
from Disaster Recovery.
. Planned and modified the permission issues in the server.
. Designed a report on the monitoring of SQL Server Performance. This
report gives a detail report to the management on the Performance of
the server.
. Fine tuning the Database Settings as well as the Server Settings.
. Configured Mail Profile for sending automatic mails to the respective
people when a job is failed or succeed. Maintaining SQL Script for
creation of Database Objects.
. Creating, maintaining the users, roles and granting privileges.
. Logical and Physical Data Modeling using AllFusion ERWIN.
. Configured Snapshot Replication (Creating Distribution Databases,
updating Publishers, creating & managing Publications, managing
Replication monitors).
. Performed System Study and Requirements Analysis, prepared Data Flow
Diagrams, Entity Relationship Diagrams, Data Diagrams, Table
Structures, with a lot of interaction with the client.
. Performed analysis and design of the application.
. Did the database administrative job of Security, Backup/recovery, ODBC
connections etc.,
. Performed Database backups (operating system, flat file backups &
export/import).
EDUCATION/CERTIFICATIONS:
. Bachelor Of Engineering, Gujarat, India
Contact this candidate