[pic][pic]

PREMKUMAR SUBRAMANI

Microsoft Certified SQL Server DBA

PROFESSIONAL SUMMARY

. Microsoft certified professional with nearly 8 years of IT Expertise,

that focuses on Design, Development and Administration of very large and

Complex DBs, over 8TBs on all versions of SQL Server 2012 through 2005,

Business Intelligence Tools 2012 through 2005 (Integration and Reporting

services).

. Expert in creation and maintenance of writing T-SQL Queries, Dynamic-

queries, sub-queries and complex joins for generating Complex Stored

Procedures, Triggers, User-defined Functions, Views and Cursors

. Experience in Creating, Configuring and deploying various applications

using SSRS and SSIS packages in Test and Production environments

. Experience in building and deploying cubes by using SSAS

. Expertise in Monitoring and Optimizing the Performance of Database using

DTA (Database Tuning Advisor) and ITA (Index Tuning Advisor)

. Expertise in planning and implementing Database Security by creating

users, Roles, and assigning permissions to them

. Extensive experience with backup and restore procedures using native and

third party backup tools

. Configured and designed database backup plan (custom scripts, IDERA SQL

Safe, REDGATE SQL Backup Pro)

. Having good knowledge on SQL Server Migration Assistant(SSMA)

. Experience in MS Build Deployments

. Expertise in Database Design, Administration, Implementation, and

Application Development of very large and complex DBs, over 8 TBs size

. Plan, design, and implement application database code objects, such as

stored procedures, functions and views.

. Build and maintain SQL scripts, indexes, and complex queries for data

analysis and extraction.

. Extensive experience in Installation, Configuration, database migrations

and Upgrading of SQL Server2000 to SQL Server 2005/ 2008 and R2

. Experienced in Design, Development, Testing, and implementation of System

Development Life Cycle (SDLC)

. Experience in performing backups using Avamar tool.

. Expertise in server performance tuning, database tuning, support and

maintenance

. In-depth understanding in Client Requirement Analysis, Physical and

Logical Design

. Extensive experience with High availability and Disaster Recovery

solutions include Microsoft Failover Clustering, Database Mirroring and

SQL server Log Shipping, Replication

TECHNICAL SKILLS:

Database: SQL Server 2012/2008R2/2008/2005, Business Intelligence

2012/2008R2/2008/2005, MOSS 2007

SQL Server Tools: SQL Server Management Studio, SQL Server

Configuration Manager, SQL Server Query Analyzer, SQL

Server Error Reporting, Business Intelligence Development

Studio, Database Engine Tuning Advisor, SQL Server

Profiler, Activity Monitor

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting

Services (SSRS), Data Transformation Services

Languages: SQL, T-SQL, PL/SQL, C#, VB.Net

Operating Systems: Windows Server 2008R2/2008/2003/2000/XP, Red Hat

Linux, UNIX

Software Tools: Spot Light, Red Gate, SQL Loader, ROUNDHOUSE, Team

Foundation Server (TFS)

CERTIFICATIONS & EDUCATION:

. Microsoft Certified Professional (MCP) - Transition your MCTS on SQL

Server 2008 to MCSA: SQL Server 2012.

. Microsoft Certified Technology Specialist (MCTS) - Microsoft SQL Server

2008, Database Development.

. Microsoft Certified Technology Specialist (MCTS) - Microsoft SQL Server

2008, Implementation and Maintenance.

. Bachelor's Degree in Information Technology from Anna University,

Chennai.

. Diploma in Information Technology from SAP College.

PROFESSIONAL EXPERIENCE:

ADP, Inc., Rose land, NJ Nov 2013-Till

Date

Sr. SQL Server DBA

Project: IHCM

iHCM provides you a way to easily manage your entire global workforce using

a single, comprehensive set of fully integrated human capital management

services. iHCM is a multi-country payroll solution offering, designed for

organizations across the globe. iHCM is a unique web based service

alternative offering variable levels of payroll service. iHCM is a fully

managed payroll service, suitable for businesses with over 1000 employees,

