SUMMARY

• Over 7 years of IT experience as SQL Server Database Administration for very large and complex databases in SQL Server 2012, SQL Server 2008R2, 2008 and 2005.
• Hands - on working experience in Installing, configuring, upgrading and managing SQL Server 2005/2008-R2/2012 and required Service Packs.
• Experienced in installing, configuring, deploying and supporting Integration Services (SSIS) and Reporting Services (SSRS).
• Expertise in implementation of security models, Database authentication modes, creation of logins and groups, granting and denying permissions, and assigning roles to users on databases.
• Experience in implementing SQL Server Security and Database Permissions.
• Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL Server agent and created database mail using SQL Server database mail configuration.
• Well experienced in scheduling SQL Server Jobs, Maintenance plans and executing them.
• Proficient with SQL Server Backup and Restore.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability SQL server solutions like AlwaysOn, Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring.
• Provided support to the developers during analysis, design, coding, and implementation of new applications.
• Created databases, tables, Indexes, Stored Procedures, and Views for the developers.
• Experience in using Profiler, Activity Monitor and Performance Monitor to resolve Deadlocks, long running queries and slow running servers.
• Experience in using tools like Spotlight and Idera for monitoring performance.
• Excellent analytical, Interpersonal and communication skills, fast learner, hardworking and versatile team player.
• Ability to meet deadlines, quickly adapt to different project environments and eager to learn new things

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008-R2/2012

Database Tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Server Data Toots, Business Intelligence Development Studio, SQL Profiler, Database Tuning Wizard.

Programming Languages: TSQL, ASP.NET, XML

ETL Tools: SSIS

Backup and Monitoring Tools: Spotlight, Idera, Lightspeed

Operating systems: Windows 2000/2003/2008

PROFESSIONAL EXPERIENCE

Confidential, Springfeild, IL

SQL Server DBA

Responsibilities:

• Installed and administered clustered and stand-alone SQL server 2012 and 2008.
• Worked extensively on configuring, managing and monitoring MS SQL Server 2005, 2008.
• Documented and prepared checklist for SQL Server upgrades and migrations.
• Configured Database mail and linked servers. Setup alerts and notification for jobs.
• Performs database administration duties such as SQL Server/T-SQL programming, query optimization, SQL Server security, application security, data integrity, performance tuning, maintenance plans.
• Automated Daily Production server status checks. Written and scheduled scripts for checking server status of SQL Server Services. Send mail in case of failures.
• Responsible for the scheduling, maintenance and performance of backup and other maintenance plans, and index optimization.
• Assist in the design of the systems including database development support.
• Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment.
• Implementing high availability with AlwaysOn Availability Groups and failover clustering
• Migrated databases from log shipping to AlwaysOn.
• Ensure high availability in secure production environment including backups, disaster recovery, and real-time system monitoring.
• Experienced in monitoring Replication and troubleshooting replication issues and working with Merge Replication Conflict resolution
• Migrated SSIS packages from SQL Server 2008 to SSIS 2012.
• Developed, deployed and monitored SSIS packages.
• Establish and maintain backup and recovery policies and procedures.
• Monitor database performance, identify issues, troubleshoot and optimize using Performance Monitor, Profiler, DMV, system views and stored procedures.
• Responsible for 24*7 Critical Production Support.

Environment: T-SQL, SQL Server 2012, OLTP, TCP/IP, SSIS, ETL, Windows 2005, 2008, Redgate and Spotlight.

Confidential, Cherry Hill, NJ

SQL Server DBA

Responsibilities:

• Monitoring the Scheduled job, Backup, SQL Server databases and Replications.
• Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers.
• Successfully Upgraded most of the MS SQL Server from SQL 2000/2005 to MS SQL Server 2008
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Configured and maintained Report Manager and Report Server for SSRS and update passwords for the quarterly password change.
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Implement best practices for Database Monitoring, Backups and Restores.
• Configured Transactional Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Managed SQL Servers in Clustered environments.
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
• Deployed and scheduled packages on multiple servers in SSIS.
• Work with Data Center teams on the infrastructure, network and storage issues.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented them.
• Provide off hour support during peak business activity period and during application deployments.

Environment: MS SQL Server 2008/2005, snapshot replication, transactional replication, merge replication, SSIS, SSRS, Query Analyzer, and Performance Tuning.

Confidential, Costa Mesa, CA

SQL Server DBA

Responsibilities:

• Support an enterprise implementation of SQL Server.
• Installed SQL Server 2000 and 2005 on windows 2000 and 2003 servers, Installed service packs and security fix on production, test and development servers.
• Installed, configured and maintained MS SQL fail over clustering for 2 mission critical servers.
• Conducted performance and HA testing to ensure client SLAs are met.
• Involved in monitoring the backup jobs and fixed the failed jobs.
• Created manual Log shipping environments for standby servers.
• Involved in securing SQL Servers and assign the permissions for users and roles.
• Designed the logical and physical database design for development projects using Erwin data modeling tool.
• Involved in improving the server performance using Performance monitor using I/O, memory and CPU counters.
• Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
• Experienced in creating backup strategy for production, test and development servers.
• Involved in disaster recovery procedures and restore the production databases.
• Involved in database restore requests and refresh the database between productions, test servers.
• Created the maintenance plans for integrity checks and optimization for production, test and development servers.
• Tunes SQL queries and stored procedures to improve the SQL Server performance.
• Provide off hour support during peak business activity period and during application deployments.

Environment: MS SQL Server 2005/2000, Windows 2000/2003 Server Operating systems, Query Analyzer

Confidential

Jr. SQL DBA

Responsibilities:

• Undergone through formal training for SQL Server 2000 and 2005.
• Involved in System Environment (DEV Environment) and database Maintaining.
• Involved with team for Installation and Configuration of the MS SQL 2005.
• Involved in upgrading database MS SQL Server .
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
• Configured high Availability Techniques like database Mirroring and different Replication models like Merge, Snapshot and Transactional on test environment.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Good understanding in performance tuning, Backup and disaster Recovery Process and tools.
• Created logins and Maintained user permissions appropriately.

Environment: MS SQL server 2000/2005, Mirroring, Replication T-SQL, Performance Monitor, SQL Profiler