Sql Server Data

Srinivasa Phaneendra Kumar Nerusu

Jacksonville, FL, 32246 248-***-**** **************@*****.***

SUMMARY:

* ***** ** ** ************ experience in Development, Client Analysis, Database Design, Testing and Support and presentation using SQL Server 2000/2005/2008 R2.

Extensive working experience in various industries including banking, financial, marketing services, and healthcare industry.

Experience in an operational environment providing support, involving coordination with release Management and Change management.

Extensive experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008 R2 on both Cluster and Stand-alone Environment.

Database Design in Full, Bulk Logged, Simple Recovery Modes, Restoring Databases with Point in Time Recovery.

Extensive experience in designing, implementation and administration SQL Server Relational Database / Data Modeling, Data Warehouse in small, medium and large organizations.

Replication, Snapshot Replication and Merge Replication.

Experience in Log Shipping (Configuration of source, Target and Monitor) Servers in SQL Server 2005.SQL Server Integration Services (SSIS). Knowledge of SQL CLR, Service Broker and other new features in SQL Server 2005, SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS). Worked on various SSIS/dts packages for data import/export/transformations from different OLEDB/Flat source to SQL 2005/SQL 2008.

Good understanding of High availability techniques Database Mirroring and Clustering.

Extensive experience in Creating alerts for SQL Server Performance. Extensively worked on Active-Active and Active-Passive Clustering. Optimization and Maintenance tasks including Re-indexing, Updating Statistics, Shrinking Databases and Recompiling Stored Procedures.

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

Experience in Loading Data using SQL Server Integration Services (SSIS) and building reports using SQL Server Reporting Services (SSRS) in star schema.

Experience in working with Linked Servers, Distributed Transactions, and Federated Databases.

Experience in creating complex DTS Packages for Data Migration and Transformation and experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2008/2005/2000.

Provided support to SharePoint users and site level administrators

Hands-on working experience with analyzing query plans, query optimization, performance tuning, managing indexes and locks, troubleshooting deadlocks.

Running of Traces using SQL Profiler tool, Performance Monitoring & Tuning using Performance Monitoring Tool, Query Optimization, Client / Server Connectivity.

Excellent skills in implementing ETL Packages using DTS and SSIS 2005/ 2008.

Involved in implementing transactional replication in a high OLTP environment.

Experienced in configuring SQL Mail.

Creating and Maintaining Databases, Adding Users, Roles and Groups and assigning privileges according to the project needs.

Experienced with XML data type and Retrieving Relational Data in XML Format.

Expertise in T-SQL, Stored Procedures, Functions, Cursors and Triggers etc.

Used Indexes for improving query performance, lower storage and maintenance cost.

Excellent Communication, Analyticalskills and Interpersonalskills. Exceptional ability to learn new concepts. Skilled at accessing client needs, working in a group, suggesting ideas that enhance Efficiency and Maximize Performance, Implementing Cutting-edge Technology Solutions and Training/Supporting end users.

TECHNICAL SKILLS:

Languages

Java, C#, ASP.NET, VB.NET,JSP, JDBC, JDOM, XML, VB,C,

C++, Java Script-SQL, PL/SQL.

Databases

MS SQL Server 2000/2005/2008 R2, MYSQL 5.0, Oracle, Sybase, MS Access.

ETL tools

DTS, SSIS, Informatica.

Operating System

Windows 2000, 2003, XP, Vista.

Software Tools

Visual Studio 2005, Visual Source safe, Microsoft Visio, MS Excel, Win Runner 7.5, Load Runner 7.0, Rational Suite, QTP 8.0, Test Director, Web Tools(Dream weaver), Macromedia Flash 2004, Siebel MS expression web and MS sharepoint designer.

Other Tools

SQL*PLUS, SQL*LOADER, TOAD, SQL NAVIGATOR, SQL DEVELOPER

EDUCATION:

Bachelor of Science (JNT University, India)

PROFESSIONAL EXPERIENCE:

Fidelity Information Services, Jacksonville FL July 14 – Sep14

MS SQL SERVER DBA

FIS is the world’s largest global provider dedicated to banking and payments technologies. With a long history deeply rooted in the financial services sector, FIS serves more than 14,000 institutions in over 110 countries. FIS employs more than 39,000 people worldwide and holds leadership positions in payment processing and banking solutions, providing software, services and outsourcing of the technology that drives financial institutions.

Responsibilities:

Migration project involved in production support for SQL server environment.

Installing and configuring of MS SQL Server 2008, 2008 R2, 2012.

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

Installed and administered clustered 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).

Migration of SQL Server 2003 to SQL server 2008/2008R2 including installation and maintenance of the new migrated servers.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

Performed monitoring and tuning of SQL scripts, tasks included creation of upgrade scripts for production database and supported it.

Performed Log shipping, Database Mirroring, Replication for Preprod, Prod and Disaster recovery servers.

Worked on service desk tickets and incidents.

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

JPMC, Dallas, TX Oct 13 – June 14

Senior SQL SERVER DBA

JPMorgan Chase is one of the oldest financial institutions in the United States. With a history dating back over 200 years, JPMC are a leading global financial services firm with assets of $2.3 trillion. Operate in more than 60 countries. Have more than 240,000 employees. Serving millions of consumers, small businesses and many of the world’s most prominent corporate, institutional and government clients.

Responsibilities:

Production support for SQL server environment.

Responsible for MS SQL 2008 R2, 2005 and Sybase 11.9.2 ASE Installation, Configuration and Tuning.

Installing and configuring of SQL Server 2008 and 2008R2.

Configured and maintained database mirroring for high availability.

Implemented different types of Replication Models like Snapshot and Transactional.

Extensively worked on Dynamic Management Views (DMV’s).

Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS.

MigratedSQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008/2008R2 which include installing of SQL Server.

Involved in designing and deploying cubes in SSAS using Star Schema.

Patched server with latest SQL Server service packs and Cumulative updates.

Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.

Data retrieval done using XML data types

Performed DBCC utilities and fixed data corruption in User databases.

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

Created and managed schema objects such as tables, views, indexes, procedures, triggers & maintained Referential Integrity.

Migrated Data from Access, Oracle and Sybase databases to and from SQL Server

Setup, implement, and maintain industry standards in database management

Performed Server & Application fine-tuning & troubleshooting.

Monitored MS SQL Server performance and network issues.

Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.

Maintained Log Shipping, Mirroring and SRDF for disaster recovery.

Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.

Controlled user access rights, and managed data security.

Developed reports, sub reports, wrote complex queries for reports, used TFS for versioning of stored procedures, reports, configured data sources in SharePoint, native mode SSRS, troubleshoot issues in reports.

Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV’s, Wizards and SQL Profiler.

Documented application user guide for end users.

Maintained multiple instances SQL Servers with maximum availability.

Involved in 24x7 on call support.

Environment: MS SQL Server 2000/2005/2008/2008R2, Windows 2000/2003/2008R2, VERITAS Net Backup, TSQL, SharePoint, TSM, Redgate, EG Monitoring.

Cincinnati Children’s Hospital, OH Jan 12 - Sep 13

MS SQL Server DBA

The Division of Biomedical Informatics (BMI) at Cincinnati Children's Research Foundation offer resources and services to investigators at Cincinnati Children's and the University Of Cincinnati College Of Medicine. The division provides the core competencies, methods and technologies that are necessary for the acquisition, storage and analysis of biomedical data using high performance computational systems

Responsibilities:

Install and configure SQL Server 2005 and 2008 instances in both production and development environments on standalone and clustered environments (Active/Active and Active/Passive).

Configured SSAS SQL Server 2008R2 and maintained, monitored and scheduled Cubes processing, involved in manual processing upon requests and debugging the failures for the cube jobs.

Apply regular security fixes and service packs in a timely manner.

Upgraded/migrated most of the sqlserver 2000/ 2005 instances to sqlserver 2008

Deployed database changes accordance with change management policies and procedures.

Created Stored procedures and SSIS packages import the data from access, oracle databases to SQL Server

Migrated Data from Access, Oracle and Sybase databases to and from SQL Server

Used linked server’s on SQL Servers to import tables from other SQL Servers & oracle databases

Worked on REDGATE to compare databases across the environments and compare the data and synchronize all database objects.

Designed a Database and a Data Warehouse for the system using Star Schema.

Created automated scripts, SQL Jobs, Operators, Alerts and Mail Profile to monitor/generate report on the database health

Created the database maintenance plans for monitoring, optimization and integrity check.

Involved installation of SQL Server Analysis Services(SSAS) 2005/2008 by Using Setup.

Monitor daily backup of databases on production servers.

Monitor and schedule existing/ new jobs on production server.

