TECHNICAL EXPERIENCE

• Over 6 years of experience as MS SQL SERVER 2000/2005/2008 Database Administrator (DBA).
• Involved in initial review of architectural diagram, database design. Disaster recovery solution and SAN disk layout for new database servers.
• Involved in peer review with application team and resource to suggest and implement reliable SQL environment
• Provided SQL Server DBA support and technical support for multiple applications in development, test/QA and production environments.
• Provided 24X7 supports (TIER1, TIER2, and TIER3) for critical server or application based on on-call rotation.
• Created and maintained database mirroring for High Availability environment.
• Worked on log shipping, data Transformation services (DTS) and SSIS packages.
• Configured and Maintain a Microsoft SQL server 2005/ 2008 on Windows Cluster environment 2003/2008.
• Installation, up gradation, applying service patches and configuration for various versions of MS SQL Servers with involving in disks layout as well as database file group structure.
• Implemented Database Security at server level using various severity alerts to keep environment secure.
• Experience in creating SSIS packages, jobs, maintenance plan and alerts using SQL Mail.
• Worked on database partitioning in SQL 2005 / 2008 and provided optimum solution for large databases for better performance.
• Extensive knowledge in optimizing SQL queries & improving the performance.
• Experience in moving data from different data source such as excels, Oracle to MS SQL Server by using link server, SSIS, DTS utilities.
• Involved in developing stored procedures, functions, views, triggers using T-SQL.
• Experienced with capacity planning, projection of database growth and advising for the hardware configuration.
• Worked on SSRS configuration, reports development and deployment on server.
• Experience on developing SSIS package using SQL server business intelligence development studio 2005/2008.
• Troubleshoot and documented database problems as they arise.
• Create and update existing documentation as necessary for business continuity and knowledge transfer
• .NET, VB6, Crystal Reports, Sybase 12.5, PowerBuilder 9.0, HTML.

EDUCATION
Bachelor of Engineering

SUMMARY OF WORK EXPERIENCE

Confiedential, Nov 2008 Present Position: SQL Server Database Administrator
Comcast is the largest cable provider and the second largest internet provider in communications and broadcasting field of the United States. Comcast mainly deals with cable, DSL, VOIP and Dial up services areas. As part of large organization, our team was maintaining around 170 production servers including OLTP and OLAP.

Responsibilities:

• Installation/configuration of SQL server 2005/2008 on standalone and windows cluster environment (2003/2008). Migrated existing environment in to SQL server 2005/2008.
• Installed SQLServer analysis and reporting services 2008 on windows cluster.
• Work with application team to analyze architectural diagram and design disk layout structure to get optimum performance
• Implemented database mirroring for hot standby disaster recovery solution to keep environment stable.
• Implemented log shipping as DR solution.
• Worked on SQL query tuning. Execution plan to enhance query performance.
• Setup SQL jobs to rebuild/reorganize index to run periodically based on index fragmentation.
• Design and implementation of Performance Tuning and Maintenance plan for database consistency checks, backup/restore.
• Design DTS package to export data form access data source to SQL Server and vice versa.
• Create and maintain SSIS packages to run jobs and export data in SQL server 2005/2008.
• Used SQL Server Profiler to track database activities to identify conflict between application and database.
• Created reports using MS visual studio 2003/2005/2008 to present data to the management.
• Involved with various business groups while developing their applications, assisting in database design, Phasing from development to QA and to Production environment.

Environment:
SQL Server 2000/2005/2008, T-SQL,MS Reporting Services, Management Studio 2000/2005, Query Analyzer, Windows 2000/2003 Server, Oracle 9i/ 10g, MS Visio.

SQL Server DBA (Consultant) Mar 2005 to Nov 2008
Confiedential,
Worked in the Confiedential, division of PennDOT as SQL Server database administrator. Maintained about10 SQL Server 2000 and about 15 SQL Server 2005 instances on various servers. He was mainly involved in creating the backup plans, disaster recovery strategies, migrating databases from development servers to Production servers, creating users/ roles. He was involved in relational data modeling for different projects. He was also involved in creating the DTS packages, SSIS packages, Reporting Services. He was a mentor for the DBAs at PennDOT. He was also responsible for creating reports using different databases. His duties include data conversion from different databases to SQL Server 2000/2005. He is involved in relational data modeling for various projects.

• Maintained SQL Server 2000/ 2005 instances
• Data modeling
• Data administration
• Backup plans
• Disaster recovery plans
• SQL performance monitoring and tuning
• Data conversion, importing the data from various databases such as Oracle, DB2, FOXPRO, Sybase using SSIS, DTS.
• Stored procedures, functions, triggers
• DTS packages/ SSIS
• Reporting Services (SSRS)

Jan 99 May 03
Various application/database developers at different organizations
Confiedential,
Developed various applications Using PowerBuilder, VB and databases such
As SQL Server, Oracle, Sybase.
Involved in designing the system, creating the prototypes, designing the screens
and extensively involved in coding, testing, user acceptance test. Involved in
creating the stored procedures, database design. Involved in the data conversion.
Involved in the coding several screens for various applications.
PowerBuilder 7.0, VB, PFC, Sybase 10.0, Oracle Cursors, Triggers, Stored
Procedures, Inheritance, Encapsulation, Polymorphism, Windows NT/95.

Confiedential, Jan 95-Nov 98