Skills:

• Building and maintaining data mart extraction processes.
• Building and maintaining DTS packages
• Building and maintaining ETL scripts
• Building and maintaining production SQL jobs
• Building and maintaining SQL scripts in Microsoft SQL Server
• Building & maintaining complex SQL queries for data analysis & data extract
• Clear/excellent communication skills for interface w/ end-users & clients
• Database design, modelling, installing, upgrading SQL server
• Programming w/ SQL Server 2005/2008, SQL stored procedures
• SQL Server Configuration
• User Data and Log File Management
• Experience in the Unemployment Insurance industry Highly desired

Education & Certifications:

• Microsoft Certified Technology Specialist (MCTS – SQL Server 2005).
• Microsoft Certified Database Administrator (MCDBA SQL Server 2000).
• Bachelor of Engineering (Electronics & Communication), Confidential University

Work Experience

Confidential,Database Administrator,May 2012 – Till Date
Confidential,DBA Tech Lead,July 2011 – Apr 2012
Confidential,Sr. DBA (MSSQL),Sep 2010 – June 2011
Confidential,Database Specialist,June 2010 – August 2010
Confidential,Sr. SQL Server DBA,July 2007 – Dec 2009
Confidential,SQL DBA,Jan 2006 – June 2007
Confidential,SQL DBA,March 2003 – Jan 2006
Confidential,SQL Developer/DBA,May 2001 – Feb 2003
Confidential,Software Engineer,June 1999 – April 2001

Employment History:

Confidential June 2011 – April2012
Database Admin 
Project Description:BankofAmerica MerrillLynch provides comprehensive market, industry, product and strategic advisory expertise to help our clients succeed in Asia and around the globe.
Key Responsibilities:

• Executing the day-to-day database operations Modelling, Installing, configuring, patching and administering the database SQL servers.
• BCP, Power down Drill exercise every quarter.
• Support migration and upgrade of Databases.
• Designed the dimensional data mart and developed SSIS packages to validate
• Database Performance monitoring and tuning.
• Backup and recovery of Databases.
• Proactive monitoring of the production servers and minimizing the downtime.
• Timely resolution of the production issues.
• Implemented BCP/ETL Scripts for data transformation
• Resolve SQL Job failures
• Design and ensuring the Physical and Logical Model are in synch with every release
• Optimize Data and Log management throughput and availability

Environment: SQL Server 2000, 2005, 2008, Windows 2000, 2003, 2008

Confidential September 2010 – June 2011
Database Admin Project Description: 
The Infocomm Development Authority of Singapore (IDA) and Hewlett Packard (HP) Singapore maintains the infrastructure capabilities for the end client. The core project responsibilities is to set up replication on BMC Remedy for reporting purpose, upgrading servers to SP4 and various database activities.
Key Responsibilities:

• Executing the day-to-day database operations modelling, Installing, configuring, patching and administering the database SQL servers.
• Support migration and upgrade of Databases.
• Database Performance monitoring and tuning.
• Backup and recovery of Databases.
• Proactive monitoring of the production servers and minimizing the downtime.
• Timely resolution of the production issues.
• Build and maintained Data Mart Extraction, transformation and loading modules.
• Building and maintaining datamart extraction process
• Implemented BCP/ETL Scripts for data transformation
• Development of data extract, transform and load (ETL) programs using Microsoft SQL Server, including T-SQL, DTS and SSIS
• Resolve SQL Job failures
• Optimize Data and Log management throughput and availability

Environment: SQL Server 2000, 2005, 2008, Windows 2000, 2003, 2008, DTS Packages

Confidential June 2010 – August 2010
SQL Server Specialist 
Project Description
Confidential is a leading international information technology (IT) services company, providing hi-tech transactional services, consulting, systems integration and managed operations to deliver business outcomes globally. 
The Singapore Youth Olympic Games Organizing Committee (SYOGOC) and Atos Origin – the Worldwide Information Technology Partner for the Olympic Games supporting the Youth Olympics 2010.
The database infrastructure is as follows -:

• 2 Active-Passive Cluster
• Extensive Replication
• 100’s of standard alone SQL Server instances

Key Responsibilities and Achievements

• Executing the day-to-day database operations modeling,Installing, configuring, patching and administering the database SQL servers.
• Involved on Creating and Implementing Disaster Recovery Plan – best practices.
• Performance Monitoring – Log (Application, System, Security) , Perform on – Regular and Timely Fashion
• Advanced Statistics gathering of Memory, CPU, I/0, Hardware Failure, Application Bottleneck.
• Setting up and Maintaining Windows Cluster & SQL Clusters
• Setting up and maintaining Replication – Transactional & Snapshot
• Created SQL Server Integration Services (SSIS) Packages for Maintenance plans, Optimization Jobs, and custom data extract scripts.
• Creating and Running Maintenance Plans during Maintenance Window.
• Replication monitoring.
• Monitoring Backup/Restore (Refresh non production databases with production database)
• Resolving Drive Space issues

Environment: Windows 2k,2k3,2k8, SQL Server 2005,2008, SSIS Packages, SQL 2005 Reporting Services, DTS Packages.

 Confidential, Bellevue, WA July 2007 – December 2009 
Sr. SQL Server Developer/DBA 
Project Description
Demand Media is a leading social media company that provides an interactive, personalized and vertically-focused media experience for over 65 million unique users. By using its proprietary social media tools and the unique distribution platform of the world's second largest domain registrar, the company connects content creators and audiences to grow its network of vertical media web properties
The database infrastructure is as follows -:

• 3 Data Centers in United States
• 3 Active-Active Cluster
• 2 Active-Passive Cluster
• Extensive Replication
• 100’s of standard alone SQL Server instances

Key Responsibilities

• Executing the day-to-day database operations Modelling, Installing, configuring, patching and administering the database SQL servers.
• Responsibilities include Configure, Design , install and upgrade SQL server
• Involved on Creating and Implementing Disaster Recovery Plan – best practices.
• Performance Monitoring – Log (Application, System, Security) , Perform on – Regular and Timely Fashion
• Advanced Statistics gathering of Memory, CPU, I/0, Hardware Failure, Application Bottleneck.
• Familiar with Log Parser 2.2 and Performance Analysis Log.
• Setting up and Maintaining Windows Cluster & SQL Clusters
• Created packages using SSIS for Data mart extraction from Flat Files, Excel Files
• Setting up and maintaining Replication – Transactional & Snapshot across geographic locations.
• Creating and Running Maintenance Plans during Maintenance Window.
• Monitor and Resolve Job Failures (Debug stored Procedure if required).
• Replication monitoring.
• Designed SQL SSIS Packages in to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations.
• Running DTS/DTSX Packages for Failed Jobs
• Monitoring Backup/Restore (Refresh non production databases with production database)
• Resolving Drive Space issues
• Monitoring using wide range of Quest tools that includes Spotlight, Performance Analysis,
• SQL Watch, Benchmark Factory for Databases, Toad
• Development of data extract, transform and load (ETL) programs using Microsoft SQL Server, including T-SQL, DTS and SSIS
• Building and maintaining datamart extraction process
• Implemented BCP/ETL Scripts for data transformation
• Resolve SQL Job failures
• Creates SQL scripts to correct identified data issues that cannot be corrected by the existing applications.
• Design and ensuring the Physical and Logical Model are in synch with every release
• Optimize Data and Log management throughput and availability

Environment: Windows 2k,2k3,2k8, SQL Server 2005,2008, SSIS Packages, SQL 2005 Reporting Services, SQL Lite Speed, DTS Packages.

Confidential, San Francisco, CA January 2006 – June 2007
SQL Server Developer/ DBA 
Project Description
Confidential, a direct-to-consumer auto insurance company, is committed to taking the hassle out of shopping for, buying, and managing auto insurance. By leveraging technology and innovating traditional processes, the company has found environmentally friendly ways to simplify auto insurance from quote to claim— saving consumers time and money. Esurance's reliable auto insurance coverage is available to 80 percent of drivers in 22 states.
Key Responsibilities

