OBJECTIVE

Objective of my career is to pursue a challenging and satisfying career in I.T Industry preferably in Health Care that can leverage considerable experience and be a part towards the goals of organization that gives me a scope to enhance my knowledge and skills in order to cope with the latest technological changes.

SUMMARY

• SQL Server database Administration/Development with over 6 years of experience.
• Extensive physical database administration experience in supporting MS SQL Server database (2000, 2005, and 2008) systems on Windows NT/ 2000/ 2003/ 2008 R2platforms.
• Strong technical skill in SQL Server. Creating of stored procedures, fine tuning queries, modifying reports using T/SQL.
• Strong working knowledge of relational database management systems and related tools (e.g. Enterprise Manager, Query Analyzer, OSQL, Profiler, SQL Server Job Agent, Analysis Services and Performance Monitor).
• Strong knowledge of database design, normalization, and data structures Solid understanding of SQL queries and transactions in order to recommend strategies to optimally manage database resources and improve performance.
• Extensive knowledge in job scheduling tools, event triggers, procedures and Scheduled, Monitoring of jobs with full update.
• Developing and Maintaining of websites using Visual Studio 2005, SQL Server as database server and C# as coding language.
• Excellent communication skills, systematic approach and ability to work effectively in a fast paced environment.
• Dedicated Software Analyst with over 2 years of experience in RAMCO 3.1 Systems.

PROFESSIONAL EXPERIENCE:

Confidential,
1. Confidential, Sep 2006 – Feb 2009
2. Confidential, Feb 2009 – Till date.
PROFESSIONAL EXPERIENCE – Confidential,

Employer: Confidential,
Duration: Feb 2009 – Till Date.
Role: SENIOR SQL SERVER DATABASE ADMINISTRATOR

Responsibilities :

• Performing day to day activity as a SQL Database Administrator- backup, restoration, replication, mirroring, and fine tuning.
• Monitoring of alerts, interfaces, backups, clusters, SQL errors using the EG Monitoring Tool.
• Creation of Maintenance Plans and troubleshooting errors.
• Troubleshooting errors found in SQL errors logs and applying hotfixes as required.
• Managing SQL data, SQL jobs, connectivity.
• Monitoring disk space, Network, database space.
• Managing of Eclipsys Sunrise Clinical Manager HL7connections, MSMQ’s, Report Services, Order Generation Services, Cluster Administrator, eLink Translators and Corresponding Queues, IIS, Printer Spoolers.
• Working on Unprocessed Reports, Suspended Clients, SXAMMWorkOrderQueues, CV3OrderGeneration Queues, CV3SendADT.
• Creating of Clarify/ Oracle CRM cases, updating, closing, and escalating them whenever required.

Employer: Confidential,
Duration: Sep 2006 – Feb 2009
Role: Junior Officer (Infotech)

Solution Environment RAMCO 3.1, RAMCO RLaunch

Responsibilities

• Handling Purchase Order Management System (POMS) and Inventory Management System (IMS).
• Created User Defined Screen (UDS) as per the requirement of the user.
• Created and modified procedures, triggers and table’s rules as per the requirements.
• Fine tuning of queries and procedures to improve the performance of the system.
• Monitored the performance of queries and effectively presented the report.
• Created Web Reports using SQL procedure.
• Created Reports using RAMCO RLaunch and Excel Reports as per the user and the system requirements.
• Performed backup and restoration of the entire live database using SQL scripts and TSQL.
• Scheduling of database backup jobs in the server using SQL scripts.
• Using VERITAS 10.0 software scheduled backup jobs for live database, desktops data and laptops data, at remote server to be taken on disk and tape drive and also have performed restoration jobs for the same.
• Creation and deletion of users on domain controller and files and print server.
• Installation of Symantec antivirus server and configuration of Symantec antivirus on client’s side.

Other Responsibilities

• Aware of the configuration and settings of Videoconference (Unit: TANDBERG) and handling the same.
• Aware of the configuration and settings of Firewall (SYNTENSIA) and handling the same.
• Performed Installation of Windows Operating System (Windows XP, 2000, 98, 95) and also performed Troubleshooting for the same.
• Performed Troubleshooting for the Network Printers and Desktops.
• Responsible for Privilege Maintenance (PM) of Desktop Machines.
• Performed Troubleshooting for the LAN Network.
• Performed Computer Assembling and Maintenance for the Desktop Machines.
• Create and Manage users and groups, active directory, tcp/ip, vpn, proxy, dhcp server, dns server, file server, print server, e-mail server, remote access service, ip addressing, remote desktop. Network installation, ftp server, internet sharing.
• Exchange server 2003 installing and configuration.

EDUCATION

ADDITIONAL SKILLS

ERP : RAMCO 3.1
Reporting Tools : RAMCO Launch
Programming Languages : C, C++, C#,
Platforms/ GUI : Windows (XP, NT, 2000, 98, 2003), Mac Os, Ms-dos
Databases : MS Access, SQL Server 2000, T/SQL
Other Tools : ASP.net, Visual Studio 2005, Clarify, Oracle CRM.
Package : MS Office