Sql Server Data

Gopal Tripathi

PROFESSIONAL SUMMARY

Highly motivated professional with seven years of database administration and development work experience in the software industry with SQL Server 2012, 2008, 2005.

Experienced in database optimization and developing stored procedures, triggers, cursors, joins, views, cursors and SQL on databases: MySQL, Sql Server 2012, 2008 etc.

Implemented installation, upgradation, troubleshoot and configuration of MS SQL Server 2005/2008/2012 database.

Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

Extensive experience and in-depth working knowledge in various SQL Server tools and IDE to work with database, reporting and business intelligence based applications like SQL server management studio, SQL server profiler, SQL server business intelligence development studio, visual Studio, and query analyzer.

Excellent experience in SQL Server administration, replication, database mirroring and log shipping.

Experience in creating and maintaining SQL clustering, optimization, backup, restore, security and disaster recovery.

Experience in developing and monitoring SQL server integration services (SSIS), SQL Server reporting Services (SSRS), and SQL server analysis services (SSAS) packages.

Comprehensively involved in data extraction, transformation and load (ETL) using DTS package in MS SQL Server 2008 and SQL Server Integration Services (SSIS), import/export data, bulk insert and BCP.

Experience in data warehouse modeling with SQL Server analysis service (SSAS).

Proficient in SQL database design, architecture, data modeling using Erwin and ER Studio tool.

Excellent knowledge in RDBMS concepts and constructs along with Objects creation such as database, table, normalization, UDF, User defined data type, indexes, SPROC, views, cursors and triggers.

Experience in performance tuning, query optimization, client/server connectivity, and database consistency checks using DBCC Utilities, DMV’s, backup and recovery.

Hands on experience with T-SQL(DDL, DML, DCL) in implementing & developing stored procedures, triggers, nested queries, joins, cursors, views, user defined functions, indexes, user profiles, relational database models, creating & updating tables and checking the database consistency by executing DBCC commands.

Checking of Event Logs, SQL Server Logs, Agent Logs and Job history.

Ensuring that all databases are backed up regularly by monitoring full, differential, transaction log backups, fixing backup failures, address and implement resolutions.

Creation of TSQL scripts for full, differential, transaction log backups, optimizations, integrity checks on some instances that has special requirements beyond maintenance plans.

TECHNICAL SKILLS

RDBMS/DBMS:MYSQL, MS-SQL Server 2012/2008/ 2005, MS Access,

Operating Systems: Windows 2008/2003/2000, NT, UNIX, Linux.

DBA Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Profiler, Idera Tool set, SQL Lite speed, SQL Sentry.

BI Tools: Reporting Service (SSRS) 2012/2008/2005, Analysis Services (SSAS)

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Migration Assistant (SSMA)

Programming Language: T-SQL, PL/SQL, C++, .Net and PowerShell

PROFESSIONAL EXPERIENCE

MS SQL Server DBA – Synaptein Solutions May 2015 – Till Date

• Over 7 years of experience in SQL database development, administration and management.

• Knowledge and experience in dealing with constraints, queries, joins, keys, indexes.

• Experienced in installation, configuration, maintenance and administration of SQL Server 2012.

• Upgraded SQL Server from version 2005 to 2008, 2008 to 2012.

• Experienced in routine database backup & recovery procedures & third party tools.

• Experienced in taking full backup, differential backup and transactional log backup.

• Planned and implemented the backup strategy based on the RTO and RPO.

• Experienced in implementing SQL server security and object permissions like maintaining database

authentication modes, creation of users, configuring permissions and assigning roles to users.

• Experienced in creating jobs, alerts, sql mail agent and scheduling DTS and SSIS Packages.

• Experienced in implementing different types of replication models like snapshot, merge and transactional

on basis of business specification.

• Experienced in setting up failover technologies like log Shipping, database mirroring and Always ON Group.

• Converting MS Access databases to SQL Server environment.

• Knowledge on code optimization, improving efficiency in databases including re indexing, updating

statistics, recompiling stored procedures and performing other maintenance tasks.

•Expertise in creating report subscription, data driven subscription, linked & parameterized reports, drill

down reports using SQL Server reporting services (SSRS).

• Experienced in building and editing the Tabular Model project by using SSAS.

• Proficient in design of ETL and SSIS Packages for integrating data using OLE DB connection from

heterogeneous sources (Excel, CSV, flat file, Text Format Data, Oracle DB, Cognos DB).

Environment: MS-SQL Server 2012,SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Profiler, Idera Tool set, SQL Lite speed, SQL Sentry.

