SUMMARY:

• Confidential is an accomplished Senior SQL Server Administrator having 8+ years of experience in various phases of software development life cycle, including Analysis, Designing, Development and Testing of business applications using SQL 2012/2008R2/2008/205.
• Senior MS SQL Server DBA with 8+ years of IT experience in Database Administration, Installing and Support of MS SQL Server 2008/R2/2005/2000 in Production, Testing and Development Environment’s.
• Experience in Data Migration from MS SQL server 2000/2005 to 2005/2008/R2.
• Extensive Monitoring of SQL Server with DMVs and Third Party Tools like IDERA, FOGLIGHT, QUEST
• Implemented Backup and Restore in SQL Server using Native SQL Backups
• Expert skills in VMware and Virtual environments
• Experience Database Consistency Checks using DBCC Utilities, Linked Servers.
• Experience in implementing different types of Replication topologies involving Snapshot, Merge, Transactional and updatable.
• Has good knowledge in implementing Log Shipping, Data Mirroring Techniques.
• Knowledge in Installing and configuring Cluster SQL Servers in Active/Passive and Active/Active environments.
• Experience in Software Development Life Cycle (SDLC) and configuring Alerts using SQL Mail.
• Experience in developing and supporting all stages of systems life cycle including Analysis, Development, Testing, Implementation and Product Support indows environment
• Moderate experience with T - SQL in developing Database Objects, Triggers, stored procedures, Functions.
• Excellent communication skills and ability to develop solutions for client needs using agile methodologies.
• Provided 24/7 database maintenance and production support.
• Good Team Player, Strong Interpersonal and Communication Skills combined with self-motivation, initiative and the ability to think outside the box

TECHNICAL SKILLS:

Primary Skill set: MS SQL Server 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, and Log Shipping SQL Server Monitoring Tools.

Secondary Skills: Project Management, Team management, requirement analysis, Implementing ITIL best practices

Skills Inventory: MS SQL Server 2008 R 2/2008/2005/2000 , MS Access, Windows 9x/NT/2000/XP/Server 2003/2008 R2, SQL Profiler, Query Analyzer, Perfmon, Netmon, SCCM, SCOM, Solar winds & ODBC.

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

Confidential

Sr. MS SQL Server DBA

Responsibilities:

• 24/7 Production support for SQL server environment.
• Installing and configuring of SQL Server 2008 and 2008R2.
• Fine tuned and Monitored SQL Servers in Web based and Transaction intensive environments. Implemented Active/Passive, Active/Active SQL Server Cluster servers.
• Configured and maintained database mirroring for high availability.
• Implemented different types of Replication Models like Snapshot and Transactional.
• Extensively worked on Dynamic Management Views (DMV’s).
• Patched server with latest SQL Server service packs and Cumulative updates.
• Managed Confidential Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
• Performed DBCC utilities and fixed data corruption in User databases.
• Migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008/2008R2 which include installing of SQL Server.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
• Performed Server & Application fine-tuning & troubleshooting.
• Monitored MS SQL Server performance and network issues.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
• Maintained Log Shipping, Mirroring and SRDF for disaster recovery.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Controlled user access rights, and managed data security.
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV’s, Wizards and SQL Profiler.
• Implemented Backup and Restore in SQL Server using Third party tool VERITAS Net Backup, SRDF, TSM and LITESPEED.
• Maintained multiple instances SQL Servers with maximum availability.
• Involved in 24x7 on call support
• A good team player with excellent communication, analytical and inter-personal skills
• Providing SQL Server DBA and Technical support for multiple applications.
• Troubleshooting the various Network, Domain, Firewall, Security related issues concerning to applications hosted on IIS, Terminal Servers and Smart Clients gaining fairly good exposure to Infrastructure and application architecture.
• Handling Incidents/Service Request escalations from various sources (First Line, Second Line, Business, and Peer Teams)
• Handling the operational tasks such as Installation of Security Updates (if applicable)Ø Maintenance tasks such as IPAK's, Account Maintenance (Passwords), Certificates, Periodic Audits (Servers, Backups)
• Root cause identification and permanent problem resolution.
• Post mortem for critical and complex incidents that impact availability.
• Responsible for raising CRs to fix the bugs in production environment.
• Communicate to customers and set expectations on deliverables.
• Ensures first/second/third line analysts are correctly prioritizing their work
• Proved to be good team player during major incidents with effective communication skills and efficient collaboration by engaging various teams including technical, program management, and user support.
• Raise Change requests for any upgrades/changes on Server Hardware/OS configurations
• Create custom reports for SLA and Team productivity metrics using the MSE reporting database
• Prepare numerous Knowledge Base Articles on the application troubleshooting, workflow troubleshooting and processes.
• Notify Application users, Downstream Systems and Business on any planned/unplanned outages
• Implement the ITIL best practices
• Follow the incident & Change management process
• Document the processes followed for the implementation
• Prepare the Technical Documentation
• Prepare for the yearly Audit, which include implementing all the processes / standards/ controls /best practices to increase the system availability
• Prepare the Disaster Recovery plan
• Plan and implement upgrades / Commission / Decommission
• Lead the team for better deliverables
• Co-Ordinate with the other teams when required, invite for the meetings, be part of the meetings even if there is minimal scope for databases, understand the requirements for better planning & execution

