SUMMARY OF QUALIFICATIONS:

**+ years of total IT experience mainly as SQL Server Database Administrator in Mortgage Industry, Telecommunication industries, Insurance Industry and Waste Management Services.

7+ years of total experience for Upgrade/Migration from earlier / legacy version to SQL Server 2014, 2012, 2008, 2008 R2 and 2005 using suitable methods.

10+ years of total experience for Building and maintaining MS SQL databases, including MS-SQL 2000, 2005, 2008, 2008 R2 and 2014.

10+ years of total experience for scheduling backups, creating special Procedures, views, functions, SSIS, ETL processing in a multi-server environment.

Proficient in managing OLT, E-Commerce and DSS environments and giving 24/7 production support

Expertise in SQL Server 2014,2012, 2008 R2, 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, SQL Server Surface Area Configuration, Database Engine Tuning Advisor, BCP and Bulk Load.

Expertise in Database Administration (DBA) tasks like Backups and Recovery, Log shipping, Mirroring, space utilization, load balance, process scheduling, security, replication, etc.

Expertise in managing 100+ Server including SQL Server, Expertise in SQL Installation and Patching 2012, 2008 R2/2008/2005/2000 on all windows servers.

Proficient in Microsoft Standard Configuration.

Implemented CLUSTERING, Mirroring, Log Shipping and Replication for DR and HA

Expertise in design and Plan HA Strategy

Understanding of ETL Process using Partitioned Tables, SSIS and Deploying SSIS Packages using Package Configuration along with Deployment utility.

High Availability -RAC / Cluster / Replication / DataGaurd / Standby /Database Failover strategy

Using DMV’s for performance analysis and Implementing Index Rebuild process for performance improvements based on Built – in SSMS reports.

Expertise in system trouble shooting in production environment and development environments.

Experience with VMware products.

Expert in T-SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and Data Transform Services (DTS)

Expertise in work with End users and solving the issues.

Expertise in work with Business Analyst and Developers to resolve the issues.

Expertise in work on 24/7 environment with all day-to-day activities.

Experience Starting and stopping the VI Client

Good knowledge of data ware housing project with knowledge of OLAP and OLTP.

Good Knowledge of SAN, LAN (local area network), WAN.

Experience in SharePoint including Administration, Development & Configuration.

Expertise in developing stored procedure, Jobs and trigger in SQL Server 2012, 2008 R2, 2008 and 2005.

Expertise in supporting team of application developers for .Net web and OLTP database application.

Involved and documented in SOP based activities.

Involved in building data warehouse using ETL Tools for creating analytical reports.

Experience in Performance Tuning, Indexing and Query Optimization. Understanding of Query Execution Plans.

Used third party tools like IDERA, RED GATE, SQL Litespeed for Backup and Monitoring

Creating Database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.

Expertise in making documentation on SQL server 2012, 2008 R2, 2005.

TECHNICAL SKILLS:

Operating Systems: Windows server 2014/2012/2008 R2 / 2003, VMware

Database: SQL Server 2005, 2008, 2008 R2, 2012, 2014, MS- Access.

Programming Languages: T-SQL Tools & Utilities: IDERA, Red-gate tool for back-up, Light speed, SQL Safe

Internet Technologies: ASP.NET 1.1, ASP, VB Script, HTML, DHTML, Java Script, XML

Reporting Tools: SSRS, SSIS, Share point, Crystal Reports

Development Environment: Visual Source Safe, Serena

SQL Server Tool: Enterprise Manager, Profiler, Query Analyzer, Export and Import

PROFESSIONAL EXPERIENCE:

Dow Corning’s, Midland, MI Aug ‘13 – Present (Working remotely from Home, Iselin, NJ)

Database Administrator

Dow Corning is an American multinational corporation headquartered in Midland, Michigan, United States. Originally established as a joint venture between the Dow Chemical Company and Corning Incorporated, it specializes in silicone and silicon-based technology, and is the largest silicone product producer in the world.

Responsibilities:

Provide Production Support and give 24/7 on-call support to E-Commerce databases

Involved in the DB Migration process from one Data Center to another data center.

Installed and Configure SQL 2012,2008 R2, SQL 2008 Active/Active and Active/Passive Cluster on production servers.

Day-to-day Technical Support on MS SQL Server 2014/2012/2008 R2/2005 Servers Platform for Production, Test and Development Environments (Clustered/non-clustered).

Implement code changes and configuration changes (if needed) and other administrative activities.

Technical support to users for various purposes like Access change, performance issues and storage space managements on RAID/SAN drives.

Prepare RCA (Root Cause Analysis) using Profiler Trace, Performance counters with System Monitor.

Created SSIS Packages on production and development environment.

Recommend possible remedies for better performance.

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Work in cooperation with developers/team for achievement of efficient database access for applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL changes to application development teams.

To ensure all scheduled administrative/business jobs are running/completed for daily/adhoc business cycle on Microsoft SQL Servers in Production, Dev and QA Environment.

Setting up Transactional and snapshot Replication for Production Environment.

Running various DBCC commands for administration of database objects and system performance.

