Skills

• Experience with SQL Server 2005/2008 Create views, complex stored procedure, 9 Years, 2012 3 - Expert
• Experience working with asp.net, C#, 4 Years, 2012 2-Proficient
• Experience in Sql Server Reporting Services (SSRS), 6 Years, 2012 3-Expert
• Expertise with T-SQL, 8 years, 2012 3-Expert
• iText .Net, 3 years, 2012 2-Proficient
• Perform database performance analysis, reporting, and configuration, 5 years, 2012 3-Expert
• Strong understanding of framework/library design and best practice designs, 6 years, 2012 3-Expert
• Knowledge of database sizing, capacity planning and full life cycle, 6 years, 2012 2-Proficient
• Experience with writing stored procedures, views, etc. 8 years, 2012 3-Expert
• Firm understanding on OO concepts and design patterns utilizing C#, 5 years, 2012 2-Proficient
• Development in Visual Studio 2010 using Team Foundation Server, Work Items, 4 years, 2012 3-Expert
• Expertise in data architecture, 3 years, 2012 2-Proficient
• Use of the Microsoft AJAX Toolkit, 3 years, 2012 3-Expert
• Experience with Microsoft Unit Testing Framework or other Unit Testing tool, 4 years, 2011 3-Expert
• Ability to lead and mentor a team, 3 years, 2010 3-Expert
• Experience with Web services, 5 years, 2012 3- Expert

Education & Certifications:
Master of Science (MS) in Computer Science Engineering.
Bachelor of Engineering (BE) in Electronics and Communications 
Microsoft Certified IT Professional: Database Administrator 2008(MCITP_DBA 2008) 
Microsoft Certified IT Professional: Business Intelligence Developer 2008(MCITP_BI 2008) 
Microsoft Certified Technology Specialist: SQL Server 2008, Implementation and Maintenance and SQL Server 2008(MCTS_DBA 2008) 
Microsoft Certified Technology Specialist: Business Intelligence Development and Maintenance (MCTS_BI 2008)

SKILLS:

• Nine Years of working experience in SQL Server as Database Administrator and Developer in IT, Pharmacy, Finance, Commercial, entertainment/media and ecommerce environments.
• As a SQL database administrator, performed End to End SQL Server administrative tasks ranging from installing and configuring servers to setup and administer clusters, replication, log shipping etc. Designed, created and maintained databases in both development and production environment.
• Experience supporting Great Plains development and SQL Server production database instances
• Expert in designing VLDB (Very large databases) using design methodologies like STAR Schema, Snowflake Schema.
• Experience with Business Intelligence Concepts like Data Reporting and Data Analysis
• Experienced Microsoft BI Developer. Skilled in SQL Server
• Experience with tools like Index Tuning Wizard, SQL Profiler.
• Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
• Experience in migrating MS SQL Server in VMware environment
• Experience in Sybase migrations involving the Sybase IQ column oriented RDBMS
• Strong knowledge and experience in Script-writing, performing backups/recovery, database monitoring, and performance tuning using SQL Profiler, SQL DBCC commands and Dynamic Management Views (DMVs), and Windows Performance Monitor.
• Solid experience and outstanding knowledge of high availability SQL Server concepts, such as Setting up and maintaining Log shipping, Replication and SQL Server clustering.
• Experience with MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Node in SQL Server 2008 R2
• Experienced SQL BI developer. Strong Experience in package design and maintenance using SQL Server Integration Services (SSIS) 2005 and 2008. Recent work includes Data transforms, database maintenance tasks, custom field mapping etc.
• Worked on SQL Server BI Studio for SSRS, performed data validation, collected data, analyzed it, and implemented effective CRM plans
• Experience with SAP Application support while maintaining and administering SQL databases
• Worked with the backend Feed processing systems consisting of reports and legacy data uploads
• Experienced SQL Data Warehouse Designer with SQL Server Analysis Service (SSAS) 2005 and 2008. Proficient in designing and administering SQL data warehouse solutions and utilizing Analysis Services tools such as Perspectives, Calculations, Actions, and partitioning.
• Worked on SQL Server BI Studio for SSRS.
• Hands on experience in understanding of BizTalk architecture and supporting the behavior of BizTalk Server Host Instances during SQL Server Failover
• Advanced IIS 6 and .NET server administration and troubleshooting experience
• Created SSIS packages for SQL 2005 data migrations and loads.
• Expert in understanding needs, focusing on the critical issues, translating them into technical actions and implementing a resulting database.
• Attended seminars on SQL Server Denali and has a firm understanding of the Contained Databases and Availability groups(HADR)
• Performance Monitor for maintaining performance.
• Experience in administration (installation, configuration, monitoring, upgrade) of large number of IIS based Web servers (versions 5, 6 & 7) with strong troubleshooting skill.
• Hands on experience in troubleshooting database issues and database backup and recovery procedures.
• Extensive experience in data migration projects
• Experience with Visual Studio 2010 using Team Foundation Server
• Experience in working on the SOX environment for SQL Server
• Written Powershell scripts that are customized for a particular dataset – such as a morning health check, which outputs different base information on reporting every morning.
• Experience in working with Microsoft Active Directory Services
• Created multiple database platform reports with Crystal Reports.
• Experienced in sorting the data, defining subtotals for reports and designing report layout.
• Excellent Report designer with SQL Server Reporting Service (SSRS) 2005 and 2008.
• Experience in SSRS interfacing with SharePoint
• Extensive Experience with C#, Asp.net, Web Services
• Experienced with Microsoft Office Share Point Server 2007 and MS Office Suite such as MS Access, Excel, and Office.

