SUMMARY:

• Over Eight years of Information Technology experience in Database Administration, Design, and Development Support of MS SQL Server 2008 / 2005 / 2000 in Health care, Manufacturing, Financial and Transportation domains, with over two years experience in Healthcare Products like QNXT 3.4, 4.7,4.8 Claim Check, Microdyn.
• Expertise in
• Database Administration, Design, Performance Analysis and Tuning, Replication, Log Shipping.
• Performance Monitor / Profiler, Spotlight 3rd party tool
• Code Optimization and improving database efficiency through Maintenance tasks Re-Indexing, Updating Statistics, Recompiling Stored Procedures
• Experience in
• Building Virtual Servers Full Clones, Linked Clones using VMWare LabManager 4.0.
• Build, configure and deploy VMs and templates.
• Exposure in using Vsphere to check various activities of VMware servers.
• Installation of EMC Networker agent.
• Validated and thoroughly tested Deduplication of backup data by integrating Networker backups with EMC Data Domain.
• Using Report builder, Report manager and Report designer.
• Installation and Configuration of SQL Server 2005/2008 32 bit and 64 bit , SQL Reporting Services SSRS i.e. both Stand Alone and Web farm installations.
• Installing and Administering Microsoft Office SharePoint Services 2007.
• Designed and implemented Backups and Restore strategies using Native SQL and Light speed 3rd party tools.
• Designed and implemented a configurable Application and Data security model to ensure controlled access to the data on Production, Test and Development environments.
• Participated in implementing Active / Passive cluster as a part of Disaster Recover.
• Provided 24 x 7 Production support for the database and application issues.
• Worked on Oracle Identity Management to centralize and automate provisioning and coordinating User Security.
• Excellent Analytical, Fast Learner, Hardworking and Versatile Team Player, Communication and Interpersonal skills, desire to excel.

TECHNICAL SKILLS:

• Databases : RDBMS- SQL Server 2008 / 2005 / 2000, Oracle10g, MS Access 2007 / 2003
• Operating Systems: MS-DOS, Windows '95 '98, Windows Server 2008 /2008 R2/ 2003 / 2000 server/XP/NT
• GUI's: Visual Basic 6.0, VB.NET
• Third Party Applications: Clarify eFront Office 9.0, Veritas 8.60, Spotlight, Lightspeed 4.8/5.0, TidalJobScheduler, VMInfrastructure Client, VMLabManager, ProClarity, PerformancePoint.
• SQL Server Tools: Enterprise Manager, Profiler,Query Analyzer,Export Import DTS , SSIS Packages.
• Oracle Tools: PL/SQL Developer, Oracle Enterprise Manager

PROFESSIONAL EXPERIENCE:

Confidential

SQL SERVER Database Administrator

Responsibilities:

• Installation, configuration, customization, maintenance and performance tuning of SQL Server 2005/2008/ 2008 R2 Standard and Enterprise Editions 32 64 BIT including SSIS, SSAS and SSRS.
• Performed database/infrastructure physical design, database upgrades applied software patches to databases as per application/client requirements.
• Monitor database server capacity/performance and make infrastructure and architecture recommendations to management for necessary changes/updates.
• Work with internal IT operations teams to troubleshoot network and server issues and optimize the database environment.
• Establish and enforce database change management standards including pushes from development to QA, on to production, etc
• Provide development and production support to troubleshoot day-to-day database or related application issue.
• Design and implement all database security to ensure integrity and consistency among the various database regions.
• Monitor the health and performance of Production servers using Quest Fog light monitoring tools.
• Suggested Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
• Suggested, developed implemented Scaling out solution with Data partitioning.
• Set up Log Shipping, MSSQL Mail and SMTP.
• Implemented MS SQL Clustering Active/Passive Active/Active .
• Interfaced with database vendors client technical support teams to isolate resolve database related problems.
• Worked on Deploying and Scheduling SSIS packages on Different environments.
• Installed and configured Biztalk 2009 on Windows 2008 servers.
• Implemented and tested new SQL Server 2008 features such as Database/Backup Compression on SQL 2008 Databases.
• Experience in using third party Applications such as Litespeed and RedGate Compare tools, Networker backup tools.
• Experienced in installing EMC networker agent.
• Tested and implemented backups and restores with EMC Networker software to centralize and automate Data backups across IT environment.
• Validated and thoroughly tested Deduplication of backup data by integrating Networker backups with EMC Data Domain.
• Exposure working on VMware ESX 4.1
• Experience building Templates, Fenced configurations, Full Cloned and Linked clone servers on Vmware labmanager 4.0
• Experience in fixing VMware Lab Manager Issues.
• Experience in installing and configuring SQL server 2005/2008 on VM servers.
• Administered and Monitored Production databases servers which have been virtualized.
• Worked with VMware Engineers in fixing performance issues on Database Servers.
• Exposure in using Vsphere to check various activities of VMware servers
• Installed and implemented custom configurations of QNXT 4.8 application. On Execution Units, Web Servers and Distribution Hubs.
• Project Specific Skills: Windows Server 2008 / 2008 R2, Windows Server 2003 32/64 BIT, SQL Server 2008/2008 R2, SQL Server 2005, SSRS 2008, Foglight, LiteSpeed, VMWare Lab manager, VSphere.

