Sql Server Data

SUMMARY

**+ years of experience in Database Administration, Design Development and Support of

MS- SQL Server 2014/2012/2008R2/2008/2005/2000/7.0 in Production, Test, Development and Cluster Server Environments.

Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/2008/2012.

Experience in Always on Availability groups, Disaster Recovery Planning. Execution and Testing at remote side.

Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.

Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008. MS SQL SERVER 2008 to MS SQL SERVER 2012 and 2014

Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.

MDX development/conversions (Excel Business Functions).

Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).

Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.

Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.

Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2005.

Introduced the Agile SCRUM process for the Risk Data team and utilized Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle including deriving product backlog items, assigning sprint work items to developers and conducting sprint review meetings.

Extensive experience working with virtualized environment where in installing and working with VMware.

Extensive experience with IIS (Internet Information Services) 5.0/6.0/7.0. Experienced in systems and/ or network administration running Windows Server with IIS .

Installed latest versions of Windows Operating Systems like 2000/2003/2008 on demand, per requirements of the clients.

Sorted complex issues pertaining to hardware and network failure – Monitored both Hardware and Software systems for errors and updated them regularly to maintain proper functioning and flow of information.

Managed the overall administration of Windows System applications and Performed various troubleshooting and maintenance operations in Windows Server environments.

Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering Active-Active, Active-Passive, Always on Availability groups.

Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005.

Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.

Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.

Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQL Server 2005 Reporting Services (SSRS), Crystal Reports.

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

Migrated, Upgraded and Installed MS-SQL 2008/2008R2 to 2012 using service packs.

EDUCATION:

Bachelor’s in Computer Science & Engineering, Hyderabad, INDIA.

Certification: Microsoft Certified Solutions Associate “Administrating Microsoft SQL Server 2012 Databases ”

TECHNICAL SKILLS:

SQL Server Tools

SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages

C, C++, C#,ASP.NET LINQ, T-SQL, My SQL, VB.NET, HTML, XML, CSS, DHTML, Java Script

Operating Systems

Windows 95/2000/2003/2008/2012/XP/VISTA/7, UNIX (Sun Solar), LINUX

Web Server

Internet Information Services(IIS) 5.0/6.0/7.0

Database Management systems

MS-SQL Server 2012/2008R2/2008/2005/2000, MS Access,

ETL Tools

Data Transformation Services(DTS), SQL Server Integration Services (SSIS)

Reporting Tools

Business Objects, Crystal Reports, SSRS

DB Utilities

SQL Server Management Utility, Query Analyzer

Application Software

Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Scripting

Powershell, VB Script

Data Modeling Tools

DB Moto, Erwin, Red gate, Lite Speed

PROFESSIONAL EXPERIENCE:

Sutter Health, Sacramento, CA Sep 2015 – Till Date

Sutter Health is a non-profit health system in Northern California, headquartered in Sacramento. It includes doctors, hospitals and other health care services in more than 100 Northern California states and towns. Major Service lines of Sutter Health-affiliated hospitals include cardiac care, women’s and children’s services, cancer care, orthopedics and advanced patient safety technology.

Responsibilities:

Administrated and Managed SQL Server 2012/2008R2/2008/2005 databases in Production, Staging, QA and development environments.

Responsibilities include the Production and Application Support for the Database and Application Servers.

Upgraded/Migrated SQL Server 2008 and 2008R2 databases to SQL Server 2012 databases and mentored other technical staff.

Created more than one availability groups using the Always ON Availability group.

Experienced in working on Always On Fail-Over clustering.

Enhanced the capabilities of Database Mirroring and ensured availability of application databases using the Always on Availability groups.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Resolving performance issues using DMVs (Dynamic Management Views).

Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.