Implemented the Partitioned Tables and Indexes in SQL Server 2005/2008

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Changed Sysadmin passwords automatically and periodically using password vault.

Handling Memory configurations for SQL Server 2000 and SQL Server 2005 on Windows 2003

Data migration from other data storage like Oracle and DB2 using SSIS.

Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL queries

Involved in monitoring performance and managing parameters to provide fast query responses

Create Views to access the tables and assign specific permission to the users

Monitored and managed database growth and capacity and tuned database performance using Performance Monitor, SQL profiler and quest spotlight.

Setup, implement, and maintain industry standards in database management

Assisted application analysts with report writing functions using SSRS as requested

Assisted application analyst in converting all applicable Microsoft Access databases to SQLSERVER

Configured and worked on SSRS in SharePoint integration and native mode

Coordinated with software vendors and performs all database upgrades

Implemented HIPAA security measures to monitor data security and activity.

Assisted application analysts to Facilitate inter-database access and report writing using SSIS and linked servers

Documented application user guide for end users.

Stored large documents in tables as XML types

Deployed and scheduled SSIS package

Create detailed documentation of all database administration policies and procedures and detailed troubleshooting documentation

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008,DB2, T-SQL, DTS, Windows 2003 Server, SSIS, SQL profiler, SSRS, TABLEAU, SharePoint, Redgate, Questlite Speed, VBScript, Veritas Netbackup, DBartisian, Quest spotlite, Password Safe, Terminal Services, IP Monitor, SQL Trace, BCP, DTS Import/Export, Visual Source Safe 2008,Profiler, Query Analyzer

Fifth Third Bank Cincinnati OH Aug 11 – Dec 11

SQL Server DBA/Developer

Fifth Third is one of the nation's leading financial institutions, lending and investment services to individual consumers, as well as to small businesses. It maintains users checking and saving account information, allows users to make a payment, transfer funds and customize reports for users and bankers.

Responsibilities

Create and maintain various databases for Development and Testing Environment using SQL Server 2005/2008 and involve in actual Relational Database Design for high OLTP environment

Installed and configured SQL Server 2008 and performed data migration from SQL Server 2005 to SQL Server 2008 through attach/detach and backup/restore method.

Worked with Client/Server tools like SQL Server Enterprise Manager and Query analyzer to administer SQL Server

Responsible for maintaining security by creating Logins and Users and assigning proper permissions

to various groups in both SQL server and Sybase.

Installed and configured SQL Server 2008R2 SSIS and SSRS and SSAS.

Created a database model by using Erwin 4.0 and also designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity

Implementation of Microsoft Office SharePoint Server 2007 Beta for corporate intranet, document management, collaboration.

Created scripts for tables, stored procedures, and DTS and SSIS, (SQL 2K5) tasks

Physical Implementation and application of Schema changes to SQL Server database using Power Designer View

Designed and built the dimensions, cubes with star schema using SQL SERVER ANALYSIS SERVICES (SSAS).

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Actively monitored performances of queries on SQL server using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language

Sending and Receiving the data and Images using XML technology

Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Good experience on working with Extract, Transform and Load (ETL) tool

Exposed to data conversion from different data sources to SQL server 2008 using SSIS

Using Import/Export wizard to move data from flat files and Excel sheets to SQL Server using SSIS

Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.

Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports

Administrative task including full and differential backups, database security by creating users and roles for login authentication and validating permissions

Environment: SQL Server 2008, SSIS, SSRS, Windows Server 2003, Visual Source Safe 6.0, SharePoint, C#, Visual Basic.

United Healthcare, India Dec 10 – Apr 11

SQL Server DBA

United Healthcare has a range of products and services that include medical imaging and information technologies, medical diagnostics, patient monitoring systems, drug discovery, and biopharmaceutical manufacturing technologies.

Responsibilities:

Actively participated in gathering User Requirements and System Specifications.

Filtered unnecessary data using complex T-SQL statements, implemented various Constraints and Triggers for data consistency.

Created Views to facilitate easy user interface implementation, and Triggers on them to facilitate consistency Data entry into the database.

Created Reports from database onto excel spread sheet using DTS.

Wrote complex stored procedures to process employee’s requirements and generating records between front end and back end.

Created various reports using Crystal Reports after performing Data Analysis

on the various Views of Business Intelligence.

Environment: SQL Server 2000, Windows NT 4 Platform, EXCEL, Erwin 3.x, Crystal Reports 9.

Contact this candidate