Summary:

• Over Seven years of experience as a MS SQL Server 2012/2008/2005/2000 DBA and experience in managing both standalone and clustered environment.
• 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.
• Used DMVs and DMFs monitoring and troubleshooting performance issues.
• Expert level knowledge in Server Consolidation and Data Center migrations.
• Implemented Database Mirroring configuration with Witness server to provide automatic failover.
• Managing SQL Servers running on VMWare ESX hosts
• Expert in designing and implementing Backup and Recovery Strategies
• Implemented different types of Replication models like Transactional and Snapshot.
• Expertise in upgrading In-place Upgrades and migrating databases from MS SQL Server 2000 to 2005 and SQL Server 2005 to 2008.
• Designed DR plans while satisfying SLA requirements and conducted DR tests.
• Worked in production support role to provide 24/7 on-call support.
• Implemented Database Mirroring for database high availability.
• Hands on Experience in installing and configuring Active/Passive Cluster on SQL 2000/2005.
• Worked with tools like SQL Profiler, Windows Perfmon and Performance counters for Monitoring and Tuning MS SQL Server Performance.
• Good understanding of change control process.
• Applied Service packs and hotfixes during off hours
• Very good experience in using Quest LiteSpeed and Idera SQLSafe to backup and restore the SQL databases.
• Conversant with all phases of Software Development Life Cycle SDLC .
• Flexible and enthusiastic team player with excellent communication and leadership skills.
• Implemented log shipping on SQL Server 2005 and 2000 versions.

Technical Skills:

• Languages : T-SQL, Visual Basic, Java, VB Script, Java script and HTML
• RDBMS : MS SQL Server 2008/2005/2000 and Oracle 9i
• Web Servers : IIS, Weblogic
• Operating Systems : Windows 2008/2003/ 2000 and Windows NT
• Backup and Restore Tools : Idera SQLSafe, Quest Litespeed,
• Storage : IBM Tivoli Storage Manager.
• Monitoring Tools : Idera Diagnostic Manager

Professional Experience:

Confidential

SQL Server DBA

Responsibilities:

• Responsible for Installing SQL Server on new servers 2008 2012
• Upgrading one of the existing 2005 Productions Server to SQL Server 2012 Version
• Moving two of the existing SQL 2005 Production Servers to New Hardware
• Upgrading SSIS Packages to SQL Server 2012 version.
• Handling day to day support tickets and development issues.
• Responsible for On-call support
• Working with Offshore team on pending issues and coordinate migration project activities to meet the project deadlines
• Responsible for Database refresh and coordinating with QA Team
• Creating Linked Servers and migrating jobs, logins
• Writing Custom scripts to refresh tables and monitoring jobs.
• Troubleshooting Performance issues

Environment: MS SQL Server 2012/2008 R2/2005, Quest Litespeed, T-SQL, Windows Server 2008/2003

Confidential

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005/2008.
• Upgraded SQL 2000 Server to SQL 2008 In place and Side-by-Side server for high volume processing databases.
• Worked closely with application owners, development teams and other teams for planning and implementation of the migration.
• Designed and Implemented Disaster Recovery Procedures.
• Implemented High Performance Database mirroring on medium scale SQL 2005 database servers.
• Automated database refresh from prod to test using custom scripts for one vendor application.
• Installed SQLSafe on all the database servers.
• Created custom jobs to back up the databases, maintenance tasks using custom scripts.
• Worked with customers to resolve the connectivity issues
• Set up linked servers in SQL 2005
• Estimated disk storage requirements for database software, database files.
• Created databases, Logins, Roles and granted appropriate permissions.
• Configured Database Mail to send out notifications
• Developed and deployed SQL Server Integration Services SSIS packages and SSRS Reports.
• Installed and Configured 2- node High availability SQL Active/Passive clusters.
• Implemented Database Mirroring for one of the large database
• Worked with 3rd party vendors to resolve database issues.
• Configured Log Shipping for high availability on SQL 2000
• Responsible for applying service packs and hotfixes
• Database refreshes from prod to test, stage and development environments.
• Provided on-call support
• Proven experience in maintenance of SQL Server in a VLDB environment experience in troubleshooting and resolving problems.

