Sql Server Power Plant

Kesava Reddy

*****.******@*****.*** / 203-***-****

SUMMARY

• Over 9 years of IT experience in Database Administration, Application Developer and System

Administration in various domains like Transportation, Aerospace, Heavy Earth movers, Energy

Solutions etc

• Experience in Installation, Configuration, Maintenance and Administration of SQL Server

2012/2008/2005/2000.

• Experience in upgrading SQL Server from version 2000/05/08/08R2 to 2005/08/12 versions.

• Experience of up gradation and migration from earlier version of SQL Server to SQL Server 2005,

SQL Server 2008/08R2, SQL Server 2012 in different environments.

• Strong in SQL, T-SQL and PL/SQL Database programming - development of stored procedures,

cursors, triggers & Views.

• Have good experience with partitioned schemas, partitioned tables and indexes, creating file

groups using SQL Server 20005/08/12.

• Good experience with SQL Server 2005/08/12 online Indexing and Recoveries features.

• Good experience with implementing DR solution, High Availability of database servers using

Database mirroring and replications and Log Shipping.

• Experience in implementing SQL Server security and Object permissions like maintaining

Database authentication modes, creation of users, configuring permissions and assigning roles to

users.

• Created maintenance plans to perform index de-fragmentation, re-indexing and update the index

statistics.

• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS and SSIS, SSAS, SSRS

Packages.

• Experience in implementing different types of Replication Models like Snapshot, Merge and

Transactional on basis of business specification.

• Experience in performing integrity checks. Methods include configuring the database

maintenance plan wizard and DBCC utilities.

• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics,

index tuning wizard.

• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long

running queries and deadlocks.

• Experience in applying patches and service packs to keep the database at current patch level.

• Good experience with Analysis Services, Reporting Services, and SQL Server Clustering.

• Expert Level skills in providing 24x7 support in Production, Preview and Development

environment.

• Have hands on experience of Cluster migration from 2005 to 2008/12.

• Designing and Developing Web forms using C#, ASP.Net 3.5, HTML, XML, LINQ, WCF, java

script, Ajax Tool kit, silver light

CERTIFICATIONS:

Microsoft® Administering Microsoft SQL Server 2012 databases

•

Microsoft® Querying Microsoft SQL Server 2012

•

Microsoft® Implementing a Data Warehouse with Microsoft SQL Server 2012

•

TECHNICAL SKILLS

Operating Systems: Windows 2000/2003/2008 Server, Windows 98/XP/NT/Vista/7

Databases: MS SQL Server 10.0/7.0/2000/2005/2008/2012

Languages: T-SQL, PL/SQL, C, C#, VS 2005/08, ASP.net 3.5.

SQL Server Tools: Management Studio, Business Intelligence Development Studio,

Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler,

Performance Monitor, DTS, Log Shipping, Server Network Utility,

Database Tuning Wizard, Index Tuning Wizard, SSIS,SSAS, SSRS

Microsoft Clustering Services (MSCS)

Report Tools: MS Reporting Services

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export

Wizard

Database Modeling & Other Tools: SQL Compare, SQL Trace

PROFESSIONAL EXPERIENCE

GE- Digital Energy, Chicago, IL Nov 2011 – Till Date

SQL Server DBA

GE Digital Energy, a division of GE, is a major solutions provider and thought leader in the effort to

modernize and optimize how we generate, move and consume energy. GE global team of more than

5,000 employees are inventing, improving and integrating communications, automation, and power

delivery technologies to give the century-old electric infrastructure new capabilities, unheard of just a

generation ago. GE provide products & services from the Power Plant to the End Power Consumer

(Commercial, Industrial and Residential)

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server

2005/08/08R2/12 on windows 03/08/08R2 Servers.

• Successfully upgraded the databases from SQL Server 2005/08/08R2 to SQL Server 08/12.

• Monitoring and Troubleshooting jobs in Production, QA and Development environment.

• Implemented MBSA 2.1 in all the environments to monitor the windows/SQL Server patches.

• Responsible for Database support, troubleshooting, planning and migration. Resource planning

and coordination for application migrations with project managers, application and web app

teams. Project involved guidance and adherence to standardized procedures for planned data

center consolidation for worldwide centers using in-house corporate and third party applications

based on SQL 2005 in upgrade project to SQL 2008/08R2/12.

• Monitoring of database size and disk space in Production, Staging & Development environments

• Conducted various meetings and conferences with application teams to meet corporate

milestones for database consolidation and data migration. Security and architectural planning

issues met as well as testing and training.

• Performed installation of SQL Enterprise 2008/08R2 64bit version on Windows 2008/08R2

