SUMMARY:

Over six years of experience as an SQL DBA. Well experienced in various aspects of database technology (Administration, Performance Tuning, Security Issues and Clustering), incident handling and SharePoint.8 year’s solid SQL Server database administration and Development, Application support, experience/ Proficient in installing, configuring, managing, monitoring and troubleshooting SQL Server 7/2005/08/12Extensive experience with SQL Server and T - SQL in constructing database objects, tables, triggers, user functions, views, indexes, user profiles, relational database model/ 5+ Experience in MS SQL Server Performance Tuning, Query Optimization, Client/Server Connectivity, Data Transformation Services and running Database Consistency checks Using DBCC/ 5+ Experience in Administering SQL Server security by Creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups/ Solid experience and knowledge of high availability SQL Server solutions, including Clustering, Mirroring, Log shipping, Replication and SQL Server clustering/ Expert in using SQL Server Agent services to create and schedule jobs/ 5+ Experience with Database Backup, Restore and Disaster recovery procedures/ 5+ Experience in Data migration between SQL Server 2000/ 2005/ 2008/2012/2014 and implement ETL from Excel, Flat file, DTS and SSIS utility/ Excellent interpersonal, analytical and communication skills and worked on SSIS,SSAS and SSRS, PowerShell scripting.

SKILL:

Languages: C#, T-SQL, Java

Web Technologies: HTML, DHTML, ASP.Net, XML, Java Script and VB Script

RDBMS: SQL SERVER 2012/2008 R2 R 2/2005 / 2000 / 7.0 , MS-Access, Front End MS Visual Basic 6.0, OLAP

Tools: MS OLAP Services Manager

Version Control Tools: Visual Source Safe, Web Server

Technologies: IIS 5.1/6.0/7.0/8.0

Reporting Tools: Crystal Reports 8,9,10, Microsoft

Reporting services: 2008/2005/2000

SharePoint: WSS 2003/MOSS 2007/O14

Modeling Tool: Microsoft Visio, Erwin .

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Implementing of HA options like Log Shipping, Mirroring and Replication and Clustering
• Implementing SQL server service pack and security patches installation.
• Automating Database Maintenance Plans.
• Scheduling SQL Server Agent Jobs, Alerts and automating scripts.
• Backups, restores, database shrink operations, DBCC commands, Database mirroring, Replication.
• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Ensure adherence to the published compliance frame work.
• Monitor by conducting periodic audits to ensure all compliance aspects are adhered to
• Analyze and publish reports on the findings
• PowerShell scripting
• SAN administration and implementation

Environment: Microsoft SQL Server 2000/2005/2008 / 2008 R2/2012/2014, SSIS, SSRS, SSAS, Microsoft .NET Framework 3.5, Visual Studio2010, SharePoint, Redgate.

Confidential, Washington, DC

Responsibilities:

• Provide technical expertise and support in database systems and associated management software for our small and large scale clients.
• Involved in setting up SQL Server Agent jobs for Periodic Backups with Backup Devices, Database Maintenance Plan and Recovery.
• Work with other outside database sources/destinations to export and import data using import/export wizard.
• Evaluate technology, techniques to implement and maintain database environment.
• Document any permanent programs and procedures that are developed; and those that are not otherwise existing in vendor supplied information.
• Planning minimum downtime during releases and software upgrades/patching.
• Configured Transactional replication between Primary Server and Read - Only server, with Distributor server and experience in troubleshooting replication problems.
• Extensively write TSQL Queries and Stored Procedures for implementing complex business logic and developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Create Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Implemented transaction log backups to clear the logs and resolve space issues.
• Automate the maintenance tasks for shrinking the logs and databases after a 95% critical space threshold has been reached, and reorganizing and rebuilding the indexes on tables on a recurring basis for performance and also provide our clients with better backup strategies that will minimize the logs and space issues.
• Responsible for the vulnerability factors and keeping compliant with the Security issues of SQL Service Accounts and default TCP/IP listening ports.
• Create SSIS packages to capture the daily maintenance plan scheduled jobs status (success / failure) with a status report daily. Also created SSIS package to list down the server configuration, database sizing, and public role privileges necessary for the Monthly report as per the audit requirement.
• PowerShell scripting for job automation and maintenance
• Storage device configuration, implementation and administration

Environment: Microsoft SQL Server 2000/2005/2008 / 2008 R2/2012/2014, SSIS, SSRS, SSAS, Microsoft .NET Framework 3, Visual Studio2010, SharePoint, Redgate.