• Executing the day-to-day database operations Modeling, Installing, configuring, patching and administering the database SQL servers.
• Responsible for development of stored procedures, triggers and ETL scripts.
• Proactively monitor the Production Database and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization.
• 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.
• 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.
• Responsible for extensive application/SQL monitoring, troubleshooting, tuning, high-availability strategies in a Windows 2000/ SQL Server 2000 24X7production environment.
• Prepares standard statistical reports, such as incident reports. Analyzes and evaluates incident reports and makes recommendations to reduce incident rate.
• Designed SQL SSIS Packages in to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations.
• Provides application support for third party software applications with which esurance integrates. Work with other internal functional areas and third party vendors to resolve issues.
• Verify batch runs. Monitors the error logs for major problems. Regularly checks site monitors to ensure site is functioning. Logs defects in tracking system for any newly identified issues.
• Creates and implements reporting mechanisms for the purposes of performance monitoring. This will include recommending software enhancements for the purposes of reporting.
• Creates SQL scripts to correct identified data issues that cannot be corrected by the existing applications.
• Development of data extract, transform and load (ETL) programs using Microsoft SQL Server, including T-SQL, DTS and SSIS
• Handles problem recognition, research, isolation, resolution and follow-up for routine user problems, referring more complex problems to supervisor or technical staff.
• Interviews users to collect information about problem and leads user through diagnostic procedures to determine source of error.
• Logs and tracks calls using problem management database, and maintains history records and related problem documentation.
• Provides application support for QA and Development groups.
• Participates in a rotating On-Call schedule.
• Design and ensuring the Physical and Logical Model are in synch with every release using Embarcadero ER Studio.
• Maintained data mart extraction process
• Implemented BCP/ETL Scripts for data transformation
• Resolve SQL Job failures
• Optimize Data and Log management throughput and availability

Environment: Windows 2000, SQL Server 2000, DTS Packages, Embarcadero ER Studio, SQL Data Compare, Toad for SQL Server 2000, Spot light for Monitoring.

Confidential Sr. Systems Engineer March 2003 – January 2006
Client: Microsoft Corporation
Location: Seattle, WA
Project Description
Project is to migrate Microsoft’s Sales and call centre data from Siebel 3.0 to Siebel 4.0. Siebel 3.0 application was developed using Siebel 6.5 ver. and Siebel 4.0 application will be developed using Siebel version 7.5.2. The existing application has four regional servers based on the geography, which are non Unicode databases apart from one Unicode database called HQ. The four regional non Unicode databases are called as DBCS databases. Then convert the non-Unicode data bases to Unicode databases. Till this point all the transformations and Unicode conversion happens on each of the 5 servers separately. After the Unicode conversion the data from 4 DBCS servers is consolidated into one centralized HQ db. After the DBCS consolidation happens, there are some more transformations implemented to affect the data in common. Integration module is responsible for integrating the migrated data in synch with the existing MS legacy application. The data in Siebel, related to the products, contacts and Accounts must be accordant with MS legacy systems. Involved with various Insurance industry
Key Responsibilities

• Executing the day-to-day database operations, Modeling, Installing, configuring, patching and administering the database SQL servers.
• Developed design documents for the system over the period of maintaining and implementing new functionality/modules on the entire system.
• Designed and Developed .net data access components using Microsoft Data Access Application Blocks.
• Designed the dimensional datamart and developed SSIS packages to validate.
• Designed SQL SSIS Packages in to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations
• Involved in designing the process flow, and prepared the technical design based the functional specification for components that are responsible for data feed and data synchronization between the Siebel DB and MSO
• Involved in preparing the technical design document for the DBCS Consolidation job
• Developed stored procedures for different modules and monitoring raw sql which exists in the application code for optimization and performance tuning.
• Developed ASP.net component for the set of 12 templates.
• Involved on Customer Support related queries/issues and implementations.
• Involved in EIM for data mapping and setting up SQL databases for Siebel Environments.
• Version controlling software used Visual Source Safe.
• Implemented BCP/ETL Scripts for data transformation
• Development of data extract, transform and load (ETL) programs using Microsoft SQL Server, including T-SQL, DTS and SSIS
• Bug Tracking software used is Project Tracking system.
• Responsibilities include administration, development and maintenance tasks for 15 SQL Servers spanning across the region (EMEA) supporting over 2000 Siebel end users.
• Creation and maintenance a highly available, secure, and reliable production database environment.
• Taking care of SQL Jobs, SQL Replication issues and working promptly and performing the audit on issues to work proactively and define process to handle the issues
• Creating, maintaining and monitoring scheduled applications and events. Developing, implementing and maintaining scheduled production extract-transform-load processes within and across database environments
• Creates SQL scripts to correct identified data issues that cannot be corrected by the existing applications.
• Design and ensuring the Physical and Logical Model are in synch with every release

