Sql Server Management
Resume:
Ankit R.Shah
Honolulu, HI-96814
*************@*****.***
Profile
Extensive industry experience (4+ years) in MS SQL Server DBA,
Configuration, Installation, Management, Upgrading system Analysis with MS
SQL server 2008, 2005, 2000 in production environment. Additional
experience in SQL Business intelligence attributes to thorough
understanding of SQL framework.
Technical Summary
> Experience with SQL server 2008/2005/2000 Installation, Upgrade,
Migration, Configuration, SSIS, SSRS and Administration.
> Reliable in support and database management services for production
application
> Experience in supporting very large and highly transitive databases and
troubleshooting the performance bottle necks on different environment
(production, DEV, UAT, Test etc)
> Worked with Indexing, Statistics, Locking and Blocking on queries.
> Experience in database Backup, Recovery, and Disaster Recovery
procedures.
> Maintained Database Authentication and Authentication of database objects
creation of users, Configuring permissions and assigning Roles to Users.
> Experience with configuring database with high avaiblity techniques like
database mirroring, log shipping, Replication, Clustering
> Experience with database performance tuning, Query optimization,
client/server connectivity on network and other network issues, database
consistency checks using DBCC.
> Experience in investigating and applying necessary SQL server database
patches and installing server packs
> Experience in debugging and optimizing Triggers, Views, Functions, T- SQL
queries and stored procedures.
> Experience in using Dynamic Management Views (DMV) to improve server
performance.
> Proficient with data transformation services like SSIS, DTS, BCP and Bulk
Insert from heterogeneous.
> Good knowledge of RAID System, Capacity Planning, Data partioning,
indexing.
> Worked on 32 Bit and 63 Bit clustered and standard server environment.
> Good Experience with data warehouse development environment using SSIS,
SSRS, and SSAS.
Education
Diploma in Electronics & Communication from Technical Education Board -
Gujarat, India
Bachelor of Science - Electronics & Telecommunication from North
Maharashtra University, India
Technical Skills
Databases MS SQL Server 2000, 2005, 2008, 2008R2, MS Access.
Programming Languages TSQL, C, C++, Assembly Language.
DBA Database administration of MS SQL Server 2008R2,
2008, 2005, 2000.
Operating Windows 2008/2003/2000, XP, Vista, Win 7.
System/Servers
ETL Tools SSIS, DTS, Cognos.
Tools SSMS, SQL DB Access, Performance Monitor, SQL
Profiler, IDERA, SQL Diagnostic Manager, SCOM,
SSRS, SSAS, RML utilities, SQLIO, SQL BPA, MAP
tool Kit etc.
PROFESSIONAL EXPERIENCE
Kamehameha Schools, Honolulu, HI
March 2011 - Present.
SQL Server DBA
Responsibilities:
> Managing approximately 80 SQL Servers (2000, 2005, 2008, 2008R2) with
team of 4 DBAs.
> Monitoring and making recommendations for performance improvement in
hosted databases.
> This involved index creation, index removal, index modification, file
group modifications, code optimization and adding scheduled jobs to re-
index and update statistics in databases.
> Providing DB level support as well as SQL Server level support to the
users.
> Maintain the integrity, availability, and recoverability of all
production data systems. Planning for overall data deployment and
operational health.
> Responsible and Involved in SQL Server Performance Monitoring, Server and
Database optimization and Query tuning & used Windows Perform and various
3rd party tools to monitor SQL Server health and gauge the performance.
Used SQL Server Dynamic Management Views and functions to monitor &
optimize the performance.
> Worked with Business Analysts, Cognos Developer, SQL Developers, SSIS
Developers in Development of the Project
> Conducting Database Refresh once in every week from PROD to UAT, DEV, and
Test Environments.
> Monitoring SQL server Error logs, Disk Space growth, Clustering
Environment.
> Performed all SQL DBA functions for SQL Servers on various environments
like Production, UAT, and Development.
> Making plans to apply latest Service Packs to different versions of SQL
Server.
> Maintain the integrity, availability, and recoverability of all
production data systems. Planning for overall data deployment and
operational health.
> Worked on performance and tunning, identifying locking and blocking for
long running queries.
> Performing Backup and Restore operation from Production Server to UAT and
DEV.
> Monitoring clients' application and fixing bugs.
> Working on EDI and Promotional request to move database on production
servers.
> Working with 32bit and 64 bit clustered environment.
> Extensive ETL (Extract, Transform Load) work including SSIS subsystem to
provide daily data exports.
> Involved with the team to run different MS SQL Server tools like MAP tool
kit, SQLIO.
Best practice analyzer (BPA), RML utilities for SQL Server health check.
> Supports Production, UAT, and Development Environment.
> Monitoring all Production servers using third party tool IDERA
> Created SQL Server logins and assigning roles and Authentication models
as a part of Security.
Environment: SQL Server 2000/2005/2008/2008 R2, Microsoft Business
Intelligence, Visual Studio for SSIS, SSRS, SSAS, MS Office Access, Windows
Server 2003/2008.
Rume Corp, Farmingdale, NY
Nov 2008 - Feb 2011.
IT Technician/SQL Server DBA
Responsibilities:
> Installed SQL Enterprise Server 2005 / 2008 64 bit version on windows
2003 Servers.
> Designed and Implemented SSIS packages to load data from heterogeneous
data source.
> Performed different kind of DB backup and restore on regular basis.
> Migration of database from SQL Server 2000 to 2005 / 2008.
> Experience with implementing different type of Replication models like
snapshot and transactional.
> Developed, deployed and monitored SSIS packages including upgrading DTS
to SSIS.
> Worked and generated reports using SQL Server 2005 reporting services
(SSRS).
> Implementation of SQL logins, Roles and Authentication modes as a part of
security policies for various categories of user.
> Involved in implementation of log shipping for synchronization of
databases
> Scheduled Jobs and Alerts using SQL Server Agent.
> Designed and configured DB Mirroring in SQL Server 2005.
> Designed and implemented comprehensive Backup plan and disaster recovery
strategies implemented
> Performed and applied SQL service pack and windows service pack to
upgrade.
> Performance testing on stored procedures, indexing and Triggers.
> Involved in trouble shooting and fine tuning of database for its
performance and concurrency.
> Proficient with SSAS
> Experience in using DMV to improve Server performance.
> Responsible to check and repair various Sensormatics Antitheft IT
Equipment's
> Repaired IT based equipment Ultra Post, M4K and M2K power pack used for
Euro max and Euro Promax pedestals used as loss prevention system
> Able to check door max, digital promax pedestals with AMD 216 and AMS
9030, AMS 9040 power pack.
Environment: SQL Server 2005 / 2008, Microsoft Business Intelligence,
Visual Studio for SSIS, SSRS, SSAS, Microsoft .Net, MS Office Access,
Windows Server 2008.
DNS Software Technologies Pvt. Ltd, Pune, India
Oct 2007 - Sept 2008.
SQL Server DBA
Responsibilities:
> Involved in System Study and database Maintenance.
> Successfully installed and configure SQL Server 2005
> Migration of MS SQL Server from 2000 to 2005
> Monitored Log shipping as high arability solution.
> Configured Server memory for maximum performance and effective
utilization.
> Integrated Performance Monitor and SQL Traces to have better graphical
analysis to find system bottlenecks.
> Extensively used filtered Indexes to improve query performance and
lower storage and maintenance cost.
> Created, Modified and monitored Replication on all Production
databases.
> Designed and Implemented comprehensive Backup plans and disaster
Recovery strategies.
> Involved in Migration of DTS package to SSIS package.
> Worked and generated basic reports using SQL Server 2005 Reporting
services (SSRS).
> Created SQL Server logins and assigning roles and Authentication
models as a part of Security Policies for various categories of user
support.
> Created, Scheduled and monitored SQL Server Jobs making sure job run
successfully every night.
> Extensively worked in UAT and Production support and involved in
trouble shooting SQL Server in various level.
Environment: SQL Server 2000/2005, Windows Server 2000/2003, Microsoft
Business Intelligence Visual Studio for SSIS, SSRS, Microsoft .NET, MS
Office access.
DOT INFO TECHNOLOGIES, Pune, India
July 2006 - Sep 2007.
SQL DBA.
Responsibilities :
> Undergone through formal training for SQL Server 2000 and 2005.
> Involved in System Environment (DEV Environment) and database
Maintaining.
> Involved with team for Installation and Configuration of the MS SQL 2005.
> Involved in upgrading database MS SQL Server 2000 to 2005
> Used tools like SQL Server Management Studio, SQL Server Profiler, SQL
Server Agent and Database Engine Tuning Advisor.
> Good in high Availability database Mirroring and Merger Replication
> Conducted in performance tuning, Backup and disaster Recovery Process and
tools.
> Created logins and Maintained user permissions appropriately.
Environment : MS SQL server 2000/2005, MS Office access, MS Visual Studio,
Windows Server 2003.
Contact this candidate