Installing, Configuring and Maintaining SQL Server 2012/2008R2/2008/2005 (64 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.

Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.

Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.

Designed Always On Availability Groups and Database Recovery plan, Implemented Database Mirroring in SQL Server 2014/2012/2008r2 and participated in Disaster Recovery Drill processes.

Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.

Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.

Performed data partitioning for efficient management of database tables and indexes. Extensively working on performance issues like update statistics, Auto Stats.

Involved in Change Data Capture process.

Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.

Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.

Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.

Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.

Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers

Transformed data from Oracle to MS-SQL Server using Data Transformation techniques Like SSIS.SSAS.SSRS

Environment:

Windows 2000/2003, MS SQL Server 2005/2008/2008R2/2012, Oracle10g/11g, SSRS, DTS, SSIS,BCP SQL Server Profiler, VB.NET, T-SQL, Erwin 4.0, Erwin 3.5.2, DBMoto, Database engine tuning Advisor, IIS.

General Electricals, Schenectady, NY Sep 2013 – Aug 2015

MS-SQL Server DBA

General Electric Co. is a technology and financial services company that develops and manufactures products for the generation, transmission, distribution, control and utilization of electricity. Its products and services include aircraft engines, power generation, water processing, security technology, medical imaging, business and consumer financing, media content and industrial products. The company operates through eight segments: Power & Water, Oil & Gas, Energy Management, Aviation, Healthcare, Transportation, Appliances & Lighting and GE Capital.

Responsibilities:

•Prepared maintained and modified SQL server installation and configuration documents.

•Installed SQL Server 2012, 2008r2 and 2008 on Windows Server Clustered environment.

•Managed and Administrated the SQL Server 2008/2005 production servers.

• Migrated data from Legacy system to SQL Server 2008 using SSIS packages.

•Upgraded/Migrated SQL Server 2005 databases to SQL Server 2008, 2008r2 and 2012 databases.

•Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment.

•Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.

•Monitored transactional replication on Production, UAT, QA and Dev servers.

•Used SQL Server Activity Monitor When troubleshooting a performance issue or monitoring a server in real time.

•Implemented new features in SQL 2008 like Policy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor and MERGE statement in T-SQL.

•Created SQL Server Audits in developing a risk mitigation plan to keep the environment secure.

•Designed a centralized data repository for storing performance data called management data warehouse and used the fully extensible performance data collection and warehouse tool the ‘data collector’.

•Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

•Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.

•Managed Security using SQL Logins, Roles and Security Modes for various users.

•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.

•Handled numerous change management requests on production and UAT servers

•Maintaining the database consistency with DBCC utility at regular intervals.

•Provided documentation for SQL configuration, and Performance measures.

•Designed Daily, Weekly and Monthly checklists for the database and server

•Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries.

•Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas

•Involved in Source Data Analysis, analysis and designing mappings for data extraction

•Created, deployed and managed reports using SQL Server Reporting Services(SSRS)

•Created and managed financial reports using SSRS

•Evaluated data storage considerations to store databases and transaction logs.

•Created the technical specification document.

•Review of Technical and Functional High Level Documents (HLDs).

•Developing Test cases for the Interfaces.

•Involved in Batch Processes.

Environment: SQL Server 2008/2005 (SSMS, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), SSRS, SSIS), Snap Manager for SQL

Bio-Rad Laboratories, Hercules, CA June 2012 – Aug 2013

SQL Server Database Administrator

Bio-Rad Laboratories plays a leading role in the advancement of scientific discovery by offering a broad range of innovative tools and services to the life science research and clinical diagnostics markets. Founded in 1952, Bio-Rad has a global team of more than 7,000 employees and serves more than 100,000 research and industry customers worldwide through the company's global network of operations.

Responsibilities:

Installed and Maintained SQL Server 2008 R2/2008/2005 on Development and Production Environments.

Usage of new compression Techniques in SQL Server 2008 R2 for backup and restore jobs.

Implemented Database Mirroring and Transactional Replication as a part of DR plan.

Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.

Creating Logins and Roles with appropriate permissions.

Creating and Maintaining Database Maintenance Plans.

Modify Stored Procedures and complex T-SQL Queries to improve query execution process.

