SUMMARY

• 7+ years of experience in Database Administration for verylarge and complex databases in SQL Server 2008R2 and SQL Server 2008/ 2005 environments
• Experience in upgrading SQL Server to new versions and applying Service packs and hot fixes and Unattended Installations.
• Monitoring Database Daily Backups and all the jobs.
• Hands on experience with High Availability &Disaster Recovery Solutions - Log Shipping, Mirroring.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing Indexes.
• Hands on experience in Planning&Scheduling Maintenance Tasks, Scheduling Jobs, and Alerts using SQL Mail
• Maintained User Permissions, Logins, and Security Issues. Monitored Event Viewer, SQL Error Logs, and Log Files for S/W and H/W errors.
• Experience in Capacity Planning and Performance Support of OLTP and OLAP databases in the client-server environments.
• Knowledge in configuring Database Mirroring/Logshipping
• Expertise in using Performance Monitor, SQL Profiler, Activity Monitor to resolve dead locks, Long Running Queries, and Bottlenecks caused by complex queries.
• Knowledge in using DMVs and DMFs in finding and solving Performance Issues
• Strong knowledge on creating SQL objects like Stored Procedures, Functions, Views etc.
• Knowledge on SSIS and SSRS
• Knowledge in SQL Server 2012 features including Data Quality Services and Master Data Services
• Strong interpersonal skills, with the ability to effectively interact with technical, non-technical, and business staff at all levels.
• Ability to work independently as well as in a team.
• Proven ability in mastering new technologies quickly and effectively.
• Experience in production support, 24 X 7 on call.

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, NV

SQL Server DBA

Responsibilities:

• Highly worked on Administration, Database Design and Performance Analysis on very large and highly transactional production databases.
• Implemented the disaster recovery models like Database Mirroring & Log shipping.
• Monitored Log shipping for trouble shooting of errors.
• Created Logins at Server level and Users at Database level and mapped Roles by assigning permissions.
• Used Performance monitor and SQL Profiler to optimize queries and enhanced the performance of database servers.
• Extensively worked on update statistics, rebuilding the indexes at regular intervals for better performance.
• Successfully implemented the Capacity planning for different servers.
• RoutineDBAjobs likemonitoring the data loading jobs, Backups (Full, Differential &Transactional), disk space, database status, handling the maintenance jobs and checking the error logs.
• Scheduled and monitored all maintenance activities including database consistency check, index rebuild/ reorganize, update statistics and backups.
• Applied hot fixes, Patches and Service Packs and create script for Unattended Installation.
• Implemented and maintained databasesecurity, policies and procedures
• Refresh Dev/Stage databases using production backup.
• Performed code reviews to ensure high quality.
• Provided 24/7 Support for Production,Development & Test Servers of MS SQL Servers

Environment: Microsoft Windows Server 2008R2/2012, MS SQL Server 2012/2008R2.

Confidential, Jersey City, NJ

SQL Server DBA

Responsibilities:

• Managed and AdministeredSQL Server 2012/2008R2 Production and Non-production Servers.
• Highly worked on Administration, Database Design and Performance Analysis on very large and highly transactional production databases.
• Implemented the disaster recovery models like Database Mirroring & Log shipping.
• Migrated SQL Server 2008 databases intoSQL Server 2008R2 databases by In-place upgrade process and also used upgrade advisor tool in up gradation.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Implemented Database Mirroring and Log Shipping as part of DR plans.
• Scheduled weekly jobs and Maintenance tasks for better performance
• Configured Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Cleanup History, and Update Statistics.
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Setup Database Security and maintain accounts and access levels by creating suitable Logins and Roles and assigning object level permissions.
• Managed Disk space, Memory, and User Connections.
• Scheduled and monitored maintenance activities including database consistency checks and index fragmentation.
• On call 24 X 7 production support.

Environment: MS SQL Server 2012/2008R2, Windows Server 2008,SQL Data Compare

Confidential, Phoenix, AZ

SQL Server DBA

Responsibilities:

• Converting DTS Packages into SQL Server 2008 Integration Services.
• Microsoft SQL server 2008\2008R2Database Administration.
• Upgrading SQL Server 2008to SQL Server 2008R2.
• Created Linked Server connections between SQL Servers databases.
• Worked on multiple instances of SQL Servers using VM Ware.
• Evaluated database performance, performed maintenance duties such as Tuning, Backup, Restoring, and Disaster Recovery.
• Creating DTS packages for data Import/Export, Scrubbing, and Scheduling jobs for backups.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Export or Import data from other data sources like flat files using Import/Export through DTS and SSIS.
• Configured the Report Server, Created, deployed, and managed Ad-hoc reports using SQL Server Reporting Services (SSRS).
• Worked on Log Shipping for database synchronization.

Environment: MS SQL Server 2008R2/2012, SSRS, Windows XP, Windows Server 2008R2/2012

Confidential

Jr SQL Server DBA

Responsibilities:

• Created Database Objects including Tables, Views, Constraints, Functions, Stored Procedures, Triggers, Rules, Defaults, and User Defined Data Types.
• Identify relationships among tables and enforce referential integrity usingforeign key constraints.
• Create Triggers to generate alerts and notifications.
• Wrote complex stored procedures to map and read data from third party formats as part of statistical Data Migration.
• Tune the SQL queries using SQLProfiler and Executions Plans.
• Created Views to facilitate easy user interface implementation, and Triggers on them to facilitate consistency Data entry into the database.
• Developed automated emails and generated dynamic RTF forms using OLE automation procedures.
• Handled development and production support, document reviews, test plans, and integration of the system.
• Wrote queries involving multiple databases through linked server.
• Documented data models using MS Visio 2003.

Environment: MS SQL Server 2000, Enterprise Manager, Windows 2000/XP and MS Visio 2003.