SUMMARY

• Over 8+ years of experience with the 64 bit MS SQL Server in Production, Development, Testing in a Clustered and Stand - alone Server Environments.
• Experience in installing and configuring MS SQL Server 2012/2008R2/2008 and applying service packs.
• Experience in implementing Side-by-Side Migration and in-place Upgrade of MS SQL 2012/2008R2/2008.
• Experience in working with Windows Server 2008 and Windows 7 operating systems.
• Worked on maintaining database security (logins, users, database/server roles and granting/revoking permissions).
• Experience in backup, restore the database manually and scheduling jobs and Maintenance Plans.
• Involved in configuring, implementing and monitoring different types of High Availability and Disaster Recovery including Replication (Snapshot and Transactional), Log Shipping and Database Mirroring.
• Experience in implementing Always-On Availability Groups in SQL Server 2012.
• Experience in using the DMVs, System Views and in-built global variables for analysis.
• Experience in analyzing Locks, Dead Locks and handling Isolation Levels.
• Involved in Performance Tuning by analyzing index fragmentation, execution plans, and finding missing indexes.
• Involved in using SQL Server Profiler, Activity Monitor and Database Tuning Advisor for performance analysis.
• Experience troubleshooting SQL Server jobs and job monitoring tools.
• Involved in Backup compression and data compression in SQL Server 2008/2012.
• Experience in creating database objects like Tables, Views, Indexes, Stored Procedures and Triggers using T-SQL.
• Sound knowledge of RDBMS concepts including Normalization, Joins, Keys and Constraints.
• Rebuilding indexes with different fill factors and updating statistics.
• Strong experience in working with a team, coordinating with developers, good communication and documentation skills and decision support.

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator

Confidential, New York, NY

Responsibilities:

• Installation of MS SQL Server 2008 R2, 2008 and 2005 on production, Test and Development boxes.
• Experience in installing and configuring SQL Server 2008 R 2/2008/2005.
• Involved in Capacity Planning, data modeling and Logical/Physical database Design.
• Involved in upgrades of both Side - by-Side and In-Place from SQL Server 2000 and SQL Server 2005 to 2008 R2/2008..
• Involved in upgrading service packs for SQL 2005, 2008 and 2008 R2 to the latest version.
• Setting up the Transactional Replication in between SQL Server databases and also from SQL Server to Oracle databases.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Created maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application, Cleansing and solving Database troubles.
• Daily support, troubleshooting, monitoring, optimization, tuning and blocking of servers and SQL server environments across entire system.
• Interacting with the application team members for scheduling the database migration during the non-production timings.
• Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Recovered many Databases at the time of Database crashes or data loss.
• Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.

Environment: Windows 2008/2003/2000/ NT4.0, MS-SQL Server 2008R 2/2008/2005/2000, System Monitor / Performance Monitor, LiteSpeed.

SQL Server DBA

Confidential, Dallas, TX

Responsibilities:

• Involved in upgrading the instance of development environment of SQL Server 2005 to SQL Server 2008.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Responsible for maintaining High availability servers like Clustering and transactional Replication.
• Handled issues in Replication like Replication Agents Failure, Subscription failure etc.
• Designing/ Implementing Backuppolicies for databases.
• Performed daily backup and created named backup devices to backup the servers regularly.
• Creating, maintaining the users, roles and granting privileges.
• Responsible for Monitoring Daily running jobs like Data Loading jobs, Replication jobs.
• Responsible for trouble shooting failed jobs and Replication Related issues etc., open trouble tickets if necessary to work with technicians from other departments
• Completely responsible for restoring the SQL database at critical time Zone
• Responsible for all data clean up, optimization, performance tuning and all backups, Rebuilding indexes on various tables.
• Extensively worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks.
• To set up SQL Server configuration settings.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Designing the Logical and Physical databases and development of SQL Server Database.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.

Environment: Windows 2003, MS SQL Server 2005/2008 R2, SSIS, MS Office Access 2003.

SQL DBA

Confidential, Bolingbrook, IL

Responsibilities:

• Providing 24/7 on call production support for Confidential Datacenters.
• Installation of Microsoft SQL Server 2008 R2, 2008 and 2005 on PROD, QA & DEV boxes.
• Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping.
• Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Maintaining and Monitoring Production, Pre - Production and Development database server environment.
• Migrating the database from existing 2005 to 2008/2008 servers.
• Involved in General Database Administration, Query Performance tuning Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Created Database and Database Objects like Tables, Views, Triggers, user defined data types and functions.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.

Environment: Windows 2008/2003/2000/ NT4.0, MS-SQL Server 2008R 2/2008/2005/2000, System Monitor / Performance Monitor.