SUMMARY:

• Overall 18 years of IT experience includes 9 + years on Database Administration and Deployment with MS SQL Server technology and managing VLDB (very large database).
• Experience in Software Development Life Cycle (SDLC) and project methodologies.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2000/2005/2008/2008 R 2/2012/2014.
• Strong SQL Server developer skills including writing stored procedures, user defined functions, views, indexes, cursors, triggers and queries.
• Experience in tuning SQL queries and improving the performance of the databases.
• Experience in implementing and maintaining High Availability solutions like Clustering, Database Mirroring, Replication, Log shipping and AlwaysOn.
• Experience in Configuring Always - On Availability Groups on SQL Server 2014/2012.
• Experience in developing Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Proficient in automated documentation for all SQL instances using SQL, PowerShell, and SharePoint.
• Experience in Database migration to new versions and editions of SQL Server as part of datacenter or server consolidation or upgrade projects.
• Experience in SQL Server Performance Tuning using tools like System Monitor, SQL Server Profiler, DMVs, Optimized expensive running Queries using Database Engine Tuning Advisor, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Experience in creating custom-tailored database backup/restore scripts for Full, Differential and
• Transactional backups and scheduled jobs for DBA automation task.
• Experience in creating and implementing Disaster Recovery Solutions.
• Providing DBAs supporting multiple SQL 2014/2012& SQL 2008 R2 RDBMS systems on large
• Production Infrastructure with responsibilities for managing the availability, reliability and performance of the environment.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Experience in working RAID and SAN environment and have good understanding in capacity planning.
• Transformed data between servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in auditing database user’s audits using SQL profiler and costumed stored procedures\packages.
• Experience in Replication strategies for setting up and configure replication (snapshot, transactional, or merge) to copy, distribute and synchronize data across multiple servers.
• Worked extensively in Clustered environment (Active / Passive) to further increase scalability and stability of business critical systems
• Working knowledge in using various third party tools and technologies like Redgate, Spotlight, Solar winds and litespeed for managing and monitoring databases performance.

TECHNICAL SKILLS:

Opertating systems: Windows 9x/NT/2000/XP, Windows server 2000/2003/2008 /2012

Databases: SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014, Oracle 9

Database tools: SSMS (SQL Server Management Studio), SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, SQL Agents, SQL Alerts, SQL Jobs, Database Mail, SQL Client Configuration utility, Backup and Restore, Replication, Log Shipping, Redgate, Solarwinds, Idera

ETL tools: DTS and SSIS

Languages: Cobol, C, C++ T-SQL and PL/SQL

Other tools: MS-office, Visio, Project

PROFESSIONAL EXPERIENCE:

Database administrator

Confidential, Atlanta, Georgia

• Installed, Managed and Administered SQL server 2008R2\2012\2014 SQL servers. 
• Implemented side by side and in place Migration of MS SQL server 2005/2008R2 to 2012, 2014 and applied Patches and Service packs to update different versions of MS SQL server. Configured Log Shipping & Database Mirroring. Implement SQL Server 2012 feature ALWAYS-ON High Availability groups with two secondary nodes. Installed SQL 2008R2 & 2012 multi node cluster environments on VMware/ Physical environments. Applying patches and hot fixes for the same. Adding nodes to already existing clustered servers as a part of data load\High availability. 
• Managed multiple larger databases ranging from 2TB to > 4TB. Implemented industry best practices of disaster recovery. Implementation of SQL server logins, Roles and Authentication modes as a part of security policies. 
• Created and scheduled maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans. Performance tuning of databases by windows performance monitor and SQL Profiler. Used Index tuning wizard to redesign and created the indexes for better performance. Reorganizing or Rebuilding Indexes based on the Index fragmentation. Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance. Used extended events/ SQL profiler for performance tuning.
• Work in change control process for production and non-production changes. Documenting the standard procedures on regular basis.  
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas. 
• Involved in transferring data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS. 
• Managed various SSIS packages for extract the data from sources like MS Access, Sybase and Oracle, load into SQL server databases after transform the data as per the requirements. Maintained 40 SSIS packages in production environment and about 300 packages in Development and UAT environments.
• Involved in 24*7 On Call production support. 

Environment: MS SQL Server 2005/2008R2/2012/2014, Windows 2003/2008/2012 , SSIS, PL/SQL, MS Access, MS SCCOM, Red-gate and solar winds.

Database administrator

Confidential, Newyork, NY

