Sql Server Manager
Resume:
B havishaben B. Pa rma r
SQL Server DBA
****@*******.***
SUMMARY
Around Seven years of M icrosoft SQL Server Database Administration &
D evelopment experience in SQL Server 2000/2005/2008.
Extensive experience in M igrating from SQL Server 2000 to SQL Server 2005 and SQL
Server 2005 to SQL Server 2008 .
Experience in u pgrading SQL server softwa re to new versions and applying service packs
and patches.
Knowledge in various states of System Development L ife Cycle (SDLC).
Good Experience in Designing & documenting L ogical and Physical data models.
Good Knowledge of R DB MS .
Experience in using d ata modeling tools like E r w in and Visio .
Created Security by setting up groups and then logins for each Roles or Users for
maintenance of Databases.
Successfully tested and implemented L og shipping technique used for warm backup solution for
MS SQL server 2000 and 2005 databases.
Experience in Implementing D atabase M i r ro ring in SQL server 2005.
Experience in implementing different types of R eplication models like T ransactional,
S napshot and Me rge .
Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS,
B CP and D TS utility .
Experience with D atabase Backup and Restore .
Good Knowledge of R A I D technologies for increased storage reliability .
Documented d isaster recovery plans and pa rticipated in disaster recovery .
Experience in Installation and Configuration of 2 n ode Clusters in SQL server 2005.
Experience in P erformance T uning, Query Optimization, Client/Server Connectivity,
D atabase Consistency Checks using DBCC U tilities .
1
Experience in using P erformance Monitor/Profiler to r esolve D ead Locks/Long r unning
q ueries.
Expert in working with Third party backup tools like SQL l itespeed.
Experience in using tools like SQL P rofiler, Windows Perfmon and perfo rmance counters
for Monitoring and T uning MS SQL Server Performance, I dera Diagnostic manager.
Worked with Popular monitoring solutions like Q uest Fog light, Spot lights.
Experience in providing good p roduction support for 24x7.
Hands on experience on SQL Server A nalysis Services (SSAS), Reporting Services (SSRS)
and I n tegration Services (SSIS) to manage d ata wa rehouse envi ronment.
Experienced in wri ting parameterized Queries for generating reports, formatting report layout, sub
reports using global variables, expressions and functions in SSRS 2005.
Good experience in using T icketing system software BMC .
Experience of opening a ticket with M icrosoft team for technical support to t roubleshoot an
issue.
Ability to m eet deadlines, quickly adapt to different project envi ronments and ability to
w ork wi th different team sizes across geographical locations.
APPL ICAT IO N AREAS
Configuring Database Mi r roring in SQL Server 2005 and 2008 for Disaster Recovery use.
Thorough understanding of Change Control Management using Change control tools.
Configuring and Maintaining of Transactional Replication in SQL Server 2005.
Creating and Managing Log shipping between Production servers and Disaster Recovery Servers.
Migrating SQL server 2005 to SQL Server 2008 and SQL Server 2000 to SQL Server 2005.
Installing Service packs and Hot fixes for SQL Server 2005.
Configuring Cluster Server as Active /Passive Cluster and Active/Active Cluster in SQL Server 2005
and SQL Server 2008.
Creating and Deploying SSIS (SQL Server In tegration Services) Packages in SQL Server 2005 and
SQL Server 2008.
ED UCAT ION
Bachelor of Engineering in Computer Engineering, Baroda, Gujarat, India.
CERT I F ICAT IONS
2
70-431: MS SQL Server 2005 Implementation and Maintenance.
70-443: Designing a database Server Infrastructure by using MS SQL Server 2005.
70-444: Optimizing and maintaining database Administrative Solution by using MS SQL Server
2005.
T EC H N ICAL SK I L LS
Languages C, C++, T-SQL, Java, VB .NET, VB script
RDBMS MS SQL Server 2008, 2005, 2000
Version Control Tools Visual Source Safe
Operating Systems Windows 2008/2003 enterprise server, Windows 2000 Advanced
Server, Windows NT
Other Tools SQL L itespeed, Erwin, MS Visio, Idera SQL Diagnostic Manager,
D BArtisans
Hardware Compaq/HP Proliants Servers, Dell Power Edge Servers.
Technologies RAID, SAN
PROFESSIONAL EXPER I E NCE
Mo rgan Stanley, Manhattan, NY Sept’09 –
t ill date
SQL Server DBA
Company Description:
Morgan Stanley is a global f inancial services f i rm headquartered in New York City serving a diversified
g roup of corporations, governments, financial institutions, and individuals. Morgan Stanley also
operates in 36 countries around the world, with over 600 offices and a workforce of over 60,000. T he
company reports US$779 billion as assets under its management. I t is headquartered in M idtown
M anhattan, New York City.
P roject Description:
As a SQL DBA my responsibilities includes to place a system which can help deliver better performance
and improve the current functionality of the system through appropriate maintenance plans and a
mechanism which ensures minimal downtime in case of failures. I ts main concern was to improve the
performance of i ts existing OLTP system and have a more consolidated and optimized database.
3
R esponsibilities:
I nstallation of SQL Server 2008/2005 with latest Service Packs.
Worked in Active/Passive and Active/Active C lustered Envi ronment .
Worked in both p roduction and testing environment .
Writing stored procedu res for report generation in migration process and r eplication .
Involved in m igrating SQL Server 2005 to 2008 and SQL Server 2000 to 2005 .
Involved in Parallel Testing while migrating SQL Server 2000 to 2005 .
Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that
do not have primary key.
Extensively involved in D atabase M i r ro ring .
Configured Log S hipping i n SQL Server 2005.
Wrote SSIS Packages to migrate users, logins, stored procedures, and tables
Extensively involved in replication and i mplemented Snapshot, T ransactional Replications.
Involved in M onito ring Performance of different production servers.
Worked in 24x7 p roduction envi ronment .
I m aintained t ables, indexes.
Used I dera Diagnostic Manager for Monitoring solutions
Involved in semiannual D isaster Recovery Testing d rills .
Identified f laws w ith DR strategies and offered suggestions of improvement.
Monitored SQL Logs to ensure success of schedules, jobs, and backups
Managed space database issues.
Wrote custom scripts and jobs to manage backups due to lack of disk space.
Working with the end user gathe ring requirements for the system.
Installing applications and establish the connectivity w ith the database.
Granting Pe rmissions to users.
Envi ronment: MS SQL server 2008/2005, Windows 2008/2003 Enterprise edition, SQL profiler, Idera
D iagnostic Manager, SQL Light speed Backup Software.
E DD’s U nemployment I nsurance Branch, Sacramento CA
O ct’08 – Aug’09
SQL Server DBA
Company Description:
4
T he Employment Development Department (EDD) is one of the largest state departments with
employees at hundreds of service locations throughout the state. The Unemployment Insurance
P rogram, commonly referred to as UI, provides weekly unemployment insurance payments for workers
w ho lose their job through no fault of their own.
P roject Description:
As a SQL DBA my responsibilities included upgrading to newer version of database, database
maintenance, user management, security management, performance tuning, implementing high
availability solutions, and 24x7 technical supports.
Responsibilities:
Installed and configured 2-node Cluster Configuration (Active/passive) in SQL Server2005.
Designed New I ndexes on tables and worked with developers to increase SQL server
performance.
Partitioning tables to achieve better performance for access and wri tes.
Resolving locking and blocking issues.
Reviewed and offered r ecommendations for Database system configurations, responsible for
t uning data, indexes, and queries as well as providing assistance on these areas to development
teams.
Analyze various aspects of S tored P rocedures and performed tuned as needed to increase
p roductivity and reusability of code.
Creating logins, groups, users, roles, database devices, databases, checking for database
consistency, fixing DBCC errors, monito ring er ror logs, database space allocations,
t ransaction log space allocations, fine tuning SQL performance.
Tuned the Production server to get performance improvement by using SQL P rofiler, SQL
Commands and Database Tuning Advisor.
Developed SQL Server Maintenance Plans .
Automate and enhance daily administrative tasks, i ncluding space management, object
a lteration, backup & recovery and performance monitoring.
Job Monitoring and making sure all jobs run successfully.
Creating SSIS packages for archiving data and D ata M ig ration .
Maintain Notifications, Jobs, Job Steps and Schedules.
Monitor connections, locks and pe rformance of SQL server.
Managing access cont rol of operational and developmental application system databases.
Resolving issues t hrough Performance Monitor and SQL Diagram.
5
Creating documentation for e r ror resolving f ixtures.
Envi ronment: MS SQL Server 2005, Windows 2003 Server Enterprise Edition, I IS Server 5.0, Visual
studio .NET, Dell Power Edge 8450, Red Gate Backup Pro 4, VSS 6.0, SQL Diagram.
Bank of America, Je rsey City, NJ
J an’08 – Sept’08
SQL Server DBA
Company Description:
Bank of America Corporation is a f inancial services company, the largest bank holding company i n
t he United States, by assets, and the second largest bank by market capitalization . Bank of America
serves clients in more than 150 countries and has a relationship with 99% of the U.S. Fortune
500 companies and 83% of the Fortune Global 500.
P roject Description:
As a SQL DBA my responsibilities included upgrading to newer version of database, database
maintenance, user management. T he project also involved analysis, technical design, and program
design and production implementation tasks like Software Installation, Database Performance Tuning
& M aintenance, Database Backup and Recovery, Export/Import of Data, Replication.
Responsibilities:
I nstalled SQL Server 2005 w ith latest Service Packs.
Worked in Active/Passive and Active/Active C lustered Envi ronment .
Worked in both p roduction and testing environment .
Writing stored procedu res for report generation in migration process and r eplication .
Involved in m igrating SQL Server 2000 to 2005 .
Involved in P arallel Testing while migrating SQL Server 2000 to 2005.
Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that
do not have primary key.
Extensively involved in D atabase M i r ro ring and L og Shipping .
Wrote SSIS Packages to migrate users, logins, stored procedures, and tables.
Extensively involved in replication and i mplemented Snapshot, T ransactional Replications.
Involved in M onito ring Performance of different production servers.
Creating tables, indexes.
6
Used I dera Diagnostic Manager for Monitoring solutions
Involved in semiannual D isaster Recovery Testing d rills .
I dentified flaws with D R strategies and offered suggestions of improvement.
Monitored SQL Logs to ensure success of schedules, jobs, and backups
Managed space database issues.
Wrote custom scripts and jobs to manage backups due to lack of disk space.
Working with the e nd user gathering requi rements for the system.
E nvi ronment: MS SQL Server 2000,MS SQL Server 2005, Windows 2000 Advanced server, I IS
Server 5.0, Idera Diagnostic Manager, Redgate, XML, Dual Pentium 4 HP DL 360 servers.
Townsend Analytics L td, Chicago
M a r’07 – Dec’07
SQL Server DBA
Company Description:
Townsend Analytics, L td has been a pioneer and innovator in the field of financial services since it
began its business in 1985. Townsend Analytics has developed a t remendous range of software solutions
for financial applications, including ActiveX components for web display of real-t ime quotes, r isk
analysis software, and applications for televised displays of streaming data.
P roject Description:
In this Project, my responsibilities includes to create the tools to monitor the performance of individual
statements within stored procedures and verify that queries use fast indexes rather than less-efficient
t able scans and the ability to integrate customer transaction with market data and perform complex
queries and t ransformations for the delivery of comprehensive client reports.
Responsibilities:
Responsible for MS SQL Server 2000/2005 configuration, tuning and provide 24 X 7
d edicated support to all Production, development and clustered servers.
Maintained the security, integri ty and availability of MS SQL Server 2000/2005.
M ig rated SQL Server 2000 to SQL Server 2005.
Performed d ata backup, recovery, and t ransfer operations.
7
Used SSIS to extract, transform and consolidate data from different sources into D ata
Warehouse.
Configured L og shipping f rom one production server to the reporting server.
Involved in implementing D atabase M i r ro ring i n SQL Server 2005 .
Performance Monitoring with SQL P rofiler and Windows System Monitor
Maintained O perators, Categories, Ale rts, Notifications, Jobs, Job Steps and Schedules.
Monitored Connections, locks and pe rformance of SQL Server.
Assign permission to user(s), role(s), object and Supports column level permission.
Administrate security for server’s logins (Windows and SQL Accounts).
Wrote and integrated Stored P rocedu res to generate the Reports.
Expertise in Security Issues such as c reating and granting permissions on various Objects.
Preparing the r eports for the day-to-day as well as weekly/monthly purposes.
E nvi ronment: W indows 2003 Server, Windows 2000 Advance Server, SQL Server 2000/2005.
TATA Steel, M umbai, I ndia
A ug’05 – Jan’07
SQL DBA/Developer
Company Description:
TATA Steel is Established in 1907 and is Asia's first and India's largest private sector steel company.
t he Company today is the tenth largest steel producer in the world with an employee strength of above
81,000 across five continents. TATA Steel is among the lowest cost producers of steel in the world and
one of the few select steel companies in the world that is EVA+.
P roject Description:
As a SQL Server DBA/Developer, I developed and helped to implement HRMS that is designed to
handle the human resource activities for the organization. HRMS is a web based three-tier architecture
system which provides information about employee data, new hire, applicants, promotion, demotion,
leave or absence, payroll data, and change of certain business rules required development of new
modules to the system.
R esponsibilities:
Installed and Maintained SQL Server 2005 on new servers.
8
Experience in M ig rating SQL server 2000 to SQL Server 2005.
Create new t ables, v iews, i ndexes and user defined functions.
Actively designed the database to f asten certain daily jobs and some stored procedure.
Optimized query performance by creating indexes.
Involved in Administration of the SQL Server by creating users & login ids with appropriate
roles & grant privileges to users and roles.
Involved in performance tuning of T-SQL queries and Stored Procedures.
Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL
queries and Stored Procedures.
Perform daily database b ackup & restoration and monitor the pe rformance of Database
Server.
Create j oins and sub-queries for complex queries involving multiple tables.
Developed complex stored procedures to create various reports.
Used D D L and D M L for writing t riggers, stored procedures, and data manipulation.
Worked on D TS Package, D TS I mport/Export for t ransferring data from Database (Oracle and
Text format data) to SQL Server.
Installed and Configured SQL Server 2000 on development server for designing and testing full
text search.
Use the SQL A nalyzer, and Profiler for studying the SQL statements and procedures
Access SQL Server using front end applications like . Net .
Envi ronment: MS SQL Server 2000/2005, D TS, Windows 2003 Server, SQL Profiler, Oracle9i.
H D FC Bank, Ahmedabad, I ndia
J an ‘04 - Jul ‘05
SQL DBA/Developer
Company Description :
HDFC Bank was incorporated in 1977 with the primary objective of meeting a social need – that of
p romoting home ownership by providing long-term finance to households for their housing needs.
P roject Description :
9
T he project involved analysis, technical design, program design and production implementation tasks
l ike Software Installation, Database Performance Tuning & Maintenance, Database Backup and
Recovery, Export/Import of Data, Replication.
Responsibilities:
I nstallation and configuration of SQL Server 2000 on Window 2000/NT OS.
Managing of database objects l ike Tables, views, indexes etc.
Managing of users i ncluding creation/alteration, grant of system/db roles and permission on
various database objects.
Managing Backup and restore, export and import.
Developed D TS Packages to transfer the data between SQL Server and other database and files.
Well experienced with tools like Q uery Analyzer, SQL utility.
Implementation of d ata t ransfer th rough D TS and setting guidelines to automate recovery
scenarios.
Creation and management of D atabase maintenance plan for various database consistency
checks.
Used SQL P rofiler to monitor the server performance, debug T-SQL and slow running
queries.
Automation and execution of d ata t ransformation scripts.
Developed T ransact-SQL scripts to enforce business rules.
Envi ronment : MS SQL Server 2000, Windows NT, Windows 2000 Server, MS Access, DTS.
10
Contact this candidate