• Anil M
  • Systems Analyst, IT Consultant, Help Desk and IT Support Worker, ... more
  • Last/current workplace: Allscripts Healthcare Solutions, Baroda
  • 36 years old from Hawthorn, VIC


Hi Robert, With reference to your requirement of “Microsoft Technical Architect.". I am pleased to enclose herewith my resume for your kind perusal. Based on your REQUIREMENT (SQL plus Windows Administration), I believe that I can be the candidate to fit your NEED as I have all the skills, experience and certifications mentioned in the job specification. In brief I would like to introduce myself as follows: Education Master of computer Applications (MCA - 2009) & Bachelor of Computer Science (BSC - 2005) Current Company Allscripts Private Limited. (A leading HealthCare IT company) Current Designation Senior SQL DBA\Application Support Citizenship: Hold Australia PR Availability: 1st March 2015 Certifications: MCSE (windows 2003) and MCSA (SQL 2012) certifications. I have undertaken various assignments/projects in this field the details of which are mentioned in my resume. I assure you that you will not regret the decision of hiring me. Thanks & Regards. Anil enariya.

Employment History

  • Allscripts Healthcare Solutions, Baroda

    • Feb 2009 - Current
    CURRENT EMPLOYER: Allscripts Healthcare Solutions, Baroda ( (Feb 2009 - till date) Designation: Senior SQL Server Database Administrator Clients: Hospitals & Physician Practices across United States, Australia Acute Application: Sunrise Clinical Manager 5.5, 6.1 Ambulatory Applications: Allscripts Professional EHR, Allscripts Professional PM, Allscripts Enterprise EHR Responsibilities o Performing day to day activity as a SQL Database Administrator- backup, restoration, replication, mirroring, and fine tuning. o Monitoring of alerts, interfaces, backups, clusters, SQL errors using the EG Monitoring Tool. o Creation of Maintenance Plans and troubleshooting errors. o Troubleshooting errors found in SQL errors logs and applying hotfixes as required. o Managing SQL data, SQL jobs, connectivity. o Monitoring disk space, Network, database space. o Major responsibility includes planning, developing, maintaining and supporting the database as per the user requirements ensuring database integrity, security, backups, reliability and performance of the database system. o Create Users and assign permissions based on the level of database access the user would need. o Design database Backup and Restoration Strategy. o Once created the database Backups, monitor those backups are being performed regularly. o Documenting major changes to the SQL Servers. o Troubleshoot various Database problems that arise in a day-to-day work and fix the issues. o Installation, Administration and Maintenance of SQL Server Instances o Installation, configuration and upgrading of Microsoft SQL Server software and related products. o Establish and maintain sound backup and recovery policies and procedures. o Monitoring performance and managing parameters to provide fast query responses to 'front end' users. o Establish and maintain sound backup and recovery policies and procedures. o Implement and maintain database security (create and maintain users and roles, assign privileges). o Database tuning and performance monitoring, setup and maintain documentation and standards o Plan growth and changes (capacity planning). o Work as part of a team and provide 7×24 supports when required. o Works on building queries, stored procedures, etc. that meet business needs. o Ensuring that storage, archiving, backup and recovery procedures are functioning correctly. o Review and monitor system and instance resources to insure continuous database operations (i.e., database storage, memory, CPU, network usage, and I/O contention using the eG monitoring Tool) Other Responsibilities o Managing of Eclipsys Sunrise Clinical Manager HL7connections, MSMQ's, Report Services, Order Generation Services, Cluster Administrator, eLink Translators and Corresponding Queues, IIS, Printer Spoolers. o Working on Unprocessed Reports, Suspended Clients, SXAMMWorkOrderQueues, CV3OrderGeneration Queues, CV3SendADT. o Creating of Clarify/ Oracle CRM/SFDC cases, updating, closing, and escalating them whenever required. o Work on Sunrise products and components - SCM/eLink/SMM, HL7 Intefaces, Reports, OGS, CDS, etc.
  • Saurashtra Cement Limited

    • Sep 2006 - Feb 2009
    PREVIOUS EMPLOYER: Saurashtra Cement Limited, Ranavav ( (Sep 2006 - Feb 2009) Designation: Junior officer (Infotech) Clients: Various departments across the company. ERP Application: RAMCO 3.1 RAMCO RLaunch Responsibilities o Created and modified SQL stored procedures, SQL triggers and table's rules as per the requirements. o Fine tuning of SQL queries and stored procedures to improve the performance of the SQL Server. o Monitored the performance of queries and effectively presented the report. o Scheduling of database backup jobs in the server using SQL scripts. o Performed backup and restoration of the entire live database using SQL scripts and TSQL. o 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. o Creation and deletion of users on domain controller and files and print server. o Installation of Symantec antivirus server and configuration of Symantec antivirus on client's side. o Created Web Reports using SQL procedures. o Created Reports using RAMCO RLaunch and Excel Reports as per the user and the system requirements. o Handling some reports in Purchase Order Management System (POMS) and Inventory Management System (IMS). o Created User Defined Screen (UDS) as per the requirement of the user. Other Responsibilities o Aware of the configuration and settings of Videoconference (Unit: TANDBERG) and handling the same. o Aware of the configuration and settings of Firewall (SYNTENSIA) and handling the same. o Performed Installation of Windows Operating System (Windows XP, 2000, 98, 95) and also performed Troubleshooting for the same. o Performed Troubleshooting for the Network Printers and Desktops. o Responsible for Privilege Maintenance (PM) of Desktop Machines. o Performed Troubleshooting for the LAN Network. o Performed Computer Assembling and Maintenance for the Desktop Machines. o 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. o Exchange server 2003 installing and configuration. Projects Done at Saurashtra Cements Limited (Previous Company) 1. Online Job Application form - For the HR Deparment. 2. Online Mehta Group Telephone Directory - For the users company wide 3. Ftp Server Configuration - For the users company wide 4. File and Printer Server - For the users Company wide 5. Upgrade from Windows 2000 to Windows 2003 Server. References:- Name Saawan Khatusuria Sunny Hirani Organization WEBJET Allscripts Private Limited Designation Network Administrator Manager, Technical Support Address Level 2, 509 St Kilda Road | 912/7 Gauthorpe Street| Rhodes NSW 2138 | Melbourne VIC 3004 | Australia Australia Telephone T Mobile Email Relationship Friend & Colleague Manager Information mentioned above is true to the best of my knowledge. References would be provided upon request. ANIL KUMAR ENARIYA


  • Information Technology (IT) Skills
  • Other

Education History

  • Sikkim Manipal University

    • Ended Jan 2009
    1. Master of computer Application (MCA) from Sikkim Manipal University in 2009 (65%)
  • Mohanlal Sukhadia University

    • Ended Jan 2005
    2. Bachelor of Science (BSc.) from Mohanlal Sukhadia University, Udaipur in 2005 (67%)
  • Higher Secondary (HS)

    • Ended Jan 2002
    3. Higher Secondary (HS) from Board of Rajasthan, Udaipur in 2002. (69.54%)
  • Senior Secondary

    • Ended Jan 1998
    4. Senior Secondary (SS) from Board of Rajasthan, Udaipur in 1998 (71%) Professional Certifications & Trainings o MCSE Windows 2003 Certified Professional o MCSA SQL 2012 Certified Professional o Completed Classroom and hands-on training on SQL Server 2008 training at Allscripts (Current Employer) o Completed Classroom and hands-on training on Visual studio using C# at SCL (Previous Employer) o Completed Classroom and hands-on training on SQL Server 2005 training at SCL (Previous Employer) o Completed Classroom and hands-on training on Advance Excel at SCL (Previous Employer) Awards and Achievements 1. Received "FEATHER IN HUT" award for best new comer in the Team at Allscripts resulting in client and executive level appreciations. 2. Received "Client Focus" award two times for the best team player resulting in client and executive level appreciations. 3. Honored with "INNOVATION AWARD" twice for going an extra mile and innovating something to smoother the process. 4. Received appreciations for in-house up-gradation of windows 2000 to windows