PROFESSIONAL SUMMARY:

• Senior Microsoft SQL Server 2012/2008 R2/2005/2000 DBA with 8+ years of quality experience.
• 8+ years of experience in handling production systems in 24/7 environment (rotating on - call)
• 8+ years experience in Administering and managing Databases VLDB (very large database)
• Expert in managing multiple instances of database servers on-site and remotely
• Database Administration:
• Installed and configured MS SQL Server 2008 R2/2005 in all environments (standalone & clustered)
• Expert in migrate/upgrade of SQL 2005, SQL 2000 to SQL 2008 R2/2012.
• Installed security patches, services packs and hot fixes for windows and SQL Systems
• 4+ years of experience upgrading and migrating SQL Systems from lower version to higher version
• 6+ years of experience in Implementing and handing SQL Server systems in Clustered environments
• 4+ years in Implementing SQL Server 2008 environment in a Virtual Environment
• Expert in implementing High Availability options Failover Clustering, Log shipping, Mirroring and Replication
• Implemented Database Mirroring in MS SQL Server 2005 and SQL Server 2008
• Backup and Disaster Recovery:
• 8+ years of experience in capacity planning and implementing disaster recovery
• 8+ years experience in implementing full backup, differential and transaction log backup for all production, development & QA systems including Compression
• Extensive use of VIRITAS Netbackup and SQL Litespeed for SQL Backup.
• Expert in restoring databases from disaster
• MS SQL Server 2008/2005/SSIS/SSRS/SSAS:
• Worked extensively on MS SQL Server 2005/2008 Integration Services (SSIS) (ETL)
• 5+ years of experience in SSIS, SSRS and SSAS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Used containers for repetitive control flow tasks
• Migrated Data from diverse source to MS SQL Server environment with SSIS
• Scheduling package execution in SSIS
• Used SSRS to Reporting for a Data warehouse system
• Extensive use of DMV’s in MS SQL Server 2008/2005
• 8+ years of experience in performance tuning MS SQL Server 2008/2005 for best performance
• Expert in using latest SQL Server DMV's for maximum performance
• Expert in using SQL Server 2008/2005 profiler trace for bottlenecks and long running queries
• Excellent knowledge in fine tuning stored procedure for super performance
• Excellent knowledge in fine tuning queries taking a long time
• Good knowledge in understanding Query Execution Plans and Statistics data
• Expert in Creating, Suggesting and implementing Indexes (Clustered, Non Clustered, Unique)
• Expert in verifying output of DBCC SHOWCONTIG and suggesting changes
• 5+ years of experience in using tuning wizard in MS SQL Server 2008/2005

TECHNICAL SKILLS:

RDBMS: SQL Server 2012/2008 R 2/2008//2005/2000, Oracle 9i/10g

Database Tools: Management Studio, BI Development Studio, SQL Profiler, Management Data Warehouse, Data Transformation Services (DTS), SQL Server Integration Service (SSIS), SQL Server Analysis services(SSAS), SQL Server Reporting services(SSRS), IDEARA, RedGate, FogLight.

Languages: SQL, TSQL, Visual Studio 2010, .NET, Visual Basic 6.0, HTML

Web Tools: MS-Front Page, Internet Information Server (IIS), MS-Outlook Express.

Applications: Microsoft Office, Erwin, MS VISIO 2003/2005.

Operating Systems: Windows 2000/2003/2008 R2, VMWARE, Linux, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, CT

Sr. SQL Server DBA

Responsibilities:

• Managing 63+ Production, development, QA SQL Clustered Servers with size ranging 500 GB to 3 Terabyte in a 24x7 Production environment.
• Planning the upgrade/migration and Disaster Recovery(DR) strategy for SQL servers
• Upgrading/migrating from MS SQL Server 2005 to MS SQL Server 2008 R2.
• Installing 2012/2008 R2 servers on VIRTUAL Servers, applying service packs and security fix for all servers.
• Tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Implemented SNAPSHOT and TRANSACTIONAL Replication for Reporting
• Running extensive backup using VERITAS Netbackup and SQL Litespeed.
• Troubleshooting production servers and fixing user and application issues.
• Data refresh in QA environment from the production.
• Configuring Database Mail, alerts and notifications as proactive monitoring.
• Creating backup strategy for production, QA and development servers.
• Creating maintenance plans for integrity checks and optimization for production, QA & development servers.
• Identifying & improving server performance using Performance monitor using I/O, memory and CPU counters.
• Configuring the Data Collection set using Management Data Warehouse.
• Configuring reports through Reporting services for server performance Dashboard.
• Installation & configuration of SQL servers for Blackberry, Sharepoint high availability.
• Working closely with application team to fix database issues, changes.

Environment: MS SQL Server 2012/2008 R2/2008/2005, Windows Server 2008 R2/ 2003/2000, SSIS, SSRS, SSAS, VMware, .NET, SharePoint 2010, ERWIN, VISIO

Confidential, Agoura Hills, CA

Senior SQL Server DBA

Responsibilities:

• As a Production and development DBA/Architect managed SQL Server in Production, Development and QA Environments.
• Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers.
• Successfully Upgraded most of the MS SQL Server from SQL 2000/2005 to MS SQL Server 2008
• Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers on VIRTUAL Servers, applied service packs and security fix for all servers.
• Extensively used VMWare for Virtual environment.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Managed SQL Servers in Clustered environments.
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments
• Did extensive Database design and Modeling using ERWIN & VISIO
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Scheduled package execution in SSIS
• Installing packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Created extensive reports using SSRS ( Tabular, Matrix )
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Involved in setting up transactional replication in production environment.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Carried out extensive backup using VERITAS Netbackup and SQL Litespeed.
• Experienced with creating database maintenance plans for efficient operations.
• Created the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: MS SQL Server 2008/2005, Oracle 10g,UNIX, LINUX, Windows 2000/2003/2008 Server Operating systems, SSIS, SSAS, SSRS.

Confidential, Atlanta, GA

Senior MS SQL Server 2005/2000 DBA

Responsibilities:

• Responsible for 24*7 Critical Production Support for 120 servers out of which 90 servers are production servers, remaining test and development servers.
• Installed SQL Server 2000 and 2005 on windows 2000 and 2003 servers, Installed service packs and security fix on production, test and development servers.
• Installed, configured and maintained MS SQL fail over clustering for 2 mission critical servers
• Involved in monitoring the backup jobs and fixed the failed jobs.
• Created manual Log shipping environments for standby servers.
• Involved in securing SQL Servers and assign the permissions for users and roles.
• Designed the logical and physical database design for development projects using Erwin data modeling tool.
• Involved in improving the server performance using Performance monitor using I/O, memory and CPU counters.
• Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
• Experienced in creating backup strategy for production, test and development servers.
• Involved in disaster recovery procedures and restore the production databases.
• Involved in database restore requests and refresh the database between productions, test servers.
• Created the maintenance plans for integrity checks and optimization for production, test and development servers.
• Tunes SQL queries and stored procedures to improve the SQL Server performance.

Environment: MS SQL Server 2005/2000, Windows 2000/2003 Server Operating systems, SSIS, SSAS.

Confidential, New York, NY

SQL Server DB

Responsibilities:

• Administered all Production, development and Test servers running SQL 2005/2000
• Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies.
• Reviewed and tune up SQL queries, stored procedures, views and triggers.
• Help in-house developers improve performance of their stored procedures, TSQL codes and database design.
• Managed health of SQL Servers including backups, restores and monitoring.
• Provide a working model of transaction processing environment for capacity assessment and planning.
• Developed a methodology for the ongoing assessment of database performance and the identification of problem areas.
• Develop a security scheme for the database environment, as well as assisting in set up of disaster recovery.
• Provided technical support during the development, design enhancement and implementation of production databases.
• Worked with the transaction processing area to develop both the physical and the logical database administration functions.
• Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
• Worked with vendors in evaluating and implementing new technologies
• Supported deployment of modules on Staging and then promoted to Production Servers
• Implemented Auto Alerts, Messaging & Notifications
• Performed tuning of SQL queries and stored procedures for slow running queries and procedures using SQL Profiler tracing and checking the query execution plan in Query Analyzer

Environment: SQL Server 2000/2005/2008, Windows Server 2003/2008, VMWARE, VISIO, SSRS, SSIS, Crystal Reports, ERWIN.

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL Server 2000/2005 on windows 2000/2003 servers, applied service packs and security fix.
• Experienced in configuring and maintaining transaction and snapshot replication to replicate the data to remote servers.
• Involved in trouble shooting SQL Server production issues. Worked with the report team to fix the reporting issues.
• Involved in configuring SQL Server to run in best optimal conditions.
• Created the new database design for development projects, worked with SQL Developers to create the applications.
• Experienced in creating database backup strategy and implemented for production, test and development servers.
• Created the maintenance plan for SQL Server database optimization and integrity checks for production servers.
• Involved in creating work requests and change management using remedy software.
• Experienced in improving SQL Server performance using performance monitor.
• Involved in tuning the SQL Server stored procedures using index tuning wizards, profiler and SQL Query analyzer.
• Created the work instructions to install and configure SQL Server 2000, service packs, security fixes.
• Experienced in restoring the production databases to restore critical production data when disaster happens.

Environment: SQL Server 2000/2005, Crystal Reports, ERWIN, Windows 2K platform.

Confidential

Jr. SQL Server DBA

Responsibilities:

• Installed SQL Server 7.0 and 2000 servers, applied service packs and security fix.
• Experienced in upgrading from SQL Server 7.0 to SQL Server 2000.
• Experienced in granting permission to the SQL Developers and application users.
• Responsible for database capacity planning and advice the system engineers for future hardware requirements.
• Experience in creating the stored procedures, triggers and views.
• Maintained the SQL Server security features and assign the permissions to application developers and users.
• Worked with the SQL Developers to create a new database design acquired the business information from Business analysts, in corporate those information in the database design.
• Experience in tuning the SQL Queries and Stored procedures.
• Experience in creating tables, triggers, stored procedures and indexes.
• Created the SQL Scripts and scheduled to run on servers for index maintenance.
• Created the backup strategy for production, test and development servers and implemented them.
• Experienced in doing the restore operations and did the data refresh between the production to test environments.
• Maintain the SQL Servers and promote the tested scripts from test to production servers.
• Maintained the application report database for report errors.
• Experienced in configuring the SQL Server for better performance.
• Extensively worked to fix the database corruption problems in SQL Server 7.0 servers.