Profile

• 7 Years of total IT experience
• 6 Plus Years of MS SQL Server DBA experience

Summary

• Over Seven years of experience in IT of which more than Six years in MS SQL SERVER 2008/2005/2000 Database Administration and Development in Windows environment.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Extensive Knowledge in various states of System Development Life Cycle (SDLC).
• Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and, Database designing.
• Extensive experience in managing MS SQL Server on Windows 2000, 2003 and 2008 Servers.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving Blocks and Deadlocks
• Experience in using tools like SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance, Idera Diagnostic Manager
• Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Implemented Database Mirroring in SQL server 2005 & 2008 with a witness server to configure automatic failover
• Implemented log shipping for SQL Server 2005 and 2000.
• Expert in implementing different types of Replication Models such as Transactional, Snapshot, and Merge.
• Extensive knowledge of installation and configuration of SQL Server 2005/2008 cluster server in active/passive and active/active mode.
• Expertise in upgrading (In-place Upgrades) and migrating databases from MS SQL Server 2000 to 2005 and SQL Server 2005 to 2008.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Expert in working with Third party backup tool like SQL Lite Speed, Idera SQL Safe to improve performance of backup and recovery
• Expert level knowledge in Server Consolidation and Data Center migrations.
• Expert in developing Stored Procedures, views, appropriate functions, effective DDL/DML Triggers and views on index to facilitate efficient data manipulation and data consistency.
• Expert in configuring and managing Linked Server, Data transfer between SQL Server.
• Experience in upgrading SQL server software to new versions suggested by Microsoft and applying service pack and hot fixes
• Experience in contacting Microsoft and other vendors for product and technical support.
• Extensively worked on Data extraction using the (SSIS) Microsoft SQL Server integration services.
• Experience on database design for large databases.(terabyte databases)
• Good understanding of change control process
• Available for 24*7 production support in mission critical environment.
• Good interpersonal, analytical and communication skills.

Education & Certificates

• Bachelor’s Degree in Computer science
• Microsoft SQL Server 2005 - Implementation and Maintenance (MCTS)
• Designing a Database Server Infrastructure Using Microsoft SQL Server 2005
• Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005

Technical Skills

MS SQL Server (2008 R2, 2008, 2005, 2000, 7.0), MS Access.

Reporting Tools:

SQL Reporting Services, Crystal Reports, Active Reports, SSRS, Oracle Forms/Reports Developer.

Programming/Scripting Languages:

C, C++, T-SQL, XML, Java script.

Version Control:

Rational Clearcase, Subversion, Tortoise SVN.

Operating System:

Windows Server 2008/2003, Windows 2000, Windows NT 4.0.

DBA & Others Tools:

Toad, Erwin DM, MS Visio, DB Visualizer, Quest Lite Speed, Quest Enterprise, Quest Spotlight, Idera SQL Safe, Idera SQL Diagnostic Manager, Red Gate SQL Compare,

Professional Experience:
Confidential,Plymouth, MN Feb’ 11 - Till date
MS SQL Server DBA
Confidential,is a leading health care company, serving more than 75 million people worldwide.

Responsibilities:

• Installed, Configured and Administered SQL Server 2008R2/2008/2005 Servers in Production, QA and UAT Environments.
• Migration of SQL Server 2000 to SQL Server 2005, SQL Server 2005 to 2008R2
• Migrated some databases from Oracle 11g to SQL server 2008R2
• Worked closely with application team, manager and other DBA’s for planning and implementation of the migration.
• Involved with change control board to ensure proper approvals and meet the timeline for database migration.
• Successfully implemented Database Mirroring in SQL Server 2005/2008R2 for high availability on two VMware servers.
• Created databases, Logins, Roles and granted appropriate permissions.
• Configured Database Mail to send out notifications
• Managing SQL server using PowerShell scripts
• Installed SQLSafe on all the database servers.
• Configured Log Shipping for high availability on SQL 2000
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and indexing updates
• Installed and Configured 2- node High availability SQL Active/Passive clusters.
• Created documentation to install SQL Server 2005, apply service packs, hot fix and clustering installation.
• Database refreshes from prod to stage, test and development environments.
• Performed Administrative tasks in SQL Server using PowerShell
• Conducted database performance monitoring and tuning
• Proven experience in maintenance of SQL Server in a VLDB environment & experience in troubleshooting and resolving problems.
• Installed SQL server instance on VMware server.
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Creating and managing schema objects such as tables, views, index, and procedures.
• Good Knowledge of using VMware Servers.
• Experience in working with ITG ticketing system.
• Experience in providing excellent 24X7 Production support.

Environment: Microsoft Windows Server 2008/2003 32/64 bit, MS SQL Server 2008 R2/2005/2000, Idera SQLSafe, T-SQL.

Confidential,New York Aug’09 – Feb’11 SQL Server DBA
Confidential,headquartered in New York is one of the largest commercial banking organizations in the United States. Its primary services include deposit, credit, trust, and investments. It also offers credit cards, mortgage banking, insurance, brokerage, and capital markets services through various subsidiaries.

Responsibilities:

• Installed and configured SQL Server 2005 in production and development environment.
• Upgraded SQL Server 2000 to SQL server 2005/2008 in 32 and 64 bit environment.
• Active involvement in installing and managing multiple 2node failover cluster set up in active/passive environment as a High Availability mechanism.
• Successfully implemented database mirroring with high availability mode in SQL Server 2005.
• Configured transactional Replication from multiple subscribers for reporting purpose.
• Involved in performance tuning, optimization of stored procedures and queries.
• Worked with customers to resolve the connectivity issues
• Set up linked servers in SQL 2005
• Estimated disk storage requirements for database software, database files.
• Monitoring and troubleshooting performance during peak periods with 1000 to 2000 concurrent connections.
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
• Use custom scripts so as to help automate routine tasks such as Maintain operators, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Created automated procedure for daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
• Good Knowledge on SQL Lite Speed a Backup solution for MS SQL Server.
• Good Knowledge of using VMware Servers.
• Experience in providing excellent 24X7 Production support.
• Experience in contacting Microsoft for product and technical support.

