Sql Server Development
Resume:
HARDIK SHAH
Senior MS SQL Server ****/****/**** Database Administrator
PROFESSIONAL SUMMARY
Senior Certified Microsoft SQL Server 2008/2005/2000 DBA with 8+ years of
quality experience.
Production Support:
8+ years of experience in handling production systems in 24/7 environment
(rotating on-call)
8+ years experience in Administering and managing Databases ranging several
gigabits.
Expert in managing multiple instances of database servers on-site and
remotely
Database Administration:
Installed and configured MS SQL Server 2008/2005 and 2000 systems in all
environments
Installed security patches, services packs and hot fixes for windows and
SQL Systems
4+ years of experience upgrading and migrating SQL Systems from lower
version to higher version
6+ years of experience in using SQL Server Agent for creating and
scheduling complicated jobs
6+ years of experience in handing SQL Server systems in Clustered
environments
Performance Tuning:
8+ years of experience in performance tuning MS SQL Server 2008/2005 for
best performance
Expert in fine tuning parameters on operating systems
Expert in using SQL Server 2008/2005 profiler trace for bottlenecks and
long running queries
Excellent knowledge in fine tuning stored procedure for super performance
Excellent knowledge in fine tuning queries taking a long time
Good knowledge in understanding query plans and statistics data
Expert in Creating, Suggesting and implementing Indexes (Clustered, Non
Clustered, Unique)
Expert in verifying output of DBCC SHOWCONTIG and suggesting changes
3+ years of experience in using tuning wizard in MS SQL Server 2008/2005
Backup and Disaster Recovery:
8+ years of experience in capacity planning and implementing solid backup
strategy for all SQL S
Timely full backup and transaction log backup for all production,
development & QA systems
Implemented SQL Clustering for MS SQL 2008/2005/2000
Expert in implementing log shipping mechanism (Manual & Wizard)
MS SQL Server 2008/2005/SSIS/SSRS/SSAS:
Worked extensively on MS SQL Server 2005/2008 Integration Services (SSIS)
4+ years of experience in SSIS, SSRS and SSAS
Created SSIS packages to Extract and Load data from diverse source (flat
file, excel, xml and oracle)
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
Created Data Flow's for Aggregate, sort, lookup, merge, union all and fuzzy
lookups.
Used containers for repetitive control flow tasks
Scheduling package execution in SSIS
Installing packages on multiple servers in SSIS
Extensively worked on SSIS for data manipulation and data extraction, ETL
Load
Used SSRS to Reporting for a Data warehouse system
Extensive use of DMV's in MS SQL Server 2008/2005
Database Development:
8+ years of experience in writing complicated queries in MS SQL Server
2005/2000
8+ years of experience in writing stored procedures, triggers and functions
having complicated logic
8+ years of experience in writing views and cursors and using temporary
tables for performance
TECHNICAL SKILLS
Technical Skills:
RDBMS: SQL Server 2008/2005/2000.
Database Tools: Management Studio, BI Development Studio, SQL Profiler,
Data Transformation Services (DTS), SQL Server Integration
Service (SSIS), SQL Server Analysis services(SSAS), SQL
Server Reporting services(SSRS), Erwin, Microsoft Visio.
Languages: SQL, TSQL, Visual Basic 6.0, HTML
Web Tools: MS-Front Page, Internet Information Server (IIS), MS-Outlook
Express.
Applications: Microsoft Office, Erwin, MS VISIO 2003/2005.
Operating Systems: Windows 95/98/2000/2003/NT 4.0/XP, Linux, MS-DOS
EDUCATION / CERTIFICATION
Bachelor of Engineering (Computer Science)
Microsoft Certified Database Administrator (MCDBA)
Certified in Microsoft SQL Server 2005
PROFESSIONAL EXPERIENCE
YMCA Retirement Fund, New York, NY
May 2009 - Present
Role: Senior MS SQL Server 2005/2000 DBA
Industry: Retirement processing & Finance
Responsibilities:
. As a Production and development support DBA responsible for maintaining
253 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 2008 and SQL Server 2005 on windows 2003 and 2008
servers, applied service packs and security fix for all servers.
. Managed SQL Servers in Clustered environments.
. Configured and maintained Log shipping architecture to provide backup
server solution for 4 environments.
. Experience in upgrading from SQL Server 2000 to SQL Server 2005 servers.
. Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
. 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.
. Involved in securing the SQL Server environment and involved in setting
up the user permissions.
. Experienced with creating database maintenance plans for efficient
operations.
. 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.
Environment: MS SQL Server 2008/2005, Windows 2000/2003/2008 Server
Operating systems, SSIS, SSAS, SSRS.
KPMG LLP, NJ
June 2007 - May 2009
Role: Senior MS SQL Server 2005/2000 DBA/Developer
Industry: Finance
KPMG member firms are leading provider of audit, tax, legal and financial
advisory services. I worked as the Senior MS SQL Server DBA handling their
production, Development and Test environments in MS SQL Server 2005/2000.
Responsibilities:
. Responsible for 24*7 Critical Production Support for 120 servers out of
which 90 servers are production servers, remaining test and development
servers.
. Installed SQL Server 2000 and 2005 on windows 2000 and 2003 servers,
Installed service packs and security fix on production, test and
development servers.
. Installed, configured and maintained MS SQL fail over clustering for 2
mission critical servers
. Involved in monitoring the backup jobs and fixed the failed jobs.
. Created manual Log shipping environments for standby servers.
. Involved in securing SQL Servers and assign the permissions for users and
roles.
. Designed the logical and physical database design for development
projects using Erwin data modeling tool.
. Configured and maintained two log shipping environments to create the
backup server.
. Involved in improving the server performance using Performance monitor
using I/O, memory and CPU counters.
. Experienced in involving SQL Server performance using index tuning
wizards, SQL Profiler and SQL Query Analyzer.
. Created the DTS packages to import and export the data from Oracle, MS
Access and text files to SQL Server.
. Created the standard operating procedures (SOP) for SQL Clustering,
replication and log shipping.
. Experienced in creating backup strategy for production, test and
development servers.
. Involved in disaster recovery procedures and restore the production
databases.
. Involved in database restore requests and refresh the database between
productions, test servers.
. Created the maintenance plans for integrity checks and optimization for
production, test and development servers.
. Tunes SQL queries and stored procedures to improve the SQL Server
performance.
Environment: MS SQL Server 2005/2000, Windows 2000/2003 Server Operating
systems, SSIS, SSAS.
SANOFI AVENTIS, Bridgewater, NJ
December 2005 - May 2007
Role: SQL Server DBA/Developer
Industry: Pharmaceuticals
Responsibilities:
. Administered all Production, development and Test servers of Sanofi
running SQL 2005/2000
. Applied DTS-FTP(File Transfer Protocol) tasks to upload files in FTP
after data churning
. Gathered end user requirements through meetings with manager and users
. Utilized joins and functions as appropriate to achieve project
requirement
. Created triggers and constrains for the purpose of meeting business
needs especially for data validation and data integrity
. Supported deployment of modules on Staging and then promoted to
Production Servers
. Imported and Exported data from Excel, SQL server and text files
. Performed Data Scrubbing and Validation for implementation in
production environment
. Produced custom reports as per business requirement for users at
various levels
. Denormalized table for the purpose of running stored procedures in an
efficient manner
. Implemented Auto Alerts, Messaging & Notifications
. Performed tuning of SQL queries and stored procedures for slow running
queries and procedures using SQL Profiler tracing and checking the
query execution plan in Query Analyzer
Environment: SQL Server 2000 Enterprise Edition, Crystal Reports, ERWIN,
Windows 2K platform.
CITIGROUP, India
February 2004 - October 2005
Role: SQL Server DBA
Industry: Finance & Investment Banking
0. Responsible for 112 SQL Servers including 76 production servers and 36
test and development servers.
1. Installed SQL Server 2000 on windows 2000 servers, applied service packs
and security fix.
2. Experienced in configuring and maintaining transaction and snapshot
replication to replicate the data to remote servers.
3. Involved in trouble shooting SQL Server production issues. Worked with
the report team to fix the reporting issues.
4. Involved in configuring SQL Server to run in best optimal conditions.
5. Created the new database design for development projects, worked with
SQL Developers to create the applications.
6. Experienced in creating database backup strategy and implemented for
production, test and development servers.
7. Created the maintenance plan for SQL Server database optimization and
integrity checks for production servers.
8. Configured and maintained the 2 log shipping environments to create the
backup server.
9. Involved in creating Installation Qualification and operational
Qualification (IQ/OQ) procedures, comply with FDA validation procedures.
10. Involved in creating work requests and change management using remedy
software.
11. Experienced in improving SQL Server performance using performance
monitor.
12. Designed the DTS packages to import and export the data between oracle
and access databases to MS SQL Servers.
13. Involved in tuning the SQL Server stored procedures using index tuning
wizards, profiler and SQL Query analyzer.
14. Created the work instructions to install and configure SQL Server 2000,
service packs, security fixes.
15. Experienced in restoring the production databases to restore critical
production data when disaster happens.
16. Worked in team environment and involved in on call rotation schedule to
support production servers.
ICICI BANK, India
October 2003 - February 2004
Role: Jr. SQL Server DBA
Industry: Finance & Investment Banking
17. Installed SQL Server 7.0 and 2000 servers, applied service packs and
security fix.
18. Experienced in upgrading from SQL Server 7.0 to SQL Server 2000.
19. Experienced in granting permission to the SQL Developers and
application users.
20. Responsible for database capacity planning and advice the system
engineers for future hardware requirements.
21. Experience in creating the stored procedures, triggers and views.
22. Maintained the SQL Server security features and assign the permissions
to application developers and users.
23. Worked with the SQL Developers to create a new database design acquired
the business information from Business analysts, incorporate those
information in the database design.
24. Experience in tuning the SQL Queries and Stored procedures.
25. Experience in creating tables, triggers, stored procedures and indexes.
26. Created the SQL Scripts and scheduled to run on servers for index
maintenance.
27. Created the backup strategy for production, test and development
servers and implemented them.
28. Experienced in doing the restore operations and did the data refresh
between the production to test environments.
29. Maintain the SQL Servers and promote the tested scripts from test to
production servers.
30. Maintained the application report database for report errors.
31. Experienced in configuring the SQL Server for better performance.
32. Extensively worked to fix the database corruption problems in SQL
Server 7.0 servers.
Contact this candidate