• Installed SQL Enterprise 2012, 2014 on standalone, VMs. Involved in implementation of SQL server 2012, 2014 in multi node active-active cluster.
• Migrated SQL server 2008 R2 to SQL Server 2012/2005 to 2008 r2/2008R2 & 2012 to 2014.
• Recovered databases from backup in disasters. Implemented Point- In-Time Recovery solutions.
• Implemented high availability solutions like Log shipping, Database mirroring and Always on.
• Automated nightly database refreshes from production backups to DEV and UAT environment to speed up the development cycle.
• Extracted Transform and load the data from access database to SQL Server databases using SSIS and loaded into Oracle and Access databases.
• Monitored using SCOM (Ops manager 2012), to help alert automation & decision management.
• Other day-to-day activities like Index management, backup, tuning, performance analysis and other ad-hoc requests are been addressed.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Experience in maintaining 99.9999% uptime for production SQL environment using SQL 2012 clustering and availability groups for automatic failover and disaster recovery.
• Extensively used tools like Solar winds, Red-gate and native tools like Profiler and performance monitor. Migrated data using SSIS from Oracle, Access and flat files. Transferred Jobs and Databases using SSIS.

Environment: T-SQL, MS SQL SERVER 2005/2008R2/2012, IIS Server 5.0, WINOWS SERVER NT/2003/2008R2/2012, SSIS and Solar winds.

Database Administrator

Confidential, Dayton, OH

• Installed configured, upgraded and monitored SQL Server 2005 and 2008R2 database server and applied patches to it on dev., and production environments. 
• Involved in development of database including creating new databases, converting old databases to new databases, and modification of existing databases. 
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers. 
• Monitor and tune all aspects of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using Perf Mon, Profiler, Dynamic management views. 
• Modified the database structure, as necessary, from information given by application developers. 
• Worked on backup and recovery of database information. 
• Migrated SQL Server 2000 data bases into SQL Server 2005. 
• Created Operational automation code for daily/weekly database maintenance tasks such as database health and status check, backups, database consistency maintenance, index maintenance,, long running queries, blocking and locking, update stats, monitoring database and log file space and growth, monitoring disk space, failed logins, errors, mirroring database status, replication agent status.
• Security Administration: creation of users, Roles and granting appropriate privileges. 
• Performed Performance Tuning of the database, index defragmentation, Stored Procedures and SQL queries upon requirement. 
• Recovering the databases from backup in disasters. 
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks with the framework of SLA. 
• Involved in Weekly Change Management meetings.

Environment: T-SQL, MS SQL SERVER 2005/2008R2, Windows Server NT/2003/2008R2/2012 and SSIS.

Database Administrator

Confidential

• Provided Databased Administration to multiple projects including activities like Installing software, Performance tuning and release deployments across all environments DEV/UAT/SIT and PROD.
• Consolidated of Hardware by implementing clustering and downgrading standalones. Consolidated of Hardware on DEV & TEST to VM clusters.
• Implementing production changes on a weekly basis. Ticket management was our day to day operations.
• Optimizing space alerts, Index tuning and fragmentation were part of our long term strategy.
• Involved in streaming the server/database level security by creating the Windows and SQL logins with the appropriate Server/db roles and object level permissions.
• Responsible for SQL backups and recovery in development, test and production.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Extensively used tools like Red-gate and native tools like Profiler and performance monitor.

Environment: Windows Server 2003/2008, MS SQL Server 2008/2005/2000 , SQL Server Reporting services, SQL, T-SQL, SQL Query Analyzer, Profiler, Erwin, VSS.

Confidential

QA Test Lead

• Involved in testing of application developed in Siebel, and Oracle as backend.
• Analyzed the application, prepared test data for functional and regression testing.
• Tested various business rule and data load rule files.
• Developed test cases and test scripts for UAT and System testing.
• Performed positive and negative testing for the application.
• Responsible for updating status to the onsite management.
• Involved in bug tracking and reporting using Mercury Quality Center.

ETL Developer/ ETL Tester

Confidential, New York

• Interacted with developers to understand functionality of the application.
• Responsible for developing Test plans, test cases.
• Review the test cases and update the team members about the corrections.
• Performed System Testing, executing the test cases.
• Defects were tracked, reviewed, analyzed and assigned to the respective team members.
• Extensive use of MS Office 97 tools to create and maintain documentation such as test planning documents, test execution documents and test results documentation.
• Performed testing on both Internet Explorer 5.0 and Netscape Navigator 4.7.
• Defects were tracked, reviewed, analyzed

ETL Tester

Confidential

• Involved in the project flow design and preparing test plans and developed automated data test scripts.
• Involved in Requirements specification document preparation and Test Planning.
• Involved in Regression testing, System Testing.
• Actively participated in Load Test, Volume Test and Stress test.
• Performance testing preparing was done manually, update the developers.
• Used Clear case for Version Control.