servers on Enterprise systems of clustered and standalone GE servers in enterprise Data

Centers Patch applications.

• Failover cluster testing and resolution on GE servers as well as monitoring and backup reporting

setup with Microsoft Operations Manager and backup teams.

• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as

well as basic account management and troubleshooting with connectivity, security and firewall

issues.

• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.

• Configured Database mail, linked servers in SQL server 2005/08/12.

• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to

SISS package conversions. Business Intelligence package design. Created tables and performed

data imports and restores for successful migration. Scripting development and troubleshooting for

various security syncing scripts to new databases as well as creation of database roles for

granting Stored Procedure rights.

• Installed and configured SQL Server Cluster server in SQL Server 2008/12.

• Generated Reports based on SSRS as a Database Administrator

• Performed Production support and on Call duties.

• Executed Change management scripts on weekly basis.

• Created monitoring scripts to alert for production issues.

Environment: SQL Server 2005/08/12, Windows 2000/2003/2008/08R2 Servers, T-SQL, PL/SQL

Developer Tool. SSIS, SSRS

GE-GETS, Jacksonville, FL

Sr SQL Server DBA Sep 2010 – Oct 2011

GE Transportation, formerly known as GE Rail, is a division of General Electric. The organization

manufactures equipment for the railroad, marine, mining, drilling and energy generation industries. It is

headquartered in Chicago, Illinois while their main manufacturing facility is located in Erie, Pennsylvania.

Locomotives are assembled at the Erie plant, while engine manufacturing takes place in Grove City,

Pennsylvania.

Responsibilities:

• • Performed server installation and configurations for SQL Server 2005 and SQL Server 2008.

• • Performed installation of SQL Server Service Packs.

• • Upgraded databases from SQL Server 2005 to SQL Server 2008.

• • Involved in capacity planning, sizing and database growth projections.

• • Scheduled Full and Transactional log backups for the user created and system databases in

the production environment using the Database Maintenance Plan Wizard.

• • Setup backup and restoration jobs for development and QA environments

• • Created transactional replication for the reporting applications.

• • Implemented disaster recovery solution at the remote site for the production databases using

Log Shipping.

• • Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index

statistics on the production databases.

• • Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and

improved the database server performance.

• • Used SQL Server Profiler to monitor and record database activities of particular users and

applications.

• • Used DBCC commands to troubleshoot issues related to database consistency.

• • Used Index tuning wizard to redesign and created the indexes for better performance.

• • Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

• • Streamlined the server/database level security by creating the Windows and SQL logins with

the appropriate server/db roles and object level permissions.

• • Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract

Transform Loading (ETL) tool of SQL Server to populate data from various data sources,

creating packages for different data loading operations for application.

•

• Worked on upgrading DTS packages to SSIS packages.

• • Implemented trigger and stored procedures and enforced business rules via checks and

constraints.

• • Worked with various business groups while developing their applications, assisting in database

design, installing SQL Server clients, phasing from development to QA and to Production

environment.

•

• Reviewed DB Scripts from the development team before releasing them into the Production.

Environment: Windows 2003 Server, SQL Server 2005, SQL Server 2000,T-SQL, PL/SQL, JavaScript,

MS IIS Server 5.0, SOAP, HTML/DHTML, XML

BOMBARDIER, Philadelphia, PA Aug 2009 – Sep 2010

SQL Server DBA/Developer

Bombardier Inc. is a Canadian multinational aerospace and transportation company, starting as

a maker of snow machines or snowmobiles, over the years it has been a large manufacturer of

regional aircraft, business jets, mass transportation equipment, recreational equipment and a

provider of financial services. Bombardier is a Fortune Global 500 conglomerate company.

Description: Bombardier is a Canada based Aerospace leading company. We handled a very big

database for Aerospace Management.

Responsibilities:

• Management of SQL Servers, databases, storage management for databases sizing from

25GB to 40GB.

• Responsible for General Database Administration and Performance.

• Data Migration from legacy to master tables using DTS-import and Export wizard.

• Trouble shooting Problems by using SQL server profiler.

• Updating with latest service packs and security patches.

• Created views to facilitate easy user interface implementation, and triggers to enforce Data and

referential integrity.

• Created indexed views in T-SQL to increase the query performance.

• Develop Backup & Restore scripts for SQL Server as needed.

• Created reports using SQL Server Reporting services.

• Has done DBCC checks to ensure the physical consistency of the database and objects.

• Checking Space monitoring, Index Defrag, Update Statistics, Log Shipping between Primary

production servers and Standby.

Environment: Windows 2000 server, VB6.0, XML, SQL Server 2000, Erwin 4.0, T-SQL, SQL Server

