Summary

• Experience in developing Capacity Planning Reports database growth estimation and Server disk space and involved in SQL Server Consolidation projects.
• 9 years of professional work experience in RDBMS design modeling, development, implementation, administration, performance tuning monitoring work experience spans across financial services, Mortgage, Federal Government projects and Healthcare Insurance domains on multi large-scale and highly visible projects. Experienced in SQL Server versions: 2012, 2008 R2, 2008, 2005, 2000, 7.0 6.5
• Technical Expertise:
• Microsoft Certified Professional, Microsoft Technology Specialist SQL Server 2005 , MCITP: Database Administrator SQL Server 2008 .
• Transcript ID 829479 and the Access Code kbaig9825 and link to view result
• Eight plus years of experience as a MS SQL SERVER DBA in Design, Development, Administration and Management using SQL Server 2008R2/2008/2005/2000 under WINDOWS environments on a 24x7 large scale production environments in a Clustered 2-node/3-node, active/active and active/passive non-clustered builds.
• Expertise in installing SQL Server 2000/2005/2008 and 2008 R2 instances and applying service packs and hot fixes using Slip Streams with minimal production downtime
• Experience with large scale migrations projects involving Analysis Services databases from SQL Server 6.5/7.0/2000 to SQL 2005 and SQL Server 2005 to SQL Server 2008R2.
• Implemented and monitored different types of High Availability Disaster Recovery scenarios like Clustering, Snapshot and Transactional Replication models, Log Shipping, Database Mirroring.
• Designed and implemented Disaster Recovery Backup/Restore Strategies involving very large and highly transactional databases with sizes ranging from 100GB to a 2TB. Performed point-in-restore for critical issues using the log tail backup.
• Identified, resolved database locks h/w -related issues, Client/Server connectivity, Query Optimization using DMV's Functions, Profiler, perfmon, DTA where necessary, Performance slow-downs due to locks, blocking, index issues and Database Consistency.
• Expertise in resolving locks, deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks.
• Proficient in SQL Server 2008/R2 new features like Activity Monitor, Filtered Indexes, Data Compression, Resource Governor, Transparent Data Encryption TDE and Backup compression.
• Strong Knowledge and experience with SQL coding standards in writing Stored Procedures, Triggers, Views, SQL functions, Error Handling Techniques and resolving locking and deadlocking issues by modifying the SQL code.
• Designed SSIS Packages which involved data from heterogeneous systems such as Oracle, MS Access and DB2 Mainframe systems and also Migrated Data from Excel, MS Access, Flat file, CSV files, Oracle to MS SQL Server by using Excel Macros, IMPORT/EXPORT, BCP, DTS and SSIS Packages.
• Extensively worked on supporting 24x7 in a Production Environment.
• Involved in User Acceptance, system testing, bug fixing documentation of the project.
• Flexible and versatile to adapt to any new environment and has the ability to work individually or in large teams involving long hours with strong inclination for finishing job before project deadline

Technical Skills:

MS SQL Server 2012/2208R2/2005/2000/7.0/6.5, MS SQL Reporting Services SSRS 2005/2008R2, MS SQL Server Analysis Services SSAS 2008R2/2005/2000, MS SQL Server Integration Services SSIS 2005/2008R2, DTS Packages, Erwin Designer 2000, MS-Access 2010/2007/2003, Oracle 9i 10g, DB2, Windows NT, Windows Server 2008/2000, Windows XP/Windows 7, Unix, Shell script, VB Script, C/C , HTML, XML, MQ Web Services, UML, MS Visio, MS office 2010, Microsoft Visual Source Safe, Subversion, Microsoft Team Foundation Server TFS , Window SharePoint Services 3.0., i3 Performance Monitor, SQL Lite Speed.

Professional Experience:

Confidential

System Architect/SQL Database Administrator

Responsibilities:

• Installing and Configuring SQL Server 2008R2 64 and 32 bit on Standalone and Microsoft Clustered servers and applying service packs and hot fixes using Slip Streams with minimal production downtime.
• Created Fail-over Cluster Active/Active, Active/Passive environments, depending on the application and business requirements.
• Managed approximately 300 SQL Servers 2005, 2008, 2008R2 with team of 9 DBAs in 24x7 production environment, provided on-call day-to-day support.
• Upgraded approximately 300 Servers from SQL Server 2005 to SQL 2008/2008R2 Server, with database sizes ranging from 100GB to 400GB.
• Implemented new features of SQL server 2008, backup compression, Page compression, CDC Change date Capture , Copy-only backup, partitioning ,resource governor, online index rebuild and assisted developers with new features in developing the application code such as unique index with null values etc.
• Database Administration for all databases Production /Development/UAT , with day to day tasks includes database monitoring, Backups, Space Management, Resource Utilization on servers.
• Involved in managing day-to-day DBA activities such as checking SQL Server logs, event logs, daily jobs, backup jobs and moving the backup files to SAN, by creating users and roles for login authentication, validating permissions and removing orphan users.
• Monitoring and making recommendations for performance improvement in hosted databases which involved index creation, index removal, index modification, file group modifications, code optimization and adding scheduled jobs to re-index and update statistics in databases.
• Participated in enterprise release management DB deploys QA to Prod./DR
• Implemented and supported snapshot, and transaction replication
• Performed DB refreshes and data scrubbing per risk management standards
• Routinely tested DB file backups to confirm validity
• Proactively monitored DB server state information by utilizing custom stored procedures with the results stored in a utility DB
• Implemented file-groups to manage VLDB's efficiently
• Responded to trouble tickets and resolved all support related issues
• Routinely monitored Windows and SQL Server error logs to diagnose and troubleshoot any known issues
• Provided 24 x 7 on-call support
• Worked on problem management, performance tuning, identifying locking and blocking for long running queries.

Environment: 2-node Clustered SQL server 2008R2/2008/2005, Active-Active Active-Passive Clustering, Windows 2008 R2/2008/2003, Transactional Replication, i3 Performance Monitoring Tool, Upgrade Advisor, SQL Profiler, Performance Monitor, DMV's, T-SQL, SSIS, VB.NET 2003/2005, and JAVA, FTP/SFTP.

Confidential

Subject Matter Expert SME /Database Administrator

Responsibilities:

• Upgraded SQL Server 7.0/2000 Servers to SQL 2005/2008 Server, 60 production databases, with database sizes ranging from 100GB to 1.5TB.
• Installed and Configured SQL Server 2005 64 and 32 bit on Standalone and Microsoft Clustered servers and Applied the latest Service Packs, Hot fixes and security patches.
• Worked with different application teams, for gathering information and analyzing the changes before upgrading the databases. .
• Depending upon the application requirement, and the size of the databases, used both Side-by-Side and In-place migration methodologies.
• Used RML Utilities and Upgrade Advisor, for analyzing the performance improvement of SQL Server 2005 over SQL Server 2000 and the changes that need to be made before and after SQL 2005 Server upgrade.
• Implemented SDLC development and acceptance test environments.
• Involved in Converting, Designing, deploying and maintaining more than 250 packages which included lot of data operations and analysis processing tasks.
• Involved in migrating DTS packages to SQL Server 2005 Integration services packages, using DTS Exchange. For deploying SSIS packages in different environments, used configuration files.
• Used SQL LiteSpeed v4.8, to backup and restore databases, scheduled TSM Tivoli Storage Manager backup jobs every night to achieve the backup files from different servers to Data Center in Waukegan.
• Involved in managing day-to-day DBA activities such as checking SQL Sever logs, event logs, daily jobs, backup jobs and moving the backup files to SAN, by creating users and roles for login authentication, validating permissions and removing orphan users.
• Installed and Configured SQL Server Analysis Services processed the cubes and dimensions after migrating the OLAP databases.
• Resolved various performance issues, by running DBCC commands, using SQL Tracer and SQL Profiler, to track down Dead locks and long running queries.
• Configured Database Mail and scheduled database maintenance tasks, alerts to the operator by means of email in case of success/failure of job and to solve emergency scenarios like server shutdown, when the database is in emergency/suspect/shutdown mode
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.