where ADP experts manage end to end payroll administration and processing

on your behalf.

Responsibilities:

. Involved in designing, developing and deploying reports in MS SQL Server

environment using SSRS-2008 and SSIS in Business Intelligence Development

Studio (BIDS).

. Writing T-SQL Queries, sub-queries and complex joins for generating

Complex Stored Procedures, Triggers, User-defined Functions, Views and

Cursors.

. Experience in using recursive CTEs, temp tables and effective DDL/DML

Triggers to facilitate efficient data manipulation and data consistency

as well as to support the existing applications.

. Involved in creating multiple parameterized stored procedures which were

used by the reports to get the data.

. Write T-SQL statements for retrieval of data and also involved in

performance tuning of TSQL queries and Stored Procedures.

. Optimized query performance by creating indexes.

. Used query execution plan to optimize the stored procedures to reduce the

cost.

. Day to day activities including monitoring the jobs and resolving the

issues occurred in the job.

. Installing SQL Server 2012 on Standalone Servers and updating service

packs on Prod, Dev and Test Environments.

. Configuring servers according to company standards.

. Implemented DR plans using Full, Differential and T-Log Backups.

. Planning High Availability Techniques like Replication and Database

Mirroring.

. Setting up maintenance plans and SQL Server jobs for backups, database

integrity checks, history cleanups and index rebuilds.

. Documenting all installation procedures for all servers for future

reference.

. Planning and implementing migrations to move DBs from Old SQL Versions

(2005\2000) to New SQL versions (2012\2008 R2).

. Managing multiple instances and databases on different environments.

. Creating SSRS Reports for Job failures and disk space statistics.

. Refresh Dev and Test environment data on a regular basis and fixing

logins.

. Run DBCC check commands on regular basis for Server maintenance.

. Configuring alerts to ensure there are no failures on all servers and fix

issues in case of alerts.

. Implementing database security policies for creating and maintaining

users, groups and their roles.

. Database and Server tuning and performance tuning by implementing

suitable optimizations, appropriate indexes and keys and work on capacity

planning.

. Register and manage Central Management Servers Generate monthly report

for list of all SQL Instances and databases.

. Monitor Footprints queue and resolve tickets as part of a team and

provide 24*7 on-call support when required.

Environment: MSSQL server 2008/2008R2/2012,Windows2003/2008,Team Foundation

Server(TFS) 2010, Visual SourceSafe, VB.Net, Query Analyzer, DTS, SQL

profiler, VM Ware 5.0, Virtual PC 6.0.

ADP, Inc., Rose land, NJ Jan 2012-Oct 2013

SQL Server DBA Project: RUN

Powered by ADP

RUN Powered by ADP (RUN) is a proven small business payroll solution

includes Mobile payroll, integration and flexibility. RUN is also fully

integrated with other available ADP small business services, including

certain retirement plans, time and attendance solutions, workers'

compensation premium payment plans and human resource tools.

Responsibilities:

. Write T-SQL statements for retrieval of data and Involved in performance

tuning of TSQL queries and Stored Procedures.

. Creating joins and sub-queries for complex queries involving multiple

tables.

. Using DDL and DML for writing triggers, stored procedures, and data

manipulation.

. Created Clustered Indexes and Non-Clustered Indexes to increase the

performance of database.

. Created several SSIS Packages to pull data from SQL server and Flat files

into Excel sheet and to archive the data as per the business logic.

. Extensively used SSIS transformations such as Lookup, Derived column,

Data conversion, Aggregate, Conditional split, SQL task, Merge and Send

Mail task etc.

. Created various SSIS packages which would load raw physical data in to

the tables of the databases.

. Created SSIS Packages using SSIS Designer for export heterogeneous data

from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server

2005/2008.

. Installed SQL Server 2008 R2\2008 on Failover Clusters and Standalone

Servers and adding additional features whenever required and updating

service packs on Prod, Dev and Test Environments.

. Documented all changes for the SDLC and notes for various issues for

future references.

. Configured servers according to Business Applications and set up

