Sql Server Data

PROFESSIONAL SUMMARY

*+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2014, 2008 R2, 2008 and 2005.

Expertise in Database Administration on Production Servers with server configuration, clustering configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

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

Administering SQL Server High Availability and Disaster Recovery strategies.

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

Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, contained Databases and, security principals.

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

Experience in using DMV and dynamic management functions for finding out long running queries.

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Experience in Disaster Recovery Planning and Security Management operations.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Having hands on experience in DR processes including Log shipping and Database Mirroring.

Worked on configuring SQL Server with minimum privileged access.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

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

Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations with WINTEL systems.

Having Experience on Data center servers and handling more than 1.0 TB databases.

Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2008.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Created Linked Servers between SQL Server 2008 R2. Also created DTS package for data transfer between the two environments.

Experience in SSIS, SSRS, SSAS and Clustering.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Strong experience in mentoring team members and writing documentation.

24 X 7 Production Database on Call Support

TECHNICAL SKILLS

DBA

Database Administration of MS SQL Server 2014, 2012, 2008, 2005

ETL Tools

SSIS using BIDS, Informatica Power Center

Business Intelligence

MSBI Suite(SSIS, SSRS, SSAS),

Databases

SQL Server 2012/2008/2005, MySQL, MS Access

Languages

SQL, PL/SQL, .NET(C#), C

Web Technologies

HTML, DHTML, XML, XAML, XSL/XSLT, IIS

Design

Erwin, Visio, Aqua Studio, Enterprise Architect, MySQL workbench, SQL Developer, Data Modeler, SQL Server Diagram Editor, TOAD Data Modeler, Visual Paradigm

Tools

MS Office Suite, TOAD, SQL Plus, SQL Developer, SQL Developer, Data Modeler

Operating Systems

Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux, WINTEL Systems

Version Control

Team Foundation Server, Visual Source Safe, SVN

Network Topologies

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

EDUCATION: Bachelors in Business Administration

PROFESSIONAL EXPERIENCE

Hewlett-Packard, Atlanta, GA

SQL Server DBA

Sep 2015 – Present

The client is implementing enhancements into the existing Enterprise Data Warehouse. These new cubes that are added will enable the client to identify loyal customers and serve them better.

Responsibilities:

Installed and configured of SQL Server 2000/7.0 on Window 2000/NT OS.

Managed of database objects like Tables, views, stored procedures, indexes etc.

Written complex stored procedures and functions according to business requirements.

Implemented Backups and restoring when necessary.

Used BCP utility to publish table output to text files.

Developed DTS Packages to transfer the data between SQL Server database and files.

Creation and management of Database maintenance plan for various database consistency checks.

Developed original system for tracking database objects (tables, views, procedures, etc.) over multiple Sybase servers using Unix Shell Scripting.

Created monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports

Designed and Implemented Reports using Business Objects Full Client.

Reports were developed using Crystal Reports utility.

Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.

Managed of users including creation/alteration, grant of system/db roles and permission on various database objects.

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.

Extensively Developed SQL scripts for maintaining administration tasks.

Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server7.0/ 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Crystal Reports, Business Objects, T -SQL, BCP.

Payspan, Jacksonville, FL

Database Administrator

Jan 2014 – August 2015

PaySpan is the largest healthcare payments and reimbursement network in the U.S. serving both Payers and Providers, focusing mainly on B2B businesses. Worked as a Database Developer Analyst responsible to work on interactive dashboards, trend analysis, ETL development, SQL development, testing and implementation.

Responsibilities:

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN Environment.

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Worked and implemented Transact SQL (T-SQL) codes.

Implemented SQL Cluster Configuration and replication for multiple nodes working and stand by.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.

Rebuilding / monitoring the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Performed transaction log backup, and shrink database log files to free log space and cluster disk space.

Responsible for database user management.

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.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

Expert in implementing the snapshot isolation and DDL triggers.

Responsible for Database Problem Management, stand by to support calls on request.

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.

Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).

Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers and WINTEL Systems).

Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, Wintel Systems, .NET, Erwin, Microsoft Visio, SFTP, SQL Server Integration Services, SSRS and Microsoft Reporting Services.

Credit Suisse, Raleigh, NC

SQL Developer DBA

Jan2013 – Dec 2013

Credit Suisse Asset Management division is one of the largest publicly traded global asset management firms in the world. The primary objective of the project was to construct an aggregated data warehouse (DWH) for analytics and reports used by business, risk management, asset management groups.

Responsibilities:

Perform business analysis, technical analysis, systems design, application software programming.

Prepared DFD's & Entity Relationship(ER) diagrams.

Restructuring the stored procedure, designing, coding and developing the same using the T_SQL Programming.

Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.

Extensively worked on Dynamic Management Views in SQL Server 2005.

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

Managed the migration of SQL Server 2000 databases to SQL Server 2005.

Monitoring SQL server performance using SQL Profiler to find performance and dead locks.

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

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.

Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.

Prepared the project management and technical documentation.

Unit Testing the SSIS packages with respect to its flow and performance issues.

Solving the Bugs Reflected by the Testing team.

Rebuilding the indexes at regular intervals for better performance.

Monitored and modified Performance using execution plans and Index tuning.

Rebuilding the indexes at regular intervals for better performance.

Extensively worked on DBCC commands and Dynamic Management Objects.

Expertise in SQL Server Reporting Services and SQL Server Analysis Services.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Complete documentation about the database. Recovering the databases from backup in disasters.

Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

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

To set up SQL Server configuration settings for better server management.

Monitoring the servers using Idera third party software.

Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment : SQL Server 2012/2008/2005, .Net Framework 3.5/4.0, C#.Net, Asp.Net2.0, JavaScript, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access, Erwin, Visio Professional, TFS

Mercedes Benz Financials Systems (MBFS), Farmington Hills, MI

SQL Server 2012 DBA

Oct 2010-Dec 2012

Mercedes-Benz Financial Services is one of the leading captive financial services providers in the world, and the global financial services company of Daimler AG

Responsibilities:

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.

Rebuilding / Monitoring the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

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.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).

Expert in implementing the snapshot isolation and DDL triggers.

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.

Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).

Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).

Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services

Frost Bank, San Antonio, TX

Database Deployment Engineer

Sep 2009 - Aug 2010

This was an Assets and Liability Management for Frost bank related to Private banking, Retail banking, and investment banking.

Responsibilities:

Database Administrator, Database Programming.

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

Rebuilding the indexes at regular intervals for better performance

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

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.

Deploying new code base release to UAT and Production Environments.

Perform SQL Server service pack and Windows Service pack upgrades.

Working with customers on Application rollouts and server migrations.

Extensively worked on Enterprise Manager for managing the database.

Troubleshoot performance problems and fine-tuning of databases.

Involved in Index Analysis and Performance Tuning.

Worked with different upstream team for downloading ETL MART data.

Converting DTS packages into SQL Server 2005 Integration Services.

Migrating SQL Server 2000 data bases into SQL Server 2005.

Recovering the databases from backup in disasters.

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

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, ME Change Request, Visio, Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Contact this candidate