Write T-SQL Scripts for database backup jobs and daily/weekly jobs.

Tune slow running queries using SQL Server Profiler.

Import data across multiple instances using BULK INSERT and BCP Utility.

Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.

Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.

Create Clustered and Non-Clustered Indexes to improve the performance of database access.

Create and manage databases across Development and Production instances using SQL Server Management Studio.

Involved in Logical and Physical Data Modeling process using MS Visio.

Use MS Visual Source Safe as a Version Control System.

Involved in Change Data Capture process.

Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Environment: SQL Server 2005/2008/2008R2, Windows 2003/2008, SCOM, VERITAS

Social Services Agency, Orange County, CA Oct 2011 – May 2012

SQL Server DBA

The Orange County Social Services Agency (SSA) operates under the policy direction of the Orange County Board of Supervisors and the California Departments of Social Services and Health Services. SSA is responsible for planning, implementing, and operating many of the social services programs provided by the County of Orange. Funding for programs comes from state, federal, and county sources.

Responsibilities:

Worked on Client/Server tools like SQL Server Management studio 2008/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.

Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.

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: SQL Server 2008/2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler

TCF Bank, Minneapolis, MN Mar 2009– Sep 2011

SQL Server DBA

TCF Banks are affiliated with TCF Financial Corporation, a financial holding corporation based in Minnesota. TCF has 444 banking offices in Minnesota, Illinois, Michigan, Colorado, Wisconsin, Indiana, Arizona and South Dakota. TCF is now the 10th largest U.S. Visa® Classic debit card issuer ranked by sales volume.

Responsibilities:

Involved in the migration of SQL Server 2000 databases to SQL Server 2005/2008

Installed, authored, and managed reports using SQL Server 2005 Reporting Services

Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.

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

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved 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

Transferred data (ETL) to Data warehouse Environment using SSIS.

Managed VERITAS net backups and Litespeed backups.

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.

Using Log shipping for synchronization of database.

Worked in Cluster Environment.

Environment: SQL Server 2008/2005 and SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, VSS and Password Updater.

Sharelogic Software Solutions, Hyderabad, India Aug 2005 – Feb 2009

MS SQL Server DBA

Sharelogic Software Pvt Limited is an IT solutions and IT enabled service company .Sharelogic, provides state-of-art technology based solutions to clients’ business problems through the following key services: Valuable experience in legacy and client-server applications, combined with unparalleled expertise in leading-edge technologies, ensures that clients’ IT investments are safeguarded in the hands of the best engineers. Ever in tune with the changing trends in leading edge technologies, Sharelogic has immense expertise in implementing solutions that make use of robust industry technologies like BEA Weblogic, IBM Web sphere, Websphere MQ (Integration), Oracle 9i, SQL Server, Postgres SQL, MySQL, SAP, IPlanet, IIS, and Apache.

Responsibilities:

Installed SQL Server 2005/2000 and created Development Database for testing, upgrades and development.

Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.

Created System Schema Diagram and Tables.

Created logical Entity relationship diagrams and implemented logical model physically.

Set up Database Maintenance Plan using SQL Server Enterprise to update the statistics.

Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.

Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.

Performance tune stored procedures, to make the report processing faster.

Used log shipping for synchronization of database.

Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.

Used ROBO Copy to move large files through networks.

Performed daily backup and created named backup devices to backup the servers regularly.

Generated Script files of the databases whenever changes are made to stored procedures or views.

Worked with remote teams to establish the first phase replication scheme for dif locations.

Implementing and administering database replication between SQL Server databases as well as dissimilar databases.

Setup the agents for replication and defined disaster recovery plan.

Provided secondary support to the Local area network (LAN).

Provided a robust back-up system that ensures data integrity.

Configured PC Anywhere software to connect to other sites through DSL using TCP/IP.

Environment: SQL Server 2005/2000/7.0, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE and Sitescope.

Contact this candidate