PRAVIN

Email: - acc99i@r.postjobfree.com

Summary

? Over 8 plus years of IT experience with exceptional skills in all phase of SDLC, which includes Requirement gathering, Analysis, Database Design, Development, Administration and Support of Microsoft SQL Server 2000/2005/2008 R2/2012 in Development, Test and Production Environments with various business domains like Financial, Education and Healthcare

? Extensive working experience in VLDBS Administration, RDBMS database design and development, SQL Scripting for both DDL and DML, High Availability, Backup & Recovery model, Cluster management, Replication, Performance Tuning, Mirroring, Database security, User management, T-SQL Query Tuning, Reporting Services (SSRS), Integration services (SSIS), Analysis Services (SSAS) in SQL Server 2000/2005/2008 R2/2012

? Strong knowledge of T-SQL queries, DMVs, DML and DML statements, complex stored procedures, user defined functions (UDF), Database triggers, Views and Constrains and DBCC Commands

? Creation and scheduling of Maintenance plans (database and log backups and cleanups), Index management, DTS to SSIS package conversions and Microsoft System Center Operations Manager (SCOM)

? Table creation and performed data imports and restores for successful migration. Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights

? Experience in Database build, Migration and upgrade from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012 and SQL Azure

? Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Testing and Documentation of various phases in a project life cycle of Client/Server Applications

? Developed & supported various mission Critical Client Server applications by handling Database requests for various application development teams involving complex business logic, functionality

? Experience in RDBMS Designing, Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs

? Good experience with implementing DR solution, Hot backup and Cold backup, High Availability of database servers using Database mirroring, replications and Log Shipping

? Implemented & managed database clustering for high availability, failover and load balance technologies, Capacity planning, Disk management using SAN as per client requirement

? Worked well independently as well as in team-oriented environments

? Excellent verbal, written communication and presentation skills, conflict resolution skills and team player

? Developed, tested & implemented a robust database backup and recovery strategy and table partitioning with client assistance

? Involved in optimizing code and improving efficiency in databases using re-indexing, index de-fragmentation, updating statistics, recompiling stored procedures, SQL Profiler, Tuning adviser and performing other maintenance tasks

? Experience in Diagnosing and Troubleshooting performance issues in SQL Server Databases

? Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance

? Test & Deploy code across various SDLC Environments like DEV, TEST, UAT, and Production

? Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2000/2005/2008 R2/2012)

? Extensive knowledge of Designing, Developing, Atomization and deploying various kinds of reports using SSRS using relational and multidimensional data

? Experienced administrator for development and maintenance of database

? Expertise in creating Report Models for building Ad hoc reports using SSRS

? Expertise in creating Parameterized, Cascaded, Link server, Drill-through and Drill-down reports

? Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems

? Strong on tools such as Erwin Data Modeler used for logical and physical data modeling and have full understanding of the Software Development Life Cycle (SDLC)

Technical Specification

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, SQL Azure, My SQL, Oracle, DB2

Languages: T-SQL, ANSI SQL, PL/SQL, DOTNET, C, C++, Java

SQL Server Tools: Business Intelligence Development Studio (BI), SSMS, Query Analyzer, SQL Profiler, DTS, Server Network Utility, Database Tuning Wizard, Microsoft Clustering Services (MSCS), Database engine tuning Advisor

Other Tools: Net backup, VMWare, Jupiter network, Lotus Notes, Remedy ticketing tool, HP Service Manager ticketing tool (SM7, SM9), VB.Net, Erwin 4.0, IIS, RedGate, Idera

Operating Systems: Windows XP/Vista/7, Windows Server 2000/2003/2008/R2/2012, Linux

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard

Version Control: Team Foundation Server (TFS), Visual Source Safe (VSS)

Professional Experience

PricewaterhouseCoopers- Tampa, FL Nov 2012 to Till Date

Project : BPM 8.0

Platform : Microsoft XP/Vista/Seven and Windows server 2008/20012

Software : SQL Server2008/R2/2012

Role : Lead Database Administrator / Developer

Team size : 12

BPM is a discipline to optimize processes, manage & monitor process performance using specially designed IT applications. BPMS provides an environment where business users can change processes in the system based on ?pre-built? components without the need for ?hard coding?. BPMS vendors differ significantly. Therefore BPMS implementation requires a solid pre-assessment of what the system is supposed to do before choosing the vendor.

Responsibilities:

? Installing and maintaining SQL Server database systems and provide 24 * 7 production support

