SUMMARY

• 7+ years of experience in SQL Server 2008/2005/2000 Database Administration and Development.
• Experience with Software Development Life Cycle (SDLC) and project methodologies.
• Extensive working experience in Sales, Telecommunication, Pharmaceutical, Insurance and Banking domains.
• Involved in migration of SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to 2008 (Side by Side).
• Experience in SQL Server 2000/2005 Installation, Configuration and Administration.
• Experience in Designing Data Models and Schemas based on functional specs as finalized by developers.
• Proficient with SQL Server tools SQL Profiler, BIDS and SQL Server Configuration manager.
• Experience using data modeling tools like All Fusion Erwin Data modeler, MS Visio and Rational Rose.

• Hands on experience and knowledge of high availability SQL Server solutions, including SQL Server Log Shipping and SQL Server clustering.
• Experience in writing complex T-SQL Stored Procedures, Scripts, Triggers and Views.
• Hands-on experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Expert in performing database consistency checks, planning and scheduling Backup & Recovery.
• Proficient in SQL programming, physical database design, and SQL Performance tuning and replication.
• 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 in Migration of Data from/to Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS utilities.
• Experience in developing SSIS packages, SSRS reports.
• Inquisitive and flexible with a desire to learn and the ability to troubleshoot errors and solve them.
• Excellent communication skills, proactive, independent and easy-going.

TECHNICAL SKILLS:

Databases:

MS SQL 2000/2005/2008, Oracle 9i/10g

SQL Server Tools:

Enterprise Manager, Profiler, Query Analyser, Export & Import (DTS/SQL Server Integration Services).

Database Tools:

SQL*Plus, TOAD 8.6/7.6, SQL developer.

Programming Languages:

T-SQL, C , SQL,PL/SQL

Scripting Languages:

VB Script, Unix Shell Script

Operating System:

Windows Server 2003/2000 / NT 4.0, Win XP and Win 98

Applications:

MOSS 2007,AXAPTA 4.0,MS SQL 2000/2005

ETL Tools:

Informatica PowerCenter, MSSQL Server Integration Services, DTS

Reporting Tools:

MS SQL Server Reporting Services, Cognos

Data Modeling Tools:

ERWIN 4.0, MS-Visio, Rational Rose

CERTIFICATION:

Microsoft Certified Technology SPECIALIST (TS: Microsoft® SQL Server™ 2005 - Implementation and Maintenance)
Microsoft Certified Professional

PROFESSIONAL EXPERIENCE

Confidential,

Warrenville, Illinois

SQL Server Administrator

05/2007 – Present

Navistar, Inc is a holding company whose wholly owned subsidiaries produce International A brand commercial and military trucks, MaxxForce brand diesel engines, IC brand school and commercial buses, and Workhorse brand chassis for motor homes and step vans. It also is a private-label designer and manufacturer of diesel engines for the pickup truck, van and SUV markets.

RESPONSIBILITIES:

• Installed and Configured SQL Server 2005 and 2008.
• Supporting Applications with SQL Server 2005 & 2008 databases across many locations.
• Migrated databases, logins, jobs, maintenance plans and objects from SQL Server 2005 to 2008.
• Planned and Successfully Implemented SQL Server 2005 on the Production, Test and Development Servers.
• Successfully Installed the Service Packs and Hot-fixes for SQL Server 2005 in all the environments.
• Administered the MS SQL Server 2005 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).
• Day-to-day activities like taking Backup (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.
• Experience working with Data model and Schema Designs using All Fusion Erwin.
• Ensured constraints and writing triggers to apply the business rules.
• Involved in Performance Tuning, Backing Up & Restoring User Databases.
• Analyzing execution plans to get an optimized processing of a query, Stored procedure etc.
• Involved in Database Administration, Query Performance tuning, and validated some of the existing schema.
• Involved in implementation of Replications like Snapshot and Transactional.
• Involved in developing customized reports using SQL Server reporting wizard as per the requirement.
• Involved in SSIS Package, DTS Import/Export Wizard for transferring data.
• On call 24/7 support to databases on weekly rotation.
• Migrated DTS packages into SSIS packages from SQL Server 2000 to 2005.
• Created SSIS Packages to migrate the data from Excel files to SQL Server Destinations.
• Generated different reports using MS SQL Server Reporting Services.

ENVIRONMENT: MS SQL Server2008/2005/2000, SSIS, SSRS, Windows 2003/2008 Server, LiteSpeed , .Net Framework 3.5, ASP.net, C#, System Monitor / Performance Monitor and Visual Source Safe.

Atlanta, GA

SQL Server Developer/Admin

11/2005 – 04/2007

AT&T has been driving communications innovation for decades, delivering more connectivity and capacity via the most advanced technologies available to make life a lot easier and more productive. New technologies will enable more efficient delivery of more content and applications, integrating wireless and wire line networks to produce more seamless access to the resources.

RESPONSIBILITIES:

• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data about the cable layout, so as to meet the company specifications.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server 2005.
• Created SSIS Packages to transform the data.
• Created Backups for databases and automated the process.
• Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
• Created Indexes and involved in Performance tuning.
• Incorporating business logic in SSIS while converting from Oracle, MS Access and Text to SQL Server, creating new database/tables to put in the extracted data and rebuilding the relationship.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Created Reports as per user requirement using MS Reporting Services 2000/2005.
• Created SSIS Packages to migrate slowly changing dimensions.
• Written stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects and so on.
• Ensured constraints and writing triggers to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Extracted data from SQL Server for report, backup, testing purposes by using DTS, BCP and Import/Export option.
• Created different user level groups, and assigned appropriate permission level to the database. This made sure that only the right person with enough authority would be able to see the Customer Information.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.

ENVIRONMENT: SQL Server 2005/2000, SSIS, SSAS, SQL Profiler, SQL Server Configuration Manager, LiteSpeed, VB, ASP .Net, VB Script, Erwin, Access, Excel, Windows XP.

Confidential,

Morgantown, WV

SQL Server Developer/Admin

10/2004 – 10/2005

Elan Corporation is a neuroscience-based biotechnology company that is focused on discovering, developing, manufacturing and marketing advanced therapies in neurology, autoimmune diseases, and severe pain.

RESPONSIBILITIES:

• 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.
• Was responsible for Reporting and resolving serious SQL Server alerts.
• Worked with workflows (Any changes on staging and development environment need to assign workflow).
• Worked 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).
• Used DDL and DML for writing Triggers, Stored Procedures, and data manipulation.
• Worked on report server configuration security to deploy SQL Server reporting Services.
• Worked on ETL tasks using SSIS.
• Configured IIS to deploy SSRS Reports on to Report server.
• Worked with SSIS in data transformation domain.
• Worked with Windows2005 Cluster environment (Active/Active and Active/Passive).
• Was responsible for Verifying all Instances are Up and Running and all error log files for any new entries.
• Expertise in Login creations and assigning Roles.

