PROFESSINAL SUMMARY

• 7 years of IT experience in Database Administration, Design Development and Support of MS SQL Server 2012/2008R2/2005/2000 in Production, Test, Development and Cluster Server Environments.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/2008/2012.
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008.
• Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• MDX development/conversions (Excel Business Functions)
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2005.
• Extensive experience with IIS (Internet Information Services) 5.0/6.0.
• Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive).
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQL Server 2005 Reporting Services (SSRS), Crystal Reports.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

TECHNICAL SKILLS

Operating Systems: Windows Server 2003, Windows 2000 Server/ Advanced Server, Windows 98/XP/Professional
Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS, 
Web Technologies: XML, HTML, VBScript
GUI Tools: Visual Studio (VB), Visual Studio2005/2003
Languages: VB 6.0, VB.Net, T-SQL, 
.Net Technologies: VB. NET, ASP.NET 
Web Server: Internet Information Server 
Databases: SQL Server 2012/2008R2/2008/2005/2000, MS Access, Oracle 9i.10g, 11g
Version Tool: Visual Source Safe
Reporting Tools: Business Objects, Crystal Reports
OLAP Tools SQL Server Reporting Server 2008/2005, SSIS (as ETL)
Third Party Tools: Lite speed, Erwin, DB Moto.

Education:Bachelor of Technology in Computer Science

Certifications:Microsoft Certified IT Professional: Database Base Administrator (SQL SERVER 2005/2008).

PROFESSIONAL EXPERIENCE

Confidential, IN Jan 2010 – Present
SQL Server DBA
Confidential is a leading provider of technology-oriented postsecondary degree programs. Confidential operates 120 Technical Institutes in 38 states, which predominantly provide career-focused degree programs of study in fields involving technology to more than 80,000 students. 
Primary objective of the project is to manage all the databases and also used SQL Server Reporting Services, to generate the reports according to the business requirements. The Project also includes creating the reports to monitor the student’s records as per the region and by pulling the historic data from the EDW (Enterprise Data Warehouse), which is on SQL.

• Managed security on Production and Development environments.
• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments using SQL Server 2005/2000.
• Created jobs to import/ export data obtained from various States to update the GIS servers.
• Installed and configured SQL Server Reporting Services.
• Installed necessary Service Packs for SQL server 2005.
• Installed SQL server 2005, 2008 and 2012 on a test environment to be the future production environment.
• Upgraded legacy 2000 databases to SQL server 2005/2008.
• Involved in Database Backup and recovery.
• Implemented high availability on the various servers using replication/mirroring.
• Tuned databases for better performance.
• Created and maintained various logins and managed security based on the required access.
• Implemented and tested the point in time recovery of the production databases.
• Involved in migrating share point from one server to the other.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Design/ developing SSIS (ETL) MDX developing components.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data ,normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
• Created various SSIS packages based upon the requirement.
• Created various reports using SSRS.
• Created the logical and physical data modeling using Erwin tool.
• Expanded Physical Data Model (PDM) for the OLTP application using ERwin.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Analyzed various backup compression tools available and made the recommendations.
• Created necessary templates for various requirements gathering and documentation.

Environment: Windows 2000/2003, MS SQL Server 2000/2005/2008/2012, Oracle10g/11g, SSRS, DTS, SSIS,BCP SQL Server Profiler, VB.NET, T-SQL, Erwin 4.0, Erwin 3.5.2,DBMoto, Database engine tuning Advisor, IIS.

Confidential - Springfield, MO Aug 2009 – Dec 2010
SQL Server DBA
This project has four modules like Online Banking, Personal Banking, Commercial Banking and Mortgage services. I was involved in the Mortgage Services module to build the following reports. Mortgage Qualifier, Mortgage Refinance Analysis, Mortgage Points, Mortgage APR, Mortgage Loan, and Rent Vs Buy, Mortgage payoff. Used Business Objects, a reporting tool and Web Intelligence, a web application that is a part of business objects to accomplish these tasks.
Responsibilities:

• Installed and maintained MS SQL Server 2000 on Windows 2003 Server. Worked on SQL Server 2000 failover clustering which is built on top of a Windows 2003 server cluster.
• Upgraded SQL Server 2000 to SQL 2005 server for high volume processing databases on a clustered environment.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning and optimizing SQL Server 2000.
• Administrator tasks like managing users, roles and permissions.
• Involved in complete database design including conceptual, logical and physical models.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups for SQL and Oracle Databases.
• Data migration using bulk copy program and DTS from Oracle Databases and Flat files.
• Modeling and architecture of the SQL Server 2000 database.
• Implemented an OLAP Data warehouse to Create BI reports using Crystal Reports& Excel for Multi-Million dollar Arbitration.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Maintained high availability of databases using Database Mirroring and Log Shipping.
• Used third party tool, Lite Speed to speed up backup operations.
• Created Complex reports using SS Reporting services.
• Created and maintained logical/physical data structures.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Used @functions to create predefined conditions and prompts to filter the data and dynamic user selection
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Involved in creating Cubes using SQL Server Analysis Services.
• Created reports using Business Objects suite functionality like Slice and Dice, Drill Down function and formulas
• General web development with an emphasis on ASP/VBScript including JavaScript, while using MS SQL as a data source.
• Created the reports using Business Objects functionality’s like Queries, Sub queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc
• Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Environment: Windows 2003,MS SQL Server 2000/2005, Oracle 9i, T-SQL, Visual Studio.Net 2003, Crystal Reports 8.5,Business Objects 6.1b,SQL Loader, CommVault, Lite Speed, MS Access, DTS, BCP,SSIS, SSAS,SSRS, SQL Profiler.

Confidential- Memphis, TN Feb 2009 – Aug 2009
SQL Server DBA
This web-based application allows authorized users, both inside and outside the organization, manages claims and assignments, and recommends next steps. Monitors and claims that need immediate attention, as well as new claims, assignments and rejected claims. Keeps track of all assigned claims until the files are closed. Notify partners via email of new assignments, and reduce their response time through automatic new-claim and next-action alerts.
Responsibilities:

• Used Erwin for physical and logical data modeling.
• Installed SQL Server service packs based on the errors and flaws that are found in the application
• Supported 24 X 7 Production environment
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Complete Internet programming and development, including web site design, project management, HTML, Cold Fusion programming (SQL/Database integration), JavaScript.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
• Performed Server & Application fine-tuning & troubleshooting. Monitored MS SQL Server performance and network issues.
• Utilized VB DLL, EXE, XML, XSLT, XML Schema, Source Safe.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Developed Reports using features like slice and dice, Drill capabilities, Master Detail, and Cross Tab tables with multiple breaks.
• Created variables, @Prompt objects, formulas and etc
• Used text files as Data providers, thereby worked with multiple dataproviders
• Created multi-format reports using Crystal 9.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Designed tables, created, and managed Sybase server to hold Sales, Support, Operations, and Billing data (read only).
• Implemented different types of Replication Models like Snapshot and Transactional.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
• Controlled user access rights, and managed data security.
• Traced long running queries and deadlocks using SQL Profiler.

Environment: MS SQL Server 2000/2005, Windows 2003 Server, Visual Studio.Net, Erwin, Business Objects 6.x, Crystal reports 9, T-SQL, MS Access, SQL Profiler, System/Performance Monitor, DTS, PowerShell.

Confidential - Madison, WI Oct 2008 – Feb 2009
SQL Server DBA
The project involved interacting with various customers and analyzing their SQL server environments and making suggestions and implementing the same for better performance. The project also involved setting up new SQL environments for various customers.
Responsibilities:
The following responsibilities were implemented at various customer sites which include:

• Interacted with various customers on day to day basis and analyzed their SQL server environments.
• Analyzed various SQL server environments and suggested best practices for better performance.
• Administered the space usage of the various databases for various applications.
• Automated consistency check of the database (DBCC) for SQL Server.
• Analyzed the complete environment for resource utilizations and suggested upgrades to increase I/O and avoid bottlenecks.
• Installed and configured SQL Server Reporting Services.
• Suggested various architectures that can be implemented after upgrading from older versions of SQL server to SQL server 2005.
• Proposed various high availability options to maintain the high availability of SQL server on various environments.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Created various automated processes to update the Reporting services databases on a regular basis.
• Suggested and implemented various SQL Server Reporting services environments.
• Upgraded SQL server 2000 boxes to SQL server 2005 and acted as the point of contact for all developers.
• Upgraded SQL server 2005 to SQL server 2008 on a Clustered environment.
• Designed and developed data warehouse data stores, and analyzed business requirements, developed target-source data mappings and delivering ETL processes for end-user OLAP and reporting initiatives (Used report services as and OLAP client schedule reporting tool ).
• Primarily responsible for developing database solutions that provide the business with the information needed to make daily operating and strategic decisions. Perform data modeling activities, applicationperformance tuning and code reviews.
• Implemented various high availability options for SQL server 2005/2008 including replication.
• Tested point in time recovery of the production 2008 databases using the traditional backup/restore technique.
• Setup replication for high availability.
• Make modifications/and add new MDX queries to cubes.
• Installed SQL server and implemented resource utilization on the server.
• Converted many DTS packages to SSIS packages during the up gradation of the servers.
• Involved in performance tuning and query optimization.
• Fixed and rebuilt many SSIS packages during the migration.
• Analyzed many databases in various environments for performance issues.
• Monitored network for bottlenecks.
• Involved in tuning various reports generated using SSRS.
• Documented the various observations made and suggestions on various environments.

Environment: Windows 2000/2003, MS SQL Server 2000/2005/2008, SSRS, DTS, SSIS, SSAS, VB 6, Erwin, SQL Server Profiler, T-SQL, SQL Loader, Database engine tuning Advisor, BPA, Upgrade Advisor.

Confidential Nov 2006 – Sep 2008
SQL Server Develop
Project involved in developing Enterprise level database objects that collects and organizes and stores data from different operational data sources to provide a single source of integrated and historical data. 
Responsibilities:

• Installation and configuration of SQL Server 2000/7.0 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• 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.
• Developed original system for tracking database objects (tables, views, procedures, etc.) over multiple Sybase servers using Unix Shell Scripting.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports
• Designed and Implemented Reports using Business Objects Full Client.
• Reports were developed using Crystal Reports utility.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server7.0/ 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Crystal Reports, Business Objects, T -SQL, BCP.

Confidential Sep 2005 – Nov 2006
Database Developer
G4S – Group 4 Securicor is the world’s leading international security solutions group, operating in
Over 100 countries with over 480,000 employees.
Responsibilities:

• Created and managed complex batch jobs.
• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Created complex queries for database auditing purposes.
• Performed database Tuning, monitoring, and Scalability Testing
• Evolved in the creation and maintenance of index using Index Tuning Advisor wizard,
• Query optimizer, and selected the best indexing plan to be deployed.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Created complex ETL Strategies to populate the Data warehouse/Data-mart facts and dimensions.
• Created a report model on SSAS cubes.
• Created Drill down Reports, Ad-hoc Reports and Drill through reports using the ROLAP as a source.
• Assisted in the scheduling and the deployment of the reports and assisted in uploading files to a report server catalog from the report manger.

Environment: SQL Server 2000, ERWIN Data Modeler, Windows 2000, Windows 2003 Advanced
Server, Windows NT, DTS, SSAS, SSRS, SSIS, Crystal Reports