Professional Summary

Having 10+ years of IT experience as a Database Administrator in MS SQL Server 2008/2005/2000, MySQL 5.5, Oracle 9i/10g supporting mission critical OLTP and OLAP environments that included Production and Development Databases under Windows and Linux platforms.

Demonstrate a solid technical background, strong communication, multi-tasker, pro-active, results oriented team player who also works well independently and excellent customer support.
Excellent experience in Installing and Configuring SQL Server 2008/2005/2000, MySQL 5.5, Oracle 9i/10g to provide the optimum performance to high volume OLTP and OLAP Environments.
Experience in Upgrading and Migrating servers from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008 and MySQL 5.1 to MySQL 5.5.
Experience in migrating data from SQL Server 2008 R2 to MySQL 5.5.
Good hands on experience in installing SQL Server in Windows Cluster Environment.
Excellent experience in Planning, database implementation, troubleshooting, performance tuning, backup and recovery and other administrative tasks in SQL Server 2008/2005/2000, MySQL 5.5.
Solid experience in Logical Database design, Physical Database Design, Physical Resource Planning, Allocation and Maintenance.
Good experience in Query Optimization, DB Optimization, building better indexes for the tables and fine tuning existing indexes.
Good knowledge in implementing stored procedures, Triggers, Cursors and Functions using TSQL.
Experience in Automating Database maintenance plans for checking database integrity and Capacity planning.
Strong hands on experience in scheduling back-ups for databases and transaction logs.
Strong hands on experience in scheduling jobs for optimization, consistency and integrity checks of the databases (using DBCC).
Strong experience in Planning and Implementing Database Security.
Experience in designing SSIS packages for import and export data to/from SQL Server Databases.
Experience in Data modeling and designing using tools like ERWin, ER/Studio and Database Design Tool.
Strong experience in data transfer from Oracle 11g/10g/9i/8i/8.0, Sybase 11.5/11.0 and MS Access to SQL Server using ETL tools like SSIS, MS DTS.
Tuning and Optimizing Hibernate Queries.
Hands on Experience and outstanding Knowledge of High Availability SQL Sever Solutions, including Transactional Replication, Log Shipping and Database Mirroring.
Experience in MS SQL Server tools like SSMS, SSIS, SSAS, Enterprise Manager, SQL query analyzer, SQL Server Profiler, Windows Performance Monitor, Database tuning advisor, Activity Monitor, etc.
Experience in SQL Server Reporting Services (SSRS) Installation and Configuration.
Experience in creating and managing reports using SSRS.
Good experience in OS system administration, configuration, troubleshooting, performance tuning, preventative maintenance, and security procedures in Windows 2008/2003/2000, Red Hat Linux 6 and Sun Solaris 9.
Provided after hours and 24/7 database maintenance and production support.
Experience in installing and configuring SharePoint Server 2010.

Technical Summary:

Databases:

MS SQL Server 2008 R2/2005/2000, ORACLE 9i/10g, MySQL 5.5

Languages:

T-SQL, PL/SQL

Data Warehouse:

MS SQL OLAP, SSAS

Operating Systems:

Windows 2008/2003/2000, Windows XP/98, Windows Vista, Windows 7, Red Hat Linux 4, Sun Solaris 9

Internet Technologies:

UNIX Shell Scripting, Perl Scripting

Internet/Web:

Internet Information Server (IIS) 7.0

Collaboration:

SharePoint 2010

Certifications:

Microsoft Certified IT Professional (MCITP)
Microsoft Certified Technology Specialist (MCTS)
Microsoft Certified Database Administrator (MCDBA)
Oracle Certified Associate (OCA)

Professional Experience:

Confidential,Alpharetta, GA Feb 2011 – Present
Role: Senior Database Architect/Administrator

Travel Syndication Technology (TST) is a travel technology company formed by AAA Clubs like AMA Travel, South Central Ontario CAA, Ohio Auto Club (AAA), AAA Mid-Atlantic, etc for building a state-of-the-art travel technology platform for consumers and travel agents. I am working as a Senior Database administrator and playing an important role in maintaining the databases required for the application and successfully handling all database related tasks independently. Directly working with the client in designing the databases. Helping developers in tuning several database SQL scripts.
Environment: WINDOWS 2008 (Enterprise Edition), Windows 2003 (Enterprise Edition), MS SQL Server 2008 R2 (Enterprise Edition), MySQL 5.5, InnoDB, MyISAM, Hibernate, Quest Software, SQL Lite