Environment: Windows 2000, Windows 2003 Server, SQL Server 2000, C# , ASP.NET, Visual Studio.net 2003 and Process Control Utility – Utility developed by Microsoft which enables the sequential execution of group of components including, exes, SQL Scripts, stored procedures and EIM tasks, Siebel Tools, EIM, DTS Packages

Confidential May 2001 – February 2003 
Sr. Software Engineer 
Project Description: 
Confidential is a privately held multinational software company headquartered in suburban Washington, D.C., in Chantilly, Virginia. In addition to the offices in the United States and Australia, it has a R&D facility at Bangalore, India. The Bangalore facility provides some of the most-talented and best-trained minds in the software industry and Icode’s products reflect this creative genius. Icode’s award winning enterprise product Everest line successfully integrates high-end e-commerce and back-end operation functionality, right out-of-the-box. It provides businesses with one software to run their entire business, from bricks to clicks’. Icode wins Microsoft `Small Business Solution of the Year' award at Asia Fusion 2001.
Key Responsibilities:

• Developed design documents for the system over the period of maintaining and implementing new functionality/modules on the entire system.
• Developed .net data access components using Microsoft Data Access Application Blocks.
• Developed stored procedures for different modules and monitoring sql which exists in the application code and triggers for optimization and performance tuning.
• Developed ASP.net component for the set of 12 templates.
• Involved on Customer Support related queries/issues and implementations.
• Developed .net installation setup component for installing the Everest eCommerce software at the customer site.
• Conversion of existing ASP based templates to ASP.net.
• Version controlling software used Visual Source Safe.
• Bug Tracking software used is Project Tracking system.

Environment:Windows 2000, MS SQL Server, ASP.NET, IIS, JavaScript, VBScripts, C#, DHTML, HTML, XML, .NET Framework, COM/DCOM,MS Visual Source safe, Rational Rose, Web load, ASP.NET, ADO.NET, JavaScript, HTML, DHTML, SQL Server 2000, IIS 5.0, Visual Source Safe, VS.NET, ASP 2.0

Confidential June 1999 – April 2001
Software Engineer 
Project Description: 
This project is used as a stage to float new goods and awareness about various products, by conducting contests and distributing prizes to the winners. This project is basically hosted by the Organization Silicon House in Adyar, Chennai. The revenue for the organization is based on the ads placed by the Local merchants around the area. The visitor to the site is encouraged by allowing them to participate in the quiz programs and puzzle and so on. The no. of hits makes the revenue for the company. Worked with Insurance clients.
Key Responsibilities:

• Developed ASP Pages for the entire site using Microsoft visual Interdev / Front Page that includes database calls, Session Tracking and dynamic functionalities.
• Developed stored procedures for different modules.
• Developed and business components to support various business functions.
• Developed Java script for the dynamic behaviors involved across the site and support for enhancements.
• Involved on customer interaction for posting their advertisements, messages and logo to the site.

Environment: Windows 2000, SQL Server 7, ActiveX Data Objects(ADO), Internet Information Server (IIS), Visual InterDev, Active Server Pages (ASP), JavaScript, VB Script, COM, Visual Basic 6.0 (VB), and Visual Source Safe (VSS), MS-Access, ASP 2.0