Sql Server Manager
Resume:
PREM KUMAR
Mail: ********@*****.***
Tel No: 409-***-****
Professional Summary:
* Over 7 years of extensive experience in database design, development
and administration with MS SQL Server versions 2008/2005/2000/7.0
using SSIS, SSAS, SSRS in Finance, Banking, Retail and Healthcare
industries.
* Highly proficient in the use of T-SQL for developing complex stored
procedures, triggers, tables, user functions, user profiles,
relational database models and data integrity, SQL joins and query
writing.
* Proficient in implementing different types of disaster recovery
scenarios like Replication models like Snapshot, transactional, log
shipping and Configure Database Mirroring in Cluster Environment.
* Extensively used tools like SQL Profiler, Index Tuning Wizard, windows
Performance Monitor for monitoring and tuning MS SQL Server
performance.
* Excellent skills in database Backup, Restoration, Recovery,
Replication, Linked Servers, Database Maintenance Planning.
* Conversant with all phase of Software Development Life Cycle (SDLC)
involving Systems Analysis, Design, Development and Implementation.
* Expertise in .NET Framework 3.0, 2.0, 1.1 web based application
development using Microsoft .NET technologies including C#, ASP.NET,
VB.NET and ADO.NET.
* Well Versed in Microsoft Business Intelligence technologies like SQL
Server Integration Services (SSIS), SQL Server Reporting Services
(SSRS), and SQL Server Analysis Services (SSAS).
* Well versed in Logical and Physical Database design and development,
Normalization and Data modeling using Erwin and SQL Server Enterprise
manager.
* Experienced in Data Modeling, Multi-Dimensional Modeling and involved
in creation of Star schema and Snowflake dimensional schema using
Erwin tool.
* Excellent experience in migration of data from Excel, Flat file and
Oracle to Microsoft SQL Server.
* Created, Configured and Fine-tuning of ETL workflows designed in DTS
and MS SQL Server Integration Services (SSIS).
* Expert in using Bulk Copy Program (BCP), Data Transformation Services
(DTS) packages and SSIS (integration services) with MS SQL Server
2000/2005/2008.
* Worked in developing and modifying multi dimensional cubes using SQL
Server Analysis Services (SSAS)
* Hands on experience in implementing Key Performance Indicator (KPI)
Objects and partitions in SSAS 2005/2008.
* Efficiently handled the Creation and Deployment of SSRS Reports on the
portal for user accessibility.
* Experienced in writing Parameterized Queries for generating Tabular
reports, Formatting report layout, Sub reports using Global Variables,
Expressions, Functions, Sorting the data, defining data source and
subtotals for the reports using SSRS 2005/2008.
* Proficient in developing Drill through and Drill down reports using
Crystal Reports and SQL Server reporting Services (SSRS).
* Extensively used performance monitor/SQL profiler to solve dead
locks/long running queries.
* Efficient in up gradation and migration from SQL Server 2000 to SQL
Server 2005/2008.
* Hands on experience in Database Installation, Configuration,
Maintenance, Monitoring, Backup and Disaster Recovery procedure and
Replication.
* Quick learner and good performer both in team and independent job
environments.
Education Qualifications:
Bachelors in Computer Science.
TECHNICAL SKILLS
RDBMS MS SQL Server 7.0/2000/2005/2008,Access.
Database Tools Management Studio, Enterprise Manager, Query Analyzer, SQL
Profiler, Data Transformation Services, Upgrade Wizard,
Replication, Crystal Reports 9.0/10.
Programming SQL, TSQL, VB.NET, XML, C++, Java, VB 6.0.
Languages
ETL Tools DTS,SSIS
Tools Microsoft Office SharePoint Server 2007 (MOSS 2007),
Windows SharePoint Services 3.0 (WSS 3.0), MS Office
2000/2003, MS Excel 2000/XP/2003, MS Outlook 2000/2003,
Erwin, MS Visio.
Backup and VERITAS Net Backup, Litespeed, Spotlight, Foglight,
Monitoring Tools Redgate.
Operating systems Windows 95/98/Me/XP/NT/2000, Unix, DOS, Linux, Windows
Server 2003 /2008.
Projects Summary:
AIG, Wilmington, DE
Jul 2008- Present
MS SQL Database Administrator
Responsibilities:
* Handled the upgrading of SQL Server 2005 to 2008 and worked on
applying the Security patches and hot fixes.
* Supporting applications with SQL Server 2000 & 2005 databases across
many locations all over United States.
* Administered more than 650 servers, with 4200 databases with 24x7 on
call support.
* Planned and Successfully Implemented SQL Server 2005 on the
Production, Test and Development Servers.
* Installation and configuration of MS SQL Server 2008 on New Production
and Test Servers with latest Security updates involving Service Packs
and Security patches.
* Worked with Multi-node, Multi-Instanced, Fail Over and Fail Back
clusters hosting huge databases.
* Proficient in monitoring the database, checking error logs, resolving
the database space management issues, connectivity of the databases to
the applications and provided timely resolutions to the issues in
response to the MOM Alerting System.
* Experience in data migrating (using tools like DTS, BULK_INSERT, BCP)
between different homogeneous/heterogeneous systems and SQL Server as
a part of Data Migration and Data Maintenance.
* Documented, developed and scheduled disaster recovery processes such
as log shipping, replication and database mirroring.
* Integrated Log shipping and mirroring for high critical databases.
* Converted an existing log shipping configuration to a database
mirroring configuration and restore on the mirror.
* Worked on SQL Server Clusters Active - Passive on mission critical
financial applications.
* Used Remedy Problem Management Ticketing and Change Control System for
problem resolution.
* Create reports in Hyperion Financial Reporting or design enhancements
to Hyperion as per requirements from business users.
* Monitored the regular backup of the production databases and resolved
the backup failures ensuring a perfect database backup strategy for
the organization.
* Worked in setting up and troubleshooting log shipping ensuring no
latency.
* Handled the Configuring and troubleshooting different types of
Replication Models like Snapshot, Merge and Transactional.
* Created SSIS Packages for data import and export from SQL Server
Databases to Various other data sources like Oracle and Sybase.
* Used new features like row and page compression mechanism, Data
Compression, Backup compression and Transparent Data Encryption.
* Implemented the Warehousing for the Sales Database using SSIS and DTS
Packages.
* Extraction of data from OLTP to OLAP systems using SSIS packages and
scheduled Jobs to call the packages and Stored Procedures.
* Designed and developed various Management Reports, utilizing Dynamic
and Cascading Prompts, sub-reports, charts, parameterized reports,
conditional and dynamic reports using SSRS.
* Performed daily monitoring using Database Consistency Checks using
DBCC Utilities to ensure consistency and integrity of the databases.
* Design and implementation of database maintenance plans for various
database activities.
* Created reports to retrieve data using Stored Procedures that accept
parameters.
* Used SQL Server profiler for auditing and analyzing the events which
occurred during a particular time horizon and stored in script.
* Performed daily tasks including backup and restore by using SQL Server
2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL
Server Agent, and Database Engine Tuning Advisor.
* Involved in preparing training document for application development
and QA/UAT teams.
Software Environment: MS SQL Server 2008, SQL Server Integration services
(SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services
(SSAS), Visual Studio 2005, VSS 2005, MS Visio 11.0, Windows NT/2003,
Microsoft .NET framework 3.5.
Deloitte, Rochester, NY
Apr
2007 - Jun 2008
MS SQL Database Administrator
Responsibilities:
* Responsible for database server upgrades from SQL Server 2005 to SQL
Server 2008.
* Administered around 150 servers and about 1750 databases of which 40
servers in production and rest in non production servers.
* Maintain and monitor database backups and rotating archives of backup
files.
* Developing and implementing DBA maintenance plan.
* Successfully Installed the Service Pack 1 and Hot-fix for SQL Server
2005 in all the Development, QA and Production environments.
* Designed and supported SQL 2008 enterprise edition for the following:
database partitioning, VLDBs (maintenance, historical data and
backup/recovery strategies), historical data archival strategies and
performance tuning/troubleshooting.
* Administering the MS SQL Server 2005 by creating user logins with
appropriate roles, dropping and locking the logins, monitoring the
user accounts, creation of groups, granting the privileges to users
and groups.
* Combined Log shipping and mirroring for multiple destination databases
to achieve the benefits of database mirroring.
* Led the transition of various SQL Server functions/tasks from
version 2000/2005/2008 including log shipping setup, monitoring and
modifications.
* Setup and maintained log shipping from a database mirroring pair to
additional server to provide multiple failover sites.
* Worked on SQL Server Transactional Replication in SQL Server 2005
environment.
* Extensively used Idera SQL Diagnostic Manager, SQL Change Manger and
Red-Gate DB Compare Tools for the day to day schema migration and
comparison.
* Plan and Schedule the Online/Offline Backups, worked on planning and
implemented Disaster Recovery Site.
* Database and Log Backup, Restoration, Backup Strategies, Scheduling
Backups; backing up master & system databases and restoring them when
necessary.
* Extensive use of Veritas NetBackup Agent for MS SQL Server 2005 for
taking Differential and Transactional backup and restore with one pass
recovery.
* Responsibilities included performing DBCC Checks.
* Performing Database Administration and Management activities in a
safe, recoverable and professional manner that ensures the optimal
operation of all database environments.
* Implemented Standard Performance Log - Events and Counters on all
Production, Development and Test Servers.
* Used AppDetective Scan application for finding the vulnerabilities and
Weak passwords in SQL Server using the Penetration Tests and Auditing
on SQL Server databases.
Software Environment: MS SQL Server 2005, SSAS 2005, SSRS 2005, SSIS 2005,
T-SQL, Visual studio 2005, DTS, Data Analyzer, MS Access, Excel, SQL
Profiler, Windows XP, Erwin 4.2, VSS 2005.
Endo Pharmaceuticals, Chadds Ford, PA
Oct 2005 -Mar 2007
MS SQL Server Developer/BI Developer
Responsibilities:
* Experience of managing multiple MS SQL 2000 & 2005 RDBMS on large
systems, clusters.
* Monitored SQL Server Databases to provide a high availability service
as a SQL Server DBA.
* Updated functional specification and technical design documents.
* Created complex Stored Procedures, DTS packages, triggers, cursors,
tables, views and SQL joins and statements for applications.
* Developed T-SQL (DDL, DML) statements using dynamically generated SQL.
* Designed an OLAP system with the help of ERWIN to visualize data
structure.
* Extracted data from heterogeneous sources and transferred to OLAP
using SQL Server Integration Services (SSIS) 2005.
* Created SQL server Analysis Projects and created multi-dimensional
databases and OLAP cubes and dimensions for the analysis of sales in
specific areas using SSAS.
* Improved query performance by cube partitioning.
* Reviewed and changed the cubes in the data marts for product valuation
based on the revenue opportunities using SSAS 2005.
* Generated daily, weekly and monthly reports using SSRS 2005.
* Developed measures and dimension members using multi dimensional
expression (MDX) to meet additional needs that were calculated from
existing measures.
* Cube calculations and KPIs done by using MDX.
* Implemented the calculations to aggregate physical measures using
management studio.
* Identified and defined the scoped assignments using script commands.
* Defined Referenced relationships with the measure groups and fact
tables.
* Managed and monitored the system utilization by using the query
optimizer and checking the execution plan.
* Extensively used Profiler to identify and repair database lockups,
deadlocks, and other issues.
* Established a sound backup and recovery policies and procedures.
Software Environment: MS SQL Server 2005 Enterprise Edition, MS SSAS 2005,
MS SSRS 2005, MS SSIS 2005, DTS, T-SQL, Windows Server 2003,Erwin 4.0.
Lincoln Financial Group, Philadelphia, VA
May 2004 - Sep 2005
MS SQL Server Developer
Responsibilities:
* Created Logical and Physical data models using ERWIN data modeling
tool.
* Developed complex Stored Procedures, Functions, DTS packages,
Triggers, Cursors, Tables, Views, Indexes and other SQL joins and
statements for applications.
* Migrating of data from various sources using DTS.
* Scheduled and performed data transfers using DTS including filtering
appropriate to the data mart for data analysis.
* Compressed data files by removing empty database pages and updating
index statistics.
* Developed and edited many complex reports with Crystal Reports 9.0.
* Designed and implemented user login and security.
* Managed and monitored the system utilization by using the query
optimizer and checking the execution plan and worked in Enterprise
Manager for job scheduling and batch queries.
* Planned the complete back-up of databases for disaster recovery
scenarios.
* Reorganized database structures as needed, automated procedures at
regular intervals.
* Optimized long running Stored Procedures and Queries for effective
data retrieval.
* Involved in project planning, scheduling for database module with
project managers.
Software Environment: MS SQL Server 2000 Enterprise Edition, MS Access,
DTS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2000 Server,
ASP.NET, Erwin 4.0, Crystal Reports 9.0
Lumin Software Technologies, Hyderabad, India
Jul 2002 - Dec 2002
SQL DEVELOPER
EPMS (Enterprise Project Management System)
Responsibilities:
* Continuously interacted with users to gather the requirements,
analysis and specifications.
* Developed high level and detail design specifications.
* Did the development of web based systems.
* Designed and developed tables, stored procedures and cursors using T-
SQL.
* Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP,
DTS and Indexes.
* Created and automated regular Jobs such as Daily/Weekly Report
Generations using crystal reports.
* Managed and Monitored System Utilization.
* Performed Backup and Disaster Recovery of the systems.
* Responsibilities included the security of the servers, part of
administration duties.
* Developed complex T-SQL code for the application.
* Designed and Implemented the Stored Procedures and Triggers for
automating tasks.
Software Environment:
MS SQL Server 2000, Windows Server, Windows NT, Erwin, VSS, Crystal
reports.
Contact this candidate