SUMMARY

• 7+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008, 2005 and 2000.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Expertise in T - SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server .
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Having Experience on Data center servers and handling 1.4 TB databases.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2005.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

TECHNICAL SKILLS

SQL Server Tools: SSMS,BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

Monitoring & compliance Tools: Spotlight, SQL secure, SCOM

Business Intelligence Tools: SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Crystal Reports

Databases: SQL Server 2012/2008R 2/2008/2005/2000 , Oracle 8i/9i/10g, MS Access 2000/2003/2007.

Operating Systems: Windows 2000/ NT/ XP/ Vista/98/ 95, UNIX, Windows 2003 server.

Programming Languages: JavaScript, VB, VB Script, C, C++, SQL, PL/SQL, XML.

Web Technologies: ASP, XML, HTML, DHTML, XHTML, XAML, CSS, XSLT, VBScript, JavaScript, AJAX, JSON, JQuery.

Version Control: Visual Source Safe 6.0, IBM Rational Clear Case, Team Foundation Server.

Other Tools: Microsoft Visual Studio. Net 2003/2005/2008 , MS FrontPage, MS Office, Visual Studio 6.0, Microsoft Visio 2003, Biz Talk Server.

PROFESSIONAL EXPERIENCE

Confidential, Hopkins, MN

SQL Server Administrator

Responsibilities:

• Providing 24/7 Production Support for SQL Server 2008 R2 / 2012.
• Installation & configuration SQL 2008 R2 & 2012 on Windows 2008 R2, apply SP and security fix.
• Resolving of High CPU spikes by identify long running Queries, Blocking & Deadlocks
• Monitoring Server Performance and Activities. Tuning Queries, created necessary indexes.
• Auditing the Security checks on QA \ PRD servers as per application security standards
• Involved in creating Backup & Restore strategies.
• Implemented Disasters Recovery (DR) plans to reduce the downtime of the SQL Server.
• Created Application Roles, assign required permissions to roles, assign to database Users
• Created Linked Server for retrieving data for distributed database
• Setup & Monitoring of Replication agents and troubleshooting
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Creation of Update statistics on the databases to improve performance
• Scheduling SQL Server Agent Tasks to periodically running of tasks.
• Working closely with application developers to participation on designing of tables and writing of views, complex SPs, UDFs, Trigger, and Indexes according to their requirements.
• Involved in Stored Procedures Tuning and Performance and Query tuning Activities
• Using SQL Profiler and Tuning Queries to improve performance and used Index tuning Wizard.
• Used BCP Command line tools to Import/export the table data into Flat Files and Flat files to tables.

Environment: MS SQL Server 2012 & 2008 R2, SSIS, SSRS, T-SQL, IIS 6.0, Windows server 2008 R2,, HTML, MS-Excel, XML.

Confidential, Plano, TX

SQL Server DBA

Responsibilities:

• Installed, Configured and Administered SQL Server 2012/2008R2/2008 Servers in Production, QA, Pre-Prod and Dev environments.
• Responsible for overall database environment and maintain operational uptime of 99.9%.
• Performance tuning, capacity planning, trend analysis, and server sizing for very large databases.
• Installed and managed multiple 3 node failover cluster set up in active/active clustered environment as a High Availability mechanism
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Extensively worked on MS SQL security and Active Directory Security administrator
• Implemented Transactional Replication for different applications and managed replication and database modifications for replicated objects
• Ticketing systems like Resolve for Change Request, Sales Force, BMC Remedy etc.,
• Created logins and Roles with appropriate permissions for temporary and permanent access requests.
• Scheduling the Backups and performing the restoration. Support for huge Databases.
• Provided 24/7 on-call support on rotation basis for production database.

Environment: MS SQL Server 2012/2008R2/2008/2005, Visual Studio 2010/2005 and Windows Server 2008/2003.

Confidential, Hoboken, NJ

SQL Server DBA

Responsibilities:

• Expertise in installation, up gradation and configuration of Stand-alone SQL Server 2005, 2008, 2008R2 and 2012 versions and maintained Microsoft best practices in applying Service Packs and Hot Fixes on regular basis.
• Worked with building, Installing, Configuring and Maintaining MS SQL Server 2005\2008R2\2012 Active-Active and Active-Passive two node failover Clusters.
• Extensively worked on implementing and maintaining with periodic performance review of CA Service Desk corporate application databases on a Active-passive cluster environment.
• Incorporated database mirroring for CA Service desk in a highly Transitive SQL Server 2005 fail-over cluster instance having a 900GB very large database (VLDB) as part of reporting strategy using database snapshots on the mirrored server and creating live and daily dashboards; thus enhancing recoverability and enabling reporting for creating dashboards.
• Performed data processing by Extracting, Transforming and Loading Data (ETL) from various data sources like access, excel, flat file, Oracle and MYSQL database objects by using Linked servers, Import\Export and creating various TSQL\Maintenance plan jobs & SSIS Packages.
• Ample time spent on conducting periodic database health and performance checks. Regularly create missing indexes, update statistics, rebuild\reorganize indexes; schedule T-SQL scripts on all production servers to monitor failed jobs and disk free space issues to avoid unnecessary breakdowns.
• Worked extensively on Service packs and hot fix upgrades as part of Application Engineering servers upgrade project. Installed SP-4 for around 30 2005 SQL servers and SP-2 for 55 2008 &2008r2 SQL servers. The SQL servers include both stand alone and Clusters (Active-Active and Active-passive).
• Database migrations and upgrades from SQL server 2005 to SQL server 2008 and 2008R2. Worked exclusively on migrating 2008 database servers to 2012.
• Authorizing, deploying and delivering reports using MS SQL Server 2005/2008/2008 R2 SSRS Report Generation and Preparation of weekly & monthly dashboards.
• Administered the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, granting the privileges to users and groups.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Effectively maintained enthusiastic and productive working relationships with Management, Application teams & End clients to achieve database solutions.
• Collaborated with different teams by assigning regular team meetings to resolve CA Service desk incident tickets and Business problems.

Environment: MS SQL Server 2008/2005, Windows Server 2008/2003,.NET 2.0, DTS, SSIS, SSRS, SSAS, T-SQL, Erwin 4.0,MS Access, XML, MS Excel, Visual Studio 2008.

Confidential, Alexandria, VA

SQL DBA (Database Administrator)

Responsibilities:

• Installed, Configured, and Managed SQL Server 2000 and 2005 in development, test, and production environment
• Installed, Configured VM Ware server and System running on VM Ware
• Installed and Configured Operating Systems, Windows Server 2000 Enterprise Edition
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Maintained Replications (Transactional)
• Configured Log Shipping as Standby database from Production database
• Upgraded databases from SQL Server 7.0 to 2000 in testing and production environment
• Applied Patch on Windows Server 2000 Enterprise Edition
• Expertise in database Performance tuning
• Backward & Forward Engineering with data modeling tools mentioned above
• Strong knowledge and working experience in Database Backup, Restore and Point-in-Time Recovery