Confidential, Maryland

SQL Database Administrator

Responsibilities:

• MS SQL Server 2012/2008R2 administrator and responsible for Administration and Maintenance of database, servers and applications.
• Worked effectively in implementing Space, Disk Management and Security alerts using SQL Mail.
• Responsible for transfer of information from client’s existing software to e-ClinicalWorks software.
• Job Functions / Responsibilities:
• Checking the general health of the servers and the databases
• Scheduling Alerts and Jobs Using SQL Server Agent.
• Monitoring SQL Server Performance and Activity.
• Backup and Restoration of Databases using RedGate and SQL native methods.
• Successfully Installed SQL Server 2012 on the Production and Development Servers.
• Implementation of SQL logins, roles and authentication modes as part of security policies for various categories of user.
• Experience in improving SQL Server performance using Performance Monitor, Performance dashboard, SQL Server Profiler, Database Tuning Advisor and execution plans.
• Analyze the reports for long running locks, deadlocks detection, backup history check & retention.
• Space estimation & monitoring for database objects.
• Granting / revoking various authorizations to different Users/Groups (security management)
• Maintained high availability of database using Log shipping
• Monitoring Dashboard Reports for Performance Tuning and finding bottlenecks in DB.
• Monitoring the server’s status, database file growths, disk space alerts etc...
• Resolving user issues on time and raising bugs, monitoring log shipping, checking for the site availability.
• Implementing application and database security polices, involved in trouble shooting of database and application problems.
• Coordinating with the users via email/chat/phone/team-viewer for better understanding of the issue and also done the Web-ex session to troubleshoot fixing the issue.

Environment: SQL Server 2000/2005/2008 R2/2012/2014, SSIS, SSRS, SSAS, SQL PROMPT 5, Windows2008R2/ 2012, Visual Studio2010, SharePoint, Redgate.

Confidential

Database Service Engineer

Responsibilities:

• Importing and Exporting of the data using DTS routines that extract, transform, and load data from heterogeneous sources.
• Developed Log Shipping and Disaster Mirroring plans and apply on production servers that guaranteed database high availability.
• Investigated the problem management incidents by checking the application logs and system logs and permanently fixed the issues.
• Enhanced performance by reviewing disk configuration and storage allocation that increased storage efficiency.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Monitored SQL Server logs, Application logs and analyzed the logs.
• Successfully worked on importing and cleansing of data from various sources like flat files onto SQL Server 2005 with high volume data.
• Supported front-end applications under .Net framework.
• Created an automated data back-up system to improve data security and recovery processes.
• Increased IT response times by 20% by introducing new procedures and modifying indexes.
• Worked closely with the system administrator to perform software installations and hardware configuration so they improved connectivity withthe DBMS
• Developed and tested storage strategies and disaster-recovery plan for large manufacturing company's operational database, delivering solution that guaranteed recovery performance and high availability.
• Trained database and computer users on how best they can utilize computer resources which increases user awareness and helped the well-being of information systems.

Environment: SQL Server 2005, Visual Basic 6.0, Crystal Reports, Microsoft .NET Framework 2.0, Windows Server 2003/2000, MS Access, MS Excel, T-SQL, SQL-Profiler.

Confidential

IT Manager

Responsibilities:

• Implemented SQL logins, roles and authentication modes as a part of security policies for various categories of user support which increased data security.
• Created the jobs Schedules and Backup and Restoration of Databases.
• Created automatic scheduled Job and Alert notifications.
• Designed and implemented comprehensive backup plan and disaster recovery strategies.
• Analyzed data and made performance recommendations that increased storage efficiency by 70%
• Proactively monitored various data transfers and added daily checks to notify via email in case of failure
• Monitored and modified performance using execution plans and index tuning.
• Consolidating the Branch Databases in the preparation of both end of year and quarterly financial reports.
• Deployed different financial and management reports from the information systems for both Head Office and Branch uses.
• Successfully monitored SQL server performance using profiler to find performance and dead locks and blockings.
• Exported or imported data from other data sources, such as, flat files using import/export of DTS.
• Analyzed long running slow queries and tuned to optimize application and system performance.
• Created and scheduled jobs, alerts which improved database performance by 15%.
• Successfully migrated database from SQL Server 2005 to SQL Server 2008.
• Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group, individual training sessions and creating user-friendly training materials which decreased department budget by 33%.

Environment: MS SQL Server 2005, 2008, Win 2003, 2008R2, Visual Basic 6.0, Crystal Reports, MS Access