Employment History:

Confidential, Hopkins, MN March 2011 - till date
Role: SQL Server DBA _ Application DBAConfidential is an international producer and marketer of food, agricultural, financial and industrial products and services. Confidential helps customers succeed through collaboration and innovation, and is committed to applying its global knowledge and experience to help meet economic, environmental and social challenges wherever it does business. The role as an Application DBA 
was involved with the Tartan Project in the Tartan Data and cut over team to Administer, maintain and troubleshoot the SQL Server databases along with the tool Cransoft which is exclusively database driven.
Responsibilities:

• Extensively worked on Microsoft Active Directory Services
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Managed over 50 Servers with hosting the high volume databases sizes up to 500 GB
• Migrated DTS packages from the development server to the production server and migrated the DTS packages to SSIS packages
• Migrated MS SQL Server 2008 databases in VMware environment
• Monitor/Maintain the highly transactional servers that process 300 batches /sec on an average
• Deployed and administered nearly 50 SQL 2005/2008 R2 servers on 64-bit/32-bit environment
• Experience in index tuning and performance optimization techniques
• Experience with Snapshots for backups using EMC Timefinder
• Setup MOM monitoring alerts for monitoring all SQL Server boxes
• Extensively used the SQL LITESPEED tool by the Quest Software to restore the backups at object level for tables and at schema level and rebuilding the indexes at regular intervals for better performance
• Maintaining the database consistency with DBCC at regular intervals
• Used the exclusively database driven tool CranSoft to develop web applications with the backend as SQL Server 2005
• Experience in the use of the Microsoft AJAX development tool
• Experience with Visual Studio 2010 using Team Foundation Server
• used the tool BMC Remedy user by the BMC software in resolving the incidents in the development servers and the production servers
• worked on configuration management extensively to design the configuration management database(CMDB) and configuration Items(CI's)
• Performed SQL DBA activities on mission critical SQL Databases on which SAP ECC 6.0 was hosted
• Experience in Sybase migrations involving the Sybase IQ column oriented RDBMS
• Using the CranSoft tool interface indexed several columns in the database through the domain specific key words, used the chart option and worked on multi-lingual settings for different geographical locations of the business as a CranSoft administrator
• Has performed the IIS 5x, 6x installation, configuration and Tuning
• Created & managed domains on IIS
• Convert MS Access database to SQL Database and generate reports from the MS Access databases
• Monitoring SQL server performance using profiler to find performance and dead locks and blockings
• Working and utilizing DMV’s in SQL Server 2005 and SQL Server 2008 R2 for tuning and optimizing the servers
• Creation of process flow diagrams in Microsoft Visio
• Worked with Linked Servers and OPENQUERY to retrieve the Oracle data into SQL Server 2005
• Querying the databases using the Powershell scripts
• Experience in Installing and configuring MS SQL Cluster Servers in Active/Passive and Active/Active environment
• Proactively monitor the Production Server and optimize stored procedures for better performance Resolve locking conflicts and resource utilization
• Has started, stopped, paused, resumed and restarted the BizTalk Server Services
• Worked together with Architects and Technology specialists to design database, clustering and migrations and implemented various RAID levels on SAN Storage for file placements to improve the performance of servers
• Monitored and fine tuned ETL jobs daily using BCP and DTSRUN
• Manage/administer the file groups for data, index and read-only for VLDB’s
• Evaluated data storage considerations to store databases and transaction logs
• Developed and implemented Replication, Archiving, Backup and Recovery strategies
• Tuned, monitored, maintained & Scheduled SQL Server Jobs
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users

Environment: SQL Server 2005/2008 R2 with clustering (64/32 bit), T-SQL, SQL LiteSpeed, BMC Remedy, Windows 2003/2008(x86/x64), MS Access 2003/2007, SSIS/SSRS/SSAS, WCF, Visio, DTSRUN, MDX, Powershell, Microsoft Active Directory Services, BCP, BO Data Integrator, Unix, Oracle 10G, SAP, Sybase ASE, MySQL 51, Net, web Services, AJAX, Visual Studio, C#, VB and ASPNet, IIS 5x,IIS 6x, BizTalk Server 2009, VERITAS Netback up, VSS, iText.NET , Team foundation server, ER Studio, SharePoint MOSS 2007, MS Cluster Service(MSCS), XML, ColdFusion MX 70, MCS, MOM 2005, SAN Storage, CranSoft 451/5311, , EMC Time finder

Confidential, Burbank, CA April 2010 - February 2011
Role: Lead SQL SERVER DBA – Production support
CONFIDENTIAL is a multinational company that has defined itself not by markets, strategies, products or services, which come and go as the world changes, but by fundamental values. The Walt Disney Company is a leading diversified international family entertainment and media enterprise with four business segments: media networks, parks and resorts, studio entertainment and consumer products. The role was of a lead production support DBA to administer and monitor the databases providing the application support to databases and of an IIS Administrator to deploy and administer web-based email applications using IIS. Was SME (Subject matter expert) for the front end applications and to lead the teams present onsite and offshore
Responsibilities:

• Used Embarcadero Rapid SQL, Embarcadero DBArtisan for intuitive SQL editing and debugging. Worked with the optimization tools to create high performance SQL code
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Used the third party tool CranSoft of Back office associates in the production environment on the SQL Server 2000 and SQL Server 2005.
• Exclusively used the CranSoft web application interface for data migration, data extraction and generating reports.
• Exclusively worked on Informatica with the tools Power center designer, Power center workflow monitor, Power center workflow manager and Power center repository manager in creating the sessions, mappings, workflows and work lets.
• Worked on Microsoft Active Directory Services
• Migrated MS SQL Server 2008 R2 databases in VMware environment
• Efficient response to database events in a production environment & performance monitoring in cluster administration of mission critical databases for SQL Server 2008 R2
• Experience in performance tuning and monitoring the SQL 2005/2008/2008R2 databases within the SAP architecture
• Provided the application support 24/7 to the applications and delivered enhancements and customizations.
• Experience with iText.NET on .NET framework for generating PDF, HTML and XML files
• Used the Powershell scripting to get the most consistent production environment.
• Identify and resolve database performance issues, database capacity issues.
• Has performed the Backup and Restore using great plains DYNAMICS database
• Has familiarity with great Plains tables architecture and performed extensive Data querying with Microsoft great plains using the Report Writer
• Has performed the installation and monitored the Service Broker
• Has deployed and administered web-based email applications using IIS
• Maintaining the database consistency with DBCC at regular intervals
• Has created reports by the SSRS using the legacy MS access databases
• As per the Common Auditor Requirements of SOX Monitored access failures and schema changes
• Has created illustration tasks using Visio to create flowcharts and technical diagrams for patent applications and other documents
• Monitored and fine tuned ETL jobs daily using BCP, DTSRUN and SSIS
• Implemented & managed database clustering, failover and load balance technologies as per client requirement
• Exclusively supported for the application deployment on IIS server
• Provided an estimation of the migration plan in terms of feasibility, time duration and resources
• Ensure all database environments (Development, Staging, QA and Production) are in sync. Defined db scripts versioning system to keep track of database versions for all environments.
• Suggested and Developed database maintenance plan for Data warehouse environment
• Maintained High Availability such as Log Shipping and Mirroring as a database disaster recovery technique
• Made database back up using SQL LiteSpeed (Full, Differential, Log and File group back up) and restore it
• Managed over 105 SQL Server 2000, SQL Server 2005, SQL Server 2008/2008R2 Servers with hosting the high volume databases sizes up to 2 TB
• Worked on security and audit requirements using the third party application of SAS70 systems
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases
• Involved in Maintaining Quality System procedures for development purpose such as Unit Test Plan
• Created Database Maintenance Plans for the Performance of SQL SERVER, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Unit Testing the SSIS packages with respect to its flow and performance issues
• Applied patches to the applications on the front end which had the ETL tool Informatica on the back end
• Scheduled jobs on SQL Server 2000 and upgraded SQL Server 2005 to 2008 R2 in production environments
• Worked on SQL Server Query Notification with BizTalk Server 2009 WCF SQL Adapter
• Involved in extensive knowledge transfer sessions to know the database recovery strategy used, the high availability solutions implemented and successfully coordinated with the off shore team
• Upgraded the front end applications to the latest versions based on the software provided by the vendor
• Gained the trust and confidence of the prestigious client Walt Disney

Environment: SQL Server 2000/2005/2008/2008 R2 with clustering (64/32 bit), T-SQL, Windows 2003(x86/x64),Windows 2008, BCP, Enterprise manager, Query Analyzer, Embarcadero Rapid SQL, Embarcadero DBArtisan, Power shell, Visio, DTSRUN, Informatica, MDX, BizTalk Server 2009, Microsoft Active Directory Services, Microsoft dynamics great plains, Unix, Service Broker, MS access 2003/2007, Citrix servers, MySQL 5.1, .Net, Visual Studio, C#, VB and ASP.Net, IIS 6, SOX,VERITAS Netback up, iText.NET , CranSoft 4.5.1/5.3.1.1, VSS, Rapid SQL, CMS .Net, Feed processing systems, MS Cluster Service(MSCS), XML, HTML, MCS, MOM 2005, SAN Storage, Lotus Notes

Confidential, Schaumburg, IL January 2009 - March 2010
Role: SQL Server DBA/Production-Support 
Confidential creates numerous products for use of the government, public safety officials, business installments, and the general public. These products include Cell Phones, laptops, computer processors, and radio communication devices. The role was of a Lead production support DBA to monitor the databases of the sales segment and assign tasks to the junior DBA’s
Responsibilities

• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Deployed and administered nearly 50 SQL 2005/2008 servers on 64-bit/32-bit environment.
• Experience with Snapshots for backups using EMC Timefinder
• Used the CranSoft tool for the back office operations on SQL Server 2000 and SQL Server 2005
• Has performed the IIS 5x, 6x installation, configuration and Tuning
• Created & managed domains, installed and configured FTP on IIS
• Working and utilizing DMV’s in SQL Server 2005 for tuning and optimizing the servers.
• Experience in index tuning and performance optimization techniques.
• Creating virtual directory using IIS
• Experience in Sybase migrations involving the Sybase IQ column oriented RDBMS
• Provided the production support for systems running on Windows Server with IIS
• Creating new Documentation, schema designing, creating new ERD’s using ER Studio.
• Proactively monitor the Production Server and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization.
• used Powershell to manage SSIS packages across multiple SQL Server instances
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• worked exclusively on service broker dialog security and transport security
• Worked together with Architects and Technology specialists to design database, clustering and migrations.
• Implemented various RAID levels on SAN Storage for file placements to improve the performance of servers.
• Migrated DTS packages to SSIS packages. Built and developed SSIS packages. Performed various transformations using SSIS.
• Monitored the behavior of BizTalk Server Host Instances during SQL Server Failover
• Manage/administer the file groups for data, index and read-only for VLDB’s.
• Installed, configured, authored, and managed reports using SQL Server 2005 Reporting Services
• used Power shell to automate admin tasks
• Evaluated data storage considerations to store databases and transaction logs. Created/Managed databases using SSMS, Database Wizard and T-SQL Statements (Scripts).
• Developed and implemented Replication, Archiving, Backup and Recovery strategies.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Developed and optimized databases using stored procedures, DMVs, Triggers, Full-Text Indexing, XQuery, XML and user-defined functions.
• Tuned, monitored, maintained & Scheduled SQL Server Jobs.
• Extensively worked on Microsoft Active Directory Services
• Designed, Built ETL procedures and a data warehouse to meet client requirements using SQL Server Integration Services/Data Integrator.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Designed created, and visualized data mining models using SSAS.
• Expertise in creating OLAP Cubes developed Multi-dimensional Expression (MDX).
• Identified and resolved database performance issues, database capacity issues
• Managed over 38 Servers with hosting the high volume databases sizes up to 1.8 TB.
• Setup MOM monitoring alerts for monitoring all SQL Server boxes.
• Worked with Linked Servers and OPENQUERY to retrieve the Oracle data into SQL Server 2005.
• Maintaining the database consistency with DBCC at regular intervals
• Developed detailed data models and designs based on functional requirements.
• Developed ETL Packages using SSIS and Informatica from Oracle Source to SQL ODS and from ODS to Data Warehouse using transformations such as Slowly Changing Dimension
• Configured Active/Active Clustering for failover on production server
• Migrated data from SQL Server 2005 to MySQL 5.1
• Worked exclusively on gathering information on database components and requirements for migrating from SQL Server 2005 to SQL Server 2008 and successfully performed it.
• Monitor/Maintain the highly transactional servers that process 300 batches /sec on an average.
• Upgraded SQL Server 2005 to 2008 in production environments
• Worked with the backend end feed processing systems consisting of reports and legacy data uploads.
• Wrote complex SQL queries and Create Reports using SSRS 2005/2008 from the Data Warehouse, Data Mart and Cube
• Create the Calculate member for Approved Capital using MDX Queries.
• Optimized cubes by Partitioning Cubes and Designing Aggregations.

Environment: SQL Server 2005/2008 with clustering (64/32 bit), T-SQL, Windows 2003(x86/x64), Windows 2008(x86/x64), SSIS/SSRS/SSAS, DTSRUN, MDX, Microsoft Active Directory Services, BO Data Integrator, Unix, BCP, Oracle 10G, Sybase ASE, MySQL 5.1, .Net, Powershell, BizTalk Server 2006 R2 ,Visual Studio, Service broker, web services, C#, VB and ASP.Net, Feeds processing systems, IIS 5x,IIS 6x, VERITAS Netback up, VSS, ER Studio, SharePoint MOSS 2007, MS Cluster Service(MSCS), XML, ColdFusion MX 7.0, MCS, MOM 2005, SAN Storage, CranSoft 4.5.1/5.3.1.1, , EMC Timefinder

Confidential, Long Island, New York October 2007 – Dec 2008
Role: SQL Server Database Administrator/ Production support
Confidential is a national bank and the role was to maintain the records and back end the reports, maintaining terabyte databases as per company requirements.
Responsibilities

• Collaborated with software engineers, architects, and Server Group to design database, clustering, and migrations.
• Provided an estimation of the migration plan in terms of feasibility, time duration and resources.
• Deployed and Administrated SQL 2005/2000 servers on 64-bit and 32-bit production environment.
• Monitored the service broker applications, stopped and started the service broker applications
• In the process of preparing the environment for the Audit as per the SOX regulations performed the division of roles and responsibilities for the SQL development team and DBAs that prevents any DBA or developer from unauthorized alterations
• Developed, implement and monitor a large-scale and time-sensitive production loading processes
• 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.
• 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.
• used Powershell to automate admin tasks
• Problem solving and issue resolution on production SQL stand alone and cluster databases.
• Design, review and implement production SQL Server database objects, models and database designs (schema)
• Migration of SQL Server 2000 to SQL server 2005 (includes re-writing the existing maintenance plans)
• Provide expertise in T-SQL for SQL Server
• Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Experience on SQL LiteSpeed.
• Expertise in working with VLDBs size up to 1.5TB.
• Good experience in setup/administer Log Shipping, Replication and Clustering.
• Implemented merge replication-based solution over a WAN to maintain warm backup servers in remote site, as well as for disaster recovery.
• Nightly merge replication of over 110 corporate centers using T-SQL scripts.
• Operational support for SQL Server Report services (SSRS) and Analysis Services (SSAS).
• Worked extensively on SSIS/DTS for Data Migration and Administration tasks.
• Extensively used Script task and Script component task in SSIS to perform custom tasks and data cleansing.
• Variables and expressions were used in the packages to generate custom SQL code to make SSIS package tasks dynamic.
• Created tables using SSIS to load error data, error descriptions and package execution diagnostics.
• Built & Deployed SSIS packages to SSIS Package Store & MSDB database.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Built the data mart using Star/Snowflake Schemas for various business Units.
• Identify and resolve database performance issues, database capacity issues.
• Apply patches to SQL Server 2000/2005. Upgrade Servers from SQL Server 2000 to SQL Server 2005.
• Unit Testing the SSIS packages with respect to its flow and performance issues
• Managing multiple Production and Development Oracle Applications environments of different releases.
• Expertise on Microsoft Operations Management (MOM) to setup SQL Server Alerts.
• Experience in capacity planning, RAID & MSCS Services.

Environment: SQL Server 2000/2005, SQL Analysis services/SSAS, SSIS, SSRS, Oracle 9i, DB2 OS/390, Enterprise manager, Sarbanes-Oxley Act (SOX), Query Analyzer, Powershell, Service broker, ERWIN, SQL Server 2005, DTS, BIDS, MS Project, MS Access 97 / 2000 & Windows Server 2003 x86/x64, ADO.NET, OLE/DB, MOM, SCOM.

Confidential, Pittsburg, PA November 2006 – September 2007 
Role: SQL Server Database Administrator 
Confidential is one of the world's leading, innovative companies in the healthcare and medical products industry. The Role was of a Database Administrator
Responsibilities

• Provided an estimation of the migration plan in terms of feasibility, time duration and resources.
• Migrated SQL Server 2000 to SQL Server 2005
• Migrated Data bases from SQL server 2000 to SQL Server 2005 in pre production environment.
• Suggested and Developed database maintenance plan for Data warehouse environment
• Developed database maintenance plans such as rebuild index, re-assign index, full, differential and transactional backup, Database consistence checks
• Maintained High Availability such as Replication (Transactional replication) as far database disaster technique.
• Maintained High Availability such as Log Shipping and Mirroring as a database disaster technique
• Made database back up using SQL LiteSpeed (Full, Differential, Log and File group back up) and restore it
• Used DDL trigger for Data base Auditing.
• Used profiler and performance tuning to get better performance.
• Supported 24*7 production support and solved all kinds of critical problems.
• Implemented SSRS reports into Share point.
• Created reports by using bar chart, pie chart to analyze critical data in
• SSRS
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Developed, implemented and monitored a large-scale and time-sensitive production loading processes.
• Migration of SQL Server 2000 to SQL server 2005 (includes re-writing the existing maintenance plans)
• Worked and utilizing DMV’s in SQL Server 2005 for tuning and optimizing the servers.
• • Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases
• Actively participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit new business requirement and implemented new design into SQL SERVER 2000.
• Successfully migrated old data from legacy system into SQL SERVER 2000 using DTS Packages.
• Created Database Maintenance Plans for the Performance of SQL SERVER, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Carried over Logins and Jobs from SQL Server 2000 to SQL Server 2005.
• Evaluated data storage considerations to store databases and transaction logs. Created/Managed databases using SSMS, Database Wizard and T-SQL Statements (Scripts).
• Tuned, monitored, maintained & Scheduled SQL Server Jobs.
• Apply patches to SQL Server 2005. Upgrade Servers from SQL Server 2000 to SQL Server 2005 and extensively used upgrade advisor utility
• Developed Store procedure and Triggers in T-SQL.

Environment: SQL Server 2000/2005, SQL LiteSpeed, SSMS, DTS, DMV, SSRS, DDL, LOG SHIPPING, REPLICATION, T-SQL.

Confidential, Richmond, VA July 2005 – September 2006
Role: SQL Server Database Administrator
Confidential provides financing and services to business customers of all sizes to help them grow
Responsibilities

• 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. Resolved locking conflicts and resource utilization.
• Administered, maintained, developed and recommended policies and procedures for ensuring the security and integrity of the company's databases.
• Operational support for SQL Server Report services (SSRS) and Analysis Services (SSAS).
• Worked extensively on SSIS/DTS for Data Migration and Administration tasks.
• Used DDL trigger for Data base Auditing.
• Manage and Create database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc)
• Good experience in maintaining Log Shipping, Replication and Clustering.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service, MSDE, MDAC 2.8 and SQL 2000 on windows 2003 enterprise edition
• Provide expertise in T-SQL for SQL Server
• Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Extensively worked on DBCC commands.
• Provided documentation of reports and the development process in order to support the System
• Created Tabular reports, Cross Tab Reports and Sub Reports.

