SUMMARY:

• Handling assignments to unfold career opportunities and manage projects involving technical challenges.
• Treating every adversity as an opportunity, aspire to morph every opportunity to an achievement and work in an energetic way to boost the performance of the organization.
• Having 3 years of IT experience on MS SQL Database Administration and Manual Testing
• Managing and administrating MS SQL Server 2008R2/2008/2005 running on Windows platforms 2008R2/2008/2003
• Worked on setting up and monitoring Transactional Replication with Push subscription on SQL Server 2008/2005 for reporting purposes
• Installation, configuration and management of Database Mirroring with High Performance (Asynchronous mode) in SQL 2008 for disaster recovery
• Involved in developing Backup and Restore strategy for production and development environment
• Good experience in performing Database Backups (Full, Differential and T - log), Database Restores and Point-in-time Recovery of SQL Server databases
• Performed Database Maintenance activities such as Performance monitoring, Server disk space and log space monitoring, ensuring the successful execution of maintenance jobs, CPU threshold, Disk I/O, Blockings, Database corruption and many more
• Identifying Index fragmentation using DMVs and Reorganizing/Rebuilding the indexes at regular intervals for better performance based on the level of fragmentation
• Identifying and resolving Blockings, CPU bottleneck, index usage and user connection issues using DMVs, DMFs
• Involved in troubleshooting issues related to database consistency, statistics, deadlocks, long running transactions, disk space and log space using DBCC (Database Console Commands)
• Involved in troubleshooting SQL Server connectivity and database connectivity issues
• Monitoring the Windows event logs and SQL server error logs for troubleshooting errors
• Used SQL Server Profiler to create traces and troubleshoot particular events, database activities of particular users and applications
• Involved in troubleshooting databases for its performance and concurrency issues
• Installation and configuration of MS SQL Server 2008R2/2008/2005 in clustered (active/passive) and standalone environments
• Installed SCOM (System Centre Operations Manager) 2007 R2 Agent on SQL Servers for monitoring the SQL Agent jobs and sending alerts to the SCOM console incase of job failures
• Deployment and Maintenance of SQL Server performance counters on SQL Server 2008/2005 instances
• Worked with various application teams by assisting them in database design, installing SQL Server clients and migrating data from development to QA and to Production environment
• Working closely with the management, developers and project managers to ensure successful project implementation and deliverables
• SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) installation and configuration on Application servers
• Have Good knowledge on Database architecture, Backup and Restore concepts, Database Recovery models, Transaction Isolation levels and Windows Server failover clustering for SQL server
• Follow ITIL processes in incident, release and change managements and prepare technical documentation. Consulting, coordinating and implementing changes as per application and business requirements
• Creating Windows and SQL logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups and managing object level permissions as a part of security policy
• Involved in capacity planning, sizing and estimating database growth projections
• Setup backup and restoration jobs for development, QA and production environments
• Imported and exported data from Excel, CSV file to SQL Server Database 2005/2008 by using DTS Import/Export wizard
• Performed Production support and On-Call duties
• Hands-on experience in Functional Testing, Integration Testing, System Testing, Regression testing and Compatibility testing
• Involved in Requirements understanding discussions with client, developers, stake holders and preparing Software Requirement Specification Document and Test Plan document for the project
• Developed extensive Test Plans, Test Cases based on the Business Requirements and Functional Specifications
• Identifying Test Scenarios and preparing/reviewing/executing of Test Cases
• Bug reporting and tracking using Bugzilla
• Defect Metrics preparation and maintenance
• Responsible for Verification of Defect fixes and subsequent closure or re-opening of the defects
• Good knowledge in STLC and Defect life Cycle
• Good interpersonal skills in handling status update calls with developers, client and stake holders

TECHNICAL SKILLS:

DATABASES: MS SQL Server 2008R2/2008/2005

OPERATING SYSTEM: Windows Server 2008R2/2008/2003

DATABASE TOOLS/TECHNOLOGIES: SQL Server Management Studio, SQL Server Configuration Manager, SQL Server Profiler, Windows Performance Monitor (PerfMon), T-SQL, DBCC (Database Console commands), DMVs (Dynamic Management Views), DMFs (Dynamic Management Functions), Import/Export utility

