Resume

Sign in

Sql Server Engineer

Location:
Indore, Madhya Pradesh, India
Posted:
October 15, 2018

Contact this candidate

Resume:

RESUME

VIVEK JAIN

H.No. - ** Keshav Nagar, Near Pratibha

School, Babu Murai Colony,Old Airport Road

INDORE,M.P (INDIA) -452005

EMAIL :- ac7dup@r.postjobfree.com

Mob. No:- +91-916*******

OBJECTIVE:-

To seek a challenging position with opportunities for growth by contributing through my ambition, sincerity and dedication. To be a part of an environment that promotes team effort and provide an opportunityforvaluebasedgrowthwhilemakingasignificantcontributiontoemployer’sorganization.

>Server Administrator Windows Server 2008,2012

>Virtualization VMWare, Hyper V

>Databases: MS-SQL 2008R2,2012

>Network Router,Switch

>Firewall SonicWall

>Voice IPpbx

CERTIFICATES:-

> Cisco Certified Network Associate(2010).

> Microsoft Certified SolutionAssociate (2010).

> RHCE 7.0 Training Taken (2016).

ACADEMIC QUALIFICATION:-

> Bachelor of Science (Maths),Rajasthan 1997.

> Working in IT field in AYKAI Hospital Ludhiana as a IT Head from SEP-2017 to till date.

> I have worked in RUNGTA HOSPITAL PVT LTD. Jaipur, Rajasthan fromSept-2015 to AUG-2017 as a Sr. System Engineer/HISCoordinator.

> I have worked in WIPRO TECHNOLOGIES . Jaipur, Rajasthan from JAN-2013toAUG-2015 as a Hardware/ SystemEngineer.

SQL SKILLS:-

^4+ years of experience in Database Administration for very large and complex databases in SQL Server 2012/R2 and SQL Server 2008.

^ Experience on Installing, configuring, monitoring and troubleshooting SQL Server

^ Experience in upgrading SQL Server to new versions and applying service packs and hot fixes.

^ Management of Database Space, Growth Monitoring of Data &Transaction log files.

^ Expertise in Database Administration on Production Servers with server configuration, performance monitoring and maintenance with outstanding troubleshooting capabilities.

^ Administering SQL Server High Availability and Disaster Recovery strategies.

^ Setup DB Mail and SQL Server Alerts (Disk Space, TLog Full, Replication, Backup, Schema Change, CPU, Indexing Fragmentation etc.)

^ Worked extensively on Clustering.

CSE EXPOSURE:

EXPERIENCE:- Total Exp- 5 Years & 6Months

^ Troubleshooting production issues and raising high availability.

^ Creating Indexes on tables to improve the performance as per Dev/App team request.

^ Proficiency and expertise in SQL Server Replication, Backup/Recovery.

^ Having hands on experience in DR processes including Log shipping and Database Mirroring. > Worked on SQL Server 2012 R2 Migration from SQL Server 2008.

Current Company(AYKAI Hospital) Ludhiana,Punjab

JOB RESPONSIBILITIES:-

^ Maintain HIS (Hospital information system) software and handle all bugs like patient registration issue, Patient admissions, Patient Billing issue, beds reservations issue.

^ Daily check data in HMIS interface for tally server.

^ Check all jobs for their current status

^ Create new stored procedures and job scheduler according to company requirement.

^ Create and modify the Triggers.

^ Update the procedure for different view changes according to user need.

^ Check the daily backup file and all jobs which are related to procedures..

^ I do main data backup file restored on demo server twice in a week.

^ Check daily all interfaces like SRL and radiology for data transfer which are inter- connect with our software.

^ Create all main services through software like ;- Bed creation, Surgery/Procedures, Blood component, consultation, room categories, investigations, etc

^ Modify any crystal report according to user requirements.

^ Create and modify the crystal report and add new data according to requirements.

• I have worked in RUNGTA HOSPITAL LTD. Jaipur, Rajasthan Sept-2015 to AUG-2017 as a Sr. System Engineer / HISCoordinator.

JOB RESPONSIBILITIES:-

^ Maintain HIS (Hospital information system) software and handle all bugs like patient registration issue, Patient Billing issue, beds problem.

^ And maintain all reports in crystal format which plug in with front end application like stores and pharmacy reports, Finance reports, IP and OP billing reports.

^ Handle all hospital related SMS like :- occupancy SMS, Patient registration SMS, Revenue SMS, Patient discharge SMS, Patient billing SMS.

^ Handle all crystal report(Fix bugs) with according to user requirement.

^ Create new reports according to user requirements.

^ Maintain the LAN networking like handle the server and router inter-connectivity.

^ Provide the Static IP range and proxy certificate. And V-LAN configuration.

^ Handle the Server bugs like RAID configuration, storage partition, windows server installation and troubleshooting.

^ Handle domain joining, outlook email certificate configuration, Network printer installation, network path sharing for data transfer from one location to another location

• I have worked in WIPRO TECHNOLGOIES LTD. Jaipur,Rajasthan JAN-2013 to AUG-2015 as a Hardware/ SystemEngineer.

JOB RESPONSIBILITIES:-

^ Installation, Configuration and Maintenance of windows server 2008,2008R2

^ Installation and Support of IIS, DNS, DHCP, RAS and Proxy Server. Installing and configuring VPN

^ Assembling of computers, installation of operating system and various software and application.

^ Installation and configuration of printers, scanners, modems, and related computer devices.

^ End user support to customers - related to system problem includes system hardware and software problem, virus problems, internet and mail problems etc.

^ Installation and Configuration windows server 2008, active directory, user based security single system and domain base environment.

^ Installation, configuration and troubleshooting of DSL/ADSL modems, and routers, wireless devices, wireless networks and security of wireless network. Father’s name Mr. F.S Jain

Mother’s name Mrs. Shanti Jain

Date of birth MAR. 05th, 1974

Sex Male.

Nationality Indian.

Marital status Married.

Languages known English, Hindi

Permanent address H.NO. - 5/16,SECTOR- 5, MALVIYANAGAR JAIPUR, (RAJASTHAN) 302017

VIVEK JAIN

PERSONAL PROFILE:



Contact this candidate