SUMMARY:

• SQL Server DBA with eight plus years of combined experience working with SQL Server 2012/ 2008 R 2/ 2008/ 2005/ 2000.
• Extensive experience in Database Administration Activities such as Installation, Configuration, Migration, High Availability Solutions, Database Security, Database Designing, Query Optimization Backup and Disaster Recovery Procedures
• Experience in SQL Server DR methodologies such as Always on, Database Mirroring, Log shipping ad clustering
• Knowledge and practice in Installing, Configuring and Maintaining SQL Server Active/Active & Active/Passive Clustering with SQL Server 2012/2008R2/2008 on Windows Server 2008R2/2008/2003
• Experience in Investigating and resolving SQL Server Production issues documenting the root Cause Analysis.
• Experience in using ticketing system such Remedy/PAC2000/Nimsoft
• Expert in SQL Server Replication solutions.
• On the job experience in designing and tuning Stored Procedures.
• Experience in defining security strategies for SOAX and PCI certified systems.
• Experience in working with various change management procedures as per company standards.
• Experience in database migration from SQL Server 2005\2008 to SQL Server 2008R2\2012
• Experience in providing Production Support for 24x7 On - Call rotation basis.
• Exposure to SQL Server 2014 with Always on Set up.
• Strong Independent DBA with a positive attitude on tackling new and exciting projects to learn and grow from.
• Experience in positive group integration involving all productions, software development, system administrators, and business leads in order to work as a cohesive business unit.

TECHNICAL SKILLS:

Languages: T-SQL,Action Script, Python

RDBMS: MS SQL Server 2012/ 2008 R

Operating Systems: Windows Server 2012/2008 R2/2008/2003 Enterprise

Technologies: RAID, SAN

Quest Tools: SQL Lite Speed, Fog Light, SQL Toad

Other Tools: Adobe Photoshop,Remedy Pac 2000 Ticketing System, Anthill, SQL Diagnostic Manager, SQL Sentry Plan Explorer

PROFESSIONAL EXPERIENCE:

Sr MS SQL Server DBA

Confidential, Charlotte, NC

Responsibilities:

• Installation, Configure, and Manage Clustered and Stand Alone SQL Server 2012, 2008R2
• Production support of various SQL Server version such as 2012, 2008R2, 2008, 2005 and 2000
• Ensure SQL Server database systems operate efficiently and securely.
• Database Migration from SQL Server 2008 to SQL Server 2008 R2 and SQL Server 2012.
• Involved in trouble shooting script performance through various methods using SQL Server and 3rd party solutions.
• Developed, Tested and Deployed SQL Server Agent jobs that would enable automatic database refreshes from Production to Lower Tier Environments.
• Established and implemented company best practice guidelines for SQL Server Installation, Security and Deployments
• Documented and automated various database related procedures.
• Executed Disaster Recovery Plan as per company guidelines during Testing.
• Set up and maintained a Database High Availability Environment.
• Transactional Replication troubleshooting experience.
• Manage internal databases, from planning and testing stages, through implementation and support in Production.
• Defining and creating indexes for query optimization. Minor scripts revisions for optimal performance.
• Tested disaster recovery scenarios with servers that contained Disaster Recovery solutions such as Mirroring and SRDF.
• Installed SQL server patches across multiple environments.
• Refresh lower tier databases from production database environment whenever needed.
• Planned, Tested and Implemented Table Compression on VLDBs to regain space.
• Implemented Change Data Capture on a varied number of table, assisting application team in knowing when changes were made to their tables.
• Provide on demand assistance to application teams as needed.
• Unlocking production critical user accounts through standard company guidelines.
• Re-organized, modified and inserted appropriate database inventory information, mapping organization wide SQL Server databases to their respective servers across all environments. Confirming their existence and making appropriate changes as deemed necessary.

MS SQL Server Database Administrator

Confidential, Garfield, NJ

Responsibilities:

• Installation, Configure, and Manage SQL Server 2008R2
• Ensure SQL Server database systems operate efficiently and securely.
• Created migration plan and migrated SQL Server 2005 to SQL Server 2008\2008 R2
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency using DMV, Performance Monitor and SQL Server Profiler.
• Developed and Tested Stored Procedures that would enable automatic SQL Server Monitoring
• Establish best practice guidelines for SQL Server Installation, Security and Deployments
• Documentation and Automation of various database related procedures
• Disaster recovery planning, testing, documentation and testing
• Set up and maintained a Database HA Environment.
• Manage internal databases, from planning and testing stages through implementation and support in Production.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Performed SQL server Patch Management
• Refresh database schemas and database data in QA and Development environments from production database environment whenever needed.
• Working with Microsoft technical support to troubleshoot issues.

MS SQL Server Database Administrator

Confidential

Responsibilities:

• Installed SQL Server 2005 both 64 bit and 32 bit
• Created SQL Server Clustering on multiple nodes.
• Maintained High Availability such as Mirroring.
• Migrated databases from SQL Server 2000 to SQL Server 2005
• Replicated databases from SQL Server to SQL Server 2005
• Created Full. Differential, Log and File Group backups with restores.
• Participated in SDLC methodologies such as planning, analysis, design and implementation.
• Documented on all Database maintenance related issues
• Imported and Exported data from different sources other RDBMS platforms such as Oracle, DB2, and Access
• Migrated old DTS Packages from SQL Server 2000 and converted into SSIS packages into SQL Server 2005
• Created, installed and scheduled different SSIS packages in both production and pre-production servers.
• Consistently monitored Server health and stability.
• Used profiler and performance tuning in order to obtain more optimal system performance.
• Evaluated database performance and performed maintenance duties such as tuning, backups, and restores.

MS SQL Server Database Administrator

Confidential

Responsibilities:

• Implemented Database Mirroring for Automatic Failover.
• Documented Disaster Recovery Plans.
• Participated in planning and testing phases of DR Plans.
• Troubleshooting locking, deadlocking and blocking issues.
• Enhanced performance by reviewing disk configuration and storage allocation.
• Installed and maintained default and named instances of SQL Server 2005 and SQL Server 2008.
• Implemented Log Shipping as part of a High Availability Plan.
• Creation of Databases tables, indexes, views.
• Managed the use of disc space, memory and connection.
• Assisted Development Team in deploying and testing application, which used SQL Server as a database.
• Provided Technical Support
• Involved in Performance Tuning planning and implementation.

Environment: Microsoft Windows Server 2003, Microsoft SQL Server 2000, 2005, 2008, Performance Analyzer.