? Handling the tickets for the production servers using HP Service manage and adhering SLA?s.

? Maintaining RDBMS includes but is not limited to ensuring successful backups, resolving system issues, DR solutions, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, Performance Tuning on VLDBS, etc

? Designed and Implemented Tables, Functions, Stored Procedures and Triggers in SQL Server 2008

? Wrote the SQL queries, Stored Procedures and Views

? Worked on Integrity, blocking, Locking and Deadlocking related Security Issues

? Develop scripts to automate administration and management

? Built data connection to the database using MS SQL Server

? Regression testing was performed after each new build of the application

? Responsible for the contribution to the smooth running of a business, leading a team in a positive manner by providing best solutions of technical and functional problems

? Coordinating with the Systems Administration team, install and maintain application software and system that integrate database systems

? Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard with fully atomization

? Design, document, and promote security "best practices", policies, standards and protocols

? Working with development and systems teams to perform application and database tuning

? Migrating Databases from SQL Server 2008 to SQL Server 20012

? Setup, test and maintain business continuity/disaster recovery infrastructure database and applications

? Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc

? Responsible to Monitor and troubleshooting Log Shipping

? Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used

iGATE ? Bloomington, IL Oct 2010 to Oct 2012

Project : Progresso

Platform : Microsoft XP/Vista/Seven

Software : MS-BI Studio 2005/ MS-BI Studio 2008, SQL Server2008/R2

Role : Senior DBA

Team size : 30

Progresso is the replacement of the existing Facility Services. Progresso will empower school leaders, teachers and administrators, by allowing data to be easily collected, stored and shared thus providing quality information to guide their decision making. The Progresso is completely built using C# Asp.net MVC framework with the help of JQuery and Entity Framework. Present Facility users can also migrate on Progresso as it provides the functionality that supports the existing database migration using SSIS Packages.

Responsibilities:

? Extensively utilized SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing application

? Implementing and updating Full backup and transactional log backup schedules

? Reconfiguration of databases as per testers request

? Responsible to improve the Server performance and SQL server optimization on VLDBS

? Administered the SQL Server security and assigned permission to developers and testers

? Extensively worked on RDBMS set up, DDL and DML statement, T-SQL, stored procedure and DBCC commands

? Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations to transfer the data from Facility to Progresso using SSIS

? Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.

? Actively involved Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio

? Created Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views, Joins and other T-SQL code for applications following SQL code standards

? Performance Tuning for Existing T-SQL code to retrieve the data faster

? Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing

? Performed unit and system testing, troubleshooting and bug fixing in development and QA environments

? Responsible for developing, monitoring and deploying T-SQL Code and SSIS packages in production

? Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services

? Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security

IBM- Arlington, VA Sep 2009 to Sep 2010

Project : IR Solutions

Platform : Microsoft XP/2007 and Windows server 2008

Software : SQL Server 2005/2008/2012

Role : Database Administrator

Team size : 8

IR Solutions is the premier provider of breaking news, financial data and expert analysis on business sectors critical to the global economy: Banking, Insurance, Financial Services, Real Estate, Energy, Media & Communications and Metals & Mining. This service provides investment professionals, from leading Wall Street institutions to top corporate management, with access to an in-depth electronic database, available online and updated 24/7.

Responsibilities:

? Maintained transactional, snapshot and merge replications

? Configured Transactional Replication and Log Shipping with SQL Server Management Studio and monitor it on live environment and troubleshoot errors within timeline

? Responsible for create/maintain well optimized queries, stored procedures, views and triggers

? Database tuning and performance monitoring

? Installed and maintained multiple instances of SQL Servers

? Experienced in troubleshooting production servers and fixed the user and application issues

? Configured the database maintenance plans for database optimization

? Responsible to improve the Server performance and SQL server optimization

? Involved in create the Backup and restore strategy for production and other development environments

? Helped the developers to tune the SQL Queries and maintaining RDBMS.

? Implemented disaster recovery solution at the remote site for the production databases using Log Shipping

? Setup full backup and incremental backup and restoration jobs for development and QA environments

? Involved in Database design and implementation of relational database

? Plans and implements backup and recovery of the databases

? Responsible for technical documentation, user documentation and requirements specifications. Developed flow diagrams, documented the high level and user level documentation, developed user guides

? Participated in requirements gathering and design sessions based on business processes, requirements and system designs

? Developed Requirement specifications and process diagrams including context, dataflow diagrams in MS-Word and MS-VISIO