maintenance plans and SQL Server jobs like full daily backups, history

cleanups and index rebuilds.

. Plan and implement migrations to move DBs from Old SQL Versions

(2005\2000) to New SQL versions (2008 R2\2008).

. Plan, design and implement application database code objects (Tables,

Views, Stored Procedures, Triggers, Cursors, etc.) for applications.

. Planned and set up high availability and Disaster Recovery procedures

(Clustering, Replication, Mirroring and Log Shipping) based on

requirement.

. Used Avamar to perform daily full backups for various environments such

as DEV,QA and Production environments.

. Managed multiple instances and VLDBs on different environments.

. Managed and monitored databases and instances for all applications.

. Deploying SSIS Packages and SSRS Reports from Test to Production.

. Configured alerts to ensure there are no failures and fix issues in case

of alerts.

. Implemented database security policies for creating and maintaining

users, groups and their roles.

. Run DBCC check commands on regular basis for Server maintenance.

. Work with SSIS and SSRS for package verification and deployments.

. Tuned Databases and Server performance.

. Monitored DB Support queue and troubleshooting tickets.

. Created system for table synonyms, capturing, reporting and correcting

error data.

. Worked as part of a team and provide 24*7 on-call support when required.

Environment: MS SQL server 2008/2008R2/2012,SSIS,SSRS, Windows

2003/2008,Team Foundation Server(TFS)2010,Avamar, Visual SourceSafe 6.0,

SQL profiler, VM Ware 5.0.

Business Management Software, Peterborough, U.K Nov

2010-Dec 2011

SQL Server DBA Project: Freedom

UK Classic

Freedom UK Classic is an end to end payroll service which encompasses pay

slip admin, data inputting, checking and BACs transfers. ADP experts will

also liaise with HMRC at tax year end on your behalf. This alternative is

ideal for companies of 100+ employees. Employees can access the self-

service option to add personal details, view e-pay slips or make holiday

requests, whilst managers are able to approve requests, generate reports

and manage performance.

Responsibilities:

. Involved in designing databases, developed various schemas such as

creating tables, Views, Stored Procedures, Indexes in DEV, Test

environments.

. Involved in performance tuning of TSQL queries and Stored Procedures.

. Optimized query performance by creating indexes.

. Experience in Writing T-SQL Queries, CTEs, temp tables, joins for

generating Complex Stored Procedures, Triggers, User-defined Functions,

Views and Cursors.

. Schema & Data comparison between various environments will be done

regularly using Red gate tool to make sure the schemas are identical.

. Installing SQL Server 2012/2008 R2 on Failover Clusters and Standalone

Servers and adding additional features whenever required and updating

service packs on Prod, Dev and Test Environments.

. Configuring servers according to company standards and installing SSL

certificates.

. Setting up maintenance plans and SQL Server jobs like full daily backups,

hourly Transactional Log backups, database integrity checks, history

cleanups and index rebuilds.

. Documenting all installation procedures for all servers for future

reference.

. Planning and implementing migrations to move DBs from Old SQL Versions

(2005\2000) to New SQL versions (2012\2008 R2\2008).

. Designing Relational Databases as per client requirement and their input

data flow.

. Plan and implement application database code objects (Tables, Views,

Stored Procedures, Triggers, Cursors, etc.) for applications.

. Managing multiple instances and databases ranging from 1GB to 4TB on

different environments.

. Planning and setting up high availability and Disaster Recovery

procedures (Clustering, Replication, Mirroring and Log Shipping) based on

requirement.

. Deploying SSIS Packages and SSRS Reports from Test to Production.

. Refresh Dev and Test environment data on a regular basis and fixing

logins.

. Managing Clustered environments and Failing over cluster nodes when

required.

. Run DBCC check commands on regular basis for Server maintenance.

. Configuring alerts to ensure there are no failures on all servers and fix

issues in case of alerts.

. Implementing database security policies for creating and maintaining

users, groups and their roles.

. Database and Server tuning and performance tuning by implementing

suitable optimizations, appropriate indexes and keys and work on capacity