Confidential, Louisiana

Responsibilities:

• Primary Responsibility was to handle the new ongoing projects.
• Prepare for the yearly IT Audit, prepare the technical and process documentation
• Follow the customer standards & Controls for security
• Production support for SQL server environment.
• Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Developed system maintenance tasks such as Database Backup and Recovery, Database mirroring and replication
• Involved in Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit environment
• Managed SQL Servers in 32/64 bit Clustered environments
• Successfully implemented Database Mirroring in SQL Server 2005/2008/2008 R2 for high availability.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Created proactive scripts to monitor SQL Servers and generate alerts which monitor backup, drive space, log, db. size and service status monitoring
• Created the standard documents for Disaster recovery testing and implemented them.
• Involved in 24x7 on call support

Confidential

Responsibilities:

• Daily responsibilities include administration and monitoring of Database servers.
• Fine-tuned and Monitored SQL Servers in Production
• Created Users and Roles, and managed security and permission of database
• Involved in Migration from SQL 2005 to SQL 2008.
• Apply the patches to make sure the databases are up to Organization recommend level.
• Implemented and Monitored Transactional Replication in SQL Server 2008
• Tuning database and SQL statements for optimal performance.
• Created SQL Server Jobs to automate the running of routine tasks such as backups, restores.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
• Maintained log shipping for disaster recovery.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Transferred logins and passwords between instances of SQL Server 2005.
• Monitoring the event logs and Server error logs for troubleshooting purposes.
• Created various maintenance plans for the regular databases maintenance jobs in the SQL server.
• Providing Mentoring and guidance to the other staff personnel and help desk on database related issues.

Confidential

Information Systems Analyst & Consultant

Responsibilities:

• Build new servers & databases as required
• Apply the latest Patches
• Daily responsibilities include administration and monitoring of Database servers.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Created SQL Server Jobs to automate the running of routine tasks such as backups, restores.
• Created Users and Roles, and managed security and permission of database
• Provide APP DBA role, work with the application teams to make sure that the application functionality is up & running
• Performed DBCC utilities and fixed data corruption in application databases.
• Maintained multiple instances SQL Servers with maximum availability.
• Involved in 24x7 on call support.

Confidential

Responsibilities:

• Involved in Data Migration from SQL 2005 to SQL 2008.
• Implemented database mirroring as a part of disaster recovery plan.
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Used DTS and SQL server integration services as part of creating the jobs on the server.
• Configuration and Administration of Windows 2000 and Windows 2003 server.
• Used DBCC commands to check physical and logical consistency of the databases.
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using Wizards and SQL Profiler.
• Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Involved in coding complex stored procedures and debugging for optimum performance
• Managed replication issues during DDL changes over data in Production\development servers.
• Implemented transactional replication model and involved in maintenance of the replication.
• Implemented Backup and restore in SQL Server 2005,2008,2008R2
• Maintained multiple instances SQL Servers with maximum availability.