REMOTE ACCESS TOOL: Net Support Manager, PC Duo

DEFECT TRACKING TOOL: Bugzilla

WORK HISTORY:

Confidential

MS SQL Server DBA

Operating System: Windows Server 2008R2/2008/2003

Responsibilities:

• Managing and Administrating more than 1000 MS SQL Database Server instances on Production and Non-production servers, and supporting mission critical databases as large as 2TB in size
• Implemented Asynchronous Database Mirroring between databases in two different datacenters on SQL Server 2008 environment for disaster recovery purpose
• Worked on setting up Transactional Replication with Push subscription for the secondary database to be used for reporting purposes
• Used DMVs, DMFs to troubleshoot Data and index fragmentation, blockings, index usage, CPU bottleneck, user connections and many more
• Used DBCC to troubleshoot issues related to database consistency, statistics, disk space and log space, deadlocks and long running transactions
• Performed Full Database backup, Differential database backup and Transaction log backups
• Performed data refresh activities to refresh the data from production to test database servers
• Restored and Recovered databases to a specific point in time
• Worked with developers to create and modify application Schema (Database, Tables, Views and Indexes) and deploy various Transact-SQL statements, User Defined Functions and stored procedures as per the project requirements
• Installed and configured Microsoft SQL Server 2005, 2008 and 2008R2 on Standalone and Clustered Windows 2003/2008R2 servers, applied security fixes
• SCOM 2007 R2 Agent installation on SQL servers for monitoring job alerts
• Troubleshooting and resolving issues related to database connectivity and SQL Server connectivity
• Used SQL Server profiler to monitor and record the database activities of particular users and applications for troubleshooting
• Following ITIL process while working on incident tickets and change requests and documenting the same in ITSM tool. Consulting, coordinating and implementing changes as per application and business requirements
• Involved in troubleshooting disk I/O issues and performance related issues by filtering and analyzing the data collected from PerfMon
• Involved in migrating databases from SQL Server 2005 to 2008 in development and Qual environment
• Involved in capacity planning, sizing and database growth projections

Confidential

Manual Test Engineer, MSSQL DBA

Operating System: Windows Server 2008/2003

Responsibilities:

• Performing Functional Testing, Integration Testing, System Testing, Regression testing and Compatibility testing
• Understanding and analyzing the user requirements and preparing Software Requirement Specification Document and Test Plan document
• Developing Test Plans and Test Cases based on the Requirements and Functional Specifications
• Identifying Test Scenarios to prepare Test Cases, Reviewing the Test Cases and Test case Execution
• Logging and Tracking of Defects in Bugzilla
• Preparing and maintaining Defect Metrics on a daily basis and handing over the report to onshore team
• Coordinating with the developers for defect analysis and performing Regression testing
• Responsible for Verification of Defect fixes and subsequent closure or re-opening of the defects
• Performing Compatibility Testing to ensure compatibility of the web based application with different types/ versions of browsers
• Good knowledge in STLC and Defect life Cycle
• Good interpersonal skills in handling status update calls with developers, client and stake holders
• Performed Backup, restore and recovery of databases using T-SQL commands as well as SQL Server Management Studio
• Day to day Database health checkup and taking the appropriate measures in advance
• Database maintenance activities such as ensuring the successful execution of maintenance jobs, monitoring CPU usage, blockings, database log size, space in data drives and many more
• Resolving Disk Space and Log space related issues
• Monitoring the event logs and SQL Server error log for errors and taking proactive measures
• Scheduling jobs using SQL Server Agent
• Troubleshooting failed SQL Server Agent jobs using SQL Server Agent error logs
• User Management: Creation of logins, database users and roles. Granting and revoking permissions to roles, managing database object permissions and removing orphan users
• Deployed SQL Server performance counters on SQL Server 2005 instances for monitoring SQL performance
• Importing and Exporting data from Excel, CSV file to SQL Server Database 2005/2008 by using DTS Import/Export wizard