Confidential,South Bend, IN Jul 2009 – Feb 2011
Role: Database Architect/Administrator

Springwise Facility Management is a privately owned facility management company with 40 years of experience and thousands of clients all over US. This is a Microsoft Certified Partner Company. Information Systems department plays an important role in the Company where most of the client and vendor association is through Web. As a part of the IT department and the only DBA, I am responsible for supporting both Microsoft SQL Server and MySQL environments and ensuring its performance, availability and security and also ensure database performance by planning, developing, managing, and securing databases.
As the Company data started growing, the need to organize the data and provide ease of access to the end users increased. As a part of this we have recently moved all our data to SharePoint 2010 which was previously stored on File Shares. I took the entire responsibility of SharePoint right from suggesting the software, installation, configuring, creating web sites, etc.

Environment: WINDOWS 2008 (Enterprise Edition), Windows 2003 (Enterprise Edition), MS SQL Server 2008/2005/2000 (Enterprise Edition), MySQL 5.5, Share Point Server 2010, Quest, SQL Lite, SQL Compare

Confidential,Quincy, MA Jan 2008 – Jun 2009
Role: Database Administrator (lead)

Fidelity Spaces is a pre-production pilot of a full-featured, social-software enabled collaboration platform from jive Software, Inc. called Clearspace. The pilot is hosted and operated by FCAT, the Fidelity Centre for Applied Technology in the FTG ETAG division.

Environment: WINDOWS 2003 (Enterprise Edition), Windows 2008 (Enterprise Edition), MS SQL Server 2008/2005/2000 (Enterprise Edition), MySQL 5.5, HP Site Scope, Oracle 10g/11g, Red Hat Linux, Clearspace, ERWin

Confidential,India Oct 2005 – Dec 2007
Client: Microsoft Technologies
Role: Production DBA (SQL Server) / SQL Developer

Microsoft Language resource Centre is a cross-company service to source, manage, and provide data of all sorts (including lexicon—dictionaries/wordlists, speech, text, and query data, covering all languages), share information, and plan future requirements for data. The purpose of MSLRC is to provide centralized language resources (text, speech, and query corpora, word lists, dictionaries…) for product development, testing and research to Microsoft groups

Environment: Windows 2003 (Enterprise Edition), Windows 2008 (Enterprise Edition), MS SQL Server 2005/2000 (Enterprise Edition), SSIS, SSAS, MS DTS, MS Analysis Services, T-SQL, Idera SQLSafe, ER Studio, Visual Studio 2005

Confidential,India Jun 2003 – Sep 2005
Client: UBS Investment Bank
Role: Database Administrator / Developer (SQL Server / Oracle)

GGL (Global General Ledger) application is a back office Global Accounting system for UBS. GGL is used for controlling the bank\'s financial operations and reporting. It is used by many Finance & Control business users, analysts, accountants, business unit controllers (BUC\'s) and senior business management personnel. GGL receives inputs (flat files) from various business units and processed by using sub systems named CAL, FDD, ICE, H3, and SAPR3&BW. Different reports like Management Reports, Head-office Reports, Regulatory Reports, Internal / General Ledger Reports are generated by GGL on daily and monthly basis.
Environment: Windows 2003 (Enterprise Edition), MS SQL Server 2000 (Enterprise Edition), Oracle 9i/10g, MS Visual SourceSafe, Visual Basic 6.0 MS DTS, T-SQL, MS Analysis Services, Red Hat Linux, Oracle Applications

Confidential,India Feb 2002 – May 2003
Client: British Telecom
Role: Production DBA / Developer (SQL Server / Oracle)

BTDBA mainly involves data synchronization of the existing and disabled telephone connections. There are two databases for OLAP and OLTP data. Based on the allocation of the network resources the databases need to be synchronized on regular basis.
Environment: Windows 2000 (Data Center), MS SQL Server 2000 (Enterprise Edition), Oracle 9i, VB 6.0, Red Hat Linux.

Education:

Bachelors Degree in Electronics and Communications Engineering.