Environment: Clustered SQL server 2000 and 2005 servers placed at Waukegan, Windows server 2003 R2, Enterprise x64 Edition Service packs 2, OLAP, Transactional Replication, Failover Clustering , SQL Lite Speed V4.8, HP Open view, DTS Exchange, RML Utilities, Upgrade Advisor, SQL Profiler, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SSAS, Informatica, VB.NET 2003/2005, Erwin 4.0.

Confidential

Database Administrator/ Developer

Responsibilities:

• Writing tuning Stored Procedures, Functions, Triggers and Views in Transact SQL for optimal performance.
• Implementing T-SQL Coding Standards and writing policies and procedures for data management.
• Architecting the solutions by using SQL Server and mentoring developers.
• Applying latest Service Packs and Hot fixes and Upgrading SQL Server 2000 to SQL Server 2005.
• Installing and Configuring SQL Server 2005 64 and 32 bit on Standalone and Microsoft Clustered servers.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Full documentation of the current systems and identification of areas that need to be reengineered.
• Involved in Installation and designing MS SQL 2000/2005, created various databases for Development and Testing Environment using SQL Server 2000/2005 and managed database locations and size.
• Used Erwin data modeling tool for creating the logical and physical data models and for forward and Reverse engineering and also used the feature complete model comparison for making the data models synchronized.
• Administrative task including full and differential backups, database security by creating users and roles for login authentication and validating permissions.
• Created complex triggers on tables for logging the data, wrote complex queries and joins as per the business requirements.
• Developed and designed SSIS packages for importing the data from ODBC sources, MS Access, MS Excel, flat files etc.
• Involved in migrating DTS packages to SQL Server 2005 Integration services packages.

Environment: SQL Server 2000/2005, Oracle, Windows 2000 server, Query Analyzer, SQL Profiler, Enterprise Manger, SQL Server Configuration Manager, T-SQL, DTS,SSIS, SQL Server Reporting Services SSRS , SSAS, Windows SharePoint Services 3.0, VB.NET 2003/2005, ASP.NET, SQL Services, Erwin 4.0, ER Studio.

Confidential

Database Administrator/ Developer

Responsibilities:

• Installed SQL Server 2005 on Windows Server 2003 applied service packs and hot fixes
• Migrated SQL Server 2000 instances to SQL Server 2005
• Actively participated in both logical modeling and physical modeling phases of SDLC
• Established relationships amongst various entities designed ER diagrams
• Normalized data till the 3rd NF de-normalized selected tables, as necessary
• Designed database schema using third party tools like Erwin
• Researched and presented technical documentation to set standards, guidelines and best practices for SQL Server database installation, administration, Backup restore procedures, database security, and SQL database development across the enterprise
• Documented and presented capacity planning projections
• Created databases, and database objects that included: tables, views, indexes, stored-procedures, triggers, functions, cursors.
• Created complex triggers on tables for logging the data, wrote complex queries and joins as per the business requirements.
• Created and managed database users, logins, and administered database security
• Developed and utilized DTS Packages extensively for ETL requirements uploaded data from Oracle, SQL Server, flat files
• Developed T-SQL scripts to enforce business rules
• Setup log shipping between various sites to support planned and unplanned application failovers
• Optimized the performance of queries by removing unnecessary columns, eliminating redundant and inconsistent data, normalizing tables, establishing table joins, and creating indexes on the most frequently queried columns
• Resolved performance related issues due to excessive blocking, and deadlocking
• Created DTS Packages based on the business requirements and migrated some DTS Packages to SSIS Packages
• Rebuilt an existing Data Transformation Services ETL system that supports the BI processes
• 24x7 supports in a Production Environment On call Support.

Environment: SQL Server 2000/2005, Windows Server 2003, IIS 6.0, DTS, SSIS, SSRS, BIDS, SQL Server Profiler, VB Script, Index Tuning Wizard, Database Tuning Advisor, ERWIN