SUMMARY

• Around 7 years of IT experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server also specialize in MS SQL Server 2008/2005/2000 in Production, Test, Development Environments.
• Good knowledge of Relational Database Management Systems (RDBMS).
• Expertise in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing and Query optimization.
• Good working experience in maintaining SQL Server Active/Passive cluster environment.
• Experience in migration from MS SQL Server 2000 to MS SQL Server 2005/2008.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Hands on experience with T - SQL (DDL, DML, DCL) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008 databases.
• Experience in MS SQL Server 2000 and 2005 installation with latest service pack, configuration, performance tuning, client/server connectivity, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC.
• Extensive experience in Capacity planning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
• Experience in developing front-end for the site written in ASP.NET, MS Visual Studio .NET, C#, VB.NET, XML, VBScript, HTML, DHTML, JavaScript, Dreamweaver.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Good experience in resolving blocking and Dead lock Issues by using SQL commands.
• Experience in Creating, Configuring and deploying various applications using SSRS and SSIS packages in Test and Production environments.
• Comprehensively involved in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2005 with .NET, Import/Export data, Bulk insert and BCP
• Experience in VB.NET, C#, ASP.NET, ADO.NET and Web Services.
• Experience in Data Loading, ETL process and Supported Cube Processing in SSAS and Transferred data to Data Warehouse Environment (ETL) using SSIS.
• Worked 24 x 7 for production support with multiple SQL Instances.

TECHNICAL SKILLS

Databases: MS SQL Server 2008 R 2/2008/2005/2000 , ORACLE, MS Access, MySQL

Database Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Analysis Services, Business Intelligence & Development Studio and Erwin

Development skills: T-SQL,PL/SQL,SSIS/SSRS/SSAS, Oracle 8i/9i/10g

Languages: T-SQL, PowerShell, C#.Net, VB.Net, JavaScript, AJAX, VB, VB Script, C, C++, PL/SQL, XML.,HTML.

ETL Tools: DTS, SSIS (SQL Server Integration Services), Informatica.

Reporting Packages: SQL Server Reporting Services (SSRS), Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel

Operating Systems: Windows 98/NT/2000/XP, 2003 Servers, UNIX.

Tools: /Methodologies MS Visio, Erwin, MS Project, SQL Profiler, SQL*Loader, TOAD for SQL Server and Oracle

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

MS SQL Server DBA /Developer

Responsibilities:

• Migrated Databases from SQL Server 2005 to SQL Server 2008R2 in Production and test Environments.
• Involved in Data modeling, designing, and building relational databases.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Backup and recovery of production databases and tuning them for better performance.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008.
• Created Linked Servers between SQL server 2005/2008 and Oracle servers in the environment.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from Oracle to SQL databases.
• Configured Snapshot and Transaction Replication.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Creation, Testing, and Implementation of SSRS packages for Reporting Services that included paper-based and interactive web-based reports.
• Experience in building adhoc reports, parameterized reports, toggle reports, reports with sub reports using SSRS.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend performance issues
• Implemented Pager options to inform corresponding DBA basis on Each Job Status.
• Performed De fragmentations Techniques of most complex indexes.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Created SSIS packages using ETL tools to migrate data from different source.

Environment: MS SQL Server 2008 R2, T-SQL, MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS),SQL Agent, SQL Profiler, Windows 2008 server, Visual Studio, .Net Framework .

Confidential, NYC, NY

SQL Server DBA

Responsibilities:

• Installation, configuration and Administration of MS SQL Server on Windows2003 Servers.
• Logical and Physical design of database for projects on basis of user requirement.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.
• Implemented and maintained database security, logins, roles and schemas.
• Developed logical and physical data models and created DDL scripts to create database schema and database objects.
• Oversaw servers’ performance, wrote batch and shell scripts, and solved many technical problems in security management, patching, performance monitoring and disc administration
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Performed Database backups (operating system, flat file backups & export/import).
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Performed application program enhancements, troubleshooting and bug fixes as required.
• Experience working with applications developed using Visual Studio .NET
• Implement Replication for Reference Data across different Instances of the application.
• Worked on Active/Active and Active/Passive Clustering.
• Migrated DTS packages to SSIS (SQL Server Integration Services) using DTS migration wizard.
• Performed query tuning & optimization using Query Plans & SQL Profiler.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Developed standards and guidelines to maintain and develop and administer the SQL Server database.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Handled Database recovery (disaster recovery), diagnosed, repaired and was involved to transfer the OLTP data to Data Warehouse

Environment: SQL Server 2005/2008, T-SQL, SQL Server Reporting services (SSRS), SQL Server Integration Services (SSIS), Windows 2003 Server.

Confidential, Louisville, KY

SQL Server DBA

Responsibilities:

• Management of SQL Servers, databases, storage management for databases.
• Management of database objects such as tables, views, indexes.
• Management of users including creation/alteration, grant of system/db roles and permissions on various database objects.
• Involved in writing Transact-SQL command line script for various needs.
• Evaluated data storage considerations to store databases and transaction logs.
• Involved in Migration of SQL Server and also on new hardware with the platform of Windows 2000 and 2003.
• Used DTS/SSIS to perform the ETL tasks from source to target.
• Tuned the database to perform efficiently by managing databases.
• For transferring, used data import and Export utility and BCP command line utility.
• Monitoring the server for High availability of the servers solving the raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Tuned Stored Procedures, DTS packages for accuracy of Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.

Environment: SQL Server 2000 & 2005, Windows 2003 Server,.Net Framework,ASP.Net. DTS, SSIS, SSRS, Erwin.

Confidential, IL

SQL Server DBA / Developer

Responsibilities:

• Development of T-SQL Stored Procedures for Export & Import of data from databases and Transaction Databases of different agencies.
• Administration of around 25+ SQL server 2005/2000servers. Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Successfully migrated nearly 200 Databases from including many number of DTS packages to SSIS.
• Developed DTS packages and schedule jobs for loading data between different sources.
• Creation and maintenance of databases, creating roles and managing user permissions.
• Created Views and Index Views to reduce database complexities for the end users.
• Code Review for different modules of SQL Technology Team.
• Implement Replication for Reference Data across different Instances of the application.
• Installation of SQL server Instances and Service Packs. Applying Hot Fixes.
• Testing and analyzing effects of Server Upgrades and Security Fixes on customized server instances with Mount Points etc. Implementation of new changes through Change Request.
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Documented disaster recovery plans and participated disaster recovery drills.
• Reviewed third party tool (Idera) so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Performed query tuning, assigned proper Indexes for better performance.
• Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: MS SQL Server 2005/2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer,PowerShell SQL Server Business Intelligence Development Studio, Microsoft Visual Studio 2005.

Confidential, Tallahassee, FL

SQL Server DBA

Responsibilities:

• Designed and implemented the database in MS SQL Server 2000 for an outsourced retail client.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Administered the SQL Servers and the databases.
• Migrated data of the products and customers from retail store’s database (SQL Server 2000) by DTS.
• Created Trigger for the application which would automatically run jobs so that synchronization between legacy and newly developed system is maintained.
• Designed and implemented the database in MS SQL Server 2000.
• Created maintenance plans in SQL Agent to backup the database.
• Implemented Log Shipping Successfully.
• Worked with BCP and DTS to load text files to SQL Server. Maintained the data, database backups and restoration, backup strategies, scheduled backups.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Wrote the DDL triggers for Auditing purpose, and also wrote automated audit process for Server configuration and scheduled to run once day.
• Analyzing transactional logs using Lumigent Log Explorer for potential data issues, DMLs and DDLs.
• Wrote ad-hoc stored procedures, T-SQL scripts and created DTS packages to synchronize the data between ACA Retail System & TCS.

Environment: MS SQL Server 2000, T-SQL, DTS and Crystal reports 8.0, IIS 5.0, VB 6.0, Windows 2000 Server/Pro.

Confidential

SQL Server DBA/ Consultant

Responsibilities:

• Collaborated with software engineers, architects, and technology specialists to design database, clustering, and migrations.
• Deployed and Administrated SQL 2000 server on production environment.
• Develop and implement Replication, Archiving, Backup and Recovery strategies.
• Proactively monitor the Production Database and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization.
• Migrated DTS packages from SQL Server previous versions to SQL server 2000 and scheduled them to run at required time.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• Manage and Create database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc.).
• Ensure all database environments (Development, Staging, QA and Production) are in sync.
• Define db scripts versioning system to keep track of database versions for all environments.
• Design, review and implement production SQL Server database objects, models and database designs (schema)
• Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Good experience in maintaining Log Shipping, Replication and Clustering.
• Identify and resolve database performance issues, database capacity issues and other distributed data issues.

Environment: SQL Server 2000, T-SQL, SQL Enterprise manager, Query Analyzer, ERWIN, DTS, MS Access 97 / 2000 & Windows Server /x64.