MS SQL Server DBA, IBM Dec 2013 - May 2015

In this project of ABN Amro which is a European major bank, our team mainly responded for manage and fix the databases in the SQL server environment, and using SQL Server BI tools to do the report and analysis work.

Responsibilities:

• Responsible for Database support, troubleshooting, planning and migration.

• Performed the Database Clean-Up Tasks.

• Upgraded databases from SQL Server 2008 to SQL Server 2012.

• Involved in consolidation for worldwide centers using in-house corporate and third party applications based

on SQL server 2008 in upgrade project to SQL server 2012.

• Monitoring of database size and disk space in production, staging & development environment.

• Implemented disaster recovery solution at the remote site for the production databases using log shipping

and mirroring.

• Setup database maintenance plans to reorganize indexes, re-indexing and update the index statistics on

the production databases.

• Used system monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database

server performance.

• Utilized the SSRS to create the parameterized and linked reports for the different requirements.

Environment: Windows Server 2008, SQL Server 2008/2012, Replication, Clustering, SharePoint, Lync.

MS SQL Server DBA

HSBC- Aug 2010–Dec 2013

HSBC Global technology is software arm of HSBC which supports banking and financial application including HSBC’s project like ONE HSBC worldwide and other wings like IT Operations and software development.

Responsibilities:

Duties basically involved installation, up gradation, administration and configuration for SQL server 2012 server.

Troubleshooting connectivity issues, implemented backups and maintenance plans.

Worked on complex data loading and performed the data conversion task..

Worked as a developer in creating complex stored procedures, SSIS packages, triggers, tables, views,

other SQL server joins and statements for applications.

Setup database maintenance plan to reorganize indexes, re-indexing and update the index statistics on

the production databases.

Using SQL Server Profiler to monitor and record database activities of particular users and applications.

Used DBCC commands to troubleshoot issues related to database consistency.

Tuning Stored Procedures using Execution Plan in T-SQL for better performance.

Using the report Manager to manage the report subscription and the security management on the report

server.

Using the SSIS 2012 (SQL Server Integration Service 2012) to create the ETL package for load the data

from different resources load into database.

Environment: Windows server 2003, SQL server 2008R2/2012, SSIS, SSRS, Log Shipping, Replication.

Sql Mid level, HTC Global Services Oct 2009 – Jul 2010

State Farm insurance is one of the prestigious clients of HTC Global based out of Bloomington, Illinois. Provided support for data modeling and sql dba with-

Responsibilities:

• Installation, configuration and maintenance of the MS SQL Server 2008.

• Performance and tuning of SQL servers and application issues related to migration.

• Testing of applications for performance, data integrity and validation issues.

• Performed the database clean-up tasks.

• Scripting the database consistency checks (DBCC), scheduling the scripts to run daily and weekly basis.

• Conducted performance monitoring and tuning using SQL Profiler and windows performance monitor.

• Performed installation, administration, configuration and development upgrades from 2005 to 2008.

• Creating and editing the database objects (tables, relationships, trigger, store procedure, and user

define functions) by using DDL.

• Editing the data in the database system by using DML.

Environment: MS SQL Server 2008, MS Visual Studio, MS Visio, SQL Server Integration Service (SSIS), SQL

Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), MS Visual Studio, Windows Server

2003/2008.

Db2 Dba, SATYAM COMPUTERS Jul 2007-Sep 2009

• Taking routine database backup such as full and differential backups as per back up processes.

• Implementing SQL server security and object permissions like maintaining database authentication modes,

Creation of users, configuring permissions and assigning roles to users.

• Collecting the organization information to finish the normalization work and design the Data Model (ER

Diagram) for the organization.

• creating and editing the database objects (tables, relationships, trigger, store procedure, and user

Define functions) by using DDL

• Assisting application developers in identifying and resolving issues to meet project timelines.

•Ensure that time consuming issues which are vital to project’s success are escalated appropriately.

• Editing the data in the database system by using DML Language.

Environment: Windows Server 2005, MS SQL Server 2005 Enterprise Edition, T-SQL, SQL Profiler,

SSIS, SSAS, SSRS, SQL Management Studio.

Education:

Degree: Bachelor of Engineering (Computer Science)

University: Rajiv Gandhi University Institute of Technology, Bhopal, India

Certifications:

Certified in ITIL® 2011 Foundation ( 2013)

Completed university of Cambridge business English

certification (BEC) – Preliminary (2010) and Vantage (2011)

Personal Information

Name: Gopal Tripathi

Mail: acrmxq@r.postjobfree.com

Contact this candidate