? UML was used for Visual modeling and a detailed Use Case Specification was developed to describe the design, architecture and dynamic behavior of the system

? Use Case analysis using UML and RUP was done to meet the changing Customer Requirements and complexity of the project

? Writing the stored procedures, checking the code for efficiency. Routine backups and restoration

? Analyzed requirement document by identifying ambiguous, incomplete and incorrect requirements

? Improved the performance of the existing databases by optimization and tuning using SQL Profiler

Accenture ? Austin, TX Sep 2008 to Aug 2009

Project : The BEAST (Live Trading system)

Platform : Microsoft XP

Software : MS Visual Studio 2005, SQL Server2005

Role : Sr. DBA / Technical Analyst

The BEAST is a robust, reliable and proven technology for brokering and trading of various asset classes for multiple currencies. This technology was initially developed at a major global inter dealer broker. The BEAST technology is known in the industry for real time market data and analytics for Over the Counter (OTC) derivatives. It is also a comprehensive trading platform for equities.

Responsibilities:

? Responsible for MS SQL Server Installation and configuring Microsoft SQL Server, apply service packs and hot fix

? Setting up SQL Server and database configuration parameters for optimum performance

? Provided 24*7 dedicated SQL Server support for 80 servers out of which 20 servers were production servers

? Configuring SQL Server clients and support for test and development servers

? Created regular backups of databases and transaction logs. Created the backup and restore strategy for all three environments like production, test and development servers

? Developed the plan for testing a backup and disaster recovery plan

? Installed SQL Clustering for 3-production environment.

? Develop different types of customer invoice Matrix and Tabular reports like Monthly Invoice, Yearly Invoice, Group wise etc as per client requirements using SQL Server 2005 Reporting services (SSRS)

? Configure and maintain auto email system using SSRS as per client requirement

? Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2008

? Created various SSIS/DTS Packages as per business requirements. Modified existing packages to incorporate changes and to improve performance tuning

? Database Developer for Development, Test and Production servers with MS SQL Server 2008 on Windows XP/Vista

? Data migration is done by cleansing the data

? Involved in Querying (SQL queries) and updating records and validate Database records as expected

? Working extensively on the data warehouse and analyzing for cleansing the data

? Used Performance Point Server to provide users with rich dashboard filters to dynamically filter all the report views displayed on the dashboard

? Set naming conventions for objects based on SQL standards

? Proactively identifying and resolving application performance issues

? Communicating with both technical and non-technical staff to support analysis, design, testing, and troubleshooting of project issues

Infosys ? INDIA Jan 2006 to Aug 2008

Project : Reliance Fibres Inventory System

Platform : Microsoft XP/Vista/Seven

Software : Microsoft C# .NET 2005, SQL Server 2005/2008/R2

Role : Database Architecture

Reliance Fibres Ltd is an International company that sources all grades of Recovered paper for the paper manufacturing industry. This company is based in UK and with sourcing operations in USA & Europe. Reliance Fibres Inventory system is web based application to register new customer, take new orders from customers, create purchase order, track shipping and generate reports in different format at the end of each transaction.

Responsibilities:

? Involved in gathering user requirements, application design, and analysis of hardware requirements to meet business needs

? Responsible for technical documentation, user documentation and requirements specifications. Developed flow diagrams, design RDBMS structure, documented the high level and user level documentation, developed user guides

? Developed various T-SQL stored procedures/functions for the Application

? Participated in requirements gathering and design sessions based on business processes, requirements and system designs

? Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler

? Interacted with the users and troubleshooting the problems involved with the development of stored

? Developed Database Backup Scripts and automated this process

? Developed Requirement specifications and process diagrams including context, dataflow diagrams in MS-Word and MS-VISIO

? UML was used for Visual modeling and a detailed Use Case Specification was developed to describe the design, architecture and dynamic behavior of the system

? Responsible for monitor development servers activity, scheduled jobs and space usage

? Configuring and auditing SQL Server security. Managing SQL Server logins and user accounts and passwords. Managing database object permissions

? Performed database consistency checks using DBCC commands and performed Backup recovery schedules, Backup scripts

? Responsible for General Database Administration and Performance tuning including resolving deadlock and blocking issues for concurrent users

? Monitored data availability for faster query response by user

? Validated incoming data before loading into the SQL Server using SSIS tools

? Utilized tools such as SQL Server Profiler and Activity Monitor to ensure maximum performance

Implemented database mirroring and replication

? Implemented email alerts for errors or warning for scheduled jobs using SQL Agents

Contact this candidate