Confidential

SQL Server Programmer

Responsibilities:

• Involved in understanding User requirements, writing stored procedures, coding, unit testing and deployment.
• Worked on developing and modifying an existing code to include encryption and Decryption functionality for an internal provider portal application to suite the encrypted data.
• Created SSIS packages to send out weekly and monthly outbound files of Medicaid Providers.
• Modified over 50 Stored Procedures to identifying the existing PCP criteria and modify it to the new PCPC criteria as per the changing user requirements.
• Involved in building configuring and deploying VMware servers.
• Experienced in installing various application software's and SQL server on VMware servers.
• Worked on Fine Tuning the performance of the existing Stored procedures
• Worked on setting up the security as a part of post migration tasks.
• Worked on Monitoring and fixing the day-to-day jobs and maintenance tasks.
• Experience in working on issue tracking and ticket management system Gemini
• Experience in using tools such as SQL Prompt and SQL Refractor to format SQL code
• Project Specific Skills: SQL Server 2005, SSIS, QNXT 3.4 SP6, Vsphere 4.0

Confidential

Database Administrator

Responsibilities:

• Installation and Configuration of SQL Server 2005 32 bit and 64 bit .
• Developed T-SQL scripts and ETL processes to load and transform data extracts from legacy systems into a SQL Server staging database.
• Support data migration and testing activities in Integration, user acceptance testing and production environments.
• Developed, publish and maintain database operations manual under revision control.
• Handled storage management, performance, monitoring and tuning of the database.
• Windows system administration including Active Directory and Group Policy.
• Manage availability, backup, restoration and recovery systems with the database.
• Designed and automated the process of QNXT quser and qenvironment security as per business needs.
• Worked with business users in analyzing the legacy data with tools such as encoder pro, fixed the data and migrated all CPT/HCPCS to QNXT 4.6 environment.
• Understanding the business logic and moving data across environments as per user request.
• Project Specific Skills: SQL Server 2005, Net 3.0 Visual Studio .NET 2005

Confidential

SQL Responsibilities:

• Managed up to 30 Production servers and 50 Development environments.
• Installation and Configuration of Microsoft office SharePoint Services MOSS 2007 .
• Involved in SQL Reporting Services Web-Farm installation and configuration.
• Redesigned existing SQL Server security to use Active Directory Groups and implement Active Directory Groups into SQL Server Security.
• Created User defined roles on SQL Server 2005 to address security gaps.
• Scheduling Jobs and Alerting using SQL Server Agent and a Tidal Job Scheduler.
• Monitored and debugged various bottlenecks through a Spotlight 3rd party monitoring tool .
• Set up alerts for various critical issues such as CPU utilization, Disk space usage and critical Job status.
• Integrated Sql traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Involved in designing efficient backup strategies.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Experience in using data modeling tool such as Visio
• Project Specific Skills: SQL Server 2005 / 2000, Net 3.0 Visual Studio .NET 2005, Oracle Identity Manager

Confidential

SQL Server Analyst

Responsibilities:

• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Installed and Configured SQL Server 2000 successfully.
• Integrated Sql traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Implemented SQL Server 2005 new concepts like data partitioning, snapshot isolation, data base snapshot, DDL triggers and DMV's.
• Project Specific Skills: SQL Server 2005 / 2000, Dot.Net 3.0, Visual Studio .NET 2005, XML

Confidential

SQL SERVER DBA

Responsibilities:

• Worked as Database Administrator in support solution division supporting on an average of 100 Database Servers to protect critical data.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Export or Import data from other data sources like flat files using Import/Export through DTS and SSIS.
• Converting DTS packages into SSIS.
• Responsible for scheduling the job steps which trigger the process to run daily and on weekends, monitoring the status of Maintenance jobs.
• Resolving the cases which were escalated by the offshore teams to solve machine critical problems in the database Servers using Clarify case management system
• Project Specific Skills: Windows 2000 server, VB.NET, ASP 3.0, SQL Server 2000/2005, UNIX based DMS Clarify case management tool, VERITAS backup.