SUMMARY

• Over 6+ years of experience working as a SQL DBA Administrator using various Microsoft Technologies
• An Innovative thinker with extensive experience in database management, design, development, testing and supporting next generation database solution possesses
• Enhance database performance, perform restores, implement disaster recovery procedures, handle performance tuning and conduct regular system backups.
• I am also knowledgeable in the production and support of 80+ SQL Server instances running on both Windows and UNIX.
• Experienced in Security and Support of MS SQL Server 2012, 2008r2, 2008, 2005, in Production, Testing, Development Environments.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• In - depth understanding of security like implementing database security infrastructure and manages user access accounts.
• Proficient in technologies like SSRS, SSIS, Amazon Web server AWS on EC2, Virtual Machine (VM).
• Extensive Experience in handling DBA duties such as Installation, up gradation of MS SQL Server software on windows Platforms, Database Creation, Database Auditing, and Production Database Support & Maintenance, enhancement, automation, Tuning and optimizing databases for high Availability, Performance and Security.
• Created and Maintained Alerts, Notifications, Jobs, Job steps and Schedules for system errors, insufficient resource, fatal database errors and security.
• Hands on experience and knowledge of high availability SQL Server solutions (DB Mirroring) and replication.
• Expertise in setting up and troubleshooting Database Clustering in Active-Active and Active-Passive Mode on a # node cluster.

TECHNICAL SKILLS

Operating Systems: Windows 2003/2008/NT/XP, UNIX, Linux, Solaris

Languages: SQL, PL/SQL, Transact SQL, SQL-PL, HTML

Databases: MS- SQL 2005 & 2008,2012ETL Tools SQL Server SSIS, SSRS

Other Tools: MS Visual Studio, Toad for SQL server

Web Technologies: HTML, VBScript, and XML

Office Tools: MS-Word, MS Excel, MS Outlook, Windows Messenger, Visio

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

SQL Server DBA

Responsibilities:

• Responsible for software installation, testing, upgrading, patching and configuring SQL Server.
• Design, implement and supports database backup, recovery systems, database migration and archiving systems and procedures.
• Create multiple databases, storage structures, database backup and recovery, monitoring and optimizing database performance.
• Completed proof of concept for a 3rd party tool, and identified that backup and restore times were comparatively faster, and helped the team to move all the databases to be backed up by Red Gate.
• Performance tuning at DB and OS level (monitor and investigate further with high resources in terms of CPU and Memory).
• Developed and established database performance baselines.
• Created views for specific columns on a table to maintain privacy of a customer data.
• Created Indexes to get the high level performance.
• Daily Health check of the Database.
• Specified user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data.
• Created & Managed Database Structure, Storage Allocation.
• Managed and resolved design issues during development stage. Worked closely with developers.
• Developed SSRS reports using Report Builder 3.0.

Environment: MS SQL Server 2008/2008 R2 Enterprise Edition, Business Intelligence Development Studio(BIDS) - SQL Server Integration Services (SSIS) SQL Agent, SQL Profiler, Database Tuning Advisor, Database Mail, Notification Services, T- SQL, Windows 2008/2012 server

Confidential, Rockville Maryland

SQL Server DBA

Responsibilities:

• Administrated and Managed SQL Server 2012/2008R2/2008/2005 databases in Production, Staging, QA and development environments.
• Installing, Configuring and Maintaining SQL Server 2012/2008R2/2008/2005 on standalone and Cluster with latest Service Packs, Hotfixes.
• Upgraded/Migrated SQL server 2005 databases to SQL Server 2012/2008 databases.
• Configured and Supported SQL Server Log Shipping, Transactional and snapshot Replication.
• Involved in development of automated daily, weekly and monthly SQL server agent jobs such as but not limited to Database backup, Integrity checks, Indexing Maintenance and Update statistics.
• Managing logins, roles, assigning rights and permissions. Created views to implement security
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Troubleshooting production servers and fixing user and application issues
• Work with developers to develop queries, stored procedures and triggers
• Participate in planning, design, Implementation and testing of new and changing database configuration.
• Application Support for the Database and Application Servers.
• Created SSIS package to fulfill the SQL server maintenance tasks including rebuilding index, backing up database and updating statistics.
• 24 X 7 Production Database on Call Support

Environment: SQL Server 2005/2008-R2/2012, Windows Server 2012/2008, Clustered, SSIS, SSRS, SSAS T-SQL

Confidential

SQL Server DBA

Responsibilities:

• Responsible for Query optimization and Performance tuning
• Implemented database mirroring as a part of disaster recovery plan.
• Created Clustered Indexes and Nonclustered 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.
• Used DBCC commands to check physical and logical consistency of the databases.
• Involved in troubleshooting, 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
• Involved with the integration of SQL Server on a Storage Area Network (SAN) platform.
• 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
• Involved in Data Migration from SQL 2000 to SQL 2005.

Environment: SQL Server 2008, SQL Server 2008 R2, Windows 2003/2000 Server, SQL Litespeed, Enterprise Manager, SQL Query Analyzer, SQL Profiler.