SUMMARY

• Over Seven Years of solid working experience in SQL Server Database Administrator performed in Production, Test and Development of MS SQL Server 2008/2005/2000 and MS SQL Server 7.0 with functional experience in industries like IT, Government, Health, Insurance, Banking, Telecom and Finance environments.
• Microsoft Certified Technology Specialist (MCTS) - Microsoft SQL Server 2005 Implementation & Maintenance (70-431) and Microsoft SQL Server 2005 Business Intelligence Implementation and Maintenance (070-445).
• Microsoft Certified IT Professional (MCITP) - Designing a Database Server Infrastructure by Using Microsoft SQL Server™ 2005 (70-443) and Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server™ 2005 (70-444).
• Access my MCP Transcript by providing “Transcript ID (833643) and Access Code (garikipati)”.
• Experience with Software Development Life Cycle (SDLC) and project methodologies.
• Extensive experience with data modeling, dimensional modeling, logical and physical database design.
• Solid working experience in SQL Server database administration and development performed with DBA duties all in enterprise environment.
• Extensively worked in OLTP & OLAP environment that includes production (24x7), QA and development databases in SQL Server.
• Excellent T-SQL programming skills.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance monitor, DBCC commands and troubleshooting.
• Experience in an operation environment providing support involving coordination with release management and change management.
• Successfully migrated SQL Server 7.0 to 2000, few SQL server 2000 servers to 2005, including Replication and cluster SQL Servers.
• Experience in backup and disaster recovery procedures.
• Good understanding of ACID properties, ERD, RDBMS, Normalization/ Denormalization, Normal Form, database modeling and referential integrity.
• Familiarity with Data warehousing and analysis skills: ETL tools, OLTP, OLAP (MOLAP, HOLAP, DOLAP, and ROLAP).
• Strong experience in design and construction of EDSS using the data marts, data views, data warehouse and data mining.
• Extensively worked and had good knowledge on Integration and Reporting services and good experience in data migration from Oracle/Access/Excel sheets to SQL Server 2005/2000/7.0 .
• Experience in using different Transformation tools like DTS packages, BCP, and BULKINSERT, familiarity with SSIS.
• Installed and Configured SQL Server Reporting Services (SSRS), and have developed complex queries for generating tabular and matrix type of reports.
• Experience in Replication - Snapshot, Merge and Transactional.
• Successfully designed logical and physical database models using ERWIN data modeler; designed initial database migration plans and procedures for migrating data.
• Experience and outstanding knowledge of high availability, high production SQL Server solutions, including replication, database mirroring and SQL Server clustering.
• Proficient with SQL Enterprise manager, SQL Query analyzer, scheduling jobs with SQL Server Agent and restoring databases.
• Extensively worked on MS Dotnet concepts such as ASP.Net, C# and VB.Net.
• Excellent inter-personal, communication and problem solving skills.

Certificate of Excellence from Microsoft

• 070-431: Microsoft SQL Server 2005 - Implementation and Maintenance (MCTS id: 6622538).
• 070-443: Microsoft SQL Server 2005 - Designing a Database Server Infrastructure.
• 070-444: Microsoft SQL Server 2005 - Optimizing and Maintaining a Database Administration.
• 070-445: Microsoft SQL Server 2005 - Business Intelligence - Implementation and Maintenance.

TECHNICAL SKILLS

Operating Systems

Windows 2000 Server, Windows 2000 Advanced server, Windows 2003 Server SP3, Windows ME/NT/XP/Vista, Unix (Sun Solaris).

Languages

C/C++, PL/SQL, T-SQL, ASP.NET, ADO.NET, VB.NET, C#.NET, PERL, Unix shell scripting

Databases

SQL Server 2008, 2005 & 2000 & 7.0, DB2, MS-Access 2000/2003/2007 , Oracle 9i & 10g, Sybase, MySQL

Database Tools

Enterprise Manager, Management Studio, Query Analyzer, SQL Server Profiler, SQL Server Upgrade Advisor, SSIS, SSRS, DTS, ETL, BCP, ODBC, SQL OLEDB, Business Intelligence Development Studio (BIDS).

High availability Tools

Microsoft Clustering Services (MSCS), SQL Server Clustering, Database Mirroring, Log Shipping, Replication.

Web-Applications

HTML, PHP, MS FrontPage.

Other Tools

Erwin Data Modeler, MS Office 2003/2007, Microsoft Visual Studio 2003/2005, Red gate tools, Microsoft Visio, Microsoft Visual Source Safe, Team Foundation System, SQL LiteSpeed, Robocopy, Tivoli.

Web Servers

IIS 7.0, Apache, Tomcat

EDUCATION

• Bachelor of Technology in Computer Science,

PROFESSIONAL EXPERIENCE

Confidential, Mechanicsburg, PA Apr 2008-Till Date SQL Server DBA

