Sql Server Data
Resume:
PURUSHOTTAM GIRI,
Email: ****.*********@*****.***
SUMMARY:
Around 7 years of experience in Database Administration and Development for very large and complex databases in SQL Server 2014/2012/2008R2/2008/2005.
Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security and Data Transformation Services.
Migration of SQL Server databases into SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL Server 2014.
Dexterity in implementing different types of High Availability &disaster recovery scenarios like Replication models (Snapshot, transactional), log shipping, Database mirroring and Clustering.
Administered multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
Exquisite skills in database Backup, Restoration, Recovery, Replication, Linked Servers, Database Maintenance Planning.
Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
Outstanding experience in SQL Enterprises Manager and SSMS – creating and scheduling jobs, alert and operators with SQL Server Agent, SQL Profiler, Backup/Recovery databases.
Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for tuning and monitoring SQL Server performance.
Experience In VMware and Hyper -V tools to virtualized the server and allocating resources to each VM machine.
Setting up SQL Server 2005, 2008, 2088R2, 2012, 2014 on MS Virtual, VMware.
Good experience in Installing, configuring and maintaining SQL Server Active/Passive cluster.
Expertise knowledge about windows clustering part. Configuration of Static & Dynamic IP addresses, heartbeat connection between the nodes using network editor, partition of disk through ISCSI, configuration of cluster and MSDTC IP address.
Experience in Network aspect like, DHCP, Subnet mask, Default Gateway.
Experience in creating maintenance plans, Jobs and Sending Alerts using SQL Mail.
Experience in installing Service Packs for SQL Server and OS.
Experience in data normalization and de-normalization.
Experience in Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
Worked on DMVs, System tables and Stored Procedures for performance tuning.
Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
knowledge about stored procedures, functions, packages, triggers.
Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
Experience in using tools like SQL Profiler and performance counters for Monitoring and Tuning MS SQL Server Performance.
Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
Good experience in resolving blocking and dead lock Issues.
Experience in SQL Server Integration Services (SSIS).
Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS).
Migrated DTS Packages to SSIS Packages.
Deployed SSIS Packages to MSDB and File system from development to Production environment.
Flexible, enthusiastic and project oriented team player with solid leadership skills to develop creative solution for challenging client needs.
TECHNICAL SKILLS:
Databases
MS SQL Server /2014/2012/ 2008, 2005,
Database Migration
* Migrated Databases from SQL server to SQL server
*Migrated Oracle and My SQL Databases to SQL Server
Programming
Visual Basic 6, Visual Basic 5, SQL, T-SQL,
SQL Tools
SSMS, Profiler, Execution Plan, Database Tuning Advisor, DMVs, DBCC, Perfmon.
ETL Tools
SSIS/DTS/BCP
Data Modeling
ERWIN, SSDD (SQL Server Database Diagram)
Operating System
Windows Server 2008/2005/2003/, NT.
VMware
Installing, configuring and administering.
Windows Clustering
Windows clustering (configuration of DNS, static, Dynamic, MSDTC, Cluster IPs)
Reporting Development & Management
SSRS (SQL server Reporting Services)
Web/Application Server
Deployed apps in development, test and production App Servers (IIS)
Hardware/Storage
San, RAID
PROFESSIONAL EXPERIENCE:
Data Group, Alexandria, VA April 2015-Till Date
SQL DBA
Data Group's information technology professional have built a reputation as business -oriented consultants with deep technical expertise, who design, build and implement innovative information technology solution to address our client's needs. We deliver it solutions to support customer as they adapt to key business transformations and technological advancements that drive the way that organization around the world differentiate themselves.
Responsibilities:
Managed and Administrated the SQL Server 2014/2012/2008R2/2008 production and Non-production servers.
Installation of SQL Server 2014/2012/2008R2/2008 on Windows Server Clustered environment.
Upgraded/Migrated SQL Server 2008/2005 databases to SQL Server 2014/12 databases.
Migrated SQL Server 2008 databases to SQL Server 2014/2012 databases including DTS to SSIS packages.
Performed backup using backup compression and Data compression in SQL Server 2014 on clustered environment.
Handled up to 2.5 TB Size databases with clustered environment.
Implemented new features in SQL 2014/12 like Policy based Management, Table Compression & backup compression, SQL Server Auditing.
Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
Setting up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
Extensively worked on Profiler, Perfmon, DMVs to tune the databases, servers and query tuning.
Managed Security using SQL Logins, Roles and Security Modes for various users.
Rebuilding the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.
Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
Analyze execution plans and generate suggestions for improvement.
To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
Created SSIS packages to load robust data from different Heterogeneous data sources like Oracle, DB2 to SQL server.
Created, scheduled database maintenance plan using SSIS Maintenance plan task.
Configured and deployed SSIS Packages from Test to Production Environments.
Created, deployed and managed reports using SQL Server Reporting Services(SSRS)
Virtualization of SQL server from P2V (Physical to virtual) environment. Strong Knowledge about windows clustering.
Supported 24 X 7 Production environment
Environment: SQL Server 2014/2012/2008R2/2008(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server Analysis Server), ASP.net Applications, IIs Application Server Windows Server 2012, 2008R2, AD (Active Directory) . Third party Application.
Emblem Health, NEWYORK, NY October 2013 - March 2015
SQL DBA
Emblem Health was created by the marriage of two companies with rich histories, local roots and complementary strengths. The founders of GHI developed the idea of paid-in-full benefits and discounted rates with participating providers in 1937. It was the first of many notable innovations. GHI plans were, for instance, the first in the country to offer dental coverage and the first insurance plan to cover preventive medicine such as annual physical exams and well-baby care and in-hospital medical care.
Responsibilities:
Installed, configured, and Managed SQL Server 2012, 2008 R2, 2005 database instances.
Managed development, test and production environment of SQL server Database Server Instances.
Upgraded from SQL server 2005 to 2008R2 and 2012.
Involved in setting up,managing and maintaining High availability technologies : Logshipping,Mirroring and Replication
Worked as a team member for 24X7 on call production support.
Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
Involved in implementation of replications like Snapshot and Transactional.
Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
Applied SP (service Pack) and Hot fixes on SQL serve database instance - standalone and HA environment (Log shipping, Mirroring, Replication and clustering Database servers)
Managing security, which includes monitoring and controlling database access, assigning permissions to application owners.
Involved in Partitioning Databases and Tables for better Performance issues.
Implemented Databases log shipping using the Lite-speed.
Experience in creating complex SSIS packages using proper control and data flow elements.
Hand on Experience on Change control management tool – BMC Remedy user for problem tickets and Change requests.
Have deployed packages on different servers by configuring it.
Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
Involved in upgrading the instance of development environment of SQL Server 2000 to 2005
Partitioning tables to achieve better performance for access and writes.
Resolving locking (Dead Locks) and Blocking issues.
Troubleshooting SQL server performance problems using Profiler and Performance monitor.
Capacity-planning, Maintaining run book documentation on all the servers in word, pdf and excel formats.
Managing and Coordinating with the off-shore team on daily Database maintenance activities
Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.
Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
Involved in SQL Server Cluster and Database Mirroring implementation.
Environment: Windows 2000, Windows NT, SQL Server 2005/2008, litespeed, Sql backup,SQL secure, ETL, SSIS, SSRS, MS Excel and MS Access, Oracle, SSAS, System Monitor / Performance Monitor.
State Street, Boston,MA April 2012 – September 2013
SQL DBA
State Street Corporation, known as State Street, is an American worldwide financial services holding company. State Street was founded in 1792 and is the second oldest financial institution in the United States. The company’s headquarters are at One Lincoln Street in Boston and it has offices in 29 countries around the world
Responsibilities:
As an administrator was responsible for Database backup and recovery such as build the master database; if crash, recover the master and user database in point in time.
Migration of SQL Server 2008 to SQL Server 2008R2/2012 using side by side strategy.
Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
Fine tune application logic for better performance.
Responsible for SQL Performance tuning by using SQL tuning advisor, SQL Profiler.
Identified and analyzed expensive T-SQL stored procedure by using the SQL Profiler (Tracing), SQL analyzer and Index tuning wizard. Optimized long running Stored Procedures & queries for effective data retrieval.
Handled multiple tasks and responsibilities independently as well as a proactive team member.
Design, develop and schedule the various DTS package for data migration, BCP (bulk copy program) for import / export of data.
Experience in SQL Server troubleshooting guidelines DNS /Authentication /Data /Common errors.
Experience in using partitioning in SQL Server 2012 by allowing tables and indexes to be partitioned across multiple file groups.
Used SSIS (SQL Server integration services) 2012 for data extraction, transformation and loading (ETL).
Performed regular reviews of database security and adjusted accordingly to ensure access and modification only to authorized users and/or applications.
Involved in the design and implementation of Disaster Recovery or data recovery plan (DRP), involving database servers and application servers.
Responsible for high availability methods like clustering, transaction log shipping, replication, database mirroring.
Configured Active/Active and Active/passive SQL Server Clusters.
Performed the peer to peer transactional log replication.
Provided the data security by using encryption in SQL Server2008/08R2/12 like for protecting passwords used encryption by passphrase
Create alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach
Monitored the event logs and server logs by troubleshooting.
Environment: SQL SERVER 2012/2008R2/2008/2005, Microsoft Dynamics, Microsoft Dynamics GP 9.0, Microsoft SQL Server Integration services SSIS, Windows Server, DTS, SQL Profiler.
Schneider Electric, Florence, KY October 2010 – March 2012
SQL DBA
Schneider Electric develops technologies and solutions to make energy safe, reliable, efficient, productive and green. The Group invests in R&D in order to sustain innovation and differentiation, with a strong commitment to sustainable development.
Responsibilities:
Successfully managed Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS.
Successfully migrated data between different heterogeneous sources such as flat file, Excel. Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
Designed and created Report templates, bar graphs and pie charts based on the financial data.
Written and executed complex T-SQL queries using enterprise manager for back end data validation testing.
We handled lo t of production issues like data correction and resolves error handling
Checked the configuration and performance of the existing databases including data file allocation, index fill factor, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.
Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
Loaded stored procedures and user defined functions implemented by developer teams into the databases.
Configured the new servers using failover clustering and SAN technology.
Migrated all the databases from old servers to new servers to test for a month.
Generated test data and tested new databases consistency with existing databases to meet the functionalities requirements. Created jobs, alerts, activity logs, error logs to capture any possible errors.
Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
Planned and co-coordinated database security measures.
Writing and testing stored procedures.
Environment: SQL Server 2005/2008, T-SQL, Access, Excel, SSRS, Asp, Microsoft Visio, Windows Advanced Server, SQL Server Reporting services (SSRS).
PMSI, Tampa, FL March 2010 – September2010
SQL DBA
PMSI is committed to serving the industry with clinically based Pharmacy, Medical Services and Equipment, and Settlement Solutions innovations for the workers’ compensation and liability markets.
Responsibilities:
Responsible for Installation, configuration of SQL Server 2005 and 2008.
Reviewed the SQL Codes while doing QA, UAT and Production Migrations.
Improve the performance of SQL Queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
Transfer data from flat files, Excel spreadsheets to and from SQL Server using DTS, BCP and Bulk Insert.
Created Email Notifications for critical events at database level.
Created SSIS packages for Data Import from Data sources.
Created and managed users, roles and groups and handled database security.
Managed test data and their updates between development and production databases.
Regularly monitor the system for bottlenecks (CPU, RAM, and Disk IO).
Involved and Prepared Documentation for Server Consolidation according to CPU, Memory and Business.
Use XML documents to pass multiple parameters for Stored Procedures to read and write database table. Also generate XML documents from tables.
Handle development and production support, document reviews, test plans, integration of the system.
Document all process and Data Flow involved in the database for future reference.
Environment: SQL Server 2005/2008, T-SQL, Access, Excel, SSRS, Asp, Windows Advanced Server.
Certification:
MCITP - 2008, (Microsoft Certified IT Professional - Database Administration)
MCITP - 2012, (Microsoft Certified IT Professional - Database Administration)
Education: BBM, Tokyo University of Agriculture, Japan
BBS, Tribhuvan University, Nepal
Contact this candidate