Environment: Microsoft Windows Server 2008/2003 32/64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008 and SQL Lite speed, spotlight, DELL power edge.

Confidential,Indiana Sept’08 – Aug’09
SQL Server DBA
Confidential,is the largest financial services group in the world, offering a diverse array of corporate and personal financial products and the greatest global distribution capacity of any financial firm.

Responsibilities:

• Created documentation to install SQL Server 2005, apply service packs, hot fix and clustering installation.
• Upgraded SQL Server 2000 to SQL Server 2005 in 32 and 64 bit clustered and non-clustered environment.
• Active involvement in installing and managing multiple 2node failover cluster set up in active/passive environment as a ‘High Availability’ mechanism.
• Prepared Estimates for Database, table size growth rate for capacity planning.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
• Implemented Log Shipping in SQL Server 2005 from Primary server to Standby Server to support DR Solution.
• Implement and maintain database security standards, policies and procedures.
• Installed and configured Quest Spotlight for SQL Server Enterprise.
• Configured Transactional Replication from Multiple subscribers for reporting purposes.
• Involved in performance tuning, optimization of stored procedure and queries.
• Upgrade DTS packages to SQL Server 2005 Integration Services (SSIS) packages.
• Managed indexes on tables using various SQL Server Commands to reduce fragmentation.
• Expert in working with Change management and change control procedure.
• Tuned the Production Server to get the performance improvement by using my own DMV’s.
• Support Development Team in deploying and testing the application.
• Experience in contacting Microsoft and other vendors for product and technical support.
• Successfully worked in 24x7 mission critical environment.

Environment: Microsoft Windows Server 2000/2003 32/64bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Visual Studio 2005, spotlight, lite speed.

Confidential,NY Oct’07 – Aug’08
SQL Server DBA/Developer

• Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor
• Develop backup and recovery strategy
• Configuring Microsoft Cluster on the Servers (4 node Active/Active cluster with 5 instances)
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases
• Involved in replication setup, configuration and maintenance in transactional replication for student scheduling and Grade reporting application
• Troubleshooting Replication Errors and handling Logs
• Manage database users/profiles and security
• Implementing SQL Server and Database security policies
• Creating and managing database objects such as tables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity
• Maintaining SQL Script for creation of Database Objects
• Created Stored Procedures and Triggers for the Application
• Optimized SQL queries for efficiency and provided queries and procedures for the front-end application
• Involved in scheduling tasks and Setting Alerts, Managing Task Scheduling, setting up a SQL mail, managing alerts, monitoring and tuning SQL Server, SQL Performance monitoring, monitoring and tuning memory and monitoring locks

Environment: Windows 2003 Server, SQL server 2005, Event Viewer, SQL Profiler, T-SQL.

Confidential,Mumbai, India Feb’07- Sep’07
SQL Server DBA/Developer
The Project involved end-to-end application deployment to support Loan Organization like online loan application, loan interest rates, Adjustable And Fixed Rate Loan, Part fixed, Part Floating Rate Loan, Balance Transfer of your existing loan from other banks, Compliance, Reporting and treasury operations.

Responsibilities:

• Installation of SQL Server 2005 with latest Service Packs.
• Worked in Active/Passive Clustered Environment.
• Writing stored procedures for report generation in migration process and replication.
• Implemented the migration of SQL Server 2000 to 2005.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Experience in monitoring software tools used to monitor the environment effectively.
• Successfully implemented Database Mirroring in SQL Server 2005 for high availability.
• Maintain both DEVELOPMENT and PRODUCTION server in sync.
• Involved in Log Shipping.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Involved in Monitoring Performance of different production servers.
• Worked in 24x7 production environment.
• Working with the end user gathering requirements for the system.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented Backup & Restore Plans.
• Creating and Maintaining Database Maintenance Plans.
• Requirements gathering from the end-users.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in analyzing the system for setting up new server and server configuration.

Environment: Windows 2000/2003 server, MS SQL Server 2000/2005, Erwin, MS Excel, Dell/EMC CX3/CX Series SAN Arrays.

Confidential,India Jan’06 – Jan’07
Client: HSBC, Singapore
SQL Server DBA
Confidential, is well known financial consultant in the world. TATA is providing the support service for their Accounts, Production and Inventory management. There are around 100 production and around 120 development servers.

Responsibilities:

• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
• Designed and implemented multiple systems using MS SQL Server 2000 and 2005.
• Prepared Estimates for Database, table size growth.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Responsible for MS SQL Server 2000/2005, configuration, tuning and provide 24X7 dedicated support to all Production, development and cluster servers.
• Performed all aspects of database administration, including backups andrecovery.
• Additionally, designed and implemented a disaster recovery system.
• Installed and configured Microsoft SQL 2 node Clustering (Active/Passive)
• Involved in the logical and physical data modeling using Erwin tool.
• Created complex stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Developed database monitoring and tuning strategies.
• Configured Log shipping of one production server and created the DR server.
• Implemented and configured Transactional, Snapshot and Merge replication.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Preparing the reports for the day-to-day as well as weekly/monthly purposes.

Environment: MS SQL-Server 2000/2005, SQL Diagrams, Erwin, MS Windows 2000 Server, MS Windows 2003 Server, MS Access, MS Excel, MS Analysis Services, MS Reporting Services, HTML 4.0.