Confidential is headed by the Court Administrator of Pennsylvania. CONFIDENTIAL is the administrative arm of the Pennsylvania Supreme Court. It deals with projects related to Pennsylvania Courts like PACMS, CPCMS, and MDJS. These applications are mainly used by the judges and court staff to enter new cases and to search for old cases related to traffic and civil cases.

My duties involved controlling access, performance monitoring and tuning of the databases, developing and implementing maintenance procedures and a database backup and restoration plan, and planning and coordinating database security measures. Further, I was responsible for the design and development of databases and respond to any technological innovation.

Responsibilities:

• Installing and configuring SQL Server 2000, 2005 and 2008(32 and 64 bit) on Standalone and Microsoft Clustered servers.
• Applying latest Service Packs and Hot fixes and successfully Upgrading of SQL Server 2000 to SQL Server 2005 and SQL Server 2008.
• Created SSIS / DTS packages to pull data from Oracle, Access and Flat Files.
• Created and scheduled jobs to setup log shipping between production servers.
• Created databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Involved in Data modeling; designing and building relational databases.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Creating and managing schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Created Linked Servers between SQL server 2000 and 2005 servers.
• Created a mirrored database on the report server using Database Mirroring with high performance mode.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
• Day-to-day activities like taking backup (or schedule the backups daily/weekly/monthly for database using Red gate SQL backup tool) on disk and restore the databases and transaction log onproduction/development servers as per requirement.
• Place the huge table/non-clustered index on the separate file group to improve the performance.
• Created cluster/non-cluster indexes on the tables, create views, cursors, tables, stored procedures and triggers. Trace out for any table required any indexes and determine the type of index on it.
• Working closely with Application Developers in optimizing the query performance, Tuning stored procedures taking long time in production environment and performance monitoring using SQL Profiler.
• Involved in database designing using Normalization.
• Designed databases for different projects and resolve database issues.
• Monitoring system performance and suggest for system upgrade like disk, processor, and memory.
• Schema Changes to the database as per application team requirement.
• Database Maintenance by script/wizard for SQL 2005 and 2000
• Used DTS/BCP, BULK INSERT for data transfer.
• Query Optimization for SQL queries.
• Worked on data access layer using ASP.Net, ADO.Net and C#

Environment: MS SQL Server 2005/2000/7.0 , Windows 2000/2003 Server Operating systems, SSIS, SSRS, SSAS, Clustering, Performance Tuning, MS Sql Reporting Services, Change Management System, Remote Desktop, HTML, MS Access, Tivoli Storage Manager

Confidential, Fort Lauderdale, FL Jan 2007 - Mar 2008

SQL Server DBA

Confidential.com is building a global online diet, fitness and motivation destination to provide consumers with solutions that help them realize life\'s full potential. Confidential.com, Inc. is a premier online diet, fitness, and healthy living destination offering professional advice, information, products and services to those seeking to improve their health and longevity. Since 1997 over 2 million consumers worldwide have become Confidential.com members.

Responsibilities:

• Installation and configuration of SQL Server 2005 and windows NT/2000
• Create the database and manage the database location files and size.
• Creation of schema objects, rules and granting of roles to the users.
• Created a mirrored database on the report server using Database Mirroring with high performance mode.
• Using Red gate SQL Compare tool to compare code in development and production environments.
• Generated different reports using MS SQL Reporting Services.
• Setup for SQL Server replication and managing replication
• Worked and coordinated with developers in writing and tuning new stored procedures.
• Worked on SSIS packages to import the data from Oracle, Access and text files.
• Responsible for stored procedures optimization, performance tuning and index tuning.
• Created Service Broker Programs to continuously load data from the mirror database to the report database.
• Strong experience in design and construction of Enterprise decision Support System (EDSS) using both data marts and data views.
• Create the cluster/non-cluster indexes on the tables; create views, stored procedures, and triggers. Trace out for any table required any indexes and determine the type of index on it.
• Creatednumerous SSIS Packages for transferring and manipulating data from existing SQL databases, Oracle data sources, flat files, access DBs and excel files using various connections, tasks, Global Variables
• Responsible for change managements, created the documentation for SQL server and service packs installations.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution
• Performed daily backups and developed recovery procedures.
• Created procedures, functions, and triggers.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Used Windows Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
• Creation of new database, planning the location of data, index, and transaction log files on the disks.

Environment: Windows NT/2000 Server, SQL Server 2005/2000, SSIS, SSRS, Clustering, Performance Tuning, MS SQL Reporting Services, TSQL, DTS, Data warehousing.

Confidential, Newark, NJ Jan 2006 - Dec 2006

Confidential, one of the leading firms which provides services like providing stock rates for various clients in form of reports, assets management for the clients worldwide. As a SQL DBA my responsibilities included upgrading to newer version of database, database maintenance, user management and I was always available 24x7 for technical support. I worked in Distributed operations as a MS SQL Server database Administrator. Our group is responsible for all MS SQL Server databases Production support and implementing SQL server application Architecture. Our group maintained over 150 SQL servers this includes (Production & Staging servers). We have another 50 development servers. Production support is 24x7.

