SUMMARY

• Overall, 6+ years experience in MS - SQL Server Development and Administration including Design and implementation of Distributed/Replicated Databases, planning/implementing backup/recovery strategies, and Performance tuning.
• Experience in providing good Production support for 24x7
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Extensively worked on Data Extraction using the Microsoft DTS and SSIS.
• Connecting remote Oracle Servers and SQL Servers as Remote Servers and Linked Servers.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Documented disaster recovery plans and participated in disaster recovery. Experience in using tools like SQL Profiler and performance counters for Monitoring and Tuning MS SQL Server Performance
• Extensively involved in Developing Stored Procedures, functions, triggers using T-SQL.
• Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
• Experience working with Windows 2000 Advanced Server - Administration and Installation.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Good Knowledge on SQL LiteSpeed a Back Up solution for MS SQL Server
• Good in Implementing SQL Server change control process.
• Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Expertise in using data modeling tools like SQL Diagrams, Erwin. Experience in creating Packages, Jobs, and Sending Alerts using SQL Mail
• Deep understanding and implementing Data Migration from MS-Access, Excel into SQL Server 2008/2005/2000.
• Expert in Data Transfer and Transformations using tools like Integration Services, DTS, BCP, and BULKINSERT.
• Expert in designing Database Mirroring using SQL Server 2005.
• Expertise in designing and developing Control flow, Data Flow, DTS packages to load data from DB/2, Oracle, Excel, Access and flat file feeds to SQL Server 2005/2000, and vice versa.
• Expert in using tools for Monitoring and Tuning of SQL Server 2005/ 2000 Performance.
• Expert in performing database consistency checks and planning and scheduling Backup & Recovery.
• Extensive experience in ETL process by using Integration Services, DTS Designer in SQL Server 2008/2005/2000.
• Expert in Reporting Services 2008/2005/2000 development, deployment and management.
• Expert in writing reports in Crystal Reports.
• Expertise in writing Stored Procedures, Triggers and cursors.
• Expert in tuning procedures and queries for maximum performance.
• Expert in writing T-SQL statements for creating tables, indexes and constraints.
• Involved in performance tuning of very complex SQL statements and procedures using showplan and iostatic, creating named cache and binding objects
• Expertise in trouble-shooting (handling database corruption, transaction log problems, Query performance problems).
• Experience in monitoring and tuning multiple databases using MS-SQL server Administration tools (MMC).
• Expert in data migration from MS SQL Server 6.5 to 7.0 / 2000.
• Expert in MS SQL Server 6.5/7.0/2000/2005/2008 Administration, which includes Installation & Configuration of MS SQL Server 6.5/7.0/2000/2005/2008 on Windows NT 4.0/2003 Server.
• Involved in Data Validation Process in Data warehouse methodologies.
• Experience in SQL Server stored procedures, views, configuration of multiple instances, and clusters.

TECHNICAL SKILLS

Operating Systems: MS-DOS 6.22, Windows 2003/2000/XP/9x/NT

Languages: C, C++, T-SQLRDBMS MS SQL Server 2008R2, 2008, 2005, 2000, 7.0, MS Access

Tools: SQL profiler, Tuning Advisor, System Profiler, SSIS, SSRS, SSASAnd Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Parsippany NJ

SQL DBA

Responsibilities:

• Administer SQL servers located within T-Mobile data center and specific servers within the regional offices and other entities.
• SQL Server 2008/2005/2000 Clustered Resources and Single Server Instances
• Administered MS Reporting and Analysis Services
• Involved in Developing DTS, Integration Services packages for Data Imports and Exports.
• Assisted application owners with DB design.
• Provided Backup/Restore Solution Support for all SQL Instances
• Performed DB Backups and Restores.
• Involved in Trouble shooting and resolved Backup solution issues
• Monitored Backup’s are successful in DEV, TEST, and PROD environments
• Installed and configured new SQL server instances
• Determine/Design drive layout and naming conventions
• Install and configure SQL server and related monitoring tools
• Developed scripts for specific monitoring solutions and process automation
• Provided high level connectivity support of query tools
• Provided the Service Desk with information required to support on-going requests
• Implemented 3rd party client connectivity software (Oracle Client)
• Provided problem determination and resolution support for SQL server related application problems
• Performed root cause analysis for problems
• Worked collaboratively with development staff toward resolution, provided advanced tuning expertise.
• Provided support for system management and monitoring tools
• Installation and configuration support for Compliance Manager, Diagnostic Manager, MS Operations Manager
• Responded to all non-critical system alerts in a timely manner