Environment: MS SQL Server 2008 R2/2005/2000, Idera SQLSafe, T-SQL, Windows Server 2008/2003, TSM

Confidential

SQL Server DBA

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 2 node 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.
• Implemented log shipping in SQL Server 2005 from primary server to standby server to support DR solution.
• Troubleshoot database performance issues and tune database objects. Set up traces and profiler to troubleshoot performance issues.
• Configured transactional Replication from multiple subscribers for reporting purpose.
• Involved in performance tuning, optimization of stored procedures and queries.
• Expert in working with change management and change control procedure.
• Create and maintain various databases for Production, Development and Testing using SQL Server 2005. Planning the location of data, index, and Transaction log files on the disk.
• Solved issues related to server performance and disk space
• Support Development team in deploying and testing the application.
• Experience in contacting Microsoft and other vendors for product and technical support.
• Providing 24 7 supports to SQL application developers in implementing the applications on production server.
• Conducted root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency.
• Creating users and assigning permissions.
• Creating back up strategies and scheduling them for execution.

Environment: Microsoft Windows Server 2003 64bit, Microsoft SQL Server 2000/2005/2008 and Microsoft Visual Studio, Performance Monitor, Profiler and DTA.

Confidential

Server DBA

Responsibilities:

• Responsible for Installation and Configuration of SQL Server 2005
• Create Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions
• Responsible for Capacity planning, disk monitoring
• Implement Transactional Replication for Sales Application
• Subscribing Oracle as a subscriber to SQL publisher.
• Create Document for Transactional Replication and production change requests.
• Manage replication and database modifications for replicated objects
• Developed and deployed SQL Server Integration Services SSIS packages and SSRS Reports.
• Test and implement SQL Server 2005 SP3 to the existing SQL Server infrastructure.
• Support and troubleshoot as required, optimize performance and resolve production problems.
• Create Linked Servers and migrate data from Oracle to SQL Server 2005
• Implement process and/or manage transfers of data between external data structures e.g. flat files, Excel files and existing databases.
• Create, test, and conduct performance tuning on SQL Server databases using Windows Performance Monitor and SQL Server Profiler
• Develop and implement backup and recovery strategies involving complete database backup/restore, transaction log backup/restore
• Monitor daily SQL jobs, event logs, error logs and performance of the database.
• Investigate and resolve SQL process issues using various SQL commands.

Environment: Microsoft Windows Server 2003, MS SQL Server 2000/2005, Litespeed, T-SQL.

Confidential

SQL Server DBA

Responsibilities:

• Responsible for Data Center migration from CA to Plano,TX.
• Installed SQLServer 2000/2005 and migrated databases from source server to destination server.
• Migrated server logins and fixed orphaned users.
• Prepared Estimates for Database, table size growth.
• Resolved user issues after databases migrations.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Additionally, designed and implemented a disaster recovery system.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Performance Tuning on live databases. This includes scanning for performance bottlenecks and troubleshoots them in order to provide the best service with the Servers.
• Developed database monitoring and tuning strategies and also Tuned Complex SQL Queries.
• Configured Log shipping from production server to the reporting server.
• Designed and tested DR solutions.
• Scheduling the Backups and performing the restoration. Support for huge Databases.
• Importing and Exporting of the Database using DTS utility.

Environment: MS SQL Server 2000/2005 Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Quest Litespeed,T-SQL

Confidential

SQL Server DBA

Responsibilities:

• Creation of Databases, Tables, Indexes, Views.
• Worked the developers identify performance issues and helped them optimizing the code.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.
• Calculate disk space and table space requirements
• Used SQL Profiler and identified long running queries.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Installation, Administration, Backup Restore Procedures, Database Security, SQL Database Development and Access database upgrades across the enterprise
• Designing the logical and physical databases and development of SQL Server Database.
• Database testing, maintaining the data and writing the procedure

Environment SQL Server 2000, T-SQL, SQL Query Analyzer, DTS, Windows NT, MS Access, MS Excel.