24x7 Technical Support for Production OLTP and Data Warehouse based on Microsoft SQL Server 2005 and 2008 Servers/databases.

To ensure all scheduled administrative jobs are running/completed for Microsoft SQL Servers.

Involved in working with the system/storage administrators to appropriately spread files across the SAN drives.

Interaction with client and onsite team members.

Environment: SQL Server 2012/2014, 2008 R2, 2008, 2005, Windows Server 2012/2008 R2/2003, SSIS, SSRS, SQL Safe, IDERA, SQL Litespeed.

GRACO, Minneapolis, MN Nov ‘12 – July ‘13

Database Administrator

Graco is an American manufacturer of fluid-handling systems and products based in Minneapolis, Minnesota. Graco serves almost all markets. Providing products for painting, anti-corrosion, fluid transfer, gluing applications for markets like Automotive, Aeronautic, Body refinish, wood, building and construction, marine... They distribute through several companies including Integrity Supply.

Responsibilities:

Installed MS SQL server 2005 and 2008 R2/2012 on all production servers and also VMware products.

Worked on Data Center Move project.

Up gradation/Migration from earlier / legacy version to MS SQL Server 2005/2008 R2 using suitable methods.

Interacted with Business Analysts and Developers in identifying the requirements and designed SQL server accordingly.

Administered MS SQL Server security by creating user logins with appropriate roles, monitored the user accounts, created groups and granted the privileges to users and groups.

Worked with Developers to identify the issues from SQL Logs.

Stored procedure optimization and index maintenance.

Maintain the SQL Backups on SAN through Light Speed.

Automated processes using SQL Server jobs and handled database objects with Enterprise Manager and Query Analyzer.

Installed SQL 2005 and 2008 Cluster on windows cluster environment.

Performed Log shipping and Replication and all standard maintenance.

Created SSIS Packages on production and development environment.

Created and provided proper access use of Views to prevent unauthorized access.

Maintenance of the database using the Database Maintenance Wizard to make some necessary changes and to keep the performance of the server at acceptable levels.

Planned and Scheduled the Online/Offline Backups. Backed up master and system databases and restored them when necessary. Performed Log Backups and Restoration.

Performed Capacity Monitoring, short and long-term capacity planning in collaboration with development resources, System Administrators and System Architects.

Performed Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.

Created all SQL-Backup script and blocking script.

Experience in Sharepoint service development and configuration.

Tuned SQL queries using Profiler, Show Plans and Execution Plans for better performance. Employed Indexing Strategies and optimized them using DBCC commands & Index Tuning Wizard.

Partitioned a lot of tables, which had frequent inserts, deletes and updates to reduce the contention and to improve the performance.

Created and implemented the use the stored procedures and triggers to improve the performance and the business logic.

Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS)

Created logins and maintained user permissions appropriately.

Environment: SQL Server 2005, 2008, 2008 R2,2012, SSIS, Win 2003, 2008/2012 Server, Win 2003 Cluster, Reporting Services (SSRS), Analysis services (SSAS), MS Visual Studio 2005, ASP,ASP.Net, Java script

State Farm Insurance, Bloomington, IL May ‘11– Oct ‘12

Database Administrator and Developer

State Farm is a group of insurance and financial services companies in the United States. In 2014, the company sold its operations in Canada to Desjardins Group, which is continuing to use the State Farm name. The group's main business is State Farm Mutual Automobile Insurance Company, a mutual insurance firm that also owns the other State Farm companies. The corporate headquarters are in Bloomington, Illinois.State Farm is ranked 44th in the 2013 Fortune 500, which lists American companies by revenue.

As a Database Administrator, I am fully responsible for the day-to-day technical and operational activities of AccuQuote database server (SQL/SQL Server 2008 R2, 2005 and Windows 2008 R2,2008) however also responsible for troubleshooting, performance monitoring, tuning, backup/recovery, archiving, optimizing, script development and analysis of new technologies. As a Database developer I am responsible for the managing and creating XML files using SQL 2008 R2.

Responsibilities:

Experience in improving SQL Server Database performance using Index Tuning Wizard, SQL Profiler and execution plans.

Create the disaster recovery plan for production server and development server.

Support and develop multiple SQL Server Databases and ensure all the developed SQL Server components functions in the production environments.

Monitor database environments, related jobs end procedures Database tuning & optimization Write and maintain stored procedures Work with database tools and utilities for administration and development

Sending and Receiving the data and Images using XML technology.

Migration of DTS packages to the SSIS on SQL Server 2008 R2/2012

Developed complex stored procedures (T-SQL) for front-end application and reports.

Maintain Fail-Over and Back-up system through use of transaction logs and Snapshot and Transactional Replication. Configured and maintained Log Shipping Environments for 2 projects.

Managing the use of disk space, memory and connections.

Capacity planning - properly sizes and organizes including archive logs; calculate optimum disk space, memory, etc.

Assisted programmers on writing queries to enable application tuning.

Manage hardware configurations and considerations for SQL Server environment Recommend security of databases; insure that policies are adhered to when they are approved and implemented

Documented System and Unit test cases for the modules developed.

Remarkable learning capability and problem solving skills.

Used Red-gate tools for Log based recovery.

