Experience Summary

• Experienced on SQL server 2008 on Windows 2008 both in standalone as well as in Cluster.
• Over 6 Years' Experience on fully supporting and maintaining MS SQL Server 2005, 2008 2008 R2 and 2012 Database technologies.
• Strong experiences in Installing/Upgrading/Patching, Memory Configuration and security management.
• Security Administration including creation/alteration of logins, Users, Schemas, system/db roles and permissions on various database objects.
• Experience in SQL Clustering on different version of windows Servers.
• Experience in monitoring SQL server, capturing performance problem and improve performance by tuning Databases.
• Proactively used Tuning Advisory, Query Optimization plan and Query Execution plan in order to address Database locking, deadlocking and blocking issue.
• Experience in creating and maintaining Backup and Restore strategy, Replication and Log-Shipping strategy a part of Disaster recovery.
• Excellent in Capacity Planning and storage management.
• Experience in supporting and troubleshooting huge databases performance as well as security problems.
• Created jobs, alerts, Schedules and monitor activity logs, error logs to capture and fix any possible errors.
• Expert in installing different Software both in Cluster and non-Clustered environment.
• Experience in Security auditing and managing performance monitoring tools.
• Experienced in Developing and Implementing Project plans in MS Project.
• Worked as both independently as well as in team-oriented environments.
• Excellent analytical and communication skills with 24/7 rotated support experience.

Confidential

SQL DBA

Responsibility:

• Upgrade, Installed and support SQL servers including production, Staging and development servers.
• Installed and configure SQL server 2005/2008/2012 on standalone machine as well as on Cluster environment.
• Installed and reviewed SQL server patches as well as service packs.
• Design and configure Database, tables, indexes, store procedures, functions and triggers.
• Troubleshot database status, performance, Replication, Log-shipping as well as various errors on production, development and UAT servers.
• Migrated SQL server 2008 to SQL Server 2008 R2 in Microsoft Windows Server 2008 R2 Enterprise Edition.
• Create maintenance plan for Backup and Restore, performance tune up.
• Involved in setting up the backup strategy for production, test and development.
• Experienced in Point-in-time restoring databases in production and development servers.
• Developed Reports using Pentaho Report designer.
• Support finance application, Epicor and troubleshoot various configuration issues.
• Monitoring SQL servers for performance ad-hoc and pro-actively.
• Design and implement T-SQL Scripts and Stored Procedures and tune up them.
• Support customer and application deployment round the clock.
• Manage and maintain database security and access.
• Create documents for deployment and troubleshot issue for references.
• Created jobs, alerts, Schedules and monitor activity logs, error logs to capture and fix any possible errors.

Confidential

SQL Server DBA

Responsibility:

• Act as a production support and upgrade DBA, maintained 36 SQL Servers including production, test and development servers.
• Participate in upgrading/Patching SQL Server 2000 to SQL Server 2005 servers.
• Upgrade SQL server 2005 to 2008.
• Installed and configured the MS SQL Fail over clustering for production servers.
• Involved in setting up the backup strategy for production, test and development.
• Experienced in Point-in-time restoring databases in production and in development servers.
• Configured and deployed Reporting Service.
• Security Administration adding logins, users, granting permissions thru roles, managing schemas on the SQL Server.
• Experienced with SQL Disaster recovery processes and documented the processes.
• Configured the SQL mail/DB Mail to send email alerts to the operators.
• Created the maintenance plan for database optimization and integrity checks.
• Experienced in monitoring capturing SQL Server performance issue by using Windows Performance Monitor Task Manager SQL native Monitor SQL profiler.
• Experienced with improving databases performance using execution plan, index tuning wizards and SQL profilers.
• Analyze SQL server deadlocking, locking and blocking and troubleshoot the root of those issue.
• Experienced in securing the SQL Servers and assign the permissions to SQL Server users.
• Actively involve and participate in team meetings and author how-to documents and knowledge base articles for various database related tasks.

Confidential

SQL Server DBA

Responsibilities:

• Installed MSSQL Server 2005 on production server and on virtual servers for development and staging environments on VMware.
• Responsible for Backup and Restore procedure including Log Shipping, database capacity issues, Replication, Clustering, and mirroring.
• Managed SQL Server database, production server monitoring, profiling and tuning of production database.
• Maintaining database servers apply critical upgrades and patches as needed and ensure that database servers are similarly configured in all environments.
• Generated scripts for database creation, users, loginand user defined permissions.
• Providing operational database support for end users and production data issues reported by users.
• Manage users including creation/alteration, grant DB roles and permissions on various objects.
• Created and Maintained Users, roles, groups and granting the privileges to users and Groups to maintain security up to date.
• Increased query performance, analyzing statistical reporting, monitoring, optimizing indexes by using performance monitor, profiler and Index tuning.
• Troubleshooting and resolved database integrity, performance, blocking, deadlocking, Agent Jobs, connectivity, security issues etc.

Confidential

Database Administrator.

Responsibilities:

• Managed 25 SQL Servers, from 20 GB servers to a 2-terabyte SAP BW data warehouse.
• Consolidated SQL Servers with SQL 2005, reducing server count by 50 and saving over 200k in licensing in one year.
• Help companies run SQL Server faster and more reliably.
• Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability of sales force automation and product routing.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Designed and populated reporting tables, views and stored procedures.
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Has the ability to work in a fast paced environment, Good team player and can work independently.
• Helped the database developers on technical issues.
• Trained developers on how to write better queries, optimize their applications and to become junior database administrators.
• SAN administration for over 80 terabytes of storage. Performed capacity planning, maintenance, evaluations, purchasing, benchmark testing.
• Data modeling with Erwin.

Confidential

Software Test Engineer

Responsibilities:

• Designed and executed quality Test Plans and Test Cases to verify Reliability, Accuracy and Compatibility of application.
• Worked with on line Commercial loan applications to get approval on Test Casesand testedloan app functionality.
• Identified defects, entered required information into Quality Centeras they relate to Test Cases.
• Performed Manual, Functional, Smoke, Regression, Positive and Negative testing.
• Responsible for identifying the functional test cases for Regression Testing and automated these scripts usingQuickTest Professional.
• Created, executed and updated automated test scripts using Mercury Interactive QTP.
• Verifying offers of smaller commercial real estate loans through capital partner program with BMC Capital and Commercial Direct.
• Utilized the Test partner to test the loan Management system.
• Analyzed customized financing solutions for commercial investors nationwide.
• Verified the need to refinance existing commercial property or acquisition financing.
• Involved in executing the SQL Queries for Data Validation, Record Counting and Non Duplication Testing.
• Performed direct correspondent of several lending institutions, clients benefit by receiving direct pricing from each capital source.
• Managed requirements with Doors.
• Participated in design enhancement reviews and submitted status reports on the progress of the testing effort.