Ankit Shah Email & Phone Number

Toronto, Canada Area

Vadodara Area, India

• To receive customer calls/e-mails, understand and analyse issue faced by customer, provide appropriate solutions.• Tracked all incidents using internal tools (JIRA) to ensure effective resolution of issues.• To escalate client issues to support manager, interact with the development/deployment team to convey client • Performed installation/configuration of software product (Indralok) at client side. • Retrieving data from database on regular basis as client’s needs data to produce to Insurance Company & inspection teams in USA.• Prepare and maintain technical documentation for support.• Monitor servers and client setup at cloud and Xen server.• Worked on how Accession's Result (Report) are calculated by Instrument and moved from Lab System to Client's EMR through various application and HL7 channels.• Knowledge of HL7 messages, moving from Client's EMR (EHR) to Lab Systems and back from Lab System to Client's EMR. • Worked with the Development team for their product “Dashboard” which helps in management of the alerts and troubleshooting.• Provided 24*7 support and on-call support on a rotational basis to meet clients SLA.• Effectively monitored their large number of clientele used a custom based tool called Nagios. All alerts were received on this tool. All alerts were resolved within the client SLA depending on criticality.• Trouble shoot and Co-ordinated with other teams to ensure that the issues get resolved within the SLA.• Expert in following procedures of the company, which differed from their client to client.

Vadodara Area, India

• Administrating, Maintaining, Configuration and Performance fine-tuning of SQL Server 2005/2008 on Windows 2003/2008 on various hardware platforms.• Administrating, Maintaining and Monitoring SQL Server 2005 cluster Instances and databases in various environments including production, pre-production & training.• Backup and Restore administration tasks − Worked with client to create backup jobs and document backup and restore procedures for disaster recovery.• Created and maintained database maintenance jobs which used to run on various schedule times and checked for all types of inconsistencies in databases, disk space usage and Index maintenances. • Executed daily DBA tasks which included monitoring of:• Daily backups − Detect any failures and check for successful completion of daily backup.• Production SQL jobs − Monitor the status of Production SQL Server jobs.• SQL Server error logs − Monitor SQL Server error logs for potential issues.• Windows system/application event logs − Detect and alert on errors in system, application, and security event logs.• Disk space − Detect and alert on disk space deficiencies before impacting production.• Database size − Detect and alert on database space issues before impacting production.• DBCC logs − Monitor database corruption using DBCC logs• Utilized SQL Server Profiler and performance monitor to trace and tune the poor performing Queries, dead locks, locking, stored procedures and hardware resource.• Provides technical support to customers and evaluators using the organization’s software product(s), including installation troubleshooting, product configuration assistance and troubleshooting improper product operation and/or erroneous product use.• Work closely with Engineering, Professional Services, and internal team in supporting new features and services.• Experience in Active Directory and Window Server 2003/2008.

Database Administrator (Advanced), Data Modeling/Warehousing And Database Administration

B.Sc.(It), Computer Science, Second

Bsc(It) Integrated, Computer Science, First