Manvendra Singh

ab0g5o@r.postjobfree.com

Mobile: +91-903*******

* *******

Around 3+ years of IT experience in SQL Database

Administration/Development, I've developed a strong, working understanding

of both the physical and logical Architecture of SQL Server Database

Management, relative to advanced Troubleshooting methods & system

management

Strong experience with common projects include

Experience with HA/DR SAN Production environment - AlwaysOn, Mirrored

Cluster, Log Shipping & Replication.

Database upgrades, patching & configured sector alignment for storage

systems.

Installation of MSSQL 2005, 2008 and 2012

Designed data Partitioning solutions for tables and indexes & Risk

monitoring & control.

Proficient using DMVs, Wait-States & Performance Monitor Counters to

quickly find the Root Cause of performance slow-downs.

Expertise in Database Administration on Production Servers with server

configuration, performance tuning and maintenance with outstanding

troubleshooting capabilities.

Expertise in T-SQL writing stored procedures, triggers and functions.

Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.

Implemented the new SQL Server 2012 mechanisms like data compressions,

online indexing, Contained Databases, security principals and AAG

Worked on logical and physical data base modeling with UML and ERWIN tools

Proficiency and expertise in SQL Server Replication, Backup/Recovery,

Disaster recovery and planning.

Troubleshoot performance problems, fine-tuning of databases and index

Analysis.

Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.

Having Experience on Data center servers and handling 1.4 TB databases.

Experience in Batch processes, Import, Export, Backup, Database Monitoring

tools and Application support.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also

created DTS package for data transfer between the two environments.

24 X 7 Production Database on Call Support.

1 Technical Education

B.Tech. Computer Science Engineering- UPTU, Lucknow

Additional Qualification:

IBM Mainframe Certification.

NewHorizon Certified Network Admin.

TECHNICAL SKILLS

Operating Systems: Windows 2000/2003 Server, Windows 95/98/XP/NT

Databases: MS SQL Server 7.0/2000/2005, Oracle8/9i

Languages: T-SQL, PL/SQL, C, C++, and Cobol

SQL Server Tools: Management Studio, Business Intelligence Development

Studio, Visual Studio 2005,Enterprise Manager, Query

Analyzer, Profiler, Performance Monitor, OSQL, DTS, Log

Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning

Wizard, MSCS

Report Tools: MS Reporting Services, SAS

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader,

Import/Export Wizard

Database Modeling & Other Tools: ERWIN 4.x, Quest Litespeed, Redgate SQL

Compare, SQL Trace

Employment History

2010 (April) - Till Date. Indus Business Systems Pvt.

Ltd.,Hyderabad(A.P.)

PROFESSIONAL EXPERIENCE

Project Name: eProtocol

Client: US Universities like Stanford University,Harvard, University Of

Calofornia at Berkeley,

University of Massachussetts, Abbott Laboratories,Yale University,

Allina Health System,

McLaren Health Care Corporation and Many Research Organizations

Duration: April 2010- Till Date

Role: DBA

Environment: SQL Server 2005, SQL Server 2008, SQL Server 2012, Windows

2000/2003 Servers,

T-SQL, Oracle PL/SQL, Quest, ERwin 7.3, Redgate

Responsibility:

Responsible for Database support, troubleshooting, planning and migration.

Resource planning and coordination for application migrations with project

managers, application and web app teams. Project involved guidance and

adherence to standardized procedures for planned data center consolidation

for worldwide centers using in-house corporate and third party applications

based on SQL 2005 in upgrade project to SQL 2008 and SQL 2012.

Monitoring of database size and disk space in Production, Staging &

Development environments

Conducted various meetings and conferences with application teams to meet

corporate milestones for database consolidation and data migration.

Security and architectural planning issues met as well as testing and

training.

Configured Mirroring,Transactional Replication and Log Shipping with SQL

Server Management Studio as well as basic account management and

troubleshooting with connectivity, security and firewall issues.

Conducted Performance Tuning using SQL Profiler and Windows Performance

Monitor.

Configured Database mail, linked servers in SQL server 2005/2008.

Creation and scheduling of Maintenance plans (database and log backups and

cleanups), DTS to SISS package conversions. Business Intelligence package

design. Created tables 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.

Created monitoring scripts to alert for production issues and Performed

Production support and on Call duties.

Reviewed DB Scripts from the development/QA team before releasing them into

the Production.

PMS-Protocol Management System (IRB & IACUC)

Client: Key solutions Inc. USA

Environment: Windows 2003 Server, SQL Server 2005, SQL Server 2000,T-SQL,

PL/SQL, Erwin 4.1, JavaScript, MS IIS Server 5.0, SOAP,

HTML/DHTML, XML, Oracle8i.

Role: DB Programmer/DBA

Responsibilities:

Performed server installation and configurations for SQL Server 2005 and

SQL Server 2008R2.

Performed installation of SQL Server Service Packs.

Upgraded databases from SQL Server 2000 to SQL Server 2005.

Involved in capacity planning, sizing and database growth projections.

Scheduled Full and Transactional log backups for the user created and

system databases in the production environment using the Database

Maintenance Plan Wizard.

Created transactional replication for the reporting applications.

Setup Database Maintenance Plans to reorganize indexes, re-indexing and

update the index statistics on the production databases.

Used DBCC commands to troubleshoot issues related to database consistency.

Reviewed DB Scripts from the development team before releasing them into

the Production.

Management of SQL Servers, databases, storage management for databases

sizing from 40 GB to 90GB.

Project Name: Sales Reporting System

Client: Key Solution Inc., USA

Duration: 2010 May - 2010 Dec

Software: SQL Server 2008, Salesforce,ACT!, Informatica

Description: The ACT! to Salesforce.com Migration Template converts data

from ACT! Systems into

Salesforce.com to populate Salesforce.com with Accounts, Contacts, Events,

Tasks, Notes, Attachments, and Opportunities. Since ACT! is contact centric

and Salesforce.com is account centric, the template creates contacts and

attaches them to accounts. It also contains de-duping logic to avoid

creating duplicate accounts and contacts if your ACT! system contains

duplicates or if you are importing from multiple ACT! Systems and require

data consolidation.

Responsibility:

Set up cross references between ACT! and Salesforce.com for data

Database Design and Maintenance.

Create user map for multi-user ACT!

Set up cross references for pick list conversions

Client interaction and Support

Performance improvement

Personal Details:

Address for Correspondence: Manvendra Singh,

House No. 8-3-637,S.V.Nagar,

Banjara Hills,Road No 14

Hyderabad-500 033, India.

Phone: +91-903*******

e-mail: ab0g5o@r.postjobfree.com

Contact this candidate