Sql Server Data
Resume:
Amninder Sokhi
********.*******@*****.***
Status : Green Card
SUMMARY
Over 8 years of experience in MS SQL Server Database Administration, Design, Development and Support in Production, development and test environments.
Good Expertise in installation of 2000/2005/2008 R2/2012/2014 MS SQL servers and applying Service packs and hot fixes.
Experience in migration of SQL Servers (side by side and In-Place) and Experience in In- Place and Side by Side migration of MS SQL Server 2000/2005 to 2008 and 2008 to 2012
Experience working with 32bit, 64-bit MS SQL Server in Clustered and Standalone Server Environment
Extensive experience with configuring high availability and Disaster recovery techniques likes Clustering, Log shipping and mirroring(High safety, High performance& High availability), Replication (Snapshot, Merge, Transactional& Peer -to- Peer)
Implemented Always-On High availability groups in SQL 2012.
Experience in setting up Active-Active and Active-Passive clustering (Two node and Multi node) on physical and VMware and Hyper-V environments.
Experience in working with both OLTP and OLAP environments
Implemented new features introduced in SQL Server 2008 like Policy Based Management, Resource Governor, Data Collector sets and Backup Compression Techniques.
Experience in working with Data Compression techniques like Row Level and Page Level Compression and Database backup Compression in SQL 2005 and 2008
Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.
Used necessary data cleansing and backup tools for migrated data like CDC (Change Data Capture) components and DQS (Data Quality Services) knowledge system.
Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
Thorough knowledge of all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
Expertise in working with Performance counters, SQL Profiler and Extended events.
Experience in using DMV, DBCC and dynamic management functions (DMF) of Tables, Triggers, and Store Procedure etc. for finding out long running queries.
Used recursive CTEs, CTE, temp tables and effective DDL / DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications
Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better Query Execution plans.
Experience in data partitioning to improve the performance of large table to reduce contention and improve availability of data.
Configured and managed Linked Servers and Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
Experience in deploying SQL Databases in CLOUD (AZURE & AMAZON).
Configured Registered Servers and Multi Server Administration.
Hands on Experience with using Data Modeling Tools such as Erwin and MS Visio.
Experience in Database designing, RDBMS, and Normalization/De-normalization.
Working knowledge of System center configuration manager (SCCM) in windows 2008 R2/2012 environment
Creation and maintenance of Databases, creating Roles and managing user permissions.
Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.
Working knowledge of Active directory(AD) Services
Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc.
Overall database design that involves creating normalized databases, user authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
Worked on VLDB’s sizing around 250 GB to 4 TB.
Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values
Experience with IIS Administration and configuration
Thorough Understanding of different RAID levels implementation.
Experience with Third Party tools like Litespeed, Foglight, RedGate, Erwin and Idera and MS tool SCOM.
Experience in creating documents for Disaster Recovery and also documenting issues with Root cause analysis.
Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
Experience in building SSIS packages using SQL Server Data tools (SSDT) environment, involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
Experience in implementation of enterprise databases on enterprise storage solutions using Storage area Network (SAN)/network attached storage(NAS)
Experience in SSAS tools on making dimensions and cubes to analyze data from complex databases
Experience in creating cubes using MS SQL Analysis Services (SSAS) part of SQL Server of Data tools (SSDT). Developed star and snowflake schemas for Data Warehouse
Proficient in implementing the business logic to design/develop the Cubes, Aggregation, Measures using SQL Server Analysis Services (SSAS).
Extensive experience in the development of Reports using SQLServer2000/2005 Reporting Services (SSRS) (part of SSDT) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, and Drilldown Reports in multiple formats using multi – dimensional objects.
Strong ability in Scheduling and deploying reports on Report manger
Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.
24*7 Production on-call support
EDUCATION
Bachelor of Technology, Lovely Professional University, India
TECHNICAL SKILLS:
Operating System
Windows 7/Vista/XP/2000/NT, Server 2012/2008R2/2003, Exchange 2003, Linux, UNIX
RDBMS:
MS-SQL Server 2005/ 2008/ 2008R2/ 2012/ 2014, MS Access
Languages
Transact-SQL, SQL, C/C++, Lab view, and Visual Basic
Database Tools:
Enterprise Manager SQL Profiler, I-SQL, T-SQL, PL/SQL, SSRS, SSAS, ODBC, OLTP, ADO, SQL OLEDB, ERWIN, PSSDIAG, VISIO, IIS,HP SAN SCSI, LITE SPEED, RED GATE, VSS, TFS,SQLMON, Quest Lite speed, SQL Safe, Redgate, Tivoli, Iderax
ETL Tools:
SSIS 2005/2008/2008 R2/2012, DTS
OLAP Tools:
SSAS 2005/2008/2008 R2/2012
Reporting Tools:
SSRS 2005/2008/2012, Crystal Reports, MS-Excel(Pivot Tables, VBA, Macros)
Data Modeling Tools:
CA Erwin, MS-Visio, MS-Visual Studio
GE Health Care, Barrington, IL Mar 2015 – Mar 2016
Sr. SQL Server DBA
Description: GE Healthcare provides transformational medical technologies and services helping to deliver patient care to people around the world. The company provides medical imaging and information technologies, medical diagnostics, patient monitoring systems, drug discovery, biopharmaceutical manufacturing technologies and performance solutions services
Role and Responsibilities:
Setup several two-node and multinode clusters using an Active/Active and Active/Passive configuration.
Creating logins, users, and roles, giving permissions pertaining to Databases security.
Implementing Always-on High Availability Groups
Design and Implementation of user login and security modes. Security issues related to logins database users and application roles and linked Servers of MS server and DB2.
Involved in design & develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.
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
Setup and maintain Database Mirroring in high performance/ high availability mode as DR strategy.
Configured Snapshot and Transactional Replication.
Configured Active directory (AD) to set, server objects, Publication and linking server
Perform restore/recoveries on a periodic basis to ensure the recoverability of the databases.
Successfully upgraded SQL 2005 to SQL 2008/2008R2 and SQL 2008 to SQL 2012 ( side by side and in place)
Migration of SQL Server 2005 to SQL Server 2008/2008R2 on both physical and virtual environments (VMWare, Hyper-V).
Performed DR tests periodically for mission critical application.
Automated daily database refreshes from production to staging and on-demand refreshes from production to non- prod environments.
Created DDL triggers for auditing any DDL change in SQL 2005/2008R2/2012.
Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008r2/2012 Analysis Services (SSAS).
Implemented data partitioning to improve the performance of large table reduce contention and increases availability of data.
Created the custom backup using Redgate tool and restore strategy for production, development and test environments.
Involved in performance tuning using Activity Monitor, Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
Involved in change management, problem management activities using BMC Remedy tool before implementing database changes in production.
Responsible for creating the reports basing on the requirements using SSRS 2005Commitment to SLA based on ticketing system where responding time with 15 minutes to production and 45 minutes to other environments.
24x7 Production on-call support
Worked in extracting data from Flat file source and excel source into SSIS and made changes to the data in slowly changing dimensions.
Environment: SQL Server 2005/2008, Windows 2003/2008/2012 Server, TFS, .Net,,visual Studio, Spotlight
Sr. SQL Server Database Administrator
State of Massachusetts (MassDOT),Boston, MA Nov 2013 – Feb 2015
Production Support.
Knowledge of SQL Server database architecture( components and processes of the database) for SQL Server 2000, 2005, 2008, 2012.
Experience in SQL developing and maintaining Stored Procedures and triggers.
Experience with Data Warehousing, and ETL (SSIS & DTS).
Knowledge of data modeling and database design concepts for OLTP applications and working knowledge of database modeling tools (ERWin, etc)
Advanced SQL and T-SQL skills (complex Stored Procedures, triggers, looping constructs etc.
Ability to do database and SQL performance analysis and make tuning changes.
Advanced experience with data analysis, data validation and data conversion.
Experience in converting MS Access databases to MS SQL Server.
Understanding of SQL Server technology on Windows OS.
Experience with SQL Server Reporting Services (SSRS) and reporting technologies.
Web development knowledge.
Data warehousing design understanding.
Experience in using Perfmon and found out Memory, disk, IO and network related issues by using the various counters and relate them with the thresh hold values and also having good experience in gathering all the perfmon values, slice and dice them with excel for comparison.
Experience in creating SQL Server profiler for gathering the information about deadlock graphs and also having experience in adding more profiler parameters to get the information about how SQL Server is behaving.
Data warehouse ETL design and development skills.
Knowledge of developing with MS .NET
Development experience using SQL Server Analysis Services.
Utilized strong writing skills to draft System Support Documentation as needed
Experience with full software development life cycle; including technical design and specifications determined from business requirement documents.
Ability to translate business requirements into a technical design and specifications.
Self-motivated and highly professional with ability to take on responsibility and also to work independently or within a team environment
Ability to work under pressure and tight deadlines.
Ability to take direction, constructive criticism and work to specified deadlines.
Performed research and analysis for problem resolution using strong written and verbal communication skills to produce System Support Documentation.
Environment: SQL Server 2005/2008/2008 R2/2012, T-SQL, Windows Server 2003/2008/2008 R2, Report Builder 3.0, VSS, Oracle.
SQL DBA Consultant Nov 2011 – Oct 2013
Nationwide Insurance, Columbus, OH
Database Administrator/Database Programming/Product specialist. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
Extensively worked on compliance issues. Wrote the packages using DTS in SQL2000. To analyze long running slow queries and tune the same to optimize application and system performance.
Worked on key performance indicators for customizable metrics. To set up SQL Server configuration settings.
Installed, authored, and managed reports using SQL Server 2000 Reporting Services. Monitoring SQL Server performance using profiler to find performance and dead locks.
Managed Disk space, memory and User connections. Rebuilding the indexes at regular intervals for better performance.
Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
Expert in relational data modeling principles and techniques.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Monitored and modified Performance using execution plans and Index tuning. Rebuilding the indexes at regular intervals for better performance.
Managed the clustering environment. Used log shipping for synchronization of database. Expertise in SQL Server Analysis Services.
Expertise in SQL Server Reporting Services. To setup, implement, and maintain industry standards in database management.
Monitored SQL Server performance using profiler to find performance and dead locks. Monitoring the servers using spot light third party Quest software.
Extracted the fixed length format files from DB2 databases. Maintained the database consistency with DBCC at regular intervals.
Implemented Data Access Layer using ADO.NET to communicate With the MS SQL Server 2005 Database. Involved in developing user controls and aspx pages.
Environment: SQL Server 2000 with clustering, T-SQL, Windows 2003 Server, VB.Net and ASP.Net
RNC Software Solutions, Hyderabad, India. Jan 2009 – Sept 2011
SQL Server 2008 DBA/Developer
Description:
This application is used to supply data to different customers. Depending upon the requirements of customers, data is supplied in appropriate formats. All the data related to customers, in their respective formats and the schedule details are stored in database. This application will generate tab delimited text files from database, in the required format and these text files will be uploaded to the Customers through FTP. These applications have greater flexibility in the sense that there is no need to change the code for each and every new Customer. Whenever a Customer requires new data/new Customer is added, then all the details about the data requirement and schedule details are added to the database using VB application. BCP, Bulk insert, Snapshot Replication and DTS package technologies are extensively used throughout the application. This project eliminated the human Intervention to greater extent and reduced the Database Maintenance work.
Responsibilities:
Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
Migrated DTS packages into SSIS packages.
Handled up to 2 TB Size databases with clustered and stand alone environment
Configured Transactional replication on migrated server.
Wrote the packages using SSIS in SQL2005.
Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
Integrated SQL traces with PerfMon log to have better graphical analysis to find system bottlenecks.
Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
Used DTS packages to move logins and jobs from one server to another server.
Used log shipping for synchronization of database.
Good experience in data modeling and metadata services.
Monitoring SQL server performance using profiler to find performance and deadlocks.
Created Stored Procedures, Triggers, Views and Functions for the Application.
Extensive testing on the Performance of the Stored Procedures.
Environment:
TSQL, MS SQL SERVER 2000/2005,SSRS, QUERY ANALYSER, VISUAL STUDIO 2005,VB.NET,C#,WINOWS SERVER 2008,IIS
Bharti Airtel,Pune, India Oct 2007- Dec 2008
SQL Server 2005 Developer/ DBA
Description: Bharti Airtel Limited is one of Asia’s leading integrated telecom services providers with operations in India, Sri Lanka and Bangladesh.
Responsibilities:
•Actively participated in gathering of Requirement and System Specification.
•Worked on complex T-SQL statements, and implemented various codes and functions.
•Involved in the migration of SQL Server 2000 databases to SQL Server 2005
•Installed, authored, and managed reports using SQL Server 2005 Reporting Services
•Evaluated data storage considerations to store databases and transaction logs.
•Managed trouble shooting of Client connections, viewing error log and applications.
•Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
•Index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
•Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
•Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation
•Monitored servers using Spotlight third party software.
•Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
•Maintaining the database consistency with DBCC utility at regular intervals.
Environment: SQL Server 2005/2000, C#., VB, VBA, ASP, .NET, Windows 2003.
Contact this candidate