Sql Server Manager
Resume:
CHINTAN SANGHVI
*******.****@*****.***
Professional Summary:
> Over 7 years of IT experience as a Microsoft SQL Server 2008/2005/2000
Database Administration and Development in Windows environment.
> Experienced in Database Administration activities like Installation,
Configuration, Migration, High Availability Solutions.
> Expert in Database Security, Performance Tuning and Query optimization,
Backup & Recovery and Disaster Recovery procedures.
> Extensive experience in Database Backup, Recovery and Disaster Recovery
procedures and Expert in Database Mirroring in SQL Server 2005/ SQL
Server 2008 in high availability.
> Successfully tested and implemented Log Shipping Technique used for warm
backup solution and Proficiency in implementing different types of
Replication like Transactional, Merge and Snapshot.
> Expert in upgrading SQL Server to new versions and applying service packs
and hot fixes and Extensive experience in Database Migration of SQL
Server 2000 to SQL 2005, SQL 2005 to SQL 2008.
> Experienced of Installation and Configuration of Clustered Servers in
Active/Active mode and Active/Passive mode and Proficiency in working
with high transaction OLTP systems in SQL Server 2008/2005/2000.
> Experienced in using SQL Server Profiler, Windows Performance Monitor for
Performance Tuning and Query Optimization, database consistency checks
using DBCC utilities and DMVs.
> Creation and Maintenance of Databases, creating roles and managing user
permissions and Proficient in using Data Modeling tools like Erwin,
Microsoft Visio and SQL Diagram.
> Experienced in creating packages, jobs, sending alerts using SQL Mail, DB
Mail and customized extended procedures.
> Database administration for multi-terabyte databases including
maintenance, backup/recovery, high availability and expert in
implementing RAID 0- 1 and 5 technologies for increased storage
reliability and performance.
> Expert in creating indexes, views, stored procedures, cursors, triggers,
Function SQL Queries and Monitoring Event Viewer, SQL Error logs and Log
File Viewer for Software and hardware related errors.
> Available for 24x7 Production support and on Call duties.
> Flexible, enthusiastic and project oriented team player with solid
communication and leadership skills to develop creative solution for
challenging client needs.
Education Qualifications:
B.S in Electronics & Communications
Skillset:
Microsoft SQL Server 2008/2005/2000, SQL Server Profiler, SQL Diagram,
SSIS, SSRS, SSAS, Erwin, Windows 2008/2003 Enterprise Server, Windows 2000
Advanced Server, C, C++, T-SQL, Windows NT 4.0, Windows XP, Windows 98/95,
Idera SQL Diagnostic Manager, RAID, Database Tuning Advisor, Double-Take
Recover Now 5.3.
Projects Summary:
Social Security Administration June2011-
Current
Woodlawn, MD
SQL DBA
Social Security Administration works for U.S. government. It manages a very
large number of secure data of whole U.S.
Responsibilities:
> Installed and configured several 2-nodes Cluster Configuration
(Active/Passive) in SQL Server 2008.
> Upgraded SQL Server 2005 to SQL Server 2008 and Migrate data from SQL
Server 2005 to SQL Server 2008 by backup and restore side-by-side.
> Created Linked Servers to move data from one server to another and
Tested and implemented backup strategies for newly commissioned
production instances prospective.
> Setup database High Availability environment (Mirroring, Replication,
and Log Shipping) & supported Application Disaster Recovery test.
> Monitor and maintain database security in cooperation with data
security administrators and Secured the SQL Server by creating user
logins and Windows logins with appropriate roles, creation of groups,
granting the privileges to Users and Groups.
> Solved issues related to server performance and disk space and
resolved issues related to query optimization, database optimization
and index tuning.
> Development of all database-related documentation, including SQL
Cluster build plans, production implementation plans, and maintenance
reports.
> Created Stored Procedures, Triggers, Views and Functions for the
Application and Extensive testing on the Performance of the Stored
Procedures.
> Tested and implemented backup strategies for newly commissioned
production instances prospective and Used Double-Take Recover Now 5.3
for point in time restore using Continuous Data Protection.
> Handled ITSM tickets, and closed in accordance with Client IT policies
and procedures and Provide 24x7 support and Performed Production
support and on Call duties.
Environment: Windows Server 2003 NT, MS SQL Server 2008 R2/2008/2005/2000,
ITSM Ticketing System, Double-Take Recover Now 5.3, Erwin 7.1 & Microsoft
Visio 2003.
MaJescomastek
Apr2010-May2011
Edison, Nj
SQL DBA
MajescoMastek is a global provider of innovative technology solutions for
Life & Annuity and Property & Casualty Insurers, Capital Markets and
Government Agencies. MajescoMastek offers an integrated portfolio of IT
products and services, including: IT Consulting, Application Development,
Systems Integration, Application Management Outsourcing, Testing, Data
Warehousing and Business Intelligence, Application Security, CRM services
and Legacy Modernization.
Responsibilities:
> Maintained and configured SQL Server 2008/2005 on existing servers
ensuring zero downtime and Installed and configured SQL Server 2008
clustering on Windows Server 2008 for failover on production servers.
> Applied latest service packs and upgrade test and Production server to
existing SQL Server 2005 and Migration of SQL Server 2005 to 2008 and
Worked closely with application owner, manager and other DBA for
planning and implementation of the migration.
> Implemented Backup, Restore and Disaster Recovery procedures and
extensively involved in setting up Database Mirroring for high
availability.
> Administration of terabyte size databases including maintenance,
backup/recovery, high availability and successfully resolved deadlock
issues by creating traces on objects using SQL Server Profiler.
> Created automated procedure for daily, weekly and monthly system
maintenance tasks such as database backup, database integrity
verification, indexing updates and compression of databases.
> Expert in implementing RAID 0- 1 and 5 technologies for increased
storage reliability and performance and maintain Operators, Alerts,
Notifications, Jobs and Schedules, Created stored procedure, triggers
and views.
> Working with Online Analytical Processing (OLAP), Online Transaction
Processing (OLTP) environments and Created roles, users and assigning
access privileges to users.
> Created configured clustering setups for failover on production
servers and maintained documentation on current configuration of
database servers.
> Done Query optimization and Performance tuning and Performed
Partitioning on very large database and Used DBCC commands to check
physical and logical consistency of the databases.
> Worked closely with QA team before implementing new
applications/updates into production. Also supported various database
components in DEV, QA, Staging environment.
> Reviewed third party tools (Idera) so as to help automate routine
tasks such as monitoring, blocking and consolidate status of scheduled
jobs.
> Deployment of SQL Server under ASP.NET
> Deployment of ASP.NET using web scripts and database scripts
Environment: Microsoft SQL Server 2008/2005/2000, Windows 2008/2003
enterprise server, SQL Profiler, Idera SQL Diagnostic Manager, Performance
Monitor.
Key Logic System Inc. Nov2008-
March2010
Columbia, MD
SQL DBA/SQL Developer
Key Logic Systems specializes in Knowledge management, program management,
and Portfolio and performance management solutions to various clients
including United States Department of Health and Human Services(DHSS),
Department of Defense (DoD), Environmental Protection Agency (EPA) and
Departments of Labor (DOL).
Responsibilities:
> Planned the Complete Backing up of Database and Restoring the Database
from Disaster Recovery and Troubleshoot backup failures and use
necessary SQL scripting to ensure that backup are performed.
> Created Database Maintenance Planner for the Performance of SQL Server
which covers Database Integrity Checks using DBCC utilities and DMVs.
> Configured Transactional Replication and Log Shipping with SQL Server
Management and Migrated DTS packages from SQL Server 2000 to SQL
Server 2005 as SSIS packages.
> Setting up Database Mirroring, a high availability solution for SQL
Server 2005 and Created Stored Procedures, Triggers, Views and
Functions for the Application.
> Implementation of SQL Logins, Roles and Authentication Modes as a part
of Security Policies for various categories of users.
> Rebuilding the indexes at regular intervals for better performance and
Good experience in data modeling and metadata services.
> Documented current environment for Intranet use for developers using
third party software and expert in implementing RAID 0- 1 and 5
technologies for increased storage reliability and performance.
> Enhanced the coding guidelines document for SQL developers and Monitor
and troubleshoot existing/new jobs on production environment.
Environment: Microsoft SQL Server 2005/2000, DB2, Windows 2003 Enterprise
server, Windows 2000 Advanced Server, Visual Source Safe 6.0, Crystal
Reports, Business Intelligence Development Studio.
Open text INC
June2008-Nov2008
NewYork, NY
SQL DBA/Support
Open Text is market leader in ECM (Enterprise Content Management) and
developing new products for users. The New York branch has created
application for lawyers for electronic document. The project was to create
Reports with help of SQL Server Reporting Services (SSRS) according to
business requirement for electronic document.
Responsibilities:
> Installed, configured and maintained SQL server 2005 databases.
> Implemented migration of SQL Server 2000 to SQL Server 2005 and
Performed backups and recovery for critical databases.
> Performed backups and recovery for critical databases and Worked with
Third Party Backup solutions like SQL Litespeed in MS SQL Server 2005.
> Implemented a Database Mirroring with automatic failover to support
Disaster Recovery solution in Sql server 2005.
> Created complex stored procedures, triggers, cursors, tables and views
for applications and Developed database maintenance plans and
performance tuning strategies.
> Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages
and Configured Log shipping and created standby server.
> Implemented and configured Transactional and Merge replication in Sql
server 2005 and Administrate security for server's logins (Windows and
SQL Accounts).
> Maintained Operators, Alerts, Notifications, Jobs, Schedules and
Created the Jobs and scheduled for daily running
> Assign permission to users, roles, and object and Administrate
security for server's logins (Windows and SQL Accounts)
> Provided 24 X 7 dedicated supports to production and development
servers and preparing the reports for the day-to-day as well as
weekly/monthly purposes.
Environment: Microsoft SQL Server 2005/2000, Windows 2003/2000 Server, SQL
Diagrams, Erwin, and SQL LiteSpeed Backup Software
Wells Fargo
July2007-May2008
Phoenix,AZ
SQL DBA/SSRS Developer/SSIS Developer
Wells Fargo & Company is an American multinational diversified financial
services company with operations around the world. Wells Fargo is the
fourth largest bank in the U.S. by assets and the largest bank by Market
capitalization. . It maintains users checking and saving account
information, allows users to make a payment, transfer funds and customize
reports for users and bankers. The features provided were opening and
closing of accounts, deposit/withdrawal of money, money transfers between
two accounts and interest calculation. View online statements and pay
bills.
Responsibilities:
> Involved in creating SQL Server Analysis Projects using MS SQL Server
2005.
> Created measures and dimension members using multi dimensional
expression (MDX).
> Created an OLAP with the help of ERWIN.
> Created cubes and dimensions for the analysis of sales in specific
areas.
> Defined the Referenced Relationships with the measure groups and fact
tables.
> Performed Automatic generation of grouping attribute members.
> Defined Granularity with in a measure group and drill through actions.
> Implemented calculations to aggregate physical measures.
> Added charts and figures and made stylist reports.
> Identified and worked with Parameters for parameterized reports in
SSRS 2005.
> Created report model to create ad hoc reports.
> Responsible for Process Database Objects Security Role.
> Developed SSIS project for transferring the data.
> Worked with data flow and control flow task in ETL (SSIS) to transfer
data from OLTP to OLAP.
> Transferred data from data warehouse to other databases (SQL server
2005, ORACLE), flat files, Excel.
> Responsible for writing T-SQL code for creating cursor and handling
the data validations.
> Developed complex T-SQL code for the application.
> Transformed the complex business logic and calculations into coding.
> Developed stored procedures, functions, tables, views and triggers.
> Created back up jobs like full backup, differential backup, and
transaction Log backup.
> Improved performance of queries using Profiler, Tuning advisor, DBCC
commnds, execution plans.
Tools & Technologies : -
MS SQL Server 2005, MS Analysis Services 2005, MS Access, Import & Export
Data, Windows XP, Erwin 4.2.
Eclipsys
Dec2005-June2007
Pune,MH
Ms SQL Developer/DBA
Eclipsys provides innovative solutions that empower all stakeholders across
the healthcare continuum to deliver world-class outcomes. The company's
clinical, financial, connectivity and information solutions for hospitals,
physician practices and post-acute organizations are the essential
technologies that enable a Connected Community of Health.
> Tested to optimize the Stored Procedures and Triggers to be used in
production.
> Maintained the client relationship by communicating the daily statuses
and weekly statuses of the project.
> Designed and implemented the Logical and Physical model of the
database using Erwin.
> Planned, defined and designed data flow processes for data migration
to the Data Warehouse using DTS.
> Created Database Objects - Tables, Indexes, Views, User defined
functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
> Developed complex T-SQL code for the application.
> Involved in log shipping, replication, backup.
> Transferred data with the help of DTS.
> Tune database queries with the help of SQL profiler
> Worked in Enterprise Manager for job scheduling and batch queries.
> Installed and maintained MS SQL Server 2000.
> Monitored performance and optimized SQL queries for maximum
efficiency.
> Implemented fine tuning of database objects and server to ensure
efficient data retrieval.
> Managed and monitored the use of disk space.
> Planned Backup strategy based on projects requirements.
> Worked with DTS packages and MSOLAP Services.
> Increased performance of the Queries with proper indexes on Tables.
> Took Backups of ORACLE database with the help of RMAN.
> Managed performance of ORACLE database.
> Multiplexed Control files and Redo log files for better security in
ORACLE database.
> Provided 24*7 technical supports.
> Worked as Call Center (in-bound) support Analyst
> Created manual test cases with the help of Quality assurance.
> Transferred manual test cases to QTP.
> Execute test cases and report bugs in automation testing.
> Created performance testing with the help of Load runner.
> Created XML schema and convert it in XML documents.
> Created DTD'S and transferred it to XML documents.
> Transferred XML documents to XHTML with the help of XSL.
Tools & Technologies : -
MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import
& Export Data, Windows 2000 Server,RMAN,ORACLE 9i.
Contact this candidate