SUMMARY

• Over 8+ years of IT experience with Microsoft Database Technologies as a SQL Server DBA in MS SQL SERVER 2008/2005/2000/7.0 in a Windows environment.
• Expert in installation, upgrade, configuration and administration of MS SQL Server 2008, 2005 & 2000 in clustered and stand alone environments.
• Experience in Normalization, Database design and capacity planning.
• Design and document Logical and Physical data models.
• Experience in performing administrative functions including Backup and Recovery, Database Security, Running Database Consistency Checks, Designing and optimization.
• Experience in implementing the new features of MS SQL Server 2008 such as Policy Based Management, Backup Compression and Transparent Data Encryption.
• Experience working with 24x7 Production support for 2008, 2005 and 2000 SQL Server.
• Expert in configuring cluster environments: SQL Server 2008/2005 Active/Active and Active/Passive Cluster on window 2008, 2003.
• Expertise in implementing Database Mirroring in SQL Server 2005 for high availability.
• Successfully tested and implemented Log Shipping Technique used for warm standby solution for MS SQL Server 2005/2000 databases.
• Experience in implementing Snapshot and Transactional replication models.
• Proficient in Migration of Data to/from various heterogeneous sources from/to MS SQL server by using SSIS/DTS utility.
• Extensive experience in Creating, Building, Deploying various Data and Control Flow tasks using SSIS and Redesign data flow between departments as per the requirements.
• Experience in developing Custom report and different types of Tabular, Matrix, Ad hoc and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS).
• Installed, Configured and maintained the Reporting Services.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, Perfmon Counters and Spotlight.
• Experience in Creating Tables, Views, Stores Procedures, Triggers, Indexes, and User - Defined Functions and monitoring Scripts using T-SQL.
• Good Knowledge of SQL Server Dynamic Management Views as well as third party tools like Quest Fog light, Spot lights, DIAG Manager from Idera, for Monitoring performance and maintenance of MS SQL Server.
• Experienced in configuring and managing Linked Server, Data transfer between SQL Server and other Databases such as Oracle.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies, Strong interpersonal and communication skills

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/2003, Windows 2000 Advanced Server, Windows NT 4.0, Windows 95/98/XP

Languages: T-SQL, PL/SQL, Visual Basic, XML, HTML, C, C++

RDBMS: SQL Server 2008/2005/2000 MS-Access

Database Modeling: Data modeling / Database design (logical / Physical) using Rational Rose

Data Warehouse Modeling SQL Server: Designing and implementing OLAP solutions Environment using Microsoft Analysis Manager, Data Transformation Services, Implementing OLAP withSQL Server 2000/2005 RDBMS

Other Tools: MS Project, Microsoft Word, Excel, OutlookPowerPoint etc.

PROFESSIONAL EXPERIENCE

Confidential, SFO, CA

SQL Server DBA

Responsibilities:

• Responsibility includes configuring, administration and troubleshooting multiple databases including VLDB in development, QA and Production environments.
• Installing and configuring Multinode Cluster environment with SQL Server 2008 as high availability.
• Upgradation from MS SQL 2005 to SQL 2008, SQL 2000 to SQL Server 2005/2008.
• Monitored growth of data and managed space allocation accordingly.
• Configured Database Mirroring in SQL Server 2005 for Report Servers.
• Creation and maintenance of Databases, creating roles and managing user permissions, resolving Blocks and deadlocks.
• Experience in providing excellent 24X7 Production support.
• Performed daily support, troubleshooting, monitoring and optimization and tuning of server and SQL server environments across entire system.
• Entertained user request for the applications like Refreshing staging, QA from Production.
• Tuned and Optimized the Queries, Stored Procedures, UDF, triggers.
• Experience in working with BMC Service Desk Express Suite for ticketing.
• Promoted and Tuned the SSIS Packages in different environment.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008/2005 as SSIS packages.
• Worked with Development team package to modify the migrated complex SSIS.
• Extensively used Litespeed for backup and maintenance plan.
• Experience in connecting to remote SQL Servers as Linked Servers.
• Configured and maintained Transactional Replication in SQL Server 2008/2005 in different domains as business requirement.
• Prepared high-level documentation for the Database Design, Database objects Security and Rules.
• Used Diagnostic Manager from Idera’s solutions and implemented custom scripts for Pro- Active monitoring SQL Servers.
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups.
• Experience in contacting Microsoft and other vendors for product and technical support.
• Created deployment scripts, including rollback scripts, for all SQL Server changes.

Environment: Windows 2000 Advanced Server, Windows Server 2008/2003 EE, MS SQL Server 2000/2005/2008 , Microsoft SQL Server Reporting Services 2005, Visual Studio.Net 2003, Compaq Proliants 8000/6500,IBM Fast T 700 Storage Area Network (SAN).

Confidential, New York, NY

Responsibilities:

• Successfully migrated from SQL Server 2005 to SQL Server 2008 on development and testing environment.
• Created complex SSIS packages for the extracting, transforming and loading the data from SQL Server 2005, flat files, Oracle, Excel files.
• Expertise in data cleansing, mapping columns, lookup with various SSIS objects.
• Converted all existing DTS package of MS SQL 2005 to SSIS packages by using package migration wizard and deployed new package in different server.
• Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
• Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
• Installed and configured edition of SQL Server 2008 like Enterprise edition.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, mirroring, database integrity verification, indexing and statistics updates.
• Designed new reports and customized existing reports of older version to new version.
• Responsible for resolving blocking and locking issues.
• Successfully implemented database mirroring between primary server and mirror server.
• Implemented log shipping in standby mode to support DR servers.

