Summary
o More than five years of experience in Database Administration,
Design, Development and Support for MS SQL Server 2008 R2, 2008,
****, **** ** **********, *******, Development and Clustered
Environment.
o Experience in upgrading/migrating MS SQL Server 2000 to MS SQL
Server 2005, MS SQL 2000/2005 to SQL 2008
o Experience in Database Administration activities including
Installation, Configuration, Backup & Recovery, Database Security,
Data Transformation Services, Database designing and Query
optimization.
o Experience as a SQL developer and Application developer, Created
different SQL objects Stored Procedures, Cursors, Triggers, Tables,
functions etc to support the application
o Provided 24x7 Production support.
o Experience in working with both high transacted OLTP systems and
OLAP database systems.
o Implemented different types of Replication like Snapshot and
Transactional.
o Successfully tested and implemented Log Shipping Technique used for
hot backup solution for MS SQL Server 2000/2005 databases.
o Experienced in Installation and Configuration of SQL 2000/2005/2008
Clustered Servers in Active/Passive and Active/Active mode.
o Expertise in Performance Tuning and Query Optimization using SQL
Server Profiler, Windows Performance Monitor, Data Tuning Advisor,
Index tuning wizard.
o Experienced in troubleshooting using DBCC Utilities and Dynamic
Management Views.
o Experienced in Data Modeling using ERWIN and VISIO.
o Created, Designed and Maintained Databases of more than 2 tera byte
size,
o Partitioned large tables with 300 Million rows to enhance the
server performance in SQL 2005 and 2008.
o Expertise in Query Optimization (Execution Plans) by building new
indexes or enhancing the old indexes/Changing the Join Criteria to
help building a strong Execution Plan.
o Knowledgeable in Implementing and suggesting RAID technologies.
o Worked as an ETL Developer for creating DTS/SSIS packages and as a
DBA to deploy the packages from PVCS/ Version Serena
Manager/VFS/TFS to the production using Deployment scripts
o Created and scheduled Jobs, sending alerts using SQL Mail and
customized extended procedures.
o Experienced in handling Security (Server/DB Access/ Roles/ Users/
Permissions/ Policy Management in 2008) issues in SQL 2000, 2005
and 2008.
o Created and maintained Linked Servers.
o Worked with third party monitoring tools like Idera's SQL
Diagnostic Manager, SQL Litespeed, and Spotlight.
o Used SQL Compliance Manager and SQL Security from Idera.
o Experienced in working with SQL Server Analysis Services (SSAS).
o Experienced in working with Windows 2003 Server, Windows 2000
Advanced Server and Windows NT Server.
o Experienced in applying service packs and hot fixes.
o Upgraded more than 500 SQL Server 2000 DTS packages into SQL Server
2005 Integration Services (SSIS) packages using DTSXchange.
o Knowledgeable in Database Mirroring in SQL Server 2005.
o Experience in contacting Microsoft PSS and other vendors for
product and technical support.
o Experienced in version control tools Microsoft Visual SourceSafe
6.0, Team Foundation Server, PVCS, SVN.
Certificate of Excellence from Microsoft:
o 070-228: Installing, Configuring, and Administering
Microsoft SQL Server 2000 Enterprise Edition
o 070-431: Microsoft SQL Server 2005 - Implementation and Maintenance
(MCTS)
o 070-229: Designing and Implementing Databases with
Microsoft SQL Server 2000 Enterprise Edition
Technical Skills:
Languages: C, C++, T-SQL, HTML, Java, VBScript, ASP
RDBMS: MS SQL Server 2008R2, 2008, 2005, 2000, 7.0, MS-Access
2000, 2003, MySQL, Oracle
SQL Server Tools: SSMS, SQL Server Profiler, SSIS, SSAS, SSRS,
DMV, DTA
Front End: MS Visual Basic, Dreamweaver, NetBeans
Version Control Tools: Microsoft Visual source safe 6.0, TFS, Serena
Mover, SVN
Job Scheduling Tools: Tivoli, Tidal Enterprise Scheduler
Data Modeling Tools: Erwin, MS VISIO
Operating Systems: Windows Server 2003, Windows 2000 Advanced
Server, Windows Datacenter Server, Windows NT 4.0,
Windows XP Professional/Media Center/Standard,
Windows 9.x, UNIX, and Linux
Other Tools: Idera SQL Diagnostic Manager, Compliance Manager,
Security, Red Gate SQL Compare tools
Education:
o Masters of Science - Computer Science
University of North Carolina at Charlotte, NC
o Bachelors of Engineering - Computer Engineering
Dharmsinh Desai University, Gujarat, India
Application Areas:
o DTS (Data transformation services)/SSIS (Integration Services)
o SSRS (Reporting Services), SSAS (Analysis Services)
o Log Shipping, Database Mirroring, Clustering
o Performance Tuning, Query/Index Optimization
o Backup/Restore Databases, Import/Export objects
o Database Security
Other Skills:
o Team Player
o Works with minimal supervision
o Strong oral and written communication skills
o Strong analytical and organizational skills
Professional Experience:
Symantec Corporation, Alexandria, VA
Mar 2011 - Present
Sr. SQL Server DBA
Description:
Symantec provides security, storage and systems management solutions
to help its customers - from consumers and small businesses to the
largest global organizations. As part of Norton Data Security Group,
My core responsibilities are to maintain and manage more than 100s of
"backup/restore" sql servers and databases for Norton Online Backup
and Norton360 product
Responsibilities:
o Install and configure SQL Server 2008 R2 Clusters, SQL Server
2005/2008 enterprise and datacenter editions
o Create Pre-migration and post-migration checklist to migrate sql
servers from one version to another
o Migrate SQL server 2005 databases to SQL server 2008 R2
o Troubleshoot migration related issues like orphaned users, linked
server setup, replication and database mirroring
o Maintain and manage replications between distributed environments
o Architect and design Data Warehouse system based on business
requirements
o Create Visio diagrams to analyze data and system flow architecture
for data warehouse
o Build a data warehouse using SSIS (ETL tool), SSAS and SSRS
o Experience in loading data from distributed environments like
MySQL, Oracle, DB2, Flat files to SQL Server
o Set up DSN connectivity, Linked servers, ODBC drivers to support
ETL processing
o Experience on populating and maintaining Facts, Dimensions and
Cubes for data warehouse
o Implement change data capture (CDC) functionality to track DML
changes on tables/databases and to support ETL processing to load
only incremental data
o Use table partitioning to improve performance of few SQL Queries
o Capacity planning of current disk space, data files usage and index
usage
o Create custom scripts to troubleshoot performance related issues
like CPU, I/O, DISK, MEMORY bottlenecks
o Create custom scripts to automate the Index maintenance on the
server instance based on the fragmentation and reduce the
maintenance window time from 6 hours to half an hour.
o Work on different adhoc reporting requests of organization
o Experience with MySQL databases/ MySQL Clustered environments using
MySQL Workbench 5.2 and Linux environment
o Provide 24x7 support on production environments and weekly/monthly
maintenance window
o Grant security access to different application/database roles,
users
o Analyze the best monitoring tool amongst all (IderaDM/ SQLsentry/
SQLdoctor/ Spotlight) in current market, Create business case and
Provide recommendation to get the license
o Create documents based on on-demand ad-hoc requests
o Use windows-diff utility to check the difference between two SQL
statements/objects
o Use Jira as ticketing system to report or resolve any issues
o Use SVN repository to store documents and development scripts
Environments:
Windows 2008 Data center, Windows Server 2008 R2, MS SQL Server 2005,
MS SQL Server 2008 and 2008 R2, SSRS, DTS/SSIS, NOBU, N360,
MySQLWorkBench 5.2
Mediaspace Solutions, Norwalk, CT
Jan 2011 - Mar 2011
SQL Server DBA/Developer
Description:
The Mediaspace Solutions is about newspaper, advertising and media
planning. They developed tools, techniques, web based solutions and
systems to help national advertisers maximize their newspaper
advertising budgets. As a SQL Server DBA/Developer, I have managed all
SQL server 2005/2008 development, QA and production versions, as well
as managing and maintaining lot of different Access and Web
application.
Responsibilities:
o Maintained and monitored SQL Server 2005/2008 Standard and
Enterprise Editions with different environment (prod/qa/dev/test).
o Created backup restore maintenance plans, Full/Differential/Log
backups based on business rules and requirements.
o Troubleshoot any ongoing support issues with different Access/
Windows/ Web Applications.
o Designed and built replication strategy to transfer the articles
from one server to another.
o Created automated jobs to handle Data Transformation using SSIS
packages.
o Designed and architect new databases/ space requirements and
objects
o Created Stored procedures, Cursors, functions to support large
access and web application
o Used Visual Source Safe to store different versions of database
objects
o Built, ran, deployed ad-hoc SSRS reports using BIDS and Report
Manager based on business requirements for different
Agencies/Advertisers and Clients
o Automated monthly/weekly ad-hoc queries and create different
reports (parameterized, drilldown, tabular, matrix, chart)
o Granted security access to different roles and members of Report
Manager
o Provided support to offshore development team for ongoing projects
o Installed and configured SQL Server 2005, 2008 and different 3rd
party tools.
o Created documents based on new troubleshooting requests and their
resolutions, servers, databases, object information.
o Used BI Documenter to document all SSIS Packages on SQL Server
2005/2008
o Used DTSXchange to migrate DTS packages from SQL 2000 to SQL
2005/2008
o Used Red Gate SQL data compare tool to generated pre-migration and
pre- upgradation report
o Used SharePoint standalone database to extract data for reporting
database based on user requests
o Granted appropriate access/permission to developers and analysts
according to requests.
Environments:
Windows 2003 Data center, Windows Server 2008 R2, MS SQL Server 2000,
MS SQL Server 2005, MS SQL Server 2008 and 2008 R2, SSRS, DTS/SSIS,
APEX, PLANET (custom applications)
Blue Cross Blue Shield of Michigan, Detroit, MI
Mar 2009 - Jan 2011
SQL Server DBA/Developer
Description:
BCBSM is nation's oldest and largest family of health benefits
companies and the most recognized brands in the health insurance
industry; it has 26 facilities located in 18 Michigan cities, it
offers insurance to individuals, groups and retirees. As a SQL Server
DBA, I have maintained all production, development and QA Legacy
Servers, including creating and maintaining DTS packages, developing
different Objects.
Responsibilities:
o Monitored SQL 2000/2005 and 2008 (around 45) production servers and
troubleshoot performance issues like Deadlock, Blocking,
Transaction log full, Disk Space full, Resource (CPU, I/O, Disk,
Memory) bottlenecks.
o Used Spotlight, SQL Profiler, and Perfmon for production server
monitoring.
o Backup/Restored databases from one server to another server.
o Maintained and monitored around 1000 production jobs and 1200
DTS/SSIS packages.
o Used ETL process to load data from different sources like DB2,
Oracle, Access, Excel, Text, CSV file to SQL Server data mart in
2000/2005/2008.
o Build different Active X Script tasks to rename existing file, copy
file to different location, delete file, open Access and Excel
database connections using VBScript.
o Improved performance of DTS packages/SSIS packages.
o Helped in troubleshooting long running queries and optimized them
to improve performance using different Optimization Hints, DTA/ITW,
Execution Plan
o Capacity planning on different productions servers and estimated
space required.
o Analyzed different business requirements and provided time estimate
for all SDLC phases (Analysis, Design, Coding, Implementation, SIT,
UAT, Production Move)
o Created Stored Procedures, Views, Functions, Scripts to improve and
support existing environment.
o Migrated databases from SQL Server 2000/2005 to SQL 2008.
o Migrated around 160 DTS packages to SSIS packages using DTSXchange.
o Installed and configured SQL server 2000, 2005, 2008 and different
3rd party tools.
o Lead on different projects to move them from Development to QA and
from QA to Production.
o Created documents on all the existing process, dts/SSIS packages,
issues faced in the past and their resolution.
o Build stored procedures to generate reports and move related Rdl
files to upload on Report Manager.
o Ran reports for various HealthCare vendors using SSRS and Report
Manager.
o Deployed reports to the production servers.
o Experienced in generating DLL file and its registration to
ASSEMBLIES and all three Security policy config file
o Granted appropriate access/permission to developers and analysts
according to requests.
o Used PVCS as repository for all the implemental fix (Objects,
Documents, DTS/SSIS packages) and move those to production.
Environments:
Windows 2000 Advanced Server, Windows 2003 Data center, MS SQL Server
2000, MS SQL
Server 2005, MS SQL Server 2008, SQL DTS Backup tool, Spotlight,
Perfmon, Clearquest Ticket
System, Tivoli Scheduler
GMO LLC, Boston
Jul 2008 - Oct
2008
SQL Server DBA
Description:
GMO is a global investment management firm committed to providing
sophisticated clients with superior asset management solutions and
services. It offer s a broad range of investment products, including
equity and fixed income strategies across global developed and
emerging markets, as well as absolute return strategies. It supports
different applications and provides them an efficient support from
database side. My responsibilities include performance monitoring,
implementing clustering, providing (24x7) production support, backups-
restore.
Responsibilities:
o Monitored production servers' performance using Idera Diagnostic
Manager, Perfmon monitor, SQL Profiler, Sitescope and Inteq
monitoring tools.
o Audited more than 30 servers using Idera Compliance Manager,
Installing Compliance Manager collection service under all the
machines
o Used SQL secure for checking the passwords' security and
permissions of particular user accounts on the servers.
o Resolved deadlocking, blocking and locking issues by using SQL
Profiler and Idera Diagnostic Manager.
o Used database tuning advisor to check all the indexes are well
organized, find out the query cost and analyze the solution.
Provided optimized query to the developer.
o Created maintenance scripts for shrinking the transaction log file
and truncating the space for our Global replication Servers which
were in Sydney, London and Berkley.
o Created Scripts to find out the latest diff and full backup from
the SQLDisastro tool.
o Created linked servers in different UAT and Test environment.
o Involved in Active Directory Management, Services, Users and
Groups,
o Used "Password Management Pro" website to store all the details of
User Accounts, Resources and passwords.
o Involved in "Change Advisory Board" (CAB) to review the changes in
production. used "FootPrints" to log any RFCs or Emergency RFCs for
changes in production.
o Installed and configured SQL Server 2000 and 2005 servers on
different physical and virtual box.
o Installed Active/Passive Cluster using SQL Server 2005.
o Used "XOSoft" and "Acronis" software to monitor and maintain the
cluster servers, replication process.
o Applied patches on weekends for both SQL server 2000 and 2005
servers.
o Created Scripts for Restoring databases, Linked Servers and
Transfer logins for the Data Center Move.
o Involved in the whole plan of Datacenter move.
o Provided support (24x7) "On Call" as per the "On Call Schedule".
o Rebuilt master database and migrated all user databases.
o Transferred logins from one server to another and mapped users with
SQL logins.
o Used "Tidal Scheduler" to schedule the backup and maintenance job
instead of using SQL Server Agent.
o Documented processes in the "Altiris" Ticket System, Idera Tools,
SQLDisastro tool.
Environment:
Windows 2000 Advanced Server, Windows Server 2003 EE, MS SQL Server
2000, MS SQL Server 2005, Red Gate Tools (SQL Compare, SQL Data
Compare), Idera's SQL Diagnostic Manager (Monitoring Tool), SQL
Compliance Manger (Auditing Tool), SQL Secure (Security tool), Altiris
Ticket system, Acronis, XOSoft, FootPrints (RFC Tool),SQL Disastro
(Backup Tool), Tidal Scheduler
Infovision Technologies Inc, New Jersey
Mar 2008 - Jul 2008
SQL Server DBA/Developer
Description:
Infovision Technologies Inc. is a leading consulting company; it helps
building a solution and provides support on existing systems for their
clients. I was providing basic production support, maintaining
databases and servers.
Responsibilities:
o Installed and Configured of SQL Server 2000/2005.
o Installed SP4 for SQL Server 2000 and SP2 for SQL Server 2005.
o Created and Scheduled SSIS Packages for importing and exporting
data to data warehouse
o Backup and Restore databases in SQL 2005 for newly acquired
websites.
o Used SQL Server Management Studio (SSMS) for monitoring,
troubleshooting and deploying database related issues.
o Prepared documentation on Capacity planning of all servers and made
recommendations.
o Consolidated various databases and tables in SQL Server 2005.
o Designed and Implemented Clustering as Disaster Recovery plan.
o Migrated DTS packages to SSIS packages using ETL tool. (Business
Intelligence Development Studio)
o Used SQL Compare and SQL Data Compare for pushing changes from test
servers to production servers.
o Experienced with Database Modeling (logical and physical design)
using ERWIN.
o Extensively documented all the databases, database objects, jobs
and the changes made to the database.
o Solved issues related to server performance and disk space.
o Generated Simple Reports, Parameterized Reports using SSRS.(
Reporting Services)
o Used extended stores procedures for creating alerts for critical
production jobs.
Environment:
Windows 2000 Advanced Server, Windows Server 2003 EE, MS SQL Server
2000, Microsoft SQL Server 2005, SQL Compare, PostgreSQL, Linux,
Idera's SQL Diagnostic Manager
Priya Sharma Software Pvt Ltd., Vadodara
May 2005 - Jul 2006
Software Engineer/Quality Analyst
Description:
PSPL is providing offshore support for different clients in USA, UK,
and Australia. Company builds a solution including developing an
application, maintaining and support after production release. My role
as a Software engineer and Quality Analyst, I was testing different
applications, generating test cases and testing different production
changes into SQL server environment
Responsibilities:
o Used SQL server Application, online web portal to test different web
applications.
o Experienced in regression testing, User acceptance testing.
o Built different test cases and test scenarios.
o Executed test cases, reporting progress and issues in a timely and
accurate manner.
o Documented changes according to production versions.
o Tested production changes in SQL Server 2000 databases.
o Worked with development staff to understand new testing requirements.
o Participated in all software phases (SDLC model) from requirement
gathering to Production Launch
o Familiar with current software testing methodologies, to include risk
based boundary, black box and white box testing.
o Conducted root cause analysis of identified defects, providing
development/business partners with sufficient detail to understand,
replicate and resolve.
Environment:
Windows 2000 Advanced Server, MS SQL Server 2000, Analysis Server
2000, Visual Basic 6.0, Visual SourceSafe 6.0, Microsoft Office Excel
2000
Ultra InfoTech, Vadodara
Jan 2004 - Apr 2005
SQL server/JSP Developer
Description:
Ultra Infotech is a premier IT service provider since a decade to
clients globally. It offers unique solutions to build integrate and
manage IT systems. My responsibilities included developing a web based
portal for HOSPITALITY ADMIN project, Airlines and Cars' online
booking.
Responsibilities:
o Requirement Gathering and Analysis for Hospitality Admin project.
o Scheduled JAD Sessions to discuss requirements with different SMEs,
Database Architect to understand requirements.
o Created functional and non functional requirement documents.
o Used MS VISIO to generate the E-R diagrams, Data Flow Diagrams.
o Created the database design architecture and relationship between
entities.
o Generated the Database and Schema using SQL Server 2000 enterprise
Manager.
o Built a Web based portal using JSP/Servlet and Beans to connect to the
MSSQL server database.
o Tested the application against different test scenarios using SIT and
UAT Testing.
o Deployed the application online.
o Used T-SQL to create queries and stored procedures to produce reports
for end-users.
o Performed security configuration and administration.
o Resolved locking conflicts and resource utilization.
Environment:
Windows 2000 Advanced Server, MS SQL Server 2000, JSP, Servlet, VISIO.
PARTHIK HARISKUMAR PARIKH
SQL SERVER DBA/Developer
Email: abg3h9@r.postjobfree.com
[pic]
[pic]