Creating Database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.

Triggers, jobs & created views and encryption of Stored Procedure on SQL Server 2008 R2/2012.

Environment: SQL Server 2008 R2/2012, SSIS, SSRS, DTS, Win 2008 R2, Win 2003 Server, SQL Back-up Red gate tool, SQL Server Business Intelligence Studio, XML

Caterpillar, Peoria, IL Jan ‘10 – April ‘11

Database Administrator

Caterpillar Inc., is an American corporation which designs, manufactures, markets and sells machinery, engines, financial products and insurance to customers via a worldwide dealer network. Caterpillar is the world's leading manufacturer of construction and mining equipment, diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives

As a DBA I am fully responsible for five different production servers, a QA server and also a development server. My role is to move databases from SQL 2000 to SQL 2005, check consistency in the database, Archive the Old data and also working with some Business Analyst Requirement and some more Job Maintenance.

Responsibilities:

Installing multiple instances of SQL Server 2008 R2and database migration from SQL Server 2000 to SQL Server 2008 R2.

Implemented SQL Server with high availability architecture using SAN.

Migration of New SQL server 2008 R2 from SQL server 2000.

Create and modification of the database according to the requirement.

Data migration using BCP utility and attach/ detach database.

Create the jobs and also maintain the jobs as daily basis as well as weekly basis.

Implemented a Disaster Recovery plans.

Creating snapshot replication and transactional replication in the SQL Server 2008 R2.

Transfer bunch of tables using SSIS packages.

Partitioned a lot of tables, which had frequent inserts, deletes and updates to reduce the contention and to improve the performance.

Wrote SSIS Script for data transfer and involved in the system designing.

Installing service packs and security patches SQL Server 2005/2008 R2.

Created logical and physical data modeling for development projects.

Rebuild the indexes using DBCC re-index and also check index fragmentation.

Testing QA server data with production servers.

Check blocking process and send them vial e-mail notification.

Actively involved in Normalization and de-normalization database.

Capacity planning in estimating and sizing of tables.

Provided a support for data issues and support to the application developers on application database and given appropriate solutions.

Set up SQL Mail and crated Jobs to automate and scheduling many tasks.

Created heavy SSIS packages on SQL Server and Reporting Services on SQL Server 2008.

Refreshing production databases. Development of policies and procedures for ensuring their security and integrity, analyzing the queries for performance.

As a DBA, managing 10 different production Servers and several QA Servers in multiple countries supporting several hundreds of users.

Maintained the production, test and development databases, tuned the database by improving relations, integrity constraints and written T-SQL procedures for transactions.

Crated documentation of database design, reporting, data analysis, security, administration.

Environment: SQL Server v2008 R2, SQL Server v 2005/2000, Used 40+ database, SQL Optimizer, DTS, SQL Log Manager, Win 2003, Win 2008 R2 Server, ASP, ASP.Net, SSIS, Reporting Service,

IDEA Cellular, Ahmedabad, India Jun ‘06 – Dec ‘09

Database Administrator

IDEA is a prestigious telephonic company, which is dealing to the Customers such as different telephonic products with package of long distance. As a SQL Server DBA I worked on hardening the servers, provide customer support and troubleshooting to the network connectivity for database access. I have also worked on company’s intranet website and an ongoing project which covers vast area in terms of company’s operations and module covered. My part is to develop reports and charts for different Modules and working with multiple databases and maintain the consistency of the database. As a Part of DBA Team I was responsible for 24/7 support to Development and production environment with 3 different SQL servers.

Responsibilities:

Maintaining multiple databases for development and tuning them for performance optimization.

Developed complex stored procedures (T-SQL) for front-end application and reports.

Triggers, jobs & created views and encryption of Stored Procedure on SQL Server 2000.

Monitor Jobs, Create/modify databases and other objects as required and configure databases.

helped in Supporting Huge Databases, Troubleshooting the problems.

Creating Database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.

Design, implementation and maintenance of web based application using Microsoft NET Framework.

Provided assistance to the Application Developer as Designing Queries.

Data migration (import and export BCP) from text to SQL Server.

Installed Service packs to offers number of performance and security

Review project documents requiring database changes and implement them.

Scheduled the jobs to run on monthly basis as well as daily basis.

Participated in meetings with the client and team members.

Monitor DB & SQL Server space usage and generate reports.

Refreshing development databases. Development of policies and procedures for ensuring their security and integrity, analyzing the queries for performance.

Documented System and Unit test cases for the modules developed.

Remarkable learning capability and problem solving skills. Testing performance and functionality.

Performance tuning of SQL queries and stored procedure using SQL Profiler.

Managed database user permissions.

Encrypted sensitive data using Encryption Features of SQL Server 2005.

Created Dedicated Administrator Connection in SQL Server 2005.

Intermediate knowledge of security enhancement of SQL Server 2005.

Used Red-gate tools for Log based recovery.

Environment: SQL Server v2000, SQL Server v 2005/2008 R2, ASP, ASP.Net, Crystal Reports, Win 2000/2003

EDUCATION:

Bachelors in Computer Science, Gujarat, India

Contact this candidate