Sri

571-***-**** oaq6zu@r.postjobfree.com

SUMMARY

Over 7 years of solid working experience in SQL Server database administration and development.

• Certified MS SQL Server 2005 Database Administrator (MCITP-DBA).

• Certified SQL Server Administrator through BrainBench.

• Best Performance Award winner in TCS.

• Experience with software development life cycle (SDLC) and project methodologies.

• Extensive working experience in various industries Financial, banking, marketing services, and healthcare industry, including designing, implementing, maintaining, and documenting complex database applications.

• Performed Capacity Planning, data modeling and Logical/Physical database Design.

• Experience in Database Backup, Recovery and Disaster Recovery procedures (Clustering, Log Shipping, Replication and Mirroring).

• Installed and configured windows 2000/ 2003 cluster.

• Experience in installing and configuring SQL Server 2005/2008 Clusters in Active/Active and Active/Passive.

• Involved in Migrating the SQL Server 2000 to SQL Server 2005 and SQL server 2005 to SQL server 2008 (Side by Side).

• Experience with SQL Server 2005/2008 installation, administration.

• Experience with SQL Server 2005 installation, configuration, SSIS, SSRS and administration.

• Installation and Configuration of SSRS with Microsoft office SharePoint Server in Integrated mode.

• Proficient with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, DTS, SSRS and SSIS.

• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including Database Mirroring, SQL Server Logshipping and SQL Server clustering.

• Experience in Replication – Snapshot and Transactional and extensive knowledge in Merge replication.

• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.

• Proficient in SQL programming, physical database design, and SQL Performance tuning, replication.

• High level plan for securing all the databases and better control for all SQL Servers.

• Involved in creation of linked servers using remote user account.

• Proficient with database backup and recovery models.

• Experience with Normalized and de-normalized database design.

• Industry working experience in SQL Server and Oracle database management, maintenance, and troubleshooting.

• Experience with monitoring, troubleshooting related issues.

• Worked on VMware machines.

Technical Skills:

Relational Databases : SQL Server 2000/20005/2008, Oracle 9i, Oracle 8.0, MS Access , DB2, SQL*PLUS

Operating Systems : UNIX, Windows 2000 Server, Windows 2003 Server, Windows NT

4.0, Windows XP

Languages : C, PL/SQL, Java, VB 6.0 and T-SQL

Web Technologies : Web Services, HTML, DHTML, Java Script,

VBScript, IIS 4.0, IIS 5.0, Application Server

Other Tools : Crystal Reports, Test Director 7.0/7.5/8.0, PVCS Tracker 7.0,

Rational Clear Quest

EDUCATION : Bachelors in Computer Science Engineering

Certification : Microsoft Certified Database Administrator (MCITP-DBA)

Certified SQL Server Administrator through Brain Bench

PROFESSIONAL EXPERIENCE:

Client: Toyota Motor Manufacturing North America, KY Aug’ 09 to till date

Sr SQL Server Administrator

Toyota Motor Manufacturing North America is the epicenter of Toyota Motor's ever-encroaching dominance in the North American car market. It is responsible for engineering design, research and development, and manufacturing activities in the US, Canada, and Mexico. Formerly Toyota Motor Manufacturing North America, TEMA develops the upper body portion, as well as parts, for the adaptation of Toyota vehicles to the North American market.

Responsibilities:

• Installed and configured SQL server 2008 active/passive cluster.

• Successfully migrated around150 databases from 2005 to 2008 including DTS packages to SSIS.

• Worked on implementing the Mirroring concept on all the production servers.

• Configured Transactional log replication and Snapshot replication.

• Initiated, managed and coordinated database change control items to predictably modify the database environments.

• Involved in Installation of Quest tool for all the Prod, UAT and Dev servers.

• Monitoring Performance Analysis and Capacity Manager on all servers using quest tool.

• Designed and developed security strategies for interfacing databases with application software.

• Involved in database security to strengthen, so that application access and distributed access apply the minimum privilege.

• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.