Environment: Microsoft Windows Server 2008 Enterprise Edition, Microsoft Windows 2003 Server, Microsoft SQL Server 2005, 2008, Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services, Microsoft Office 2003.

Confidential, Paramus, NJ

SQL Server DBA

Responsibilities:

• Provided system administration team with suggestions regarding disk configuration, RAID level according to database sizing and capacity planning.
• Actively involved in Installing SQL Server 2005, Maintenance and Performance Tuning
• Moved production databases to new servers within least downtime, and responsible for space allocation, Recovery(Backup/Restore) strategies, table maintenance
• Monitoring server performance with Windows Performance Monitor, SQL Profiler, Query Analyzer, Execution Plan, Server Trace, Client Statistics or system stored procedures
• Checked data file allocation, index, fill factor, fragmentation.
• Actively monitor impact on system performance to analyze existing or potential problems to optimize performance, and created jobs, alerts, activity logs, error logs to capture any possible errors
• Worked with DBA to manage setup the procedure of database backup and restore.
• Performed SQL Server Log Shipping to send transaction logs of critical database (the primary database) to the secondary database on a constant basis to back up the primary database and enhance the SQL Server availability in environment of SQL Server 2005
• Maintain data consistency and synchronization with other branches using Replication.
• Database Design and Development using SQL Server 2005 management studio
• Actively involved to monitor the performance and availability requirements of on-line systems and multiple applications, including normalizing or de-normalizing database design to achieve efficient storage or better performance
• Migrated some DTS packages of SQL Server 2000 to SQL Server 2005 to make them reused in new environment
• Created SSIS packages to achieve data clearance and load data into desired destination with preferred format
• Created SSIS package to fulfill the SQL Server maintenance tasks including rebuilding index, backing up database and updating statistics
• Created SSAS package to build OLAP Cubes based on multidimensional database with star schema or snow flake schema
• Built SSRS project to generate reports with desired forms(Webpage, PDF, Excel and etc) to present statistics information according to business requirement

Environment: SQL Server 2005, SSIS, SSAS, SSRS, T-SQL, Windows server 2003, Windows 2000 server, SQL Server2000 (Enterprise Manager, Query Analyzer), RAID utilization, DTS, Database Engine Tuning Advisor, SQL Server Management Studio, Excel, SQL Server Agent, Microsoft Visual Studio .

Confidential, Redwood city, CA

SQL Server DBA

Responsibilities:

• Installing MS SQL Server2000, configuration and doing performance tuning, capacity planning, query optimization
• Created backup and Restore strategies and scheduling them for execution.
• Created user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Employing indexing strategies and optimizing them using SQL Profiler and Index Tuning Wizard.
• Created stored procedures, scripts, cursors for the Bulk application, tested them on the test servers and moved them to production.
• Monitoring SQL server LOGS, Traces, Application logs and analyzing the logs.
• Connecting SQL servers remotely using Terminal services.
• Assign permission to user(s), role(s), and object.
• Support Administrate security for server’s logins (Windows and SQL Accounts).

Environment: SQL Server 2000, Windows 2000Server, DTS, TSQL, SQL Profiler.

Confidential

Tech Support Engineer

Responsibilities:

• Performing Backups of user data.
• Responsible for Asset Inventory for all Hardware and Software items.
• Training of new executives joining in Technology Team and business users on the Software’s used in organization.
• Trouble shooting system and software related problems.
• Installing Desktops & Laptops, Upgrades of hardware and software products to existing products. Performing and maintaining hardware devices: LAN card, Modem, Printer and Scanner.

Environment: SQL Server 2000, WIN 2000, Visual Basic 6.0

Confidential

SQL Server Developer

Responsibilities:

• Designed Sales Monitoring database from the existing system.
• Created Stored Procedure, User-defined Functions to take care of back end validations when transferring data to Production Server.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality Implemented backup and database maintenance plans.
• Created DTS packages and jobs to monitor, backup, import/export data and data warehouse extracts.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Performance monitoring and tuning of SQL Server queries.
• Import and Export of Database objects.
• Worked to establish connectivity between VB Applications and MS SQL Server by Using ODBC.
• Administering MS SQL Server by Creating Logins and assigning appropriate roles.
• Was involved in design in Database.

Environment: MS SQL Server 2000, Windows NT, SQL Profiler, Access, Excel, Windows 2000, Query Analyzer, Enterprise Manager.

Confidential

MS SQL Server Developer

Responsibilities:

• Created databases, schemas, tables, indexes, views, constraints.
• Defined stored procedures for module integrity and application.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Involved in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to SQL Server using DTS and also used BCP and Bulk Insert and even the other way.
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Maintained database and Backup/recovery. Defined Database Maintenance Plan, which was scheduled as job which ran automatically.
• Created and managed users, roles and groups and handled database security.
• Monitored the system for bottlenecks using performance counter.
• Use the SQL Analyzer and Profiler for studying the SQL statements and procedures
• Created joins and sub-queries for complex queries involving multiple tables.
• Converted Logical Database Diagram into Physical Schema using the balanced Normalization in 2nd and 3rd Normal Form for highest performance.
• Managed Database files, transaction log and estimated space requirements.
• Documented and commented the queries for easy understanding for future reference.

Environment: MS SQL Server 2000, Enterprise Manager, T-SQL, DTS, MS Excel, MS Word