Responsibilities:

• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and problems related to the privileges.
• Responsible for Database Backups & Restoration, Backup strategies and scheduling Backups.
• Conversion of the legacy systems data into MS SQL server using DTS packages.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Designed databases for different projects and resolve database issues.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Involved in planning and monitoring Log Shipping.
• Planning, Implementing and troubleshooting Replication.
• Created SSIS Packages to migrate slowly changing dimensions
• Generated different reports using MS SQL Reporting Services.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from Database
• Addressed the Replication Issues. Created new replications, DTS packages to maintain high availability of the data between the servers.

Environment: T-SQL, SQL Server 2000/2005, DTS, BCP, MS Reporting Services, Performance Tuning, Clustering, Bulk Insert, HTML, DHTML, PL\\SQL, Windows 2000.

Confidential, California, CA Sep 2004 - Dec 2005

SQL Server DBA

Confidential. is a premier global financial services firm with assets of $715 billion and operations in over 60 countries. The firm is a leader in investment banking, asset management, private equity, consumer banking, private banking, e-finance, custody and processing services.

Responsibilities:

• Involved in Data modeling; designing and building relational databases.
• Creating and managing schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Responsible for MS SQL Server 2000, configuration, tuning and provide 24 X 7 dedicated support to all Production, development and clustered servers.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured Transactional replication between Primary Server and three Read–Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Additionally, designed and implemented a disaster recovery system.
• Configured the Log shipping and created the Standby server.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Created the logical and physical data modeling using Erwin tool.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• When we had 5000 user connections solved latching issues by creating multiple servers (Read – Only Servers) using replication.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
• Expertise in Security Issues such as creation and granting permissions on various Objects.

Environment: SQL Server 2000 Enterprise, Windows Enterprise Server 2003, IIS 6.0, C#, OLAP, VB.NET, .NET, Erwin, Microsoft Visual Studio 2005, FTP, Crystal Reports.

CONFIDENTIAL, Washington DC Dec 2003 – Aug 2004

SQL Server DBA

The Pan American Health Organization is a part of World Health Organization (CONFIDENTIAL/WHO). They have 32 branches in the North America. This project contained several modules like Budget, Obligations, Payments, Procurements, Inventory, Documents, etc.

My responsibilities in this project were to design, develop, and implement all databases including stored procedures, triggers, and complex queries used in this project. Also, responsible for the administration of various enterprise databases in both development and production environment, including performance monitoring and tuning, database maintenance, backup/recovery, data consistence check, security administration, data quality, documentation, and technical support.

Responsibilities:

• Involved in Analysis and Design Documentation, gathering User requirements and maintaining good documentation.
• Supported production and development databases.
• Performance tuning in Database level, T-Sql level and operating system level.
• Converted the Old systems data from mainframes by using DTS packages.
• Developing SQL scripts for maintaining administration tasks.
• Creating DTS packages to maintain central repository.
• Extensively used different SQL2000 DTS tasks.
• Replication between field offices and Headquarters, merge replication, snapshot replication by creating all the necessary scripts for publication and Subscription maintaining replication servers and backup and recovery plans.
• Performance tuning in Database level, T-SQL level and operating system level.
• Designing some Excel databases and converting them into SQL databases.
• Upgraded all the servers from 7.0/2000
• Using the new features in DTS SQL 2000 and upgraded all the packages. Simplified the DTS functionality by using different tasks in SQL2000.
• Implementation of fail over clustering. Implementing warm stand by servers and raid 1–5 technologies.
• Involved in network issues maintain communication with field offices Installing FTP services.

Environment: Windows 2000/NT4.0, MS-SQL Server 7.0/2000,Erwin3.5.2/4.0, .Net, vb.net, VB Script, Visual Source Safe and FTP Communication, Replication, DTS.SQL DMO.

Confidential Jul 2002 – Nov 2003

SQL Dev/ DBA

One of the service providers of mobile telephony in India Confidential is the brand name of Confidential. Confidential is presently operating in the states of Punjab and Karnataka i.e. in 2 circles of 23 Telecom Circles of India.

My responsibilities involved in the usage, accuracy, efficiency, security, maintenance, administration, and development of all CO databases in production, development, and test environment, including hardware configuration, software installation, database optimization, performance monitoring and tuning, database maintenance, backup/recovery, data consistence check, security administration, and data cleanse. Responsible to design and implement CO databases including tables, relationship, stored procedures, views, user-defined functions, triggers, complex queries, and the indexes for mission-critical business applications. Also responsible to monitor and tune large databases for performance and availability, modify database structures, develop database backup/recovery procedures, and provide support and guidance to operational models.

Responsibilities:

• Installing and Configuring of SQL Server 2000/7.0 0n windows 2000/NT OS.
• Implementing 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.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Managing of databases objects like tables, views, indexes.

Environment: Windows 2000, MS-SQL Server 7.0, Internet Information Server 4.0, FTP Communication.