Reporting services.

ELD & FLD, Peoria, IL March 2008 – Aug 2009

Company: Caterpillar, IL SQL Server DBA/Developer

Caterpillar Inc. is an American corporation which designs, manufactures, markets and sells

machinery and engines and sells financial products and insurance to customers via a worldwide

dealer network. Caterpillar is the world's leading manufacturer of construction and mining

equipment, diesel and natural gas engines, industrial gas turbines and diesel-electric

locomotives. Caterpillar was ranked number one in its industry and number 44 overall in the

Fortune 500.

Responsibilities:

• Creating and maintaining various databases for Production, Development and Testing use SQL

Server 2000.

• Installing SQL Server 2000 on the server and client machines, providing connections and

managing databases.

• Planning and scheduling backups and developing recovery procedures.

• Migration of data across different databases and different servers.

• Creating procedures, functions, and triggers, handling database performance and tuning.

• SQL Server Installation, patch application, migration of databases.

• Creation of new databases, planning the location of data, index, and Transaction log files on

disks.

• Setting up backups for the databases.

• Providing support to the Application developers on the application databases.

• Handled 24/7 Production Issues.

Environment: MS SQL Server 2000, Windows 2000 Advance Server, MS Office.

GE-GETS, Jacksonville, FL June 2006 – Feb 2008

Company: Satyam Computers Ltd, NJ

C-wind is a software application to track and monitor the work orders. The application will help in the

entire lifecycle of the work request from creation through execution till closure. All kinds of metrics get

tracked in this application that can be tracked at any instant by the user. An important feature is the

dynamic resource loading status, which shows resource availability to the user at any point of time.

Metrics generated in this tool are used for all purposes: Project Management, Projections, Team

Performance, Team utilization and this application also has Document Repository & Action Items Track

as additional features.

Responsibilities:

• Involved in creating Requirement Specification and the architecture of the solution

• Gathered requirements from the business users, created technical specification documents.

• Database creation; database tuning, performance planning, backup planning and database

administration.

• Transformed data from various data sources such as Excel and text files

• Designing and Developing Web forms using C#, ASP.Net 3.5, HTML, XML, LINQ, WCF, java

script, Ajax Tool kit, silver light

• Designed and Developed the .NET GUI for the user interface using ASP.NET Web Forms.

• Used SQL Server 2005 database for data storage. Created tables, Reports and Queries

• Creation of various data objects like tables with constraints, added relationship, created stored

procedures with cursors, added indexes using T-SQL.

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

Administer SQL Server.

• Developed web pages with data bound controls like DataGrid, DataList and DataRepeater using

the methods Data Binding

• Created and developed global custom Client side scripts using Java Script, depending on the

requirements and DHTML Scripts, CSS (Cascading Style Sheet) for User Interface and Server

side scripts from Server side Validations.

• Have to use Ajax Controls for the Partial Page Refresh extensively.

• Troubleshooting the application in production environment without scarifying the uptime and

services.

• Code Review, Unit testing, Debugging and Integration testing of the application. Also analyzed

the business and design the screen flow of the application.

• Involved in to publishing & deploying the application. Creating end user documents.

• Involved in Developing ASP.NET Web Services using C#.NET as per the client requirements.

Environment: C#, MS – SQL Server 2005, ASP. Net 3.5, IIS, ADO.Net 3.5, VSS, Visual Studio

2003/2008, Windows XP, Excel, MS Word

Tensor Software Solutions Ltd,

June 2004 – June 2006

Bangalore, INDIA

SQL Server DBA/Developer

Responsibilities:

• Installation, configuration and maintenance of the MS SQL Server 2000.

• Migration of SQL server 6.5 to 7 and from SQL server 7 to 2000.

• Performance and tuning of SQL servers and application issues related to migration.

• Testing of applications for performance, data integrity and validation issues.

• Data Transfers between various servers using BCP and Managing Disk space on NT systems.

• Migrated oracle8i data into SQL Server 2000.

• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and

weekly basis.

• Complete automating on NT so that the tasks are run without user monitoring.

• Writing the stored procedures, checking the code for efficiency. Routine backups and

restoration.

• Administrative and Production support for various applications in all environments.

• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and

Contingency plans. Testing and implementing these procedures.

Environment: SQL Server 2000, SQL server 7, SQL server 6.5, T-SQL, Oracle PL/SQL, Query Analyzer,

SQL Profiler, Windows 2000 Server, Import & Export Data, TOAD.

EDUCATION:

Bachelor of Engineering (Mechanical Engineering) from Jawaharlal Nehru Technological University, India

- 2004.

Contact this candidate