• Worked on creating the new linked servers and also changed the existing linked server’s remote user to a new account.

• Changing the startup account form local system account to windows domain account for all the Servers.

• Performed data backup, recovery and transfer operations and worked on developing disaster recovery strategies.

• Involved in T-SQL query tuning.

• Involved in the creation and maintenance of indexes, tables and other database objects.

• Designed and developed ETL processes using SSIS to receive customer files from data warehouses and load them into transaction processing systems.

• Involved in creation and maintenance of Users, roles, groups and their privileges.

• Involved weekly meeting to discus about the project status, issues and achievements.

Environment: Windows 2008/2003, MS-SQL Server 2008/2005/2000, Clustering, Replication, DTS, SSIS, SSRS, Visual Studio, HTML, Site Scopes monitoring tool and SQL Safe Backups tool, , VMware machines.

Client: Baldor Electric Co. AR. Nov’ 08 to Jul’ 09

Sr SQL Server Administrator

Baldor Electric Company designs, manufactures, and markets industrial electric motors, mechanical power transmission products, drives, and generators. Its industrial electric motor products include AC and DC electric motors, and a line of integral gear motors; and mechanical power transmission products.

Responsibilities:

• Providing 24/7 on call support for all the Production servers.

• Used upgrade advisor tool to check any prerequisites steps to be taken before migrating the Databases.

• Involved in Migration of SQL Server 2000 to SQL server 2005 and some servers from 2005 to 2008.

• Migrated DTS packages to SSIS packages.

• Involved in Capacity Planning, data modeling and Logical/Physical database Design.

• Installation of SQL server 2005, SSRS and SSIS.

• Involved in configuration of SSRS with Microsoft office SharePoint Server in Integrated mode

• Administering the MS SQL Server 2005 & 2008 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

• Worked on Site Scopes Monitoring tool and SQLSafe Backups tool.

• Involved in setting up Database Mirroring with and without witness Server in SQL server 2008 (Manual / Automatic fail-Over).

• Configured and maintained Transactional and Snapshot replication.

• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.

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

• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.

• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

• Database Refresh from Production backup to Stage and Development environments

• Working with ITSM Tickets (Any changes on Production, staging and development environment need to Create ITSM Tickets).

• Developed few reports using MS SQL Reporting Services.

• Worked on critical issues on production servers with the help of Microsoft tech support.

• Extensive experience on VMware machines.

Environment: Windows 2003/2000/NT4.0, MS-SQL Server 2005/2008, SSIS, SSRS, Site Scopes monitoring tool and SQLSafe Backups tool, Clustering, VMware machines.

Client: Fox Racing. CA. Dec’ 07 to Oct’ 08

Sr SQL Server Administrator

The Fox brand is the most recognized and bestselling brand of motocross apparel in the world. Fox built its business by developing clothing for the high intensity, physically demanding motorsport of motocross. Fox has created the best motocross riding apparel in the world, which is able to withstand the elements and the tortuous racing conditions that are a major part of motocross.

Responsibilities

• Installed and Configured SQL Server 2005 and 2000.

• Supporting Applications with SQL Server 2008 & 2005 Databases across Many Locations all over United States.

• Installation of MS SQL 2005 & 2008 Enterprise servers on production, Test and Development boxes.

• Planned and Successfully Implemented SQL Server 2005 on the Production, Test and Development Servers.

• Successfully Installed the Service Pack 1 and Hot-fix for SQL Server 2005 in all the Dev and Prod Environments.

• Administering the MS SQL Server 2005 and 2008 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

• Involved in Migrating the existing database to SQL Server 2005 (Side by Side).

• Created a mirrored database on the report server using Database Mirroring with High Performance Mode.

• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.

• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.

• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.

• Involved in DTS Package, DTS Import/Export for transferring data.

• Involved in implementation of replications like Snapshot and Transactional.

• On call 24/7 support to databases on weekly rotation.

• Created SSIS Packages to migrate the data from database to Text files.

• Generated different reports using MS SQL Reporting Services and Crystal Reports.