planning.

. Register and manage Central Management Servers Generate monthly report

for list of all SQL Instances and databases.

. Involved in Administration of SharePoint Services.

. Monitor Remedy SQL DBA queue and resolve tickets as part of a team and

provide 24*7 on-call support when required.

Environment: MS SQL server 2008/2008R2, Windows 2003/2008,Team Foundation

Server(TFS) 2010, Visual Sourcesafe, VB.Net, Query Analyzer, DTS, SQL

profiler, VM Ware 5.0, Virtual PC 6.0.

MICROSOFT, INDIA Jan 2008-Oct 2010

SQL Server DBA Project: Bing

This project deals with providing better user experience to all Bing users

(http://www.bing.com). Instant Answers is a feature which gives the

important information to the user in the same page. In this way, user need

not navigate to other pages to know the information.' Cards' is a feature

which is a group of related instant answers making into a single entity.

Responsibilities:

. Installed SQL Server 2008 and Replication and applied Service Packs on

different environments.

. Implemented various SSIS Tasks and Data Flow Transformations to build

packages and implemented Package Configurations and deployed Packages on

different environments.

. Planned Disaster Recovery and implemented Tasks like backup/restore.

. Planned High availability for Production environment and implemented cost

effective techniques (Replication, Log Shipping, Database Mirroring and

Clustering) as per client requirement.

. Created Maintenance Plans, Scheduling jobs, alerts and notifications with

SQL agent and configuring Linked servers for data access between

different servers.

. Tuned databases and queries for better performance.

. Implemented Data Archival techniques periodically to ensure database is

not growing constantly.

. Involved in Administration of SharePoint Services.

. Managed Internal SharePoint Site for Reports, Calendars, Lists, Tasks,

etc.

. Gathered Client requirement, analyzed all stages of SDLC and documented

project and coding specifications and planned deliverable schedule.

. Responsible for all database architecture including planning and design

of Relational Data Warehouse.

. Implemented application database code objects for applications (database

diagrams, tables, views, joins, stored procedures, triggers, functions,

temp tables and table variables).

. Managed Multiple SQL Servers, from 1 TB to 4TB in the data warehouse.

. Migrated databases and transferred jobs, logins and objects from Old to

New Servers.

. Monitored Quality Center for defects and bug-fixes and managing Onsite

and Offshore teams and providing 24*7 call support for the Critical

issues.

Environment: MS SQL server 2005, TableDiff, Business Intelligence

Development Studio, Windows 2003/2008, VB.Net, SQL profiler, Microsoft

Virtual PC 5.0.

MICROSOFT, INDIA Jun 2007-Dec 2007

SQL DBA Project: Windows Live OneCare

Windows Live OneCare is a comprehensive and consumer subscription service

that provides automated protection, maintenance and performance tuning for

Windows-based PCs. OneCare includes anti-virus and anti-spy ware

protection, a two-way firewall, backup and restore, tasks that do routine

maintenance of your PC such as disk cleanup and de fragmentation and also

tools to improve boot-time performance. One of the critical features of

OneCare is the backup and restore feature. This feature provides automated

backup of files by category, along with the option to back up all files on

the system or only those that have changed since the last time the action

was performed. If files are accidentally deleted or corrupted on the PC

hard drive, the service is designed to restore saved versions or map them

on a new PC.

Responsibilities:

. Installed SQL Server 2008, Replication and Clustering on all nodes and

applied Service Packs on different environments.

. Documented all stages of software development life cycle (SDLC) for the

project.

. Implemented Backups, Restore, Replication and Clustering to ensure higher

availability.

. Developed reports (Standard Tabular type reports, including Drill Down

and Drill through Functionality and Graphical presentations such as

Charts and Dashboard type metrics).

. Scheduled jobs, created alerts and notifications with SQL agent and

configured Linked servers.

. Administered servers by managing active directory, create and drop user

logins with appropriate roles, monitoring user accounts and groups.

Environnent: MS SQL server 2005, Windows 2003, SQL profile.

[pic]

Contact this candidate