Environment: SQL Server 2008(R2)/2005/2000, T-SQL, Management Studio, Integration Services/DTS, BCP, Bulk Insert, Bulk Load, Analysis Services, SQLXML, Erwin, Visio.

Confidential, Boston-MA

SQL Server DBA

Responsibilities:

• Administer SQL servers located within Confidential data center and specific servers within the regional offices and other entities.
• Scheduling Backup and Restoring of Databases
• Managed Database Users and security
• Production support as per on call basis
• SQL Server 2008/2005/2000 Clustered Resources and Single Server Instances
• Administered MS Reporting and Analysis Services
• SQL Server jobs monitoring, Job failures and root cause analysis
• Involved in Developing DTS, Integration Services packages for Data Imports and Exports.
• Assisted application owners with DB design.
• Provided Backup/Restore Solution Support for all SQL Instances
• Performed DB Backups and Restores.
• Monitored SQL Error log, Event Log for error and issues
• Implemented Database Standards and policy among all the databases
• Involved in Trouble shooting and resolved Backup solution issues
• Monitored Backup’s are successful in DEV, TEST, and PROD environments
• Installed and configured new SQL server instances
• Determine/Design drive layout and naming conventions
• Install and configure SQL server and related monitoring tools
• Developed scripts for specific monitoring solutions and process automation
• Provided administration and support for Ad Hoc query users
• Granted user access to data
• Participated in Audit and provide information for Audit purpose and implement Audit recommendation
• Provided high level connectivity support of query tools
• Provided the Service Desk with information required to support on-going requests
• Implemented 3rd party client connectivity software (Oracle Client)
• Provided problem determination and resolution support for SQL server related application problems
• Performed root cause analysis for problems
• Worked collaboratively with development staff toward resolution, provided advanced tuning expertise.
• Provided support for system management and monitoring tools
• Installation and configuration support for Compliance Manager, Diagnostic Manager, MS Operations Manager
• Responded to all non-critical system alerts in a timely manner

Environment: SQL Server 2008(R2)/2005/2000, T-SQL, Management Studio, Integration Services/DTS, BCP, Bulk Insert, Bulk Load, Analysis Services, Windows 2003, Enterprise manager, DTS/SSIS, SQL profiler. MS Analysis Services, Diagnostic Manager, MS Reporting Services, HTML, SQL Light speed Backup Software.

Confidential, Houston, TX

SQL Server DBA

Responsibilities:

• Installations, configuration and up gradation of SQL Server software, Service Packs and Hot fixes.
• Administer SQL servers located within Consolidated Graphic’s data center and specific servers within the regional offices and other entities.
• Installation, Upgrade, Migration and applying Service Packs for SQL Server Database, SSIS, SSRS Software.
• SQL Server 2008/2005/2000 Clustered Resources and Single Server Instances
• Administered MS Reporting and Analysis Services
• Creation of Databases and handling database configuration changes.
• Setting up of Database Maintenance Plans or creation of SQL Jobs for DBCC, Database reorganization etc.
• Implementing and Database availability with Cluster Management, Database Mirroring, Log shipping, Replication.
• Performed database refreshes including BCP operations
• Setting up of Database Replication, DR database setup and monitoring
• Involved in Developing DTS, Integration Services packages for Data Imports and Exports.
• Monitoring SQL Server Error log, Database, SQL jobs Monitoring and troubleshooting to fix the errors.
• Trouble shooting and resolution for Database issues
• Coordinated with developers for Optimization and improvements of Database Design
• Database Query /Instance monitoring and tuning for optimal performance
• Database User, Security Administration and audit setup.
• Worked with support groups for smooth functioning of the SQL Server Environment
• Provided Backup/Restore Solution Support for all SQL Instances
• Monitored LiteSpeed Backup activities on all installed servers
• Involved in Applying of LiteSpeed Upgrades
• Performed DB Backups and Restores.
• Performed Object Level Recoveries using LiteSpeed
• Involved in Trouble shooting and resolved Backup solution issues
• Monitored Backup’s are successful in DEV, TEST, and PROD environments
• Installed and configured new SQL server instances
• Performed root cause analysis for problems
• Worked collaboratively with development staff toward resolution, provided advanced tuning expertise.
• Provided support for system management and monitoring tools
• Installation and configuration support for Compliance Manager, Diagnostic Manager, DB Artisan, MS Operations Manager
• Responded to all non-critical system alerts in a timely manner

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, Visual Studio 2008, SQL Server Management Studio (SSMS), SSRS and SQL profiler.