Environment: Windows 2003/2000/NT4.0, MS-SQL Server 2005/2008, SSIS, SSRS, System Monitor / Performance Monitor, DTS, Performance Tuning, Clustering, .net, VB Script and Visual Source Safe.

Client: GE Health Care, AL Feb’ 07 – Nov’ 07

SQL Server DBA

GE Healthcare has a broad range of products and services that include medical imaging and information technologies, medical diagnostics, patient monitoring systems, performance improvement solutions, drug discovery, and biopharmaceutical manufacturing technologies. These enable healthcare providers to better diagnose and treat cancer, heart disease, neurological diseases, and other conditions earlier. The company's vision for the future is to enable a new "early health" model of care focused on earlier diagnosis, pre-symptomatic disease detection and disease prevention.

Responsibilities

• Providing 24/7 On-Call support for critical production databases of GE Health Care and GEASP Datacenters

• Proactive monitoring of production databases

• Responsible for General Database Administration, Query Performance tuning, and validated some of the existing schema.

• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

• Loaded the data from multiple systems to the Reporting Data warehouse database.

• Expertise on SQL Diagnostic Manager Tool which can be configured for all production databases

• Reporting and resolving serious SQL Server alerts.

• Refreshes from Production backup to Stage and Development environments

• Working with workflows (Any changes on staging and development environment need to assign workflow this is GEHC Standards)

• Working with Change Controls (Any changes in Production database need to assign Change control this should be approved by Global DBA team after changes made in stage and development environment)

• 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 (Oracle and Text format data) to SQL Server.

• Using SSIS, Experience in data transformation domain.

• Worked Windows2000 Cluster environment (Active/Active and Active/Passive).

• Verifying all instances are up and Running.

• Verifying all error log files for any new entries.

• Login creations and assigning roles

Environment: MS SQL Server 2000, Windows 2000/2003 server, Windows NT 4.0, T-SQL, DTS, Clusters, IDERA Monitoring Tool (SQLDM), SSRS.

Client: Citibank, India. Oct' 04 – Nov' 06

SQL Server DBA

Citibank is one of the nation's leading financial institutions, lending and investment services to individual consumers, as well as to small businesses. CitiDirect is a direct access to Citibank account and financial services. It maintains users checking and saving account information, allows users to make a payment, transfer funds and customize reports for users and bankers. It also consists of web-based application, which was developed, in ASP as a front end and SQL Server as a backend database. The features provided were opening and closing of accounts, deposit/withdrawal of money, money transfers between two accounts and interest calculation. View online statements and pay bills.

Responsibilities:

 Responsible for integrating data into a centralized database with dynamic design and user friendly web application, to keep track of Direct Bill Payments and Commissions from various Clients across the nation.

 Responsible for MS SQL Server 2000 and 2005, configuration, tuning and provide 24 X 7 dedicated support to all Production/staging/development servers.

 Tuned Complex SQL Queries as a part of Query optimization.

 Configured Log shipping from one production server to the staging server.

 DBA’s ensure the database consistency and integrity through various database maintenance plans.

 Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins.

 Monitor SQL Error Logs, Schedule tasks, database activity.

Environment: T-SQL, SQL Server 2000/2005, Log shipping, replication, DTS.

Client: TCS, Hyderabad, India May’ 03 – Sep’ 04

SQL Developer

• Involved from the Scratch in Designing Coding and implementation

• I have used many features in this application Development like COM/DCOM and developed ActiveX Controls.

• Worked with the Windows API calls to get interaction with the Operating System from my Front End VB6.0.

• Developed various stored procedures, constraints and views in SQLServer2000.

• Designed database connectivity modules, using ADO with SQL Server as the database.

• Involved in the Database Design where I worked on Cursors, Complex Triggers and Stored Procedures.

• Generated the Reports using Crystal Report7.0 and developed the Context free help.

Environment: Windows 2000 Professional, VB and Crystal Reports, SQL Sever7.0

Contact this candidate