Confidential,

Manhattan, NY

SQL Server Administrator

11/2003 – 09/2004

American International Group, Inc. (AIG), a world leader in insurance and financial services, is the leading international insurance organization with operations in more than 130 countries and jurisdictions. AIG companies serve commercial, institutional and individual customers through the most extensive worldwide property-casualty and life insurance networks of any insurer. In addition, AIG companies are leading providers of retirement services, financial services and asset management around the world.

RESPONSIBILITIES:

• Installed SQL Server 2000 on Windows 2000, applied Service packs and Security fixes.
• Designed databases for different projects and resolve database issues.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Addressed the Replication Issues.
• Created New Replications, DTS packages to maintain high availability of the data between the servers.
• Implemented the SQL login security for developers and users.
• Created DTS packages to pull data from Oracle and Flat Files.
• Runned DBCC consistency checks and fixing data corruption in user databases.
• Created of schema objects, rules and granting of roles to the users.
• Worked and coordinated with developers in writing and tuning new stored procedures.
• Worked on DTS packages to import the data from Oracle, Access and Text files.
• Involved in setting up Backups for the newly created databases.
• Scheduled transfer of backups and log files to different servers.
• Provided a support for data issues and given appropriate solutions.
• Provided training to development team on performance tuning and SQL best practices for enhancing application output.
• Responsible for change managements, created the documentation for SQL server and service packs installations.

ENVIRONMENT: MS SQL Server 2000, SQL Profiler, Windows 2000, Visual Basic 6.0, ASP, Asp.Net, VB.Net, JavaScript, MS Visio, VSS, XML, Oracle, Access.

Pune, INDIA

SQL Server Developer/Admin

12/2001 – 10/2003

The Industrial Development Bank of India Limited commonly known by its acronym IDBI is one of India\'s leading public sector banks. RBI categorized IDBI as "other public sector bank" that provide credit, Home loans, Insurance and other facilities for the development of the fledgling Indian industry.

RESPONSIBILITIES:

• Created Database objects including Tables, Triggers, Views, Stored Procedures, Indexes and Rules.
• Set Database access privileges for different Users and User Groups.
• Performed optimization of SQL queries in SQL Server.
• Imported Data from MS-Access Database and XML to SQL Server Database.
• Involved in Maintenance of Clustered and non-Clustered Indexes.
• Created jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Created DTS Packages in SQL Server Database.
• Performed database consistency checks at regular intervals.
• Monitored SQL Server activity through profiler.
• Developed backup & restore scripts for SQL Server as needed.
• Involved in Design and implementation of database maintenance plan.
• Involved in Performance optimization and normalization of database.
• Involved in Tuning and optimizing queries and indexes.
• Scheduled jobs, batch, alert and E-mail notification setting.
• Monitored SQL Server log files.

ENVIRONMENT: SQL Server 2000, MS-Access, XML, Stored Procedures, Triggers, Views, Crystal Reports and Visual SourceSafe.

EDUCATION:

Bachelors in Electronics and Communication Engineering.