Environment: SQL Server 2000, Replication, Archiving, Backup and Recovery, Stored Procedures, SSRS, SSAS, SSIS, DDL, LOG SHIPPING, REPLICATION, Clustering, T-SQL, DBCC

Confidential, Danville, PA May 2004 – July 2005
Role: SQL Developer / Database Administrator
The role entails SQL Server 2000 development and support. The role requires interaction with Business and consolidating the business requirements into technical requirement and implementing them. Working in a team of other DBA’s to deliver the solutions. 
Responsibilities

• Set up efficient monitoring of SQL Server jobs to ensure that failures are reported immediately.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Designed and created databases, tables, views, store procedures and triggers.
• Developed various views and functionalities for the Affinity Compensation system department according to their specification.
• Suggest index tuning and performance optimization techniques.
• Work with teams across the country in different time zones to meet their requirements. .
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Designed and developed file loading process by creating complex stored procedures, functions and bind them with DTS package for logical execution.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Rebuilding the indexes at regular intervals for better performance
• Created DTS packages for migration of data from SQL Server to MS Access or Oracle Databases.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Experience in Log shipping.
• Worked on cluster environment, SAN and WAN
• Monitored and modified Performance using execution plans and Index tuning
• Worked with Data warehouse team to build the OLAP Cubes.
• Monitoring SQL server performance using profiler to find performance and dead locks and blockings.

Environment: Windows Server 2000/2003, SQL Server 2000, DTS, Analysis Services, Data Marts, Profiler, T-SQL

Confidential August 2002 – March 2004
Role: SQL Developer
Developed logical and physical data models, design data access strategies and write SQL code to access and manipulate data stored in relational databases.
Responsibilities

• Understanding Requirement Specification via interaction and writing functional specification.
• Developed, tested and implemented Stores Procedures.
• Written Triggers to capture the date and id of the record last updated on all the tables in the system.
• Tuned various SQL queries in the system for better performance.
• Developed User Interface Screens using Visual Basic 6.0.
• Development in Visual Basic 6, MS Access in Back-end Installation and implementation of new software applications.
• Automated testing the user interface screens using SQA.
• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server 2000.
• Designed databases for applications with requirements for large numbers of transactions, heavy access and high availability.
• Optimized T- SQL code.
• Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.
• Worked with Logical and physical models in Erwin (ETL).
• Expertise in forward and reverse engineering using Erwin (ETL).
• Developed and customized OMS according to client requirements, which allow user to create and maintain the documents and general administration.
• Extensively involved in designing and development of the application for various features such as maintaining loan applicant details and their documents, verifying the credit reports, enhanced search facility to search his/her applicant documents very easily etc.