Sql Server Manager
Resume:
Rohit Gupta
Database Administrator - SQL Server
acdddt@r.postjobfree.com
. 8+ Years of experience in Database Administration, Architecture,
Design, Implementation, Performance Tuning, Deployment, Development,
Capacity Planning, Scaling & Support of Mission Critical MS SQL
Servers 2008/2005/2000 in Development, Production, Test, Replication,
Cluster, QA and VLDB Environments.
. Installed, Configured, Maintained and Monitored MS SQL Server
2008/2005/2000/7.0 Versions in both mission Critical, Clustered
(Active/Passive and Active/Active), Stand-Alone and VMware
Environments.
. Implemented High Availability plans like Clustering, Log shipping &
Database Mirroring.
. Performed Upgrades & Migration from SQL Server 2000 to SQL Server
2005, SQL Server 2005 to SQL Server 2008 in both 32 bit and 64 bit and
resolved the issues.
. Designed, Implemented Data-ware Houses, Data Marts and Data Mining.
. Designed, Implemented & Tested Archiving, Database Backup, Point in
time Restores and Disaster Recovery Procedures.
. Resolved Database, Performance, Replication, Log-shipping, Database
Mirroring, Connectivity, Security, Blocking and dead locking related
Issues.
. Performed Data Modeling, Conceptual, Logical and Physical database
design.
. Implemented different types of Replication models like Snapshot, Merge
and Transactional replication and monitoring them.
. Deploying Reports using Microsoft Reporting Services (SSRS)
. Experience in Resolving Tickets, Software Development Life Cycle
(SDLC), SQL Server Memory Management, Incident Management, Change
Management, Version Control, OLTP, MS-DTC, Fixing database corruption.
. Used Tools like SQL Litespeed for backup-recovery and Spotlight for
performance tuning.
. Performed schema management, Client/Server Connectivity, Database
Rollouts, Load Testing, Load Balancing, Database consistency checks
using DBCC Utilities.
. Created Linked Servers, Maintenance Plans, Entity- Relationship
Diagrams, Perl Scripts, Power shell Scripts.
. Configured and Maintained the Report Manager and Report Server.
. Installed SQL Server 2005 Reporting Services in SharePoint integrated
Mode and had done configurations on the MOSS box.
. Created OLAP Cubes and modified the cubes using Cube Designer.
. Provided 24X7 on call Production Support to both the Applications and
SQL Servers.
CERTIFICATIONS:
Microsoft Certified Technology Specialist SQL Server 2008
Microsoft Certified IT Professional SQL Server 2008
Databases MS-SQL Server 2008/2005/2000/7.0, MS Access
Languages T-SQL, PL/SQL, C, C++, VB Script, Power shell Script, XML
SQL Server Enterprise Manager, Profiler, Query Analyzer, Export & Import,
Tools MS BI Dev Studio,SSAS, Client Network Utility, Server Network
Utility, SQLCMD, SQL Server Configuration Manager, Service
Broker, BCP, Database Engine Tuning Advisor, Replication
Monitor, Report Services Configuration tool, T-SQL Debugger,
Activity Monitor, Resource Governor, Performance Data
Collector, SQL Server Audit, Data Compression
ETL Tools DTS, SSIS
Reporting Tools SSRS, Crystal Reports, Report Marshal, Report Builder, Report
Manager
Back UP Tools Idera's SQL Safe backup, Quest's Litespeed, IBM's Tivoli
Storage Manager, Red Gates SQL Backup.
Cluster Cluster Administrator, Veritas Cluster Server
Performance Perfmon, SQL ultimate Performance Monitor, Foglight Performance
Monitor Tools Analysis, Spotlight, SQL Diagnostic Manager
Operating Windows NT 4.0/ 2000/2003/XP/2008, Linux
System
PROFESSIONAL EXPERIENCE:
db professionals June 2013 -
Present
Ashley Furniture
Rolling Meadows, IL
Lead SQL Server DBA
Responsibilities:
. Installed, configured SQL server 2008 on Active-Active Clusters and
applied service packs.
. Performed performance tuning on the databases, Instances, servers,
application and increased the Performance.
. Performed upgrades from SQL Server 2005 to SQL Server 2008 and applied
Service Packs on them.
. Monitored and troubleshoot issues that impact database, Instances,
servers, application performance, stability and overall service
delivery.
. Had set up and monitored the Active-Active clusters, database
Mirroring, Log shipping, Transactional Replication and the Resolved
the Issues related to them.
. Took the Back Ups and restored them when it is necessary and
troubleshooting the orphan users.
. Monitored the Jobs, Errors, Bottlenecks and fixed them.
. Created SSIS Packages for cleaning and Loading the Business data into
the Data-warehouse.
. Worked on SSAS Cubes issues.
. Created the Logins, Users and granted them the necessary access and
Permissions to them.
. Resolved the Tickets on SQL Server.
. Managed the Log Shipping and Transactional Replication of all
production environments
. Deploying Reports using SSRS.
. Designed and Implemented databases including schema and table layouts,
underlying disk configuration, backup process, high availability and
all other configurations.
. Created and configured the databases in support of design
specifications
. Created the linked servers, Maintenance Plans and managed them.
. Performed production review of in house written code and assisted
developers in optimization and troubleshooting
. Reviewed the client requirements and Performed the capacity Planning.
. Developed and tested the data recovery strategies and performed data
restoration.
. Monitored and troubleshoot the databases, servers, Instances on the
production, development, and test environments.
. Deployed the Databases on the Test, Production, Development Servers
. Developed, reviewed, and supported SQL code, stored procedures, Open
Query statements, triggers, etc.
. Performed production code elevations following change management
procedures
Environment: SQL Server 2008/2005/2000, Windows Server 2008/2003/2000,
SSIS, SSAS, DTS, SSRS, IIS, Query Analyzer, Litespeed, Perfmon, Spotlight.
Albany Molecular Research Institute
Albany, New York
Sr. SQL Server DBA May 2010 - February 2013
Responsibilities:
. Installed and configured SQL server 2005 in an Active-Active Clusters
and applying service packs.
. Migrated from SQL Server 2005 to SQL Server 2008 and Fixing the
Issues.
. Designed, Implemented and supported High volume Transactional
databases.
. Created, documented, tested and Implemented disaster recovery plan,
high Availability, Compressed Back-ups and Recovery strategies for all
the databases.
. Developed, Implemented and maintained Security of the databases and
Servers.
. Performed the capacity planning to find out the adequate space for the
servers and databases.
. Creating Documents on DR, Back UP and Restore, Server Access and
Database Access, Server Configuration (Hardware and software).
. Creating Clustered indexes and Non-clustered indexes as part of the
Performance tuning.
. Took Lite Speed Back Ups and restored them whenever it is necessary.
. Implemented Database Mirroring, Log shipping, Data-warehouse.
. Checking the Errors and fixing them.
. Designing and Implementing the Physical, Logical Data Models.
. Migrating DTS packages to SSIS Packages
. Optimized the design of large Databases which are TB in size
. Setting up the log shipping and Transactional Replication using Push
Subscription
. Created, scheduled and Monitored Maintenance plans, SSIS packages and
jobs.
. Performing the daily checklist on the database and server as a day to
day activity
. Performance tuning the store procedures and making them run faster.
. Monitoring the activities on databases and servers, Database Growth.
. Performed Query Optimization and tuning the Indexes.
. Traced the Bottlenecks and fixed the contention Issues, Increased the
performance of slow running applications and Databases.
. Performed Database Consistency Checks using DBCC commands.
. Fixed the Deadlocks and prevented them from occurring again.
. Monitored the Performance of the SQL Server by using Performance
Monitor, SQL Profiler, Foglight Performance Analysis and Spotlight.
. Provided 24X 7 Production support.
Environment: SQL Server 2005/2008, Windows Server 2003/2008, Enterprise
Manager, SSIS, SSAS, DTS, SSRS, IIS, Query Analyzer, Litespeed, Perfmon,
Spotlight, Idera.
GE NBCU December 2009 - April
2010
Englewood Cliff, NJ
Sr. SQL Server DBA
Responsibilities:
. Installing and configuring SQL server 2005 in an Active-Active
Clusters and on VMware and applying service packs.
. Migrating from SQL Server 2000 to SQL Server 2008, SQL Server 2005 to
SQL Server 2008 and Fixing the Issues.
. Creating Disaster Recovery Plan for the servers.
. Creating Compressed Database Back UP's and Recovery Procedures.
. Monitoring the growth of the databases and performing capacity
planning both on the databases and on the disk space.
. Setting up Transactional replication using pull subscription,
monitoring the replication and fixing the replication issues.
. Creating, Optimize, Deploy and Test SSIS packages and DTS packages as
per the business rules.
. Doing the performance tuning on the slow running queries and
optimizing the databases.
. Creating Clustered indexes and Non-clustered indexes as part of the
Performance tuning.
. Performing Index Tuning, caching and Buffer tuning.
. Set up SQL Server 2005 Reporting Services on SharePoint Integrated
mode on Microsoft Office SharePoint server 2007 and configured it.
. Creating users, assigning permissions to them and set up notifications
in SharePoint.
. Setting up Clustering and also high availability plans like Database
Mirroring.
. Performed Database Compression, Database Partitioning, Database
Encryption.
. Installed the services packs and hot fixes.
. Creating Partitioning Keys, Partitioned Schemes, Partitioned
Functions, partitioned Tables and aligned Indexes.
. Implemented various forms of Normalization, Data Models (Conceptual,
Logical and Physical) and database designs.
. Created the Implementation plans/strategies, Roll Back plan for the
changes.
. Assess the Change Impact and Implementing the Change
. Applying a structured methodology and lead change management
activities.
. Completing the Change Management assessments.
. Identify, analyze and prepare risk mitigation plans
. Driving, developing, managing and maintaining the major incident.
. Preparing the Root Cause Analysis of the problem as a part of the
Problem Management
. Creating Jobs, Maintenance Plans, Scheduling and monitoring them
through SQL Server Agent.
Environment: SQL Server 2000/2005, Windows Server 2003/2008, Enterprise
Manager, SSIS, SSAS, SSRS, Query Analyzer, Litespeed, Perfmon, Spotlight
Wipro Infotech Ltd June 2008 - December 2009
Sr. SQL Server DBA
Responsibilities:
. Installing SQL Server 2005 and updating it with the latest service
packs.
. Involved in setting up a clustered environment on windows 2003
. Migration from SQL Server 2000 to SQL Server 2005,
. Exporting and Importing of databases using Export/Import
. Creating databases, tables, views, Pivot Tables, indexes and
constraints on Very large databases like 18 TB.
. Creating and modifying clustered Indexes and non-clustered Indexes on
all the required tables and increasing the performance.
. Designing Backup/Restore Strategy and automating it.
. Performed database mirroring.
. Implemented Linked Server between Order Placement databases to admin
database for cross database transactions.
. Fine tuning the stored procedures to improve the performance of the
application
. Implemented Transactional replication between Order Placement
databases to Admin and Report databases, monitored the replication and
resolved the issues
. Assisting the Business Analysis team in developing functional and
detailed design specifications and data models.
. Troubleshoot different conflicts between two servers in Replication.
. Setting up the Schedule jobs, alerts and notifications.
. Involved in Database Architecture design for scaling databases across
multiple servers.
. Created users and logins with appropriate roles, dropping and locking
the logins, monitoring the user accounts, creation of Groups, Granting
the Privileges to Users and Groups.
. Run DBCC consistency checks, rebuild indexes, and update statistics
for databases on regular basis.
. Performed Data transfers between various servers using BCP and
DTS/SSIS.
. Implemented data models, logical and physical database designs, data
access and table maintenance codes
. Created and maintained Error Handling and data Repositories.
. Involved in troubleshooting and diagnosing database problems.
. Configured the Log shipping and created the Standby server.
. Moving and managing the schemas between different environments
. Took Back Ups using Lite Speed and Red Gate Backup tool restored them
according to the necessity.
. Managed Published Reports using Report Manager.
. Designing and documenting of SQL Server Strategies and plans for
DR, Change control management and security policies.
.
Environment: SQL Server 2000/2005, Windows Server 2003, Enterprise Manager,
SSIS,SSAS, DTS, SSRS, SSAS, IIS, Query Analyzer, Litespeed, RedGate,
Spotlight, MS-DTC.
Ramco Systems Ltd January 2006 - June
2008
SQL DBA
Responsibilities:
. Installed and configured SQL Server2000.
. Designed and developed the databases
. Actively participated in logical design of database design to meet new
product requirement.
. Wrote and modified stored procedures to implement the complex business
needs for generating new customer number, account no, increasing,
decreasing and setting credit limit as per business policies, updating
user profiles, transaction processing, generating messages with code
encryption
. Configured the DTS packages to run in periodic intervals.
. Writing stored procedures and triggers extensively and working very
closely with developers, business analyst and end users to generate
various audit reports and troubleshoot their query problems and
connectivity problems.
. Facilitated simplified access of database for end users using
denormalized views and created triggers on them to maintain to database
integrity
. Created tables, views, triggers, stored procedures and indexes.
. Created integrity rules and defaults.
. Created Cursors to facilitate the users to scroll through the Queues to
perform manual operations on the payment
. Created ftp connections, database connections for the sources and
targets.
. Maintained security and data integrity of the database.
. Used SQL Profiler to trace the slow running queries and optimized query
execution with the use of Index Tuning Wizard and Rebuild indexes if
necessary
Environment: SQL Server 2000/2005, Windows Server 2003, Enterprise
Manager, SSIS, Query Analyzer, Report Marshal
Education
Manipur University - MSCIT, 2008 - 2010
Institutes of Technology